Aurora PostgreSQL Database Administrator (DBA)

Job Title: Aurora PostgreSQL Database Administrator (DBA)

Location: Remote

Duration: 6+ months Contract

Hourly Rate: $60-$65/hour

Job Description:

Aurora PostgreSQL Database Administrator (DBA)

Position Overview

Experienced Aurora PostgreSQL Database Administrator (DBA) to design, administer, Eligible to workimize, and support highly available PostgreSQL databases running on Amazon Aurora PostgreSQL. The DBA will be responsible for database reliability, performance, security, backup/recovery, monitoring, and production support across development, test, and production environments.

The ideal candidate has strong hands-on PostgreSQL expertise, extensive AWS/Amazon Aurora experience, and a solid understanding of database performance, high availability, automation, and troubleshooting.

Key Responsibilities

• Administer and support Amazon Aurora PostgreSQL database environments.
• Install, configure, upgrade, patch, and maintain PostgreSQL/Aurora database systems.
• Manage Aurora clusters, read replicas, failover, parameter groups, subnet groups, and endpoints.
• Perform database performance tuning, including:

o Query Eligible to workimization

o Execution plan analysis

o Index Eligible to workimization

o Connection and memory tuning

o Lock and wait-event analysis

o Vacuum and autovacuum Eligible to workimization

• Monitor database health, capacity, performance, and availability using AWS and PostgreSQL monitoring tools.
• Implement and maintain backup, restore disaster recovery, and business continuity strategies.
• Perform point-in-time recovery and support database recovery exercises.
• Troubleshoot production database incidents, performance issues, connectivity problems, replication issues, and failures.
• Manage database security, including users, roles, permissions, encryption, auditing, and access controls.
• Work with application and development teams to review SQL queries, schema designs, indexes, and database-related application issues.

Support database migrations to Aurora PostgreSQL from on-premises DB2 or other database platforms.

• Develop automation and operational scripts using tools such as Python, Lambda, or AWS CLI.
• Establish and maintain database standards, operational procedures, documentation, and runbooks.
• Participate in on-call rotations with customers and provide production support for critical database environments.
• Assist with capacity planning, cloud cost Eligible to workimization, and database modernization initiatives.

Required Qualifications

• 5+ years of experience in database administration with PostgreSQL.
• 2+ years of hands-on experience with Amazon Aurora PostgreSQL.
• Strong understanding of PostgreSQL architecture, administration, and internals.
• Strong experience with SQL, PL/pgSQL, indexes, transactions, locking, and query execution plans.
• Experience with PostgreSQL backup, recovery, replication, and high-availability strategies.
• Strong AWS knowledge, particularly:

o Amazon Aurora

o Amazon RDS

o EC2

o IAM

o CloudWatch

o S3

o Airflow

o Lambda

• Experience troubleshooting database performance using tools such as EXPLAIN, EXPLAIN ANALYZE, PostgreSQL statistics views, Performance Insights, and CloudWatch.
• Experience with database monitoring and alerting.
• Strong scripting/automation skills using Python, or similar languages.
• Experience working with production-critical databases and incident management processes.

Preferred Qualifications

• AWS Certified Database - Specialty or comparable AWS certification.
• PostgreSQL certification or equivalent professional experience.
• Experience migrating databases to Aurora PostgreSQL using AWS Database Migration Service (DMS).
• Experience with CI/CD pipelines.
• Experience with database observability and tools such as Datadog, Grafana or similar platforms.
• Experience with PostgreSQL version upgrades and Aurora major-version upgrades.

Technical Skills

Databases: PostgreSQL, Amazon Aurora PostgreSQL, Amazon RDS

AWS: Aurora, RDS, EC2, VPC, IAM, CloudWatch, S3, KMS, DMS, Lambda, Airflow

Performance: EXPLAIN/EXPLAIN ANALYZE, query tuning, indexing, wait events, locks, vacuum/auto vacuum, connection management

High Availability & DR: Aurora replication, read replicas, failover, backup/restore, Point-in-Time Recovery, disaster recovery

Automation: Python, AWS CLI, Lambda, Airflow

Monitoring: AWS Performance Insights, CloudWatch, PostgreSQL monitoring, Grafana/Prometheus, Datadog

Soft Skills

• Strong analytical and problem-solving skills.
• Excellent troubleshooting and incident-management abilities.
• Ability to work effectively with developers, architects, and infrastructure teams.
• Strong communication and documentation skills.
• Ability to work Consultantly in a fast-paced production environment.
• Strong ownership and attention to reliability, security, and operational excellence.

Typical Experience Level

Senior-level / 6+ years of database administration experience

Success in This Role

Success in this position means maintaining highly available and secure Aurora PostgreSQL environments, proactively improving database performance and reliability, automating routine DBA activities, minimizing production downtime, and partnering effectively with engineering teams to deliver scalable database solutions

Role Descriptions: 5+ years of experience in database administration with PostgreSQL.

2+ years of hands-on experience with Amazon Aurora PostgreSQL.

Strong understanding of PostgreSQL architecture| administration| and internals.

Strong experience with SQL| PL/pgSQL| indexes| transactions| locking| and query execution plans.

Experience with PostgreSQL backup| recovery| replication| and high-availability strategies. Strong AWS knowledge| particularly: o Amazon Aurorao Amazon RDSo EC2o I AM Cloud Watcho S3 Airflowo Lambda

Key responsibilities

Administer and support Amazon Aurora PostgreSQL database environments.

Install| configure| upgrade| patch| and maintain PostgreSQL/Aurora database systems.

Manage Aurora clusters| read replicas| failover| parameter groups| subnet groups| and endpoints.

Perform database performance tuning| including: Query Eligible to workimization Execution plan analysis Index Eligible to workimization Connection and memory tuning Lock and wait-event analysis Vacuum and auto vacuum Eligible to workimization Monitor database health| capacity| performance| and availability using AWS and PostgreSQL monitoring tools.

Implement and maintain backup| restore disaster recovery| and business continuity strategies.

Perform point-in-time recovery and support database recovery exercises.

Troubleshoot production database incidents| performance issues| connectivity problems| replication issues| and failures.

Manage database security| including users| roles| permissions| encryption| auditing| and access controls.

Work with application and development teams to review SQL queries| schema designs| indexes| and database-related application issues.

Support database migrations to Aurora PostgreSQL from on-premises DB2 or other database platforms.

Develop automation and operational scripts using tools such as Python| Lambda| or AWS CLI.

Establish and maintain database standards| operational procedures| documentation| and runbooks.

Participate in on-call rotations with customers and provide production support for critical database environments.

Assist with capacity planning| cloud cost Eligible to workimization| and database modernization initiatives.

Disclaimer: Diverse Lynx LLC is an Equal Opportunity Employer. All applicants and employees are evaluated without discrimination, based solely on their qualifications, ability, competence and performance. This email and its attachments may contain confidential or proprietary information and is intended only for the recipient(s). If you received this message in error, please disregard it and notify the sender. If you no longer wish to receive our communications, you may unsubscribe at any time.

Security Notice: Our official website is www.diverselynx.com We do not operate or authorize any other websites representing Diverse Lynx LLC.