What are the responsibilities and job description for the My SQL DBA position at Talently Group?
MySQL DBA-
– Eden Prairie, MN
6 Months Contract to Hire
*Must pass a drug test and background check once offered position*
Projects the candidate will be working on:
- Supporting Cirrus databases.
Team and Team size:
- Team is 5 DBAs
Top Responsibilities:
- Operational maintenance and support of 120 database instances across 15 environments.
- Patches, upgrades, proactive/reactive maintenance, supporting the app dev team (performance tuning, SQL dev), war rooms and incident restoration
Software tools/skills:
- Experience in PXC environment & Knowledge /experience with Percona tools and PMM
Skills/attributes:
- Team is split between US and India. Candidate must be self motivated with great communication written and verbal as well as time availability to maintain the relationship with India team.
- Strong proficiency in MySQL database management in managing large scale MySQL databases.
- Deep understanding of replication and clustering. Experience with replication configuration in MySQL .
- Good knowledge on MySQL Architecture & Advanced knowledge on InnoDB internals. Understanding of MySQL’s underlying storage engines, such as InnoDB and other engines.
- Experience in MySQL installation and upgrade process .
- Hands on experience with designing and implementing database high availability solution strategies.
- Experience on backup solutions and strategies
- Knowledge of standards and best practices in MySQL
- Proficient in writing and optimizing SQL statements.
- Knowledge of limitations in MySQL and their workarounds .
- Experience administering in Linux
- Experience in MySQL user management.
Nice to have:
- Jenkins pipeline development
- UNIX scripting
- ProxySQL
- Data partitioning
- Experience with GitHub
- Experience with MongoDB, Postgres or Oracle
Working Time:
Standard business hours usually starting by 8am CST
Job Types: Full-time, Contract
Pay: $65.00 - $70.00 per hour
Experience:
- Percona tools and PMM: 4 years (Preferred)
- PXC: 4 years (Required)
- SQL DBA: 6 years (Preferred)
- My SQL : 6 years (Required)
- Linux: 2 years (Required)
Location:
- Eden Prairie, MN (Required)
Work Location:
- One location
Work Remotely:
- Temporarily due to COVID-19