Remote Senior DBA: MySQL/Aurora & SQL Server on AWS

OSV; United States; A distancia; USD 120.000 - 180.000; Jornada completa

Descripción de la vacante

OneSource Virtual (OSV) is seeking a Senior Database Administrator to support migrations of our database footprint into AWS Aurora MySQL and AWS RDS SQL Server. You will focus on MySQL/Aurora query performance tuning, indexing, and refactoring while providing support for SQL Server environments.

Join a collaborative team within our Product Development and R&D groups to optimize performance, mentor engineers on best practices, and ensure reliable backups, maintenance, and cross-engineering

Formación

• 5+ years as a Database Administrator with MySQL focus.
• 5+ years in query performance tuning and index optimization (MySQL/Aurora).
• 3+ years managing/migrating workloads on AWS Aurora MySQL and AWS RDS SQL Server.
• 3+ years relational data modeling, schema conversion, and architecture.
• Hands-on experience refactoring SQL code including stored procedures and functions.

Responsabilidades

• Lead MySQL and Aurora query performance tuning and index strategies.
• Refactor and tune database code for MySQL and SQL Server.
• Migrate schemas and data to AWS Aurora MySQL and AWS RDS SQL Server.
• Mentor developers and review queries for best practices.
• Maintain AWS Aurora MySQL and AWS RDS SQL Server instances and backups.
• Translate business requirements into performant relational models.

Conocimientos

MySQL / AWS Aurora MySQL

SQL Server

Query performance tuning

Execution plan analysis

Team collaboration

Cloud migration knowledge

Herramientas

AWS DMS

AWS SCT

Flyway

Liquibase

Yuniql

Descripción del empleo

OneSource Virtual (OSV) is seeking a Senior Database Administrator to support migrations of our database footprint into AWS Aurora MySQL and AWS RDS SQL Server. You will focus on MySQL/Aurora query performance tuning, indexing, and refactoring while providing support for SQL Server environments.

Join a collaborative team within our Product Development and R&D groups to optimize performance, mentor engineers on best practices, and ensure reliable backups, maintenance, and cross-engineering