We are seeking an experienced PostgreSQL DBA with strong expertise in managing PostgreSQL databases in both on-premise and cloud environments (preferably AWS). The ideal candidate will have extensive experience in database administration, performance tuning, migration, automation, and cloud-native services, along with excellent problem-solving and communication skills.

Key Responsibilities

• Manage, maintain, patch, migrate, and upgrade PostgreSQL and AWS RDS databases.
• Configure and administer database security policies, user authentication, and IAM in AWS.
• Implement effective and maintainable database coding practices aligned with architectural best practices.
• Optimize database performance through indexing, partitioning, and advanced tuning techniques.
• Manage PostgreSQL migration projects, including technical estimation and execution.
• Work with AWS services (RDS, S3, EC2) and tools for database operations.
• Support message queuing, full-text indexing, and other high-performance data concepts.
• Utilize Linux OS for database administration, with proficiency in SSH and key-based authentication.
• Automate processes using Jira, GitHub, Ansible, Terraform, and CI/CD pipelines (GitLab).
• Manage batch processes, job scheduling automation, and database integrity checks.
• Ensure data quality, security, and privacy standards in database coding and operations.
• Collaborate with cross-functional teams and provide client-facing support.
• Troubleshoot and resolve complex database issues while identifying alternative solutions.

Required Qualifications

• 7–8 years of experience in managing PostgreSQL databases, including 5+ years in cloud (preferably AWS RDS).
• Hands-on experience with PostgreSQL performance tuning, partitioning, and query optimization.
• Strong knowledge of AWS cloud services (RDS, EC2, S3) and database administration in AWS.
• Working knowledge of EDB, Oracle, and SQL Server.
• Strong Linux OS administration skills.
• Experience with automation tools (Ansible, Terraform) and CI/CD (GitLab).
• Knowledge of batch processes and job scheduling automation.
• Excellent problem-solving, analytical, and communication skills.
• Strong client-facing experience.

Posted By