SQL Developer

Title: Application Developer Location: Montgomery AL Duration: 12+ Months Contract to Hire Onsite Job Description: Employees in this class are 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 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. • 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 the details and likes figuring out what went wrong and how to fix it. • Can work by themselves when needed, adjust when things change, and write things down clearly so others can understand and use their work later. • Comfortable working in a ticket-driven production support environment, where timely and accurate resolution of issues is critical. 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. • Develop new SSIS/SSRS packages to meet business needs • Working hands-on with all aspects of the System Development Life Cycle. Knowledge of Microsoft Team Foundation Server 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