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 workplace

* 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)

📌 Mysql Database Administrator _ Chennai (Contract -1 Year)
🏢 Tata Communications
📍 Chennai