Sr. Database Administrator

OneSource Virtual; United States; Hybrid; USD 110,000 - 170,000; Full time

Job summary

OneSource Virtual is seeking a Senior Database Administrator to drive performance tuning for MySQL/Aurora and manage migrations to AWS Aurora MySQL and AWS RDS SQL Server. You will join a DBA team supporting cloud-based database platforms and work with developers to optimize data access patterns.

Ideal candidates have 5+ years of DBA experience, strong query tuning skills, and hands-on AWS migration experience.

Qualifications

• 5+ years of hands-on DBA experience with MySQL and SQL Server.
• Proven ability to tune queries, optimize indexes, and analyze execution plans.
• Experience managing migrations to AWS Aurora MySQL / AWS RDS SQL Server.

Responsibilities

• Lead MySQL/Aurora performance tuning and index design.
• Refactor and optimize stored procedures, views, triggers, and inline queries.
• Collaborate with DBAs and developers on cloud migrations and schema changes.

Skills

MySQL / Aurora

Query performance tuning

Execution plan analysis

SQL Server basics

Data modeling

Team collaboration

Tools

AWS DMS

AWS SCT

Flyway

Liquibase

Yuniql

PowerShell

Bash

Job description

## Sr. Database AdministratorApply: US-Remote: Full time: Posted Today: REQ-2026-351OneSource Virtual (OSV) has worked exclusively with Workday customers since 2008 to deliver compliant, in-tenant technology and expert services to automate the administrative, transactional tasks of payroll, taxes, earned wage access, accounts payable, and benefits. With over 1,500 customers, 92% retention, and $225+ billion in treasury movement annually, OSV helps organizations maximize their Workday investment and operate it with confidence. Payroll, benefits, and finance solutions — all in one place. **Summary**As a Senior Database Administrator, you will join our database administration team to support, optimize, and help drive the migration of our database footprint into **AWS Aurora (MySQL)** and **AWS RDS (SQL Server)**. Working within the Product Development and R&D group alongside fellow DBAs, your primary focus will be **MySQL and AWS Aurora MySQL query performance tuning, index optimization, and database engine refactoring**, while also providing secondary administration and tuning support for our SQL Server / RDS environments. **Key Responsibilities*** **MySQL & Aurora Query Performance Tuning:** Lead deep-dive query tuning and performance diagnostics primarily on **MySQL and AWS Aurora MySQL** (along with SQL Server), analyzing execution plans (EXPLAIN, Query Store), index strategies, and memory usage to eliminate bottlenecks and optimize response times.* **Database Code Refactoring:** Analyze, refactor, and tune database logic—including existing MySQL and SQL Server stored procedures, views, triggers, and inline queries—to improve execution efficiency, error handling, and transactional throughput.* **DBA Team Collaboration & Cloud Migration:** Work alongside existing DBAs to execute schema refactoring, data transformations, and object migrations into AWS Aurora MySQL and AWS RDS SQL Server using native tools and AWS migration services (e.g., AWS DMS/SCT).* **Developer Mentorship & Code Review:** Partner with software developers, QA teams, and fellow DBAs to review database queries before deployment, enforce MySQL/Aurora indexing best practices, and mentor engineering teams on query tuning techniques.* **Database Maintenance & Operations:** Share operational responsibilities with the DBA team for maintaining AWS Aurora MySQL and AWS RDS SQL Server instances, including parameter group adjustments, Inno DB buffer pool optimization, index maintenance, and backup validations.* **Data Modeling & Architecture:** Translate complex business requirements into performant, clean relational data models and efficient data transformation logic across both engine ecosystems, with an emphasis on MySQL architecture.**Core Competencies*** Deep expertise in **MySQL / AWS Aurora MySQL** query performance tuning, engine internals, and index design, complemented by working knowledge of **SQL Server**.* Proven capability in analyzing execution plans (EXPLAIN, Query Store) to identify, refactor, and optimize slow queries and underlying stored procedures.* Collaborative team player who thrives working alongside other DBAs and cross-functional engineering teams.* Strong grasp of relational schema design, indexing strategies, and locking/concurrency behavior in dual-engine environments.* High autonomy, strong problem-solving skills, and clear technical communication.**Qualifications****Required*** **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.**Preferred*** Practical experience assisting with cloud migrations using **AWS Database Migration Service (DMS)** or **AWS Schema Conversion Tool (SCT)**.* Experience supporting both **OLTP** (transactional) and analytical/data warehousing workloads.* Familiarity with database schema version control and deployment tools (e.g., Flyway, Liquibase, Yuniql).* Experience with PowerShell or Bash scripting for automated DBA health checks and maintenance tasks. #LI-REMOTE