PostgreSQL DBA with DevOps Experience -W2 Contract

Overview

On Site
$40 - $50
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

Database Administration
Collaboration
Confluence
Continuous Delivery
Continuous Integration
Archiving
Google Cloud Platform
Grafana
High Availability
JIRA
DevOps
Disaster Recovery
Docker
GitHub
GitLab
Good Clinical Practice
Bash
CentOS
Cloud Computing
Clustering
Management
Microsoft Azure
Database
Database Security
Jenkins
Performance Tuning
Python
Query Optimization
Kubernetes
Linux Administration
Migration
MongoDB
NoSQL
PostgreSQL
Agile
Amazon RDS
Amazon Web Services
Ansible
Apache Cassandra
Remote Desktop Services
SQL
SQL Azure
Scripting
Shell
Slack
Backup
Recovery
Red Hat Linux
Redis
Regulatory Compliance
Replication
Streaming
Terraform
Ubuntu

Job Details

Job Title: PostgreSQL DBA with DevOps Experience

Location: Chicago, IL

Job Summary:

We are seeking a skilled PostgreSQL Database Administrator (DBA) with hands-on experience in database administration, performance tuning, backup/recovery, and high availability solutions. The ideal candidate should also bring exposure to DevOps practices, including automation, CI/CD pipelines, and cloud platforms.

Key Responsibilities:

  • Install, configure, and maintain PostgreSQL databases in production and non-production environments.

  • Monitor database health, optimize performance, and troubleshoot issues related to queries, indexes, and replication.

  • Implement database backup, recovery, and disaster recovery strategies.

  • Manage database security, user access, and compliance requirements.

  • Work on database upgrades, patches, and migrations.

  • Configure and support high availability (HA), replication, and clustering solutions (e.g., Patroni, Pgpool, repmgr).

  • Collaborate with development teams to optimize SQL queries and database schema design.

  • Support DevOps initiatives by automating database deployments, integrating with CI/CD pipelines, and managing Infrastructure as Code (IaC).

  • Deploy and manage databases on cloud environments (AWS, Azure, Google Cloud Platform) using services such as RDS, Aurora PostgreSQL, or Cloud SQL.

  • Monitor and log database activities using tools like Prometheus, Grafana, ELK, or CloudWatch.

Required Skills & Qualifications:

  • 8+ years of experience as a PostgreSQL DBA in production environments.

  • Strong expertise in performance tuning, query optimization, and indexing strategies.

  • Hands-on experience with backup/recovery tools (pgBackRest, Barman, WAL archiving).

  • Experience with HA/DR solutions (Patroni, repmgr, Pgpool-II, streaming replication).

  • Solid understanding of Linux systems administration (RedHat, Ubuntu, CentOS).

  • Exposure to DevOps tools:

    • CI/CD (Jenkins, GitLab CI, GitHub Actions, etc.)

    • Containerization (Docker, Kubernetes)

    • Infrastructure as Code (Terraform, Ansible, Helm)

  • Familiarity with cloud database services (AWS RDS/Aurora, Azure Database for PostgreSQL, Google Cloud Platform Cloud SQL).

  • Scripting knowledge (Bash, Python, or Shell) for automation.

Preferred Qualifications:

  • Experience in multi-region database deployments and data replication across clusters.

  • Knowledge of NoSQL databases (MongoDB, Cassandra, Redis) is a plus.

  • Experience in database monitoring and alerting using Grafana, Prometheus, or equivalent tools.

  • Familiarity with agile methodologies and collaboration tools (Jira, Confluence, Slack).

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.