FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expert-level T-SQL proficiency and extensive experience in optimizing complex queries and managing multi-terabyte databases. Capable of performing root-cause analysis and improving data mining processes while collaborating effectively across departments.
Highest-signal resume keywords
Expert-Level T-SQLQuery OptimizationSQL Server InternalsDatabase Administration FundamentalsMulti-Terabyte Database Experience
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
T-SQLQuery OptimizationExecution PlansIndexingPartitioningStored ProceduresData StructuresRoot-Cause AnalysisData MiningPerformance Tuning
Soft Skills
CollaborationTechnical CommunicationPrioritization
Tools & Technologies
SQL ServerQuery StoreDMVsExtended EventsPowerShellPythonAzure SQL DatabaseAzure SQL Managed Instance
Industry Keywords
Healthcare Payment IntegrityMedical ClaimsPharmacy ClaimsData Warehouse DesignColumnstore Indexing
Tech Stack
Tools & technologiesAzureCloudPythonSQL
About the role
Key responsibilities & impact- Tune complex T-SQL against multi-terabyte claims datasets using execution plans, Query Store, wait statistics, DMVs, and Extended Events, and measure results
- Design and maintain clustered, nonclustered, filtered, and columnstore indexes, partitioning, and statistics strategies
- Monitor database performance and resolve blocking and deadlocks
- Tune tempdb and memory
- Partner with infrastructure on capacity planning, backups, and high availability
- Develop stored procedures, views, and data structures supporting data mining
- Write, run, and monitor SQL analyzing medical and pharmacy claims to uncover overpayments and recovery opportunities
- Investigate slowdowns, data anomalies, and declines in findings through root-cause analysis
- Improve data mining and enrichment processes through tools and automation
- Own small projects end to end, review SQL, coach analysts, and collaborate across departments
Requirements
What you’ll need- 5+ years of hands-on experience as a SQL Server DBA, database engineer, or performance-focused database developer
- Expert-level T-SQL and proven query optimization experience
- Ability to read execution plans, identify bottlenecks, and optimize queries
- Deep knowledge of SQL Server internals, including indexing, statistics, partitioning, Query Store, DMVs, wait stats, and Extended Events
- Experience with multi-terabyte databases, billion-row tables, or enterprise data warehouses
- Database administration fundamentals including backup and recovery, high availability (Always On Availability Groups), security, and monitoring
- Ability to juggle multiple priorities and explain technical tradeoffs to non-technical partners
- Bachelor’s degree in computer science, information systems, or a related field, or equivalent experience
- Bonus: Experience with medical and pharmacy claims or healthcare payment integrity
- Bonus: Azure SQL Database, Azure SQL Managed Instance, or cloud database migrations
- Bonus: Automation with PowerShell or Python
- Bonus: Data warehouse design and columnstore indexing
Benefits
Comp & perks- Work from anywhere in the US
- Top Medical/Dental/Vision offerings
- FSA/HSA
- Tuition reimbursement
- Competitive salary
- 401(k) with company match
- Additional health and wellness benefits and perks
- Flexible and trusting environment where you’ll feel empowered to do your best work