Description

You will manage and optimize large-scale PostgreSQL environments.

Responsibilities

• Execute database procedures including upgrades, backups, recovery, and migrations.
• Perform expert-level installation, configuration, patching, and remote monitoring.
• Profile server resource usage to optimize and tweak system performance.
• Troubleshoot and tune SQL queries and underlying storage engine performance.
• Manage cloud deployments and migrations using AWS services.

Required Skills

• 10+ years of PostgreSQL DBA experience in large, dynamic environments.
• Deep understanding of PostgreSQL storage engines and replication.
• Expertise in SQL coding, query tuning, and performance assessment.
• Hands-on experience with AWS services including EC2, RDS, and Aurora.
• Proficiency in shell scripting and automation.
• Experience with Jenkins, Bitbucket, and Terraform.
• Familiarity with PostgreSQL pgAdmin client connectivity tools.
• Strong knowledge of SDLC and Change-Management principles.
• Practical understanding of data quality, management, and testing strategies.

Key Skills

Education

Bachelor's degree