Description
You will manage and optimize large-scale PostgreSQL and AWS RDS environments.
Responsibilities
- Install, configure, patch, migrate, and upgrade open-source PostgreSQL and AWS RDS databases.
- Implement database coding practices, partitioning, and indexing to ensure architectural stability.
- Manage high availability and resiliency using Aurora Read Replicas and Global Database.
- Execute capacity planning, performance assessments, and query optimization.
- Oversee database migrations, including technical estimation and management.
Required Skills
- 10-12 years of experience in PostgreSQL database management.
- 5 years of experience managing AWS RDS services, including IAM, security policies, and user authentication.
- Deep knowledge of database design, query optimization, index management, and isolation levels.
- Advanced Linux OS proficiency, including remote system management via SSH.
- Hands-on experience with Ansible, Terraform, GitHub, and Jira.
- Experience with PostgreSQL administration tools such as PgBouncer and PgPool.
- Proficiency in troubleshooting complex database issues and evaluating workarounds.
- Working knowledge of AWS services including S3, EC2, and Lambda.
- Experience with Python and CI/CD workflows using GitLab.
- Knowledge of Oracle, SQL Server, and EDB.
Preferred Skills
- Experience with message queuing and full-text indexing.
- Practical experience using AWS Performance Insights and RDS KPI design.