Description

You will design, implement, and manage database systems using Amazon Aurora PostgreSQL.

Responsibilities

• Design, deploy, 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 database operations such as backups, monitoring, and scaling.
• Ensure high availability and disaster recovery for mission-critical systems.

Required Skills

• 8+ years of experience working 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.
• Ability to troubleshoot connection problems, query slowdowns, and replication failures.
• Bachelor's Degree.

Preferred Skills

• Experience with database monitoring tools and performance tuning.

Key Skills

Education

Bachelor's Degree