Description

You will own the administration, performance tuning, and reliability of PostgreSQL environments, primarily on AWS RDS. You will design high-availability architectures, manage data migrations, and enforce security standards.

This role is remote.

Responsibilities

• Administer PostgreSQL databases and optimize query performance through indexing and stored procedures.
• Manage AWS RDS instances, including configuration, scaling, and integration with IAM.
• Implement backup, recovery, and disaster recovery strategies, including Point-in-Time Recovery (PITR).
• Monitor system health using CloudWatch and configure alerting for proactive issue resolution.
• Lead data migration efforts and ETL process improvements to support business data needs.

Required Skills

• 10+ years of experience in database administration, with deep expertise in PostgreSQL.
• Strong proficiency in SQL optimization, query tuning, and execution plan analysis.
• Hands-on experience managing PostgreSQL on AWS RDS.
• Solid understanding of high availability, replication, and disaster recovery mechanisms.
• Experience with data migration, ETL processes, and database capacity planning.
• Familiarity with PostgreSQL security models and IAM integration.

Preferred Skills

• Experience with Infrastructure as Code tools such as Terraform and CloudFormation.
• Knowledge of PostgreSQL extensions and streaming replication.
• Proficiency with database clients like pgAdmin or DBeaver.

Key Skills

Education

Any Gradute