Remote MySQL DB Engineer II: Automation & Migrations

AgreeYa Solutions, Inc.; United States; Remote; USD 95,000 - 150,000; Full time

Job summary

AgreeYa Solutions, Inc. is seeking a Database Engineer II for a remote, six-month contract. You will respond to on-call issues, deploy and optimize MySQL infrastructure, and design data migrations and replication strategies to support game services.

The role emphasizes automation, monitoring, and cross-team collaboration with developers. You will work with cloud-based and on-prem MySQL deployments, require 3–4 years of database administration experience, and prefer experience with AWS

Qualifications

• 3 years database administration experience with cloud and on-prem MySQL
• 4 years database administration experience with large-scale Relational MySQL databases
• Experience with full database development life cycle
• Proven ability to administer, maintain, and recover MySQL databases
• Proven ability to design automated data migrations using replication, code, and business logic
• Proven ability to work with development teams on schema, query, and database design
• Ability to optimize Database and SQL Query performance
• Proven experience using monitoring and alerting tools to determine health of your database ecosystem
• Bachelor’s Degree Computer Science, Engineering or equivalent experience.

Responsibilities

• Respond to on call / customer / emergent work relating to database deployments and maintenances
• Configure, deploy, maintain, and optimize database infrastructure to support games and services
• Design and implement routine data migrations between MySQL data sources
• Design and implement replication and backup technologies for MySQL databases
• Design and implement database monitoring and alerting for MySQL stack
• Design and implement relational database schema and queries to support service and game teams
• Design and implement automation to manage Riot’s database infrastructure

Skills

MySQL administration

SQL performance optimization

Automation scripting

Data migrations design

Monitoring & alerting

Team collaboration with developers

Cloud-based MySQL

Go/Python/Java basics

Education

Bachelor’s Degree Computer Science, Engineering or equivalent experience

Tools

AWS RDS/Aurora

Docker

Kubernetes

GoLang

Python

Java

Job description

AgreeYa Solutions, Inc. is seeking a Database Engineer II for a remote, six-month contract. You will respond to on-call issues, deploy and optimize MySQL infrastructure, and design data migrations and replication strategies to support game services.

The role emphasizes automation, monitoring, and cross-team collaboration with developers. You will work with cloud-based and on-prem MySQL deployments, require 3–4 years of database administration experience, and prefer experience with AWS