MySQL DBAWork location: Eden Prairie MN or telecommuteWork hours: 7:30am CST start time, on call after hours, weekends as neededProject/initiative summary: Application DBA for Percona MySQL clustersTeam size: 6 membersTeam skill breakdown: 5 DBAs, 1 ManagerTop responsibilities:Operational maintenance and support of 120+ database instances across 15 environmentsPatches, upgrades, proactive/reactive maintenanceSupporting the app dev team (performance tuning, SQL dev)War rooms and incident restorationTop required skills:Strong proficiency in MySQL database management in managing large scale MySQL databases. 5+ yearsDeep understanding of replication and clustering.
Experience with replication configuration in MySQL. 5+ yearsSelf motivated with great communication written and verbal as well as time availability to maintain the relationship with India teamIdeal candidate background: 5+ years of MySQL DBA experienceRequired skills/attributes:Strong proficiency in MySQL database management in managing large scale MySQL databasesDeep understanding of replication and clustering.
Experience with replication configuration in MySQLGood knowledge on MySQL Architecture & Advanced knowledge on InnoDB internalsUnderstanding of MySQLs underlying storage engines, such as InnoDB and other enginesExperience in MySQL installation and upgrade processHands on experience with designing and implementing database high availability solution strategiesExperience on backup solutions and strategiesKnowledge of standards and best practices in MySQLProficient in writing and optimizing SQL statementsKnowledge of limitations in MySQL and their workaroundsExperience administering in LinuxExperience in MySQL user managementPreferred skills:Jenkins pipeline developmentUNIX scriptingProxySQLData partitioningExperience with GitHubExperience with MongoDB, Postgres or OracleInterview process: Very technical, 1 round, video