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.

Key Skills

Education

Any Graduate