About the Role:
We are seeking a highly skilled and experienced PostgreSQL Database Administrator to join our dynamic team. In this role, you will be responsible for the administration, maintenance, and optimization of our PostgreSQL databases, ensuring their reliability, performance, and security. You will work closely with development and operations teams to support our critical business applications. The ideal candidate will have a strong background in PostgreSQL administration, AWS Aurora/RDS PostgreSQL, and scripting languages such as Shell and Python. Experience with SQL Server, Redshift, and Opensearch/ElasticSearch is a plus. This is a fantastic opportunity to contribute to a growing organization and make a significant impact on our database infrastructure.
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.
- 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.