- Database Management and Maintenance Design, implement, and maintain robust, scalable, and secure PostgreSQL and MySQL database systems for production, staging, and development environments.

- Conduct database installation, configuration, patching, and upgrades to ensure systems are running on supported and secure versions.

- Develop, manage, and test data backup and recovery procedures to ensure business continuity and minimize data loss risk.

- Implement and manage database replication strategies (e.g., PostgreSQL Streaming Replication, MySQL Group Replication) for high availability and disaster recovery.

- Manage database security, including user access, roles, permissions, and ensuring compliance with established security policies.

- Performance Optimization and Tuning Proactively monitor database systems to ensure optimum performance, stability, and resource utilization.

- Optimize database performance through thorough query tuning, indexing strategies, and server configuration adjustments (e.g., modifying postgresql.conf parameters).

- Analyze and resolve complex database performance issues, deadlocks, and contention problems.

- Conduct regular database health checks and capacity planning to anticipate future resource needs.

- Support and Collaboration Provide L3 support for database-related incidents and outages, participating in on-call rotation as required.

- Collaborate closely with development, DevOps, and IT Operations teams to design efficient database schemas, assist with application performance issues, and automate routine tasks.

- Create and maintain comprehensive documentation for database procedures, architecture, and standards.

Requirements :

- 8-12 years of Database Administrator experience with deep expertise in PostgreSQL.

- Strong proficiency in Database administration.

- Design, implement, and maintain PostgreSQL and MySQL databases.

- Optimize database performance through query tuning, indexing, and configuration.

- Manage replication, backups, and disaster recovery for high availability.