- Create and Maintain Staging and Production database health and perform end-to-end DBA activities.
- Provision MySQL instances, both in clustered and non-clustered configurations.
- Ensure database security, access controls and availability of databases.
- Monitor database performance and optimize the database for efficiency and scalability.
- Solve database issues and provide solutions for resolution.
- Collaborate with teams to integrate data across multiple systems.
- Develop and maintain scripts for the automation of database tasks.
- Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
- Prepare documentation and specifications.
- Provide profile server resource usage, optimize and tweak as necessary.
Requirements
- BS/MS degree in Computer Science, Engineering or a related subject.
- Has 6-8 years of Data Base Administration experience in MySQL and Mongo database management.
- Decent experience with recent versions of MySQL and Mongo.
- Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM.
- Experience with replication configuration in MySQL and Mongo DB.
- Knowledge of de-facto standards and best practices in MySQL.
- Proficient in writing and optimizing SQL statements.
- Knowledge of MySQL features, such as its event scheduler.
- Ability to plan resource requirements from high level specifications.
- Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.
- Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases.
- Proven experience with MongoDB scaling across data centers and/or in-depth understanding of MongoDB HA strategies, including replica sets and sharding.
- Experience provisioning and managing Hadoop clusters.
- Strong operational experience with NoSQL Data Modeling.
- Ability to write and maintain Unix/Linux shell scripts.
- Proficient understanding of code versioning tools such as {Git / Mercurial / SVN}.