Senior PostgreSQL DBA

Remote contract, 6 + months (ongoing)

East Coast Hours.

Corp to Corp or W2 possible for this role.

Pay rate 70-80 per hr for W2.

Senior level candidates only.

PostgreSQL Database Administrator (DBA)

Job Summary

We are seeking an experienced PostgreSQL Database Administrator (DBA) to install, configure, maintain, monitor, and optimize PostgreSQL database environments. The ideal candidate will ensure database availability, security, performance, and disaster recovery while supporting application development and production operations.

Key Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases.
• Experience with Azure and VM/virtual servers.
• Design, implement, and maintain high-availability and disaster recovery solutions (streaming replication, failover, clustering).
• Monitor database performance and identify bottlenecks.
• Perform query optimization and SQL tuning.
• Manage database backup, recovery, and restoration procedures.
• Configure and monitor replication, partitioning, and indexing strategies.
• Perform database capacity planning and storage management.
• Implement database security, user roles, privileges, and auditing.
• Automate routine DBA tasks using shell scripting, Python, or Ansible.
• Troubleshoot database issues related to performance, locking, deadlocks, and replication.
• Collaborate with developers to optimize database design and application performance.
• Support database migrations, upgrades, and patching with minimal downtime.
• Create and maintain database documentation, standards, and operational procedures.
• Participate in on-call production support when required.

Required Skills

• Strong experience administering PostgreSQL (version 11 or later preferred).
• Expertise in SQL, PL/pgSQL, query optimization, and execution plans.
• Experience with PostgreSQL replication technologies and failover solutions.
• Experience with cloud platforms Azure Database for PostgreSQL
• Knowledge of backup and recovery tools such as pgBackRest, Barman, or WAL-G.
• Experience with performance monitoring tools such as pgAdmin, pg_stat_statements, Prometheus, and Grafana.
• Oracle DBA
• Knowledge of Linux administration (Red Hat, CentOS, Ubuntu).
• Experience with scripting (Shell, Python, or Bash).
• Familiarity with database security, encryption, and access management.
• Understanding of DevOps practices, CI/CD pipelines, and Infrastructure as Code.

Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.

W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality.

Please be advised- If anyone reaches out to you about an open position connected with Eliassen Group, please confirm that they have an Eliassen.com email address and never provide personal or financial information to anyone who is not clearly associated with Eliassen Group. If you have any indication of fraudulent activity, please contact [email protected].