Purple Drive
Job Role
: PostgreSQL DBA
Experience: 5+ Years,
Location: St. Louis, MO
Role Overview
The role is for an experienced
PostgreSQL Database Administrator (DBA)
who can manage, maintain, and optimize PostgreSQL databases in production environments. The candidate should be strong in database performance tuning, replication, backup & recovery, and scripting automation.
Experience Required
Minimum
5 years
of hands-on experience as a PostgreSQL DBA or in a database administration role with a strong PostgreSQL focus.
Primary (Core) Skills
PostgreSQL Administration:
Installation, configuration, maintenance, and upgrades. Performance Tuning:
Query optimization, indexing strategies, and tuning PostgreSQL parameters for high-performance systems. Backup & Recovery:
Experience using tools like pg_dump, PITR (Point-In-Time Recovery), and replication setups for data safety. Replication and High Availability:
Proficient with streaming replication, logical replication, and failover mechanisms. Monitoring:
Familiarity with monitoring tools such as pgAdmin, Prometheus, or similar to track performance and health metrics. Scripting & Automation:
Strong command over SQL, Shell scripting, and possibly Python or Ansible for automating DBA tasks. Database Security:
Knowledge of role-based access control, SSL/TLS configurations, encryption, and auditing practices. Secondary / Good-to-Have Skills
Experience with
AWS RDS or Aurora PostgreSQL
environments. Exposure to
Docker, Kubernetes , or other container/orchestration tools. Basic
Linux system administration
knowledge. Familiarity with
NoSQL
databases or other RDBMS (Oracle/MySQL) for migration projects. Understanding of
CI/CD pipelines
for automated database deployment. Key Responsibilities
Manage PostgreSQL environments across production and non-production instances. Perform and validate backups, recovery, and cloning operations. Optimize database performance and troubleshoot slow queries. Set up and maintain replication and high availability strategies. Automate maintenance and monitoring processes through scripting. Implement and maintain database security and compliance standards. Collaborate with developers and DevOps teams for schema design and deployment support.
: PostgreSQL DBA
Experience: 5+ Years,
Location: St. Louis, MO
Role Overview
The role is for an experienced
PostgreSQL Database Administrator (DBA)
who can manage, maintain, and optimize PostgreSQL databases in production environments. The candidate should be strong in database performance tuning, replication, backup & recovery, and scripting automation.
Experience Required
Minimum
5 years
of hands-on experience as a PostgreSQL DBA or in a database administration role with a strong PostgreSQL focus.
Primary (Core) Skills
PostgreSQL Administration:
Installation, configuration, maintenance, and upgrades. Performance Tuning:
Query optimization, indexing strategies, and tuning PostgreSQL parameters for high-performance systems. Backup & Recovery:
Experience using tools like pg_dump, PITR (Point-In-Time Recovery), and replication setups for data safety. Replication and High Availability:
Proficient with streaming replication, logical replication, and failover mechanisms. Monitoring:
Familiarity with monitoring tools such as pgAdmin, Prometheus, or similar to track performance and health metrics. Scripting & Automation:
Strong command over SQL, Shell scripting, and possibly Python or Ansible for automating DBA tasks. Database Security:
Knowledge of role-based access control, SSL/TLS configurations, encryption, and auditing practices. Secondary / Good-to-Have Skills
Experience with
AWS RDS or Aurora PostgreSQL
environments. Exposure to
Docker, Kubernetes , or other container/orchestration tools. Basic
Linux system administration
knowledge. Familiarity with
NoSQL
databases or other RDBMS (Oracle/MySQL) for migration projects. Understanding of
CI/CD pipelines
for automated database deployment. Key Responsibilities
Manage PostgreSQL environments across production and non-production instances. Perform and validate backups, recovery, and cloning operations. Optimize database performance and troubleshoot slow queries. Set up and maintain replication and high availability strategies. Automate maintenance and monitoring processes through scripting. Implement and maintain database security and compliance standards. Collaborate with developers and DevOps teams for schema design and deployment support.