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 :

(ref : hirist.tech)