What are the responsibilities and job description for the SQL Database Developer position at Amtex Systems Inc.?
SQL Database Developer – Couchbase
Duration : 5 month contract
Location: Remote, but must be local to DFW area
POSITION SUMMARY:
Under general direction of the Director of Applications Development or other management level associate, responsible for the development, installation, and maintenance of systems software.
PRIMARY DUTIES AND RESPONSIBILITIES:
1. Designs, develops, and implements complex SQL Server databases and solutions to meet business requirements.
2. Implements best practices for database schema design, normalization, denormalization, and data partitioning where necessary.
3. Writes and optimizes T-SQL queries, stored procedures, functions, and triggers for efficient data retrieval and manipulation.
4. Analyzes database performance metrics and query execution plans to optimize database performance.
5. Implements indexing strategies, query optimization techniques, and caching mechanisms to enhance database performance.
6. Designs and develops Couchbase data models, document structures, and indexes to support efficient data storage and retrieval.
7. Implements N1QL queries, views, and indexes to optimize data access and manipulation in Couchbase databases.
8. Develops and maintains application design, program specification documents, and proprietary applications.
9. Interacts with user management regarding project status and user requirements to promote an environment with improved productivity and satisfaction.
10. Provides technical leadership and training for less experienced team members.
11. Acts as a high-level technical consultant.
12. Perform related duties as assigned.
EXPERIENCE AND EDUCATIONAL REQUIREMENTS:
Bachelor’s degree or related experience. 5 plus years of development experience. Requires some training in fields such as business administration, accountancy, sales, marketing, computer sciences or similar vocations generally obtained through completion of a four year Bachelor's Degree program, technical vocational training, or equivalent combination of experience and education. Normally requires a minimum of eight (8) years directly related and progressively responsible experience with at least three (5) years in a development role. Extensive experience in SQL Server required. Couchbase and .NET a plus.
MINIMUM SKILLS, KNOWLEDGE AND ABILITY REQUIREMENTS:
1. Thorough understanding of Systems Development Life Cycle (SDLC) process
2. Familiarity with the Company’s products and resources and prior healthcare industry knowledge preferred.
3. Strong analytical, problem-solving and conceptual skills
4. Ability to communicate effectively both orally and in writing.
5. Good interpersonal skills
6. Ability to prioritize workload and consistently meet deadlines.
7. Ability to use good judgment in conveying project status and problem escalation
8. Strong organizational skills; attention to detail.
WORK ENVIRONMENT:
The work environment characteristics described here are representative of those an associate encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions: The noise level in the work environment is generally moderate. PHYSICAL AND MENTAL REQUIREMENTS: The physical demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions:
1. Sedentary physical activity requiring reaching, sifting, lifting, finger dexterity, grasping, feeling, repetitive motions, talking and hearing.
2. Visual requirement is for close vision, distance vision, peripheral vision and ability to adjust focus.
3. 75 percent or more time is spent looking directly at a computer.
4. Associate is frequently required to stand, walk (or otherwise be mobile).
5. Ability to deal with stressful situations as they arise.