Advanced Systems Design - Application Developer

Client: Advanced Systems Design

Location: Montgomery, AL

Contract: undefined

Job Description

Advanced Systems Design is seeking an Application Developer for our client located in Montgomery, AL. This position is onsite in Montgomery, AL, and requires in-person availability starting day 1.

Responsible for performing moderately to highly complex programming and systems analysis work on projects with integrated systems that impact multiple applications to support end-user needs. Requires full proficiency in T-SQL as identified by the development manager.

• Create Stored Procedures
• SSIS ETL Packages
• Unit tests
• Documentation of developed code
• Status updates as requested by the Project Manager and Development Manager

Requirements

Required Qualifications:

• 5 years of experience in software development
• 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 it practically.
• 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.
• Solid understanding of data structures, relational modeling, and normalization.
• Comfortable navigating and fixing issues without always having step-by-step documentation.
• Possesses a strong analytical mindset with a natural drive to identify root causes and deliver effective, sustainable solutions.
• Maintains focus when addressing live production issues.
• Pays attention to details and likes figuring out what went wrong and how to fix it.
• Can work independently, adjust to change, and document work clearly for others.
• Comfortable working in a ticket-driven production support environment, where timely and accurate resolution of issues is critical.

Preferred Qualifications:

• Create moderate to advanced T-SQL Stored Procedures and Triggers.
• Ability to write moderate and advanced 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 the analyst.
• Elicit data requirements through interviews, document analysis, workshops, use cases, and workflow analysis.
• Experience with SQL Server versions 2012 and later.
• Programming business requirements in database language.
• Develop new SSIS/SSRS packages to meet business needs.
• Hands-on experience with the System Development Life Cycle.
• Knowledge of Microsoft Team Foundation Server.
• Experience with State Government, Medicaid, CHIP, and DHR business areas or healthcare industry.

Education Required

• Experience with State Government, Medicaid, CHIP, and DHR business area or healthcare industry.

Education Preferred

• SQL certification.