Description

You will own the administration, performance tuning, and high availability of PostgreSQL environments on AWS RDS.

This role is remote.

Responsibilities

• Manage AWS RDS instances, including configuration, patching, and security IAM integration.
• Perform query optimization, indexing strategies, and stored procedure development to ensure optimal performance.
• Implement and test backup, recovery, and disaster recovery procedures, including Point-in-Time Recovery (PITR).
• Monitor system health using CloudWatch, configure alerts, and handle capacity planning.
• Lead data migration and ETL processes while maintaining database architecture standards.

Required Skills

• 10+ years of experience in PostgreSQL administration and performance tuning.
• Deep expertise in AWS RDS management, SQL optimization, and replication.
• Strong background in data engineering, ETL processes, and database architecture.
• Proficiency in Pgadmin for database management and administration tasks.
• Experience with high availability configurations and disaster recovery planning.

Preferred Skills

• Experience with infrastructure as code using Terraform or CloudFormation.
• Familiarity with PostgreSQL extensions and streaming replication.
• Proficiency with DBeaver or similar database client tools.

Key Skills

Education

Bachelor's degree