Senior Programmer Analyst (Database Engineer)

Job Description – Senior Programmer Analyst (Database Engineer)
Primary Skill: SQL Server Database Development
Employment Type: Full-Time / Contract

Location : NC

Job Summary

We are seeking an experienced Senior Programmer Analyst / Database Engineer with strong expertise in SQL Server database development, data modeling, performance tuning, and production support.

The ideal candidate will be responsible for analyzing business requirements, developing technical specifications, designing database solutions, optimizing complex SQL queries, and supporting mission-critical healthcare applications.

The role primarily focuses on SQL Server databases, data integration, and application support within a regulated healthcare environment.

Key Responsibilities

- Analyze business and system requirements and translate them into technical solutions.
- Design, develop, and maintain database objects, including tables, views, indexes, stored procedures, functions, packages, and triggers.
- Develop and maintain logical and physical data models.
- Perform database performance tuning, query optimization, and troubleshooting.
- Create technical design documents, architecture diagrams, and data flow diagrams.
- Support system integrations using APIs, Web Services, XML, and data exchange mechanisms.
- Investigate and resolve production issues, including root cause analysis.
- Collaborate with Business Analysts, QA, Release Management, Operations, and Infrastructure teams.
- Participate in application support activities, including occasional after-hours support.
- Ensure compliance with healthcare and regulatory requirements.

Required Skills & Qualifications

- Minimum 6+ years of experience in database design, development, and support.
- Strong hands-on experience with SQL Server 2016 or higher.
- Expertise in writing complex SQL queries.
- Strong experience with Stored Procedures, Functions, Triggers, and Packages.
- Hands-on experience in Performance Tuning and Query Optimization.
- Strong understanding of Data Modeling and Database Design.
- Experience with relational databases such as:
  - Microsoft SQL Server
  - Sybase
  - DB2
  - MS Access
- Understanding of data architecture and database best practices.
- Experience creating technical documentation using Visio and Microsoft Office.
- Knowledge of XML, Web Services, and data integration methodologies.
- Excellent analytical, troubleshooting, and problem-solving skills.
- Strong verbal and written communication skills.

Preferred Skills

- Knowledge of .NET applications.
- Exposure to application integration and support.
- Microsoft Fabric knowledge is an added advantage but is optional.

Role Breakdown

- 70% – Database Development (SQL Server)
- 20% – Data Modeling, Performance Tuning & Production Support
- 10% – Application / Integration Exposure (.NET knowledge preferred)