Senior Database Administrator - Performance Tuning (6-8 yrs)

Requirements :

- 7+ years of experience as a Database Administrator or in a similar role.

- Proficiency in managing Oracle, PostgreSQL, MongoDB, MySQL, and Redis databases.

- Strong understanding of query execution plans, query tuning, and performance optimization.

- In-depth knowledge of disaster recovery principles, including backup/restore operations.

- Familiarity with change request processes and 24x7 support for production environments.

- Experience implementing database security measures and conducting vulnerability assessments.

- Proficiency in troubleshooting and resolving complex database issues.

- Strong analytical, problem-solving, and communication skills.

- Experience with cloud-based database solutions such as AWS RDS or standalone databases or clusters running in EC2

- Knowledge of scripting languages like Python, Bash, or PowerShell for automation.

- Any Database certifications.

- Familiarity with CI/CD pipelines and DevOps practices.

Skills required for each DB :

- Oracle

- Strong knowledge of Oracle database architecture and administration (RAC, ASM).

- Expertise in Oracle SQL and PL/SQL programming.

- Experience in database performance tuning, query optimization, and indexing.

- Hands-on experience with Oracle Data Guard for high availability and disaster recovery.

- Proficiency in managing Oracle backup and recovery using RMAN.

- Knowledge of Oracle Enterprise Manager (OEM) for monitoring and management.

- Experience in patching, upgrading, and migrating Oracle databases.

- Proficiency in implementing database security and user access control policies. PostgreSQL

- Expertise in PostgreSQL database administration, configuration, and optimization.

- Hands-on experience with extensions like PostGIS, pgAudit, or TimescaleDB.

- Proficiency in writing and tuning advanced SQL queries and PL/pgSQL functions.

- Knowledge of database replication (logical and streaming) and failover strategies.

- Experience with PostgreSQL backups, PITR (Point-in-Time Recovery), and recovery techniques.

- Familiarity with tools like pgAdmin, psql, and pgBouncer for database management.

- Proficiency in partitioning, indexing, and table optimization techniques.

- Experience in PostgreSQL version upgrades and migration to/from other database platforms. MongoDB

- In-depth knowledge of MongoDB architecture, including replica sets and sharding.

- Proficiency in designing NoSQL schemas and understanding document-oriented databases.

- Experience in performance tuning, query optimization, and aggregation frameworks.

- Expertise in backup, restore, and disaster recovery processes for MongoDB.

- Familiarity with tools like MongoDB Atlas, Compass, and MongoDB CLI.

- Knowledge of MongoDB security best practices, including user roles and data encryption.

- Experience in monitoring and troubleshooting MongoDB clusters using tools like Ops Manager.

- Understanding of integrating MongoDB with application layers and ORM libraries. MySQL

- Strong knowledge of MySQL database architecture and administration.

- Expertise in writing and optimizing complex SQL queries and stored procedures.

- Experience with MySQL replication (master-slave, master-master) and failover setups.

- Proficiency in MySQL performance tuning, indexing, and query optimization.

- Hands-on experience with backup and recovery using tools like mysqldump and Percona XtraBackup.

- Knowledge of MySQL security features, including user authentication and encryption.

- Familiarity with MySQL Workbench, phpMyAdmin, and CLI tools for database management.

- Experience in managing large-scale MySQL databases in high-availability environments.