PostgreSQL Database Admin
Required Skills
Minimum of 10 years of strong and relevant experience as a PostgreSQL Database Administrator, specifically for large scale applications.
Extensive experience with AWS RDS Postgres, including setup, configuration, and management.
Strong knowledge of PostgreSQL architecture, configuration, and administration.
Minimum of 8 years of hands-on experience developing and reviewing complex PL/pgSQL functions, procedures, and other database objects.
Extensive experience with database performance tuning and optimization techniques.
Proficiency in SQL and PL/pgSQL programming.
Familiarity with database security best practices.
Experience with backup and recovery strategies.
Strong problem-solving skills and attention to detail.
Excellent communication and collaboration skills.
Ability to work independently and as part of a team.
Flexibility in working hours to support global teams and critical database operations.
Must have experience in production system monitoring and incident management processes.
Must provide after-hours on-call support.
Experience in designing database schemas, access patterns, and locking strategies.
Experience in conducting performance analysis and capacity planning.
Familiarity with DevOps practices and tools (e.g., Bitbucket, Bamboo, Github, Jenkinks).
Preferred Skills
Knowledge of other database systems (e.g., MySQL, Oracle).
Commitment to continuous learning and staying updated with new technologies and industry trends.
Experience working with large scale database models related to health and human services applications is considered a big plus.
Responsibilities:
We are seeking a highly experienced Postgres Database Administrator with a minimum of 10 years of strong and relevant experience. This extensive experience is critical for architecting, designing, setting up, and managing large scale application database systems having complex database structures. The successful applicant should have a proven track record of administrating PostgreSQL databases, specifically within AWS RDS environments. This role demands a proactive individual who can manage, maintain, and optimize our database systems to ensure high availability and performance, especially in environments with more than 2,000 tables across multiple schemas. The ability to quickly understand application database models and entity relationships, and to start demonstrating DBA skillsets in a fast-paced project environment, is essential. Amazon RDS flips role as a DBA around, so you spend only a fraction of your time on routine management tasks. This leaves the rest of your time for aligning your work more closely with the business and value derived from the data assets that you manage. You can then focus on lending your DBA skills to application teams and end users helping deliver new features, functionality, and proactive tuning value to the core business.
Setup and Configuration:
o Architect, design, and implement PostgreSQL databases on AWS RDS, ensuring optimal configuration for performance and scalability.
o Configure parameter groups, option groups, and security groups for AWS RDS Postgres instances.
o Configure and manage database users, roles and
o Set up and manage database instances, including multi-AZ deployments for high availability.
o Implement automated backups, snapshots, and point in time recovery configurations.
o Configure monitoring and alerting using AWS CloudWatch and other monitoring tools.
Database Management:
o Manage and maintain PostgreSQL databases with more than 2,000 tables across multiple schemas.
o Ensure data is available, protected from loss and corruption, and easily accessible.
o Perform database tuning, optimization, and troubleshooting to ensure high performance and availability.
o Implement and manage database security measures, including user access controls and data encryption.
o Develop and maintain database backup and recovery procedures.
o Follow operation run books to ensure consistent and reliable database operations.
Schema Design and Access Patterns:
o Design database schemas, access patterns, and locking strategies to ensure data integrity and optimal performance.
Scripting and Automation:
o Extensive experience with writing shell/bash/Python scripts related to Postgres DB management and automation.
o Develop and maintain scripts for automating routine database tasks and processes.
o Implement a