Job Summary

Looking for a seasoned Amazon Aurora PostgreSQL Database Consultant to join our organization. The ideal candidate will have a strong background in managing, optimizing, and troubleshooting Aurora PostgreSQL databases in cloud environments, and will be adept at supporting high availability and scalable solutions.

Key Responsibilities

• Troubleshoot and resolve issues related to Aurora PostgreSQL performance, scalability, reliability, and security.
• Develop automated backup, disaster recovery, and failover strategies tailored for cloud-native Aurora deployments.
• Collaborate with engineering teams to optimize queries, indexes, and schema for maximum performance and efficiency.
• Monitor database health and resource utilization within Aurora clusters, providing actionable insights and proactive recommendations.
• Ensure compliance with data privacy and security standards, including encryption, access controls, and auditing.
• Maintain thorough documentation of configurations, best practices, and operational procedures specific to Aurora PostgreSQL.
• Should have knowledge on DB Migration On-Prem to Cloud

Skill Requirements

• Bachelor’s degree in Computer Science, Information Technology, or equivalent experience.
• Expertise in database design, query optimization, replication, and security for cloud-based PostgreSQL solutions.
• Proficiency in writing and refining SQL queries, procedures, and scripts.
• Experience with AWS ecosystem, including RDS, IAM, CloudWatch, and networking fundamentals.
• Knowledge of Linux/Unix systems and automation tools relevant to cloud database administration.
• Strong analytical, communication, and documentation abilities.

Other Requirements

Preferred CertificationsAWS Certified Database – Specialty or equivalent certifications (preferred, but not required)