Description

You will design, deploy, and manage mission-critical database systems using Amazon Aurora PostgreSQL.

This role is on-site.

Responsibilities

• Design and maintain database solutions using Amazon Aurora PostgreSQL.
• Optimize performance through indexing, query tuning, and partitioning strategies.
• Manage database security, including user roles, access controls, and encryption.
• Automate operations such as backups, monitoring, and scaling.
• Ensure high availability and disaster recovery for critical systems.

Required Skills

• 8+ years of experience with PostgreSQL databases, specifically Amazon Aurora PostgreSQL.
• Proficiency in writing complex SQL queries, stored procedures, and functions.
• Experience with database clustering, replication, and failover strategies in Aurora.
• Strong understanding of database design, indexing, and optimization techniques.
• Hands-on experience with AWS services including EC2, S3, IAM, and CloudWatch.
• Familiarity with infrastructure-as-code using Terraform or CloudFormation.
• Knowledge of DevOps principles and experience with CI/CD pipelines.
• Bachelor's Degree.

Preferred Skills

• Experience with database monitoring tools and performance tuning.

Key Skills

Education

Bachelor's Degree