Secret SQL Developer

Insight Global - Dahlgren, VA

Full-time

Dahlgren, VA

Administrative and Support Services

About the position

The Secret SQL Developer position at Insight Global involves a range of responsibilities centered around the evaluation, troubleshooting, and optimization of SQL queries and stored procedures. The role requires performing daily checks of database services and systems to ensure their availability and monitoring the health of database management systems, particularly in terms of resource usage such as memory and CPU. The developer will assist software developers with query design and tuning, ensuring that the database operates efficiently and effectively. In addition to these tasks, the developer will be responsible for performing Extraction, Transformation, and Loading (ETL) of data as necessary, diagnosing and resolving issues within the database management systems during service reductions or failures. The role also includes consulting with system architects and software developers on the design of database objects, which encompasses tables, stored procedures, views, triggers, and indices. Furthermore, the developer will develop, monitor, and maintain any necessary database jobs to ensure the health of the database servers, while also ensuring that the settings for the database servers and individual databases are appropriate for optimal performance. This position is critical in maintaining the integrity and performance of the database systems, and it requires a proactive approach to problem-solving and a strong understanding of relational database management systems, particularly Microsoft SQL Server.

Responsibilities

• Evaluating and troubleshooting SQL queries and stored procedures for optimal performance.
• Performing daily checks of database services and systems to ensure availability.
• Monitoring database management systems for health in terms of resources such as memory and CPU usage.
• Assisting software developers with query design and tuning.
• Performing Extraction, Transformation, and Loading (ETL) of data as necessary.
• Diagnosing and resolving database management systems during service reductions or failures.
• Consulting with system architects and software developers on database object design (tables, stored procedures, views, triggers, indices, etc.).
• Developing, monitoring, and maintaining any database jobs necessary to maintain the health of the database server(s).
• Ensuring that database server and individual database settings are appropriate.

Requirements

• Interim or Active Top Secret clearance.
• Security+ certification (or equivalent IAT II).
• Bachelor's Degree in Computer Science, Engineering, or a relevant degree (or equivalent experience).
• Proven years of experience as an SQL Developer or in a similar role.
• Well-versed in the use of relational database management systems such as Microsoft SQL Server.
• 7 years' experience in relational database design, database administration, and/or database server installation and administration.
• Adept at troubleshooting issues related to database servers including performance, connections, server failures, and more.