Senior Database Administrator – MySQL, SQL Server, AWS Cloud

OneSource Virtual

. Lead deep-dive query tuning and performance diagnostics on MySQL, AWS Aurora MySQL, and SQL Server .

Posted 10/13/2026full-timeRemote • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive expertise in MySQL and AWS Aurora MySQL, focusing on query performance tuning, index optimization, and relational data modeling. Proven ability to mentor teams and translate business requirements into effective database solutions.

Highest-signal resume keywords

MySQL Query Performance TuningAWS Aurora MySQL ManagementSQL Server Database AdministrationExecution Plan AnalysisRelational Data Modeling

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Query TuningIndex Strategy OptimizationStored Procedure RefactoringSchema RefactoringData TransformationExecution Plan AnalysisRelational Schema DesignDatabase ArchitectureAWS DMSAWS SCT

Soft Skills

Problem-SolvingTechnical CommunicationTeam Collaboration

Tools & Technologies

AWS RDSEXPLAINQuery StoreFlywayLiquibaseYuniqlPowerShellBash

Industry Keywords

OLTP WorkloadsData WarehousingIndexing Best PracticesConcurrency Behavior

Tech Stack

Tools & technologies

AWSMySQLSQL

About the role

Key responsibilities & impact

Lead deep-dive query tuning and performance diagnostics on MySQL, AWS Aurora MySQL, and SQL Server
Analyze execution plans, index strategies, and memory usage to eliminate bottlenecks and optimize response times
Analyze, refactor, and tune stored procedures, views, triggers, and inline queries
Execute schema refactoring, data transformations, and object migrations into AWS Aurora MySQL and AWS RDS SQL Server
Use native tools and AWS migration services such as AWS DMS/SCT
Review database queries before deployment and enforce MySQL/Aurora indexing best practices
Mentor software developers and engineering teams on query tuning techniques
Maintain AWS Aurora MySQL and AWS RDS SQL Server instances
Adjust parameter groups, optimize the InnoDB buffer pool, maintain indexes, and validate backups
Translate business requirements into relational data models and data transformation logic

Requirements

What you’ll need

5+ years of hands-on experience as a Database Administrator, with primary expertise in MySQL and secondary expertise in SQL Server
5+ years of dedicated experience in query performance tuning, index strategy optimization, and execution plan analysis, with heavy emphasis on MySQL/Aurora
Hands-on experience analyzing and refactoring complex SQL code, including stored procedures, functions, and transactional logic
3+ years of practical experience managing or migrating database workloads on AWS Aurora (MySQL) and AWS RDS (SQL Server)
3+ years of experience with relational data modeling, schema conversion, and database architecture
Deep expertise in MySQL/AWS Aurora MySQL query performance tuning, engine internals, and index design
Working knowledge of SQL Server
Experience analyzing execution plans using EXPLAIN and Query Store
Strong grasp of relational schema design, indexing strategies, and locking/concurrency behavior
Preferred: Practical experience with AWS Database Migration Service (DMS) or AWS Schema Conversion Tool (SCT)
Preferred: Experience supporting OLTP and analytical/data warehousing workloads
Preferred: Familiarity with Flyway, Liquibase, or Yuniql
Preferred: Experience with PowerShell or Bash scripting
Collaborative team player with strong problem-solving skills and clear technical communication

Benefits

Comp & perks

Values-based culture
Upward mobility
Professional development opportunities
Opportunities to learn and share ideas
Creative collaboration