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 expertise in SQL Server database architecture, optimization, and management, with a strong focus on cloud solutions in AWS and Azure. Proficient in performance tuning, disaster recovery planning, and automation using Python and PowerShell.
Highest-signal resume keywords
Senior-Level SQL Server DBA ExperienceT-SQL Query OptimizationAzure SQL Database OptimizationPython AutomationRoot-Cause Analysis
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-SQL Query OptimizationStored Procedure DevelopmentDatabase Architecture DesignDisaster Recovery PlanningPerformance TuningBackup StrategyHA/DR ConfigurationCapacity ForecastingSSIS ExperienceSSAS Experience
Soft Skills
Client CollaborationStakeholder Communication
Tools & Technologies
AWS RDSAzure SQL Managed InstancePower BIPowerShellPython
Industry Keywords
Cloud Database ArchitectureCost OptimizationPerformance SLOsAutomated RemediationIncident Reviews
Tech Stack
Tools & technologiesAWSAzureCloudPythonSQLSSIS
About the role
Key responsibilities & impact- Serve as a trusted advisor to clients, proactively identifying performance, availability, and security risks
- Advise clients on cloud database architecture, migration, and cost optimization across AWS and Azure IaaS and PaaS
- Lead architecture design, disaster recovery planning, and capacity forecasting initiatives
- Own the end-to-end database service lifecycle, including backup strategy, HA/DR configuration, proactive tuning, and platform roadmap planning
- Define and track database availability and performance SLOs
- Drive automated remediation for recurring failure patterns
- Lead root-cause analysis and post-incident reviews for major issues
- Translate incident findings into automation or process changes that prevent recurrence
- Design and implement scalable database structures, including partitioning strategies and audit specifications
- Develop and maintain deployment and rollback scripts
- Coordinate version updates across environments
- Build Python and PowerShell automation for backup validation, monitoring, alerting, and reporting integrations such as Power BI
- Migrate and support SSIS packages and SSAS cubes
- Develop stored procedures for reporting
- Collaborate with client technical teams and executive stakeholders to translate technical findings into business-relevant recommendations
Requirements
What you’ll need- Senior-level SQL Server specialist / Senior-level SQL Server DBA experience
- T-SQL query optimization, including reading and rewriting execution plans, resolving parameter sniffing, statistics/cardinality issues, and Query Store-based tuning
- Rewriting and refactoring stored procedures and T-SQL code for performance
- Designing and maintaining clustered, nonclustered, and covering indexes; evaluating columnstore indexes; managing fragmentation and maintenance
- Root-cause performance diagnosis, including wait-stats analysis, CPU/memory/I-O bottleneck isolation, tempdb contention, and blocking/deadlock resolution
- Hands-on optimization of Azure SQL Database, Azure SQL Managed Instance, and AWS RDS for SQL Server
- Azure and AWS cloud database architecture, migration, and cost optimization across IaaS and PaaS
- Proactive performance baselining and monitoring
- Architecture design, disaster recovery planning, and capacity forecasting
- Backup strategy and HA/DR configuration
- Defining and tracking SLOs for database availability and performance
- Root-cause analysis and post-incident reviews
- Designing scalable database structures, including partitioning strategies and audit specifications
- Deployment and rollback scripting; coordinating version updates across environments
- Python and PowerShell automation
- Backup validation, monitoring, alerting, and reporting integrations such as Power BI
- SSIS and SSAS experience
- Stored procedure development for reporting
- Ability to collaborate directly with client technical teams and executive stakeholders
- Up to 20% domestic US travel for client onsite visits
Benefits
Comp & perks- Full medical benefits
- Full-time employment
- Up to 20% domestic (US) travel for client onsite visits
