{"schemaVersion":"jobsearcher.job.v1","id":"1f9cc65734ff23b2ca97c008","url":"https://jobsearcher.com/jobs/1f9cc65734ff23b2ca97c008","canonicalUrl":"https://jobsearcher.com/jobs/1f9cc65734ff23b2ca97c008","title":"Sr. Database Administrator","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.\n\nSummary\n\nAs 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.\n\nKey Responsibilities\n\nQuery 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.\nDatabase 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.\nMigration 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.\nReplication and High Availability: Design, build, and troubleshoot binlog/GTID replication, Aurora replicas, failover behavior, and Multi-AZ configurations on RDS.\nMaintenance 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.\nMonitoring 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.\nDeveloper 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.\nStandards 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.\nData Modeling: Translate business requirements into clean, performant relational models, with an emphasis on MySQL.\n\nWhat You’ll Need to Be Able to Do\n\nRead a slow query log, identify the offending queries, and explain the fix to a developer.\nDiagnose replication lag, lock contention, and deadlocks on a live system.\nPlan and execute a migration cutover or major version upgrade with a rollback path.\nRestore a database to a point in time and verify that the recovered data and database functionality meet the recovery requirements.\nWork independently and within a team of DBAs, developers, and QA, following established standards and collaborating as needed.\nCommunicate clearly in writing and provide timely, concise updates during incidents.\n\nRequired Qualifications\n\n5+ years of DBA experience, with primary expertise in MySQL and working knowledge of SQL Server.\n5+ years of experience tuning query performance, developing index strategies, and analyzing execution plans, primarily in MySQL environments.\nHands-on experience with MySQL replication (binlog/GTID), failover, and backup/recovery.\nExperience refactoring complex SQL code, including stored procedures, functions, and transactional logic.\n3+ years of relational data modeling and schema design.\nDemonstrated ability to work independently and within a team environment.\nDemonstrated ability to follow, maintain, and promote documented standards and change control processes.\nAbility to participate in an on-call rotation.\n\nPreferred Qualifications\n\nExperience managing or migrating production workloads to AWS Aurora MySQL.\nExperience administering AWS RDS for SQL Server.\nExperience with AWS DMS and/or SCT.\nExperience with both OLTP and analytical/data warehouse workloads.\nExperience with schema version control and deployment tools (Flyway, Liquibase, Yuniql).\nExperience using PowerShell or Bash to automate health checks and maintenance tasks.\n\n#LI-REMOTE\n\nYou 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.","company":"Onesource Virtual","rawCompany":"onesource virtual","city":"Myrtle Point","state":"OR","isRemote":false,"isActive":false,"createdAt":"2026-10-16T11:09:40.293Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Sr. Database Administrator","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.\n\nSummary\n\nAs 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.\n\nKey Responsibilities\n\nQuery 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.\nDatabase 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.\nMigration 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.\nReplication and High Availability: Design, build, and troubleshoot binlog/GTID replication, Aurora replicas, failover behavior, and Multi-AZ configurations on RDS.\nMaintenance 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.\nMonitoring 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.\nDeveloper 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.\nStandards 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.\nData Modeling: Translate business requirements into clean, performant relational models, with an emphasis on MySQL.\n\nWhat You’ll Need to Be Able to Do\n\nRead a slow query log, identify the offending queries, and explain the fix to a developer.\nDiagnose replication lag, lock contention, and deadlocks on a live system.\nPlan and execute a migration cutover or major version upgrade with a rollback path.\nRestore a database to a point in time and verify that the recovered data and database functionality meet the recovery requirements.\nWork independently and within a team of DBAs, developers, and QA, following established standards and collaborating as needed.\nCommunicate clearly in writing and provide timely, concise updates during incidents.\n\nRequired Qualifications\n\n5+ years of DBA experience, with primary expertise in MySQL and working knowledge of SQL Server.\n5+ years of experience tuning query performance, developing index strategies, and analyzing execution plans, primarily in MySQL environments.\nHands-on experience with MySQL replication (binlog/GTID), failover, and backup/recovery.\nExperience refactoring complex SQL code, including stored procedures, functions, and transactional logic.\n3+ years of relational data modeling and schema design.\nDemonstrated ability to work independently and within a team environment.\nDemonstrated ability to follow, maintain, and promote documented standards and change control processes.\nAbility to participate in an on-call rotation.\n\nPreferred Qualifications\n\nExperience managing or migrating production workloads to AWS Aurora MySQL.\nExperience administering AWS RDS for SQL Server.\nExperience with AWS DMS and/or SCT.\nExperience with both OLTP and analytical/data warehouse workloads.\nExperience with schema version control and deployment tools (Flyway, Liquibase, Yuniql).\nExperience using PowerShell or Bash to automate health checks and maintenance tasks.\n\n#LI-REMOTE\n\nYou 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.","datePosted":"2026-10-16T11:09:40.293Z","dateModified":"2026-10-16T11:09:40.293Z","hiringOrganization":{"@type":"Organization","name":"Onesource Virtual","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Myrtle Point","addressRegion":"OR","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"1f9cc65734ff23b2ca97c008"},"url":"https://jobsearcher.com/jobs/1f9cc65734ff23b2ca97c008"}}