Sr. Database Administrator (MySQL Focus & SQL Server / AWS Cloud)

OSV; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

OneSource Virtual (OSV) is seeking a Senior Database Administrator to support migrations of our database footprint into AWS Aurora MySQL and AWS RDS SQL Server. You will focus on MySQL/Aurora query performance tuning, indexing, and refactoring while providing support for SQL Server environments.

Join a collaborative team within our Product Development and R&D groups to optimize performance, mentor engineers on best practices, and ensure reliable backups, maintenance, and cross-engineering

Qualifications

• 5+ years as a Database Administrator with MySQL focus.
• 5+ years in query performance tuning and index optimization (MySQL/Aurora).
• 3+ years managing/migrating workloads on AWS Aurora MySQL and AWS RDS SQL Server.
• 3+ years relational data modeling, schema conversion, and architecture.
• Hands-on experience refactoring SQL code including stored procedures and functions.

Responsibilities

• Lead MySQL and Aurora query performance tuning and index strategies.
• Refactor and tune database code for MySQL and SQL Server.
• Migrate schemas and data to AWS Aurora MySQL and AWS RDS SQL Server.
• Mentor developers and review queries for best practices.
• Maintain AWS Aurora MySQL and AWS RDS SQL Server instances and backups.
• Translate business requirements into performant relational models.

Skills

MySQL / AWS Aurora MySQL

SQL Server

Query performance tuning

Execution plan analysis

Team collaboration

Cloud migration knowledge

Tools

AWS DMS

AWS SCT

Flyway

Liquibase

Yuniql

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,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

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.