PostgreSQL Database Administrator

Location:

Workplace Type:

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