SQL Developer

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

Perks of Working for Us (Benefits):

Medical Coverage – Cigna - 4 Options

- Traditional - PPO Open Access Plus Network

- (2) HDHP - PPO Open Access Plus Network

- HDHP - EPO Open Access Plus Network

Dental Coverage – Cigna - PPO Base & Buy-Up Plans

Vision Coverage – Principal - VSP Choice Network

Paid Holidays: Full-time employees receive 11 paid federal holidays

Paid Time Off (PTO) – PTO accrual starts at 15 days per year

Training Benefit – Annual training allowance available toward any job-related training or education

401(k) – Multiple Fund Choices through Fidelity with a company match

For our full list of benefits, please visit http://www.sprymethods.com/careers/benefits/