Description

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

Responsibilities

• Architect and implement PostgreSQL databases on AWS RDS, including the configuration of parameter groups, option groups, and security groups.
• Manage database instances and multi-AZ deployments to ensure high availability and scalability.
• Develop and review complex PL/pgSQL functions, procedures, and other database objects.
• Design database schemas, access patterns, and locking strategies for complex structures.
• Execute performance tuning, capacity planning, and production system monitoring.
• Manage automated backups, snapshots, and point-in-time recovery configurations.
• Provide after-hours on-call support and participate in incident management processes.

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