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