OneSource Virtual
OneSource Virtual
OneSource Virtual furnizează procese de afaceri ca serviciu (BPaaS) pentru organizațiile care utilizează Workday. Serviciile sale sprijină salarizarea, administrarea beneficiilor și operațiunile financiare și contabile, combinând automatizarea proceselor cu expertiză specializată și asistență proactivă. Compania ajută clienții Workday să îmbunătățească acuratețea administrativă, să reducă volumul de muncă manuală și să își utilizeze mai eficient resursele interne.

Senior Database Administrator, MySQL and AWS

Lead database performance tuning and operations for OneSource Virtual’s Workday payroll, benefits, and finance solutions. Manage MySQL, Aurora, and SQL Server environments while supporting AWS migration and optimization.

Descriere

  • Lead performance tuning and diagnostics for MySQL, AWS Aurora MySQL, and SQL Server databases.
  • Inspect execution plans, indexing, and memory use to resolve bottlenecks and improve response times.
  • Refactor and tune stored procedures, views, triggers, and inline queries.
  • Migrate schemas, data, and database objects to AWS Aurora MySQL and AWS RDS for SQL Server.
  • Apply native database tools and AWS migration services, including DMS and SCT.
  • Review queries before deployment and uphold MySQL and Aurora indexing practices.
  • Coach developers and engineering teams in query tuning.
  • Operate AWS Aurora MySQL and AWS RDS for SQL Server instances.
  • Configure parameter groups, tune the InnoDB buffer pool, maintain indexes, and check backups.
  • Turn business needs into relational data models and data transformation logic.

Cerințe

  • At least five years of hands-on database administration experience, with primary expertise in MySQL and secondary expertise in SQL Server.
  • At least five years focused on query tuning, index optimization, and execution plan analysis, especially for MySQL and Aurora.
  • Hands-on experience analyzing and refactoring complex SQL, including stored procedures, functions, and transactional logic.
  • At least three years managing or migrating database workloads on AWS Aurora MySQL and AWS RDS for SQL Server.
  • At least three years of experience in relational data modeling, schema conversion, and database architecture.
  • Deep knowledge of MySQL and Aurora query tuning, engine internals, and index design.
  • Working knowledge of SQL Server.
  • Experience analyzing execution plans with EXPLAIN and Query Store.
  • Strong understanding of relational schema design, indexing, and locking and concurrency behavior.
  • Preferred: Practical experience with AWS Database Migration Service (DMS) or AWS Schema Conversion Tool (SCT).
  • Preferred: Experience supporting OLTP and analytical or data warehousing workloads.
  • Preferred: Familiarity with Flyway, Liquibase, or Yuniql.
  • Preferred: Experience with PowerShell or Bash scripting.
  • Collaborative approach, strong problem-solving skills, and clear technical communication.

Beneficii

  • A values-based culture.
  • Opportunities for career advancement.
  • Professional development opportunities.
  • Opportunities to learn and exchange ideas.
  • A collaborative, creative work environment.

Locuri de muncă similare

Hearst Health

Digital Media Advisor, Outside Sales — Hearst Health

Hearst Health

Sell Hearst Health’s digital marketing solutions to small and midsize businesses. Build client portfolios, pitch marketing strategies, and grow accounts through consultative outside sales.

Deschide
Northern Star Resources Limited

Reliability Planning Project Coordinator — Alaska

Northern Star Resources Limited
1.001 – 5.000 Angajați
B2BÎntreprindere

Lead maintenance reliability, planning, scheduling and project execution at Northern Star Resources’ remote Alaska gold-processing plant. Improve work management discipline and equipment performance across the site.

Deschide