PostgreSQL Database Administrator (DBA) - DBaaS Environment (Level 3)

Intuitive Technology Partners, Inc.; Aurora (CO); Remote; USD 90,000 - 150,000; Full time

Job summary

Join a forward-thinking company as a PostgreSQL Database Administrator, where you will manage a cutting-edge Database-as-a-Service platform. Your expertise will ensure the performance, reliability, and security of PostgreSQL databases in a dynamic, multi-cloud environment. Collaborate with DevOps and cloud engineers to architect scalable solutions, automate workflows, and mentor junior DBAs. This role offers the opportunity to work on innovative projects while utilizing the latest technologies in cloud computing and database management. If you're passionate about database technologies and looking to make a significant impact, this is the role for you.

Benefits

Flexible Working Hours

Health Insurance

Remote Work Opportunities

Professional Development

Performance Bonuses

Qualifications

• 8+ years as PostgreSQL DBA with cloud experience.
• Expertise in PostgreSQL 12+, HA/DR tools, and automation.

Responsibilities

• Design and configure PostgreSQL clusters in DBaaS environments.
• Optimize database performance and ensure high availability.

Skills

PostgreSQL

Cloud Platforms (AWS, Azure, GCP)

Performance Tuning

Scripting (Python/Shell)

Automation

Monitoring (Prometheus, Grafana)

High Availability & DR

Soft Skills (Analytical, Communication)

Education

Bachelor’s in Computer Science

Equivalent Experience

Tools

Terraform

Ansible

pgBadger

ELK Stack

Barman

Docker

Job description

Database

Remote

Contract

Title: PostgreSQL Database Administrator (DBA)- DBaaS Environment (L3)
Start Date:Immediate
Position Type:Contract
Location: Remote across USA

Job Description
We seek a seasoned PostgreSQL DBA to manage our cloud-based Database-as-a-Service (DBaaS) platform. You will ensure optimal performance, reliability, and security of PostgreSQL databases while collaborating with DevOps, cloud engineers, and clients. Your role will involve architecting scalable solutions, automating workflows, and mentoring junior teams in a dynamic, multi-cloud environment.

Key Responsibilities

• Architecture & Deployment: Design, install, and configure PostgreSQL clusters in DBaaS (AWS, Azure, GCP) using IaC tools (Terraform, Ansible).
• Performance Tuning: Optimize queries, indexing, and vacuum strategies; troubleshoot latency/issues using tools like pgBadger, EXPLAIN ANALYZE.
• High Availability & DR: Implement replication (streaming/logical), Patroni, repmgr, and PITR/WAL archiving for 24/7 uptime.
• Security: Enforce encryption (TDE, SSL), RBAC, audit logging, and compliance (GDPR, HIPAA).
• Automation: Script provisioning, backups, scaling (Python/Shell), and integrate with CI/CD pipelines.
• Monitoring: Set up Prometheus/Grafana dashboards, configure alerts, and analyze logs (ELK Stack).
• Capacity Planning: Forecast resource needs, optimize storage, and manage costs in cloud environments.
• Mentorship: Guide L1/L2 DBAs, conduct knowledge sharing sessions.
• On-Call Support: Resolve critical outages and perform root-cause analysis.

PostgreSQL Database Administrator (DBA) - DBaaS Environment (Level 3)

• Database

• Remote

• Contract

Title: PostgreSQL Database Administrator (DBA)- DBaaS Environment (L3)
Start Date:Immediate
Position Type:Contract
Location: Remote across USA

Job Description
We seek a seasoned PostgreSQL DBA to manage our cloud-based Database-as-a-Service (DBaaS) platform. You will ensure optimal performance, reliability, and security of PostgreSQL databases while collaborating with DevOps, cloud engineers, and clients. Your role will involve architecting scalable solutions, automating workflows, and mentoring junior teams in a dynamic, multi-cloud environment.

Key Responsibilities

• Architecture & Deployment: Design, install, and configure PostgreSQL clusters in DBaaS (AWS, Azure, GCP) using IaC tools (Terraform, Ansible).
• Performance Tuning: Optimize queries, indexing, and vacuum strategies; troubleshoot latency/issues using tools like pgBadger, EXPLAIN ANALYZE.
• High Availability & DR: Implement replication (streaming/logical), Patroni, repmgr, and PITR/WAL archiving for 24/7 uptime.
• Security: Enforce encryption (TDE, SSL), RBAC, audit logging, and compliance (GDPR, HIPAA).
• Automation: Script provisioning, backups, scaling (Python/Shell), and integrate with CI/CD pipelines.
• Monitoring: Set up Prometheus/Grafana dashboards, configure alerts, and analyze logs (ELK Stack).
• Capacity Planning: Forecast resource needs, optimize storage, and manage costs in cloud environments.
• Mentorship: Guide L1/L2 DBAs, conduct knowledge sharing sessions.
• On-Call Support: Resolve critical outages and perform root-cause analysis.

Qualifications

• Education: Bachelor’s in CS, IT, or related field (or equivalent experience).
• Experience: 8+ years as PostgreSQL DBA, 4+ years in DBaaS/cloud environments.

Technical Skills:

• Expertise in PostgreSQL 12+, extensions (pg_partman, pgAudit).
• Cloud platforms (AWS RDS/Aurora, Azure Database, GCP Cloud SQL).
• HA/DR tools (Patroni, repmgr, pgPool), backup tools (Barman, WAL-G).
• Scripting (Python/Shell), IaC (Terraform, Ansible), monitoring (Prometheus, Grafana).
• Soft Skills: Strong analytical, communication, and leadership abilities.

Preferred Qualifications

• Certifications: PostgreSQL Certified Engineer, AWS/Azure/GCP certifications.
• Experience with Kubernetes, Docker, DevOps practices, and multi-cloud strategies.
• Knowledge of other databases (MySQL, MongoDB) and migration tools (pg_dump, AWS DMS).

Apply Now