SQL Developer

Technix - Montgomery, AL

Full-time - Mid Level

Montgomery, AL

Professional, Scientific, and Technical Services

About the position

The SQL Developer position is a critical role responsible for developing applications and integration using the Microsoft SQL Server platform while providing technical and production support. This position will involve a variety of tasks including business intelligence, data analysis, reporting, capturing requirements, testing, monitoring, and implementing solutions through a structured software development life cycle. The SQL Developer will work closely with health systems and the Analytics Division to provide analytics support, ensuring that the data needs of the organization are met effectively and efficiently. In this role, the SQL Developer will design and develop reports using Microsoft SQL Server Reporting Services (SSRS) and create ETL packages using Microsoft SQL Server Integration Services (SSIS). The developer will actively participate in meetings with project managers, team leads, analysts, and other agency staff as needed, fostering collaboration and communication across teams. Additionally, the SQL Developer will assist in mentoring and training business analysts, sharing knowledge and best practices to enhance team capabilities. The position requires writing SQL code accurately for quality measures, demonstrating a strong understanding of various databases. The SQL Developer will also be responsible for writing and deploying SQL patches, assisting with schema design, conducting code reviews, and tuning SQL queries for optimal performance. Furthermore, the developer will assist with application schema upgrades and improvements, as well as data upgrades, ensuring that the database systems are up-to-date and functioning efficiently. The role includes developing stored procedures, functions, packages, triggers, and views using SQL, as well as creating scripts to build new database objects.

Responsibilities

• Provides Analytics support to Health Systems and Analytics Division.
• Designs and develops reports in Microsoft SQL Server Reporting Services (SSRS) and ETL packages in Microsoft SQL Server Integration Services (SSIS).
• Actively participates in meetings with project managers, team leads, analysts, and other Agency staff as needed.
• Assists in mentoring and training business analysts.
• Writes SQL code accurately for the quality measures, with an accurate understanding and knowledge of various databases.
• Writes and deploys SQL patches.
• Assists with schema design, code review, and SQL query tuning.
• Assists with application schema upgrades and improvements, and data upgrades.
• Develops stored procedures, functions, packages, triggers, and views using SQL.
• Creates scripts to build new database objects.

Requirements

• Typically has 10+ years of high-tech industry and/or IT work experience.
• Bachelor's Degree in Computer Science, Information Systems, Engineering, or another related field.

Nice-to-haves

• Critical thinking and ability to problem-solving skills is a must.