Mysql Database Administrator _ Chennai (Contract -1 Year)

Primary MySQL DBA Support:

* 8+ years of experience as a MySQL DBA (as primary)

* Secondary database knowledge of Postgres database preferred

* A Good Knowledge of MySQL database replication

* Sound Knowledge on MySQL InnoDB cluster configuration/troubleshooting

* Sound knowledge on Percona Tools / cluster configurations and troubleshooting

* Sound Knowledge on MEM and MEB

* Optimize MySQL database performance

* Responsible for database integrity, security

* Sound knowledge in MySQL backup and Recovery

* Responsible for MySQL DB build, HA Build and Replication configurations

* Estimate MySQL database capacities; develop methods for monitoring database capacity and usage

* Establish mechanisms for data backup/restore of relational databases provide restoration services as needed

* Develop and optimize physical design of MySQL database systems

* Develop application-specific fault-tolerant distributed database mechanisms

* Knowledge of MongoDB or MariaDB or PostgreSQL would be plus

* Able to prioritize and execute tasks in a high-pressure environment

* Experience working in a team-oriented, collaborative environment

* Good written and oral communication skills

* MySQL cluster technologies experience is also preferred.

Secondary Postgres DBA Support:

• Installing and Configuring PostgreSQL from source or packages on Linux machines.
• Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
• Implementing backup and recovery (Logical and Online).
• Setup and maintenance of postgres master-slave clusters utilizing streaming replication (BDR)
• Performing schema management, database sizing, maintaining privileges.
• Data migration while upgrading database versions.
• Extensive experience with Warm Standby (PostgreSQL 9.x and later), and Hot Standby (PostgreSQL 9.x and greater).
• Performance monitoring and optimization
• Installing and configuring Object level replication like Slony etc.
• Installing and configuring connection pooling tools like PgBouncer and pgpool etc.
• Configuring log analyzation tools like pgtune and pgbadger etc.
• Removing the Index bloat Concurrently to improve the performance.
• Scheduled maintenance activities to vacuum, analyse to improve the query response time.
• Maintaining custom vacuum strategies at table and db level.
• DB optimization and troubleshooting

Education:

Bachelors/Maters degree (BSc/BE/BTech)(MCA/MSc/MS/MTech)

Certification:

MySQL Administrator Certified (Preferred)

ITIL (desirable)