PostgreSQL Database Administrator
PostgreSQL Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Title: PostgreSQL Database Administrator
Location: Nashville TN/Day 1onsite
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 handson 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 problemsolving 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 afterhours oncall 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 2000 tables across multiple schemas.
- The ability to quickly understand application database models and entity relationships and to start demonstrating DBA skillsets in a fastpaced 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 usershelping deliver new features functionality and proactive tuning value to the core business.
Setup and Configuration:
- Architect design and implement PostgreSQL databases on AWS RDS ensuring optimal configuration for performance and scalability.
- Configure parameter groups option groups and security groups for AWS RDS Postgres instances.
- Configure and manage database users roles and
- Set up and manage database instances including multiAZ deployments for high availability.
- Implement automated backups snapshots and point in time recovery configurations.
- Configure monitoring and alerting using AWS CloudWatch and other monitoring tools.
Database Management:
- Manage and maintain PostgreSQL databases with more than 2000 tables across multiple schemas.
- Ensure data is available protected from loss and corruption and easily accessible.
- Perform database tuning optimization and troubleshooting to ensure high performance and availability.
- Implement and manage database security measures including user access controls and data encryption.
- Develop and maintain database backup and recovery procedures.
- Follow operation run books to ensure consistent and reliable database operations.
- Schema Design and Access Patterns:
- Design database schemas access patterns and locking strategies to ensure data integrity and optimal performance.
Scripting and Automation:
Extensive experience with writing shell/bash/Python scripts related to Postgres DB management and automation.
Develop and maintain scripts for automating routine database tasks and processes
Employment Type
Full Time
