SQL Developer

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.

• 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. 
• 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.

• 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 (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. 

• 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