PostgreSQL Database Administrator

PostgreSQL Database Administrator

About the Role

Key Responsibilities

• Administer and maintain PostgreSQL databases, ensuring their availability, performance, and security.
• Implement and maintain database security measures, including user access controls and encryption.
• Monitor database performance and identify areas for optimization.
• Perform database backups and recovery procedures.
• Troubleshoot database issues and provide timely resolutions.
• Develop and maintain database documentation.
• Collaborate with development and operations teams to support application deployments and database changes.
• Automate database tasks using Shell and Python scripting.
• Manage and maintain AWS Aurora/RDS PostgreSQL instances.
• Participate in on-call rotation for database support.
• Implement and maintain high availability and disaster recovery solutions.
• Perform database upgrades and patching.
• Conduct performance tuning and query optimization.
• Ensure compliance with data governance and security policies.

Required Skills & Qualifications

• Bachelor's degree in Computer Science or a related field.
• 7-10 years of experience in PostgreSQL database administration.
• Expertise in PostgreSQL administration, including installation, configuration, and maintenance.
• Strong experience with AWS Aurora/RDS PostgreSQL.
• Proficiency in Shell and Python scripting for database automation.
• Solid understanding of database security principles and best practices.
• Experience with database backup and recovery procedures.
• Excellent troubleshooting and problem-solving skills.
• Strong communication and collaboration skills.
• Ability to work independently and as part of a team.
• Must be able to join within Immediate to 15 days notice period.