Senior SQL Developer - T-SQL, Performance Tuning & Power BI

Method, Inc.; Virginia (MN); On-site; USD 115,000 - 125,000; Full time

Job summary

Spry Methods is seeking a SQL Developer to support a DOJ FBI program. The ideal candidate has strong Microsoft SQL Server administration skills and 6+ years of relevant experience, plus U.S.

Citizenship and Top Secret clearance. You will design, develop, and optimize T-SQL queries, implement index and statistics strategies, build Power BI datasets and DAX expressions, and create ER diagrams to enable enterprise reporting.

Qualifications

• U.S. Citizenship with an active Top Secret clearance.
• 6+ years of relevant experience (or equivalent certifications and experience).
• Bachelor’s degree in Computer Science, Information Technology, or related field (or additional experience in lieu of degree).
• Strong expertise in T-SQL development, performance tuning, and query optimization.
• Solid understanding of database architecture, design principles, and normalization.
• Proven ability to troubleshoot and resolve complex T-SQL performance problems.
• Strong communication, analytical, and organizational skills.
• Ability to work independently and collaboratively in a team environment.

Responsibilities

• Design, develop, optimize, and maintain complex T-SQL queries, stored procedures, functions, views, and database scripts to support enterprise applications and reporting requirements.
• Monitor and tune database performance through query optimization, indexing strategies, and execution plan analysis.
• Develop, manage, and continuously improve index management and statistics optimization.
• Develop, design, and support Power BI datasets, ensuring efficient integration with SQL queries, views, and underlying data models.
• Develop and optimize Power BI DAX expressions for advanced reporting and analytics.
• Experience with design and implementation of complex data structure types and integrations across multiple organizational units
• Experience with mapping and creating entity relationship diagrams
• Ensure database performance through proactive query optimization.

Skills

T-SQL development

Query performance tuning

Query optimization

Power BI datasets

Power BI DAX expressions

Data modeling / ER diagrams

Database design principles

Communication & collaboration

Education

Bachelor's degree in Computer Science / IT or related field

Experience in lieu of degree

Tools

SQL Server

Power BI

AWS / Cloud data platforms

Job description

Spry Methods is seeking a SQL Developer to support a DOJ FBI program. The ideal candidate has strong Microsoft SQL Server administration skills and 6+ years of relevant experience, plus U.S.

Citizenship and Top Secret clearance. You will design, develop, and optimize T-SQL queries, implement index and statistics strategies, build Power BI datasets and DAX expressions, and create ER diagrams to enable enterprise reporting.