Job Description:
As a Senior Database Administrator, you will be responsible for managing and maintaining highly available EDB PostgreSQL and MySQL database environments. Your role will include database architecture design, performance tuning, replication setup, backup and recovery, and ensuring data security. You will also provide expertise in cloud migrations and ensure database environments meet high availability and disaster recovery requirements.
Key Responsibilities:
- Database Management:
- Install, configure, and maintain EDB PostgreSQL and MySQL databases.
- Manage database schemas, perform upgrades, and apply patches.
- Monitor database health, availability, and performance across multi-node clusters.
- Ensure high availability and disaster recovery setups using replication, clustering, and failover mechanisms.
- Performance Tuning and Optimization:
- Conduct performance tuning and optimization for SQL queries, indexes, and overall database design.
- Monitor and optimize resource utilization (CPU, memory, storage) for both EDB PostgreSQL and MySQL.




- Troubleshoot and resolve performance bottlenecks and database-related application issues.
- Backup and Recovery:
- Implement robust backup strategies, including full, incremental, and point-in-time backups.
- Plan and perform database recovery operations to ensure minimal data loss.
- Use tools such as pgBackRest, WAL archiving, MySQL dump, and physical and logical backup techniques.
- Replication and Clustering:
- Set up and maintain replication (e.g., streaming replication, logical replication) and clustering solutions.
- Configure and manage failover solutions to enhance database resilience and availability.
- Administer and troubleshoot EDB Postgres Advanced Server tools like EFM (EDB Failover Manager), PG Pool, and PG Bouncer.
- Database Security and Compliance:
- Implement security best practices, including role-based access control and encryption.
- Ensure compliance with regulatory and security standar

📌 Postgres SQL EDB (Delhi)
🏢 Innominds Software
📍 Delhi