Description

You will act as the single point of contact for Postgres database administration and escalations for the Banking Industry project.

Responsibilities

• Install, configure, patch, migrate, maintain, and upgrade PostgreSQL and AWS RDS platforms.
• Manage day-to-day operations across EDB and AWS services including S3 and EC2.
• Implement effective and maintainable database coding practices that form an architectural foundation.
• Perform Postgres SQL performance improvement, indexing, and partitioning.
• Manage Postgres SQL migration approaches from on-prem to AWS and vice versa.

Required Skills

• 10+ years of experience managing Postgres databases, specifically within the EDB ecosystem.
• 5 years of cloud database experience, preferably AWS, including RDS service management, security policy, IAM, and AWS database administration.
• Advanced understanding of Linux OS and using SSH with password and key pairs.
• Hands-on experience with AWS RDS, capacity planning, and performance assessment.
• Strong production DB administration experience with Postgres/SQL Server.
• Practical experience with monitoring, Performance Insights, and RDS KPI design.
• Hands-on experience with Jira, GitHub, Ansible, and Terraform.
• Familiarity with CI/CD using GitLab and batch job scheduling automation.
• Knowledge of database design principles, query optimization, and isolation levels.

Key Skills

Education

Any Graduate