Exp: 15+ yrs

Location : Chennai

Role: MYSQL DBA - Lead Engineer

No of Positions : 1

Mode: WFO (5 Day)

Shift : 24*7

Key Skills : MYSQL DBA , Postgress, SQL Server, AWS RDS aurora.

Job Description :

Below JD for the MYSQL DBA position.

Job Description – Lead DB Administrator

Work Experience: 15+ years

Role: Sr. Lead Database Administrator

Mandate Skill :

• Strong technical expertise on SQL, NoSQL and databases like PostgresDB, SQL Server, CosmosDB, MongoDB, Cassendra and Cloud DB
• Minimum 10 + years of experience in production DB management
• Working experience on relational database and non relational database administration
• Working experience in advanced DB management, backup/recovery and tuning.
• Has good hands-on MySQL, Postgresql and Maria database installation, creation, configuration and fine tuning
• Good experience in MySQL different versions (MySQL-5.6.x,5.7.x and 8.x)
• MySQL installation and configuration, Monitoring,backup and recovery,Point in time recovery
• MySQL replication concepts(Master-slave, Master-Master, HA availability clusters like Galera etc)
• MySQL Performance tuning and query tuning, DB version upgrade.
• MariaDB - Good experience in MariaDB different versions (MariaDB-10.x,11.x)
• MIria DB Installation, version upgrade, replication, backup and restore, Performance tuning and query tuning and Monitoring
• Must have good experience in AWS cloud MariaDB in ec2 and RDS.
• PostgreSQL - Good experience in AWS PostgreSQL RDS and Aurora.
• Postgresql DB Backup and restore, performance tuning
• Must have good experience in AWS cloud database services like RDS MySQL, Aurora MySQL.
• Redshift - AWS redshift configuration, installation, backup and restore, DB version upgrade, User management,Database Migration.
• Must have good experience in AWS DMS.
• Migration database from physical servers to AWS cloud DB services and configuring ETL replication from RDS to redshift through AWS DMS.
• Should possess work experience on migration/upgradation projects On premise or On-premise to cloud.
• Manage SQL Server databases through multiple product life cycle environments, from development to mission-critical production systems.
• Have a good understanding and exposure on project deliverables and timely delivery.
• MongoDB - MongoDB installation, backup and restore, user management.
• Good to have knowledge in AWS document DB.
• Experience with Linux and Windows Server environments
• Extensive experience with database technologies (MySQL, Maria, PostgreSQL,Redshift MongoDB)
• Experience with cloud services (AWS, Microsoft Azure) a plus