Sr. Database Administrator

OSV

United States

Remote

USD 130,000 - 180,000

Full time

9 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Remote-friendly

Job summary

OneSource Virtual (OSV) is seeking a Senior Database Administrator to join the Product Development and R&D DBA team. You will optimize MySQL/Aurora MySQL, migrate Oracle MySQL to Aurora, and support SQL Server workloads on EC2 and RDS for SQL Server, with on-call responsibilities.

Ideal candidates have 5+ years as a DBA with MySQL focus, experience with replication, backups, performance tuning, and strong collaboration with developers and QA in a fast-paced environment.

Qualifications

  • 5+ years of DBA experience focused on MySQL
  • Experience tuning query performance and analyzing execution plans, primarily in MySQL environments
  • Hands-on experience with MySQL replication (binlog/GTID), failover, and backup/recovery
  • Experience refactoring complex SQL code, including stored procedures and transactional logic
  • 3+ years of relational data modeling and schema design
  • Ability to work independently and within a team; follow standards and change control
  • Ability to participate in an on-call rotation

Responsibilities

  • Lead query tuning and performance diagnostics on MySQL/Aurora MySQL and SQL Server
  • Refactor and tune stored procedures, functions, views, and inline queries
  • Migrate Oracle MySQL to Aurora MySQL and migrate SQL Server workloads to RDS for SQL Server
  • Design, build, and troubleshoot replication and high availability configurations
  • Manage parameter groups, backups, and routine maintenance tasks
  • Maintain monitoring and on-call readiness with alerts and incident response
  • Review queries and schema changes before deployment and mentor developers

Skills

MySQL expertise
SQL Server knowledge
Query tuning
Replication experience
On-call readiness

Tools

AWS Aurora
AWS RDS
DMS
PowerShell
Bash

Job description

OneSource 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,600 customers and $250+ 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 on the Product Development and R&D database administration team, you will support and optimize our database platforms while helping migrate Oracle MySQL workloads to AWS Aurora MySQL and SQL Server workloads to Amazon RDS for SQL Server. Your primary focus will be MySQL and Aurora MySQL, including query performance tuning, index design, replication, and day-to-day operations. You will also provide secondary administration and tuning support for SQL Server environments on EC2 and help migrate those workloads to RDS. This role participates in the team’s on-call rotation.

Key Responsibilities
  • Query Performance Tuning: Lead query tuning and performance diagnostics on MySQL and Aurora MySQL using EXPLAIN / EXPLAIN ANALYZE, performance_schema, the sys schema, the slow query log, pt-query-digest, and Aurora Performance Insights. Analyze index strategy, buffer pool behavior, and locking to eliminate bottlenecks. Provide the same support on SQL Server using execution plans and Query Store.
  • Database Code Refactoring: Refactor and tune stored procedures, functions, views, triggers, and inline queries in MySQL (and SQL Server as needed) to improve execution efficiency, error handling, and transactional throughput.
  • Migration to Aurora for MySQL and AWS RDS for SQL Server: Execute schema refactoring, data transformation, and object migrations from Oracle MySQL to Aurora MySQL. Use native methods—including MEB restores from S3, binlog/GTID replication from the external source for cutover, and logical dump/load—where appropriate. Migrate SQL Server workloads to RDS for SQL Server using native backup and restore, and use AWS DMS or SCT when the migration path calls for them. Before cutover, validate compatibility between Oracle MySQL and Aurora MySQL, including versions, parameters, SQL modes, and unsupported features.
  • Replication and High Availability: Design, build, and troubleshoot binlog/GTID replication, Aurora replicas, failover behavior, and Multi-AZ configurations on RDS.
  • Maintenance and Operations: Share operational ownership of Aurora MySQL and RDS for SQL Server by managing parameter group changes, sizing InnoDB buffer pools, maintaining indexes, upgrading engine versions, configuring backups and point-in-time recovery, and routinely testing restores.
  • Monitoring and On-Call: Maintain monitoring and alerting (Performance Insights, CloudWatch, Enhanced Monitoring). Participate in the on-call rotation, responding to production database incidents and following through with root cause analysis.
  • Developer Partnership and Code Review: Review queries and schema changes before deployment, promote team standards and MySQL/Aurora indexing best practices, and mentor developers and QA on query tuning.
  • Standards and Change Control: Follow and maintain the team’s database standards for naming conventions, indexing, schema design, coding practices, parameter configuration, and change management. Deliver changes through the established review and deployment process and encourage developers and peers to do the same.
  • Data Modeling: Translate business requirements into clean, performant relational models, with an emphasis on MySQL.
What You’ll Need to Be Able to Do
  • Read a slow query log, identify the offending queries, and explain the fix to a developer.
  • Diagnose replication lag, lock contention, and deadlocks on a live system.
  • Plan and execute a migration cutover or major version upgrade with a rollback path.
  • Restore a database to a point in time and verify that the recovered data and database functionality meet the recovery requirements.
  • Work independently and within a team of DBAs, developers, and QA, following established standards and collaborating as needed.
  • Communicate clearly in writing and provide timely, concise updates during incidents.
Required Qualifications
  • 5+ years of DBA experience, with primary expertise in MySQL and working knowledge of SQL Server.
  • 5+ years of experience tuning query performance, developing index strategies, and analyzing execution plans, primarily in MySQL environments.
  • Hands-on experience with MySQL replication (binlog/GTID), failover, and backup/recovery.
  • Experience refactoring complex SQL code, including stored procedures, functions, and transactional logic.
  • 3+ years of relational data modeling and schema design.
  • Demonstrated ability to work independently and within a team environment.
  • Demonstrated ability to follow, maintain, and promote documented standards and change control processes.
  • Ability to participate in an on-call rotation.
Preferred Qualifications
  • Experience managing or migrating production workloads to AWS Aurora MySQL.
  • Experience administering AWS RDS for SQL Server.
  • Experience with AWS DMS and/or SCT.
  • Experience with both OLTP and analytical/data warehouse workloads.
  • Experience with schema version control and deployment tools (Flyway, Liquibase, Yuniql).
  • Experience using PowerShell or Bash to automate health checks and maintenance tasks.

#LI-REMOTE

You are encouraged to learn and share ideas when you join the OneSource Virtual team. We reward innovative thinking, fresh perspectives, creative collaboration, and hard work. As an organization experiencing routine strategic growth, we are always on the lookout for intelligent, talented, and forward-thinking professionals to join our team. OSV employees enjoy a values-based culture, upward mobility, and professional development with opportunities of all kinds.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Database Administrator
Sr. Database Administrator

OneSource Virtual • United States

Hybrid
USD 110,000 - 170,000
Remote Senior MySQL/Aurora DBA for AWS Migrations
Remote Senior MySQL/Aurora DBA for AWS Migrations

OSV • United States

Remote
USD 130,000 - 180,000
Remote-friendly
Senior DBA - MySQL/Aurora & SQL Server (Remote)
Senior DBA - MySQL/Aurora & SQL Server (Remote)

OneSource Virtual • United States

Hybrid
USD 110,000 - 170,000
Sr. Software Developer
Sr. Software Developer

OSV • United States

Remote
USD 110,000 - 160,000
Application Support Analyst
Application Support Analyst

Remote Jobs • Dallas (TX)

Remote
USD 60,000 - 80,000
Application Support Developer
Application Support Developer

OneSource Virtual • United States

Remote
USD 65,000 - 90,000
Remote work option
Professional development
Career growth opportunities
Sr. Database Administrator
Sr. Database Administrator

Radiant Info Systems Ltd. • Kansas City (KS)

On-site
USD 80,000 - 100,000
Confidentiality according to EEO guidelines
Manager, Database Administration
Manager, Database Administration

ticketnetwork • South Windsor (CT)

Hybrid
USD 100,000 - 120,000
Medical, Dental, Vision, Life Ins.
401K and more
Paid Time Off and Holidays
+5
Sr. Manger, Specialist Solution Architects - Relational Databases, WWSO, Data & AI GTM
Sr. Manger, Specialist Solution Architects - Relational Databases, WWSO, Data & AI GTM

Amazon Web Services (AWS) • Arlington (VA)

On-site
USD 201,000 - 272,000
Sr. Manger, Specialist Solution Architects - Relational Databases, WWSO, Data & AI GTM
Sr. Manger, Specialist Solution Architects - Relational Databases, WWSO, Data & AI GTM

Amazon Inc. • Seattle (WA)

On-site
USD 201,000 - 272,000
Health insurance
401(k) matching
Paid time off
+1