Senior PostgreSQL / Database Administrator (DBA) – On-Prem & AWS RDS
Role Overview
We are seeking an experienced Senior PostgreSQL / DBA with strong expertise in EDB PostgreSQL, Oracle and AWS RDS for PostgreSQL to join our team. The ideal candidate will be responsible for the administration, performance tuning, high availability, and security of mission-critical PostgreSQL databases across hybrid environments.
Experience in Oracle-to-PostgreSQL migrations is a strong plus.
Key Responsibilities
- Manage and administer EDB PostgreSQL databases and AWS RDS for PostgreSQL instances.
- Perform installation, configuration, upgrades, patching, and migration of PostgreSQL / EDB databases.
- Ensure database availability, backup / recovery, replication, and disaster recovery strategies.
- Monitor and optimize database performance, query tuning, and storage usage .
- Implement database security, auditing, and compliance standards .
- Work with application teams to design scalable and highly available database solutions .
- Automate routine DBA tasks using scripting (Python, Shell, etc.) .
- Support database migrations from Oracle to PostgreSQL including schema conversion, data migration, and performance optimization.
- Provide production support , troubleshooting, and issue resolution.
- Collaborate with DevOps / Cloud teams to integrate database management into CI / CD pipelines.
Required Skills & Qualifications
8+ years of experience as a Database Administrator.Strong expertise in PostgreSQL / EDB PostgreSQL administration (installation, upgrades, tuning, backup, replication, HA).Experience with Oracle DBA tasks.Hands-on experience with Oracle-to-PostgreSQL migrations (using tools such as AWS DMS, EDB Migration Toolkit, etc.).Hands-on experience with AWS RDS for PostgreSQL (parameter groups, snapshots, Database insights, monitoring).Solid understanding of PostgreSQL internals , indexes, query execution plans, and performance tuning.Knowledge of backup & recovery strategies (pgBackRest, Barman, native tools).Proficiency in Linux / Unix environments and scripting (Shell, Python, Bash, etc.) .Experience in database security, auditing, and access management .Excellent troubleshooting and problem-solving skills.Nice-to-Have Skills
Exposure to cloud-native monitoring and automation tools (CloudWatch, Terraform, Ansible).Knowledge of other AWS services (VPC, IAM, EC2, Secrets Manager, etc.).Education
Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field