Description

You will architect, administer, and optimize large-scale PostgreSQL environments on AWS RDS for enterprise applications.

This role is on-site.

Responsibilities

• Architect and implement PostgreSQL databases on AWS RDS, managing parameter groups, option groups, and Multi-AZ deployments for high availability.
• Perform performance tuning, optimization, and troubleshooting of production database issues to ensure reliability and scalability.
• Design scalable database schemas, access patterns, and locking strategies for environments with 2,000+ tables.
• Configure automated backups, snapshots, and point-in-time recovery strategies, maintaining strict operational runbooks.
• Develop Shell and Python scripts to automate routine database administration tasks and support incident management.

Required Skills

• Minimum 10 years of experience as a PostgreSQL Database Administrator supporting large-scale enterprise applications.
• Extensive experience with AWS RDS PostgreSQL, including architecture, setup, configuration, and management.
• Minimum 8 years of hands-on experience developing and reviewing complex PL/pgSQL functions, procedures, triggers, and database objects.
• Strong SQL and PL/pgSQL programming skills with expertise in performance tuning and optimization.
• Hands-on experience with shell scripting (Bash/Shell) and Python for database automation.
• Experience with database security, user management, encryption, and access controls.
• Familiarity with DevOps tools such as GitHub, Bitbucket, Bamboo, and Jenkins.
• Experience with AWS CloudWatch and database monitoring tools for production monitoring and capacity planning.
• Bachelor's degree in a relevant field.

Preferred Skills

• Experience with MySQL and Oracle databases.
• Experience supporting Health and Human Services (HHS) applications or large-scale government database environments.

Key Skills

Education

Bachelor's degree