Insight Global - Dahlgren, VA
posted 2 months ago
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.