Senior MySQL DBA - Performance & Reliability

PestRoutes.com; McKinney (TX); Presencial; USD 90.000 - 130.000; Jornada completa

Descripción de la vacante

Field Service Holdings, LLC is seeking an experienced MySQL database administrator to ensure performance, availability, and security of clusters of MySQL instances. You will provision instances, monitor resources, and collaborate with the team on migrations, backups, and data integrity.

Responsibilities include documenting specifications, upgrading MySQL versions, and optimizing SQL. Experience with Redis/Elasticsearch and Flyway is preferred.

Formación

• Strong proficiency in MySQL database management.
• Decent experience with recent versions of MySQL.
• Understanding of MySQL storage engines (InnoDB, MyISAM).
• Experience with replication configuration in MySQL.
• Knowledge of best practices in MySQL.
• Proficient in writing and optimizing SQL statements.
• Knowledge of MySQL features like event scheduler.
• Ability to plan resource requirements from high level specs.
• Knowledge of limitations and workarounds vs. other relational databases.
• Proficient with Git/Mercurial/SVN.
• Experience with Redis and Elasticsearch is preferred.
• Experience with Flyway for DB versioning.
• Experience in upgrading MySQL versions.

Responsabilidades

• Provision MySQL instances, clustered and non-clustered configurations.
• Ensure performance, security, and availability of databases.
• Prepare documentation and specifications.
• Handle upgrades, backups, recoveries, migrations.
• Profile server resource usage and optimize.
• Collaborate with team members and stakeholders.
• Identify or create tools to detect data integrity issues.

Conocimientos

MySQL administration

MySQL replication

InnoDB / MyISAM

SQL optimization

Git / Mercurial / SVN

Redis

Elasticsearch

Flyway

MySQL upgrades

Herramientas

Flyway

Descripción del empleo

Field Service Holdings, LLC is seeking an experienced MySQL database administrator to ensure performance, availability, and security of clusters of MySQL instances. You will provision instances, monitor resources, and collaborate with the team on migrations, backups, and data integrity.

Responsibilities include documenting specifications, upgrading MySQL versions, and optimizing SQL. Experience with Redis/Elasticsearch and Flyway is preferred.