Role:Application Developer( T-SQL )
Location:Montgomery AL (Onsite)
Duration:12+ Months contract to Hire
USC and GC visa Only
Position Details:
Requires full proficiency in T-SQL as identified by the development manager Deliverables:
• Create Stored Procedures
• SSIS ETL Packages
• Unit tests
• Documentation of developed code
• Status updates as requested by the Project Manager and Development Manager
Skills Required:
- Modify and maintain T-SQL stored procedures, views, user-defined functions, and SSIS packages. Advanced T-SQL skills, including CTEs, window functions, joins, dynamic SQL, and error handling.
- Strong experience with stored procedures, scalar/table-valued functions, and views.
- Proficient in SQL Server Management Studio (SSMS) and working in live production environments.
- Triage and resolve incoming production support tickets related to incorrect or missing data.
- Investigate data integrity issues and apply SQL-based fixes safely and efficiently.
- Analyze root causes and recommend long-term solutions to prevent recurring issues.
- Communicate findings clearly to both technical and non-technical stakeholders.
- Track fixes and outcomes for audit/compliance documentation.
- Perform performance tuning and query optimization for high-traffic queries.
- Familiarity with SSIS especially modifying existing packages, understanding workflows, and debugging.
Skills Preferred:
- Create moderate to advance T – SQL Stored Procedures and Triggers.
- Ability to write moderate and advance SQL commands.
- Ability to test and troubleshoot database procedures and ETL Packages.
- Excellent written and verbal communication skills
- Experience developing code using C#, .NET, HTML, or other web front-end technologies
- Ability to document code developed by analyst
- Elicit data requirements by assisting with interviews, document analysis, data requirements workshops, Data process descriptions, use cases, Data analysis, task and workflow analysis.
- SQL Servers version 2012 and later
- Programming business requirements in database language.
Experience Required :
- 5 years of experience in software development experience
- 5 years of experience in database development
- 5 years of experience in tools used for software development (e.g., Visual Studio, Developer Tools, SSRS)
- Experience using TFS as Source Control
- Experience with Agile Scrum project development methodology and able to apply methodology in a practical manner.
Experience Preferred: Experience with State Government, Medicaid, CHIP and DHR business area or healthcare industry
Education Required: Bachelor’s Degree in Computer Science, Information Systems or other related field. Or equivalent work
Education Preferred : SQL certification