Description

You will architect, design, and manage large-scale PostgreSQL database systems within AWS RDS environments.

This role is on-site.

Responsibilities

• Architect and implement PostgreSQL databases on AWS RDS, configuring parameter, option, and security groups.
• Manage database instances and multi-AZ deployments to ensure high availability and scalability.
• Develop, review, and optimize complex PL/pgSQL functions, procedures, and database objects.
• Design database schemas, access patterns, and locking strategies for complex data structures.
• Execute performance tuning, capacity planning, and production system monitoring.

Required Skills

• 10+ years of experience as a PostgreSQL Database Administrator for large-scale applications.
• Extensive experience with AWS RDS Postgres setup, configuration, and management.
• 8+ years of hands-on experience developing complex PL/pgSQL functions and procedures.
• Deep knowledge of PostgreSQL architecture, configuration, and administration.
• Proficiency in SQL and PL/pgSQL programming.
• Experience with database performance tuning and optimization techniques.
• Proven ability to manage environments with over 2,000 tables across multiple schemas.
• Familiarity with database security best practices and backup/recovery strategies.
• Experience with DevOps tools such as Bitbucket, Bamboo, GitHub, or Jenkins.

Preferred Skills

• Knowledge of MySQL or Oracle database systems.
• Experience with large-scale database models related to health and human services applications.

Key Skills

Education

Any Gradute