Senior Database Administrator

Key Responsibilities :

• 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 :
• 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.

(ref : hirist.tech)