SQL Developer

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

Who We’re Looking For (Position Overview):

Spry Methods is seeking a SQL Developer to support a strategic laboratory program for our DOJ FBI customer. The ideal candidate has experience with strong Microsoft SQL Server database administration skills.

What Your Day-To-Day Looks Like (Position Responsibilities):

• Design, develop, optimize, andmaintaincomplex 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 optimizePower BI DAX expressions for advanced reporting and analytics.
• Experienced 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.

What You Need to Succeed (Minimum Requirements):

• U.S. Citizenship with an active Top Secret clearance.
• 6+ years of relevant experience (or equivalent combination of certifications and experience).
• Bachelor’s degree in Computer Science, Information Technology, or related field (oradditionalexperience in lieu of degree).
• Strongexpertisein 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.

Ideally, You Also Have (Preferred Qualifications):

• Experience supporting federal, law enforcement, or scientific organizations.
• Experience migrating on-premises databases to AWS or other cloud platforms.
• Experience assessing and documenting client environments, infrastructure, and operational processes.
• Background in data warehousing, analytics platforms, and reporting solutio

$115,000 - $125,000 a year

Compensation is determined based on relevant experience, technical qualifications, certifications, clearance level, and contract requirements.