Database Administrator - PostgreSQL

Description :

We are seeking an experienced PostgreSQL Database Administrator with strong expertise in managing, optimizing, and securing PostgreSQL databases on AWS.

The ideal candidate will have hands-on experience with Amazon RDS for PostgreSQL, Aurora PostgreSQL, and cloud-native tools for performance tuning, automation, backup, monitoring, and security.

This role requires a proactive individual who can ensure high availability, optimize database workloads, collaborate with development teams, and maintain compliance with security policies.

Key Responsibilities :

- Design, deploy, configure, and maintain PostgreSQL databases on AWS, including Amazon RDS and Aurora PostgreSQL.

- Manage lifecycle activities such as patching, upgrades, parameter tuning, and schema changes.

- Ensure smooth operation, high availability, scalability, and reliability of databases.

- Perform in-depth SQL query tuning, index management, execution plan analysis, and stored procedure optimization.

- Continuously monitor database health using AWS CloudWatch, Performance Insights, Datadog, pg_stat_statements, and other monitoring tools.

- Analyze workloads, identify performance bottlenecks, and implement proactive optimization measures.

- Configure and monitor automated backups, snapshots, and PITR (Point-In-Time Recovery) across AWS environments.

- Implement disaster recovery (DR) strategies using cross-region replication, logical replication, or Aurora global databases.

- Periodically test failover and recovery procedures, ensuring business continuity.

- Implement and maintain security best practices including AWS IAM roles, VPC configurations, KMS-based encryption, and access policies.

- Ensure compliance with company security standards and regulatory requirements.

- Conduct periodic audits, vulnerability assessments, and hardening of DB instances.

- Set up advanced monitoring and alerting using CloudWatch, Datadog, Prometheus, or related tools.

- Automate routine administrative tasks such as backups, housekeeping, patching, and performance reporting.

- Collaborate with DevOps & development teams to integrate database operations into CI/CD pipelines.

- Work closely with application developers to optimize database queries, stored functions, schema designs, and data workflows.

- Provide on-call support and troubleshoot production issues with quick turnaround time.

- Proactively communicate upcoming incidents, risks, or bottlenecks to stakeholders.

- Regularly review DB instance sizing, storage usage, and performance insights to recommend cost optimization measures.

- Provide guidance on database lifecycle management and instance right-sizing.

- Maintain comprehensive documentation of architecture diagrams, upgrades, configurations, troubleshooting steps, and best practices.

- Update playbooks, SOPs, and DR procedures regularly.

Key Requirements :

Technical Skills :

- Bachelors degree in Computer Science, Engineering, or related field.

- Strong hands-on experience with PostgreSQL administration and AWS cloud-based database services.

- High proficiency in SQL, performance tuning, query optimization, and stored procedures.

- Experience with AWS services including RDS, Aurora PostgreSQL, IAM, VPC, KMS, CloudWatch, and related tools.

- Familiarity with PostgreSQL extensions such as PostGIS, pg_stat_statements, logical replication, etc.

- Experience with monitoring tools such as Datadog, CloudWatch metrics, and AWS Performance Insights.

- Solid understanding of backup/restore, DR strategies, replication techniques, and availability architectures.

- Knowledge of automation scripts using Shell, Python, Terraform, or CloudFormation (optional but valuable)