Description
You will design, optimize, and manage PostgreSQL database infrastructure and performance on AWS.
This role is on-site.
Responsibilities
- Design and optimize PostgreSQL databases for performance and integrity.
- Manage database operations including monitoring, backup, recovery, and security compliance.
- Execute database migration strategies using AWS DMS, verifying data integrity during transitions.
- Troubleshoot and resolve complex database issues across various systems.
Required Skills
- 5+ years of experience in database administration.
- Strong understanding of PostgreSQL architecture and internals.
- Experience with AWS Aurora features, including high availability and Global databases.
- Proficiency in database design, development, and query optimization.
- Experience with AWS automation tools like CloudFormation (CFT) and Terraform.
- Knowledge of Database Security and Access Management practices.
- Familiarity with Oracle and MongoDB environments.
Preferred Skills
- Experience with Aurora performance and cost optimization strategies.