Senior SQL Developer: T-SQL, Power BI & Data Warehousing

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

Job summary

Spry Methods is seeking a seasoned SQL Developer to support a DOJ FBI program. The role emphasizes strong Microsoft SQL Server administration, T-SQL development, and advanced data modeling with Power BI.

A Top Secret clearance and 6+ years of experience are essential as you design, optimize, and maintain complex data structures across multiple units. Candidates will monitor performance, optimize queries, and implement indexing strategies while collaborating both independently and within a team.

Qualifications

• U.S. Citizenship with an active Top Secret clearance.
• 6+ years of relevant experience (or equivalent).
• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 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 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 improve index management and statistics optimization.
• Develop and optimize Power BI datasets, ensuring efficient integration with SQL queries, views, and data models.
• Develop Power BI DAX expressions for advanced reporting and analytics.
• Work on complex data structures and integrations across multiple organizational units.
• Map and create entity relationship diagrams.
• Ensure database performance through proactive query optimization.

Skills

T-SQL development

Performance tuning

Query optimization

Power BI

Education

Bachelor's degree in CS/IT or related field

Tools

SQL Server

Power BI

AWS

Job description

Spry Methods is seeking a seasoned SQL Developer to support a DOJ FBI program. The role emphasizes strong Microsoft SQL Server administration, T-SQL development, and advanced data modeling with Power BI.

A Top Secret clearance and 6+ years of experience are essential as you design, optimize, and maintain complex data structures across multiple units. Candidates will monitor performance, optimize queries, and implement indexing strategies while collaborating both independently and within a team.