SQL Developer

@ Spry Methods
Spry Methodssprymethods.com

SQL Developer

Posted 1 week ago

About the job

Spry Methods supports federal clients with data solutions. We seek a SQL Developer experienced in T-SQL, performance tuning, and Power BI to enhance enterprise reporting and analytics.

Requirements

  • U.S
  • citizenship and Top Secret clearance
  • 6+ years of experience
  • Expertise in T-SQL development
  • Performance tuning skills

Qualifications

  • Bachelor’s in CS or related field
  • Experience troubleshooting T-SQL
  • Knowledge of database architecture
  • Ability to work independently
  • Analytical and organizational skills

Full 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, 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.

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

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

Show full description