Database Administrator: Engineer for MySQL DBA and Postgres DBA

Minimum 1.5 years of experience in MySQL Database Administratrations. Secondary database knowledge of Postgres database preferred

A Good Knowledge of MySQL database replication

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 workplace

Experience working in a team-oriented, collaborative environment

Good written and oral communication skills

MySQL cluster technologies experience is also preferred.

Installing and Configuring PostgreSQL from source or packages on Linux machines.





Setup and maintenance of postgres master-slave clusters utilizing streaming replication (BDR)

Maintaining custom vacuum strategies at table and db level

Education:

Bachelors/Maters degree (BSc/BE/BTech/MCA)

Certification:

MySQL Administrator Certified (Preferred)

ITIL (desirable)

Roles Responsibilities

Installation of various MySQL and PostgreSQL databases on x64-bit Linux Operating System

Ability to work Independently, self-starter, positive team player with strong problem solving and troubleshooting skills

Migrating data from one version to another or from different databases.

Creating Database Maintenance plans, rebuild/ reorganize indexes performing integrity checks

Experience in performance analysis and/or performance optimizations.

Perform Database Backups, Recovery, Restore

Server performance debugging (event log, request monitoring)

Work closely with different teams like development, operations, security, and external stakeholders.

Able to manage multiple tasks effectively and forecast/plan different database activities

Work on Current Features, Migrations POC''s and different DB projects.

Provide support when necessary.

📌 Engineer Cloud Operations Chennai (India)
🏢 Tata Communications
📍 India