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

OneSource Virtual; Oregon; Hybrid; USD 120,000 - 190,000; Full time

Job summary

OneSource Virtual is seeking a Senior Database Administrator to support migration of our database footprint to AWS Aurora MySQL and AWS RDS SQL Server, focusing on MySQL performance, indexing, and refactoring to improve throughput.

You will collaborate with DBAs and developers, tune queries using Explain and Query Store, refactor stored procedures, and help design scalable relational models across dual engines in a hybrid cloud environment.

Qualifications

• 5+ years as a Database Administrator with MySQL focus.
• 5+ years in query performance tuning and execution plan analysis.
• 3+ years migrating workloads to AWS Aurora MySQL and AWS RDS.
• 3+ years relational data modeling and schema design.
• Hands-on refactoring of stored procedures, views, and triggers.

Responsibilities

• Tune MySQL/Aurora queries and optimize execution plans.
• Refactor database code to improve throughput and error handling.
• Collaborate with DBAs to migrate schemas using AWS tools.
• Mentor developers and review queries before deployment.
• Maintain AWS Aurora MySQL and AWS RDS instances including backups.
• Translate business requirements into efficient relational data models.

Skills

MySQL / AWS Aurora MySQL

Query performance tuning

SQL Server

Index design

Relational data modeling

Tools

Flyway

Liquibase

Yuniql

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

QualificationsRequired

• 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.