SQL Developer

Lever, Inc.

Quantico, VA, United States

20 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

6 years minimum

Compensation

$115,000.0 - $125,000.0

Working hours

Regular working hours

Job source

jobs.lever.co

Tech stack

Amazon Web Services Databases Data Structures Data Warehousing Entity Relationship Models Microsoft SQL Server Performance Tuning Query Optimization Power BI SQL Stored Procedures SQL Databases Transact-SQL

+4 more

Enterprise Software Applications Database Optimization Database Performance Information Technology

Job description

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.

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