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 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.
Skills Required
- 5+ years of hands-on experience as a Database Administrator, primarily with MySQL and secondarily with SQL Server
- 5+ years of dedicated experience in query performance tuning, index strategy optimization, and execution plan analysis
- 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
- Practical experience assisting with cloud migrations using AWS Database Migration Service or AWS Schema Conversion Tool
- Experience supporting both OLTP and analytical or data warehousing workloads
- Familiarity with database schema version control and deployment tools such as Flyway, Liquibase, or Yuniql
- Experience with PowerShell or Bash scripting for automated DBA health checks and maintenance tasks
OneSource Virtual Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about OneSource Virtual and has not been reviewed or approved by OneSource Virtual.
-
Healthcare Strength — Healthcare coverage is presented as comprehensive, including medical, dental, vision, life/disability, and mental-health support, with both copay and HDHP/HSA-style options. Domestic-partner eligibility and standard support services like an EAP are also described as available.
-
Leave & Time Off Breadth — Time-off and flexibility are portrayed as comparatively strong, with PTO/“unlimited” or flexible time-off framing and paid volunteer time referenced. Remote work is repeatedly positioned as a valued part of the overall rewards experience tied to work–life balance.
-
Wellbeing & Lifestyle Benefits — Financial-wellbeing and lifestyle add-ons are highlighted through earned-wage access and wallet-style tools (e.g., myFlexPay/myFlexWallet) alongside mentions of items like a fitness stipend and company-sponsored events. These extras are framed as modern perks that can improve day-to-day benefits usefulness beyond core insurance.
OneSource Virtual Insights
What We Do
OneSource Virtual (OSV) is the Workday partner that has helped more than 1,300 companies with everything from deployment to maintenance to payroll and more—all to make the day more doable. Founded in 2008, OSV pioneered Business Process as a Service (BPaaS) and has become the leading provider of automated solutions for organizations of all sizes using Workday, delivering services with unparalleled choices, unwavering commitment, and uncompromising care.
