Database Engineer II

AgreeYa Solutions, Inc.; United States; Remote; USD 95.000 - 150.000; Vollzeit

Zusammenfassung

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

Qualifikationen

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

Aufgaben

• 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

Kenntnisse

MySQL administration

SQL performance optimization

Automation scripting

Data migrations design

Monitoring & alerting

Team collaboration with developers

Cloud-based MySQL

Go/Python/Java basics

Ausbildung

Bachelor’s Degree Computer Science, Engineering or equivalent experience

Tools

AWS RDS/Aurora

Docker

Kubernetes

GoLang

Python

Java

Jobbeschreibung

Title- Database Engineer II

Location- Remote

Duration : 6 Months

Responsibilities:

• Respond to on call / customer / emergent work relating to database deployments and maintenances
• Configure, deploy, maintain, and optimize new and existing database infrastructure to support new and existing games and services
• Design and implement routine data migrations between MySQL data sources as part of routine database consolidation, upgrades and host changes
• Design and implement replication and backup technologies for critical MySQL databases
• Design and implement Database level monitoring and alerting for Client’s MySQL database stack
• Design and implement Relational Database schema and query changes, supporting assorted service and game development teams with their database performance and application needs.
• Design and implement automation to manage Riot’s database infrastructure

Required Qualifications:

• 3 years database administration experience working with cloud based and locally deployed MySQL technologies
• 4 years database administration experience working with large scale Relational MySQL databases
• Experience with full database development life cycle
• Proven ability to administrate, maintain, and recover MySQL databases
• Proven ability to design and implement automated data migrations using replication, code, and business logic between data systems
• Proven ability to work with development teams and service code on schema, query, and database design
• Ability to optimize Database and SQL Query performance
• Ability to solve problems with programming scripts (python, bash etc)
• Ability to implement solutions through automation
• Proven experience using monitoring and alerting tools to determine health of your database ecosystem.
• Bachelor’s Degree Computer Science, Engineering or equivalent experience.

Desired Qualifications:

• Hands on experience with AWS RDS or Aurora
• Experience with Docker, Kubernetes and microservice application developmentLinux systems administration skills (operate the database and the infrastructure)
• Experience programming in GoLang, Python and/or Java
• Ability to speak Korean conversationally