PostgreSQL DBA | Las Vegas, NV | 10+ Years | W2/Fulltime |

Overview

On Site
$100,000 - $140,000
Full Time

Skills

Amazon RDS
Amazon Web Services
Bash
Business Intelligence
Communication
Database
Database Administration
Debugging
Dynatrace
Instructional Design
Korn Shell
Linux
Migration
Oracle Linux
Performance Tuning
Perl
PostgreSQL
Profit And Loss
Python
Remote Desktop Services
Replication
SQL
Scripting
Splunk
Streaming
Tcl
Teradata

Job Details

Role: PostgreSQL DBA
Location: Las Vegas, NV(Day1 Onsite)
Experience: 10+ Years
Contract: W2/Fulltime(No C2C) Through TechM (Immediate Interviews)

Responsibilities:
Primary contact for PostgreSQL incidents and service requests.
Troubleshoot query performance, connection issues, and data anomalies.
Help developers debug functions, procedures, and triggers.
Guide Teradata-experienced teams on PostgreSQL usage.
Conduct Q&A sessions and create cheat sheets/quick guides.
Highlight key differences between Teradata and PostgreSQL.
Experience in the design, maintenance, and administration of EDB Postgres, Postgres Distributed and AWS RDS.
Deep understanding of EDB Postgres architecture and internals.
Proficient in PostgreSQL installation and configuration, especially PostgreSQL Plus Advanced Server and Postgres Distributed from Enterprise DB.
Skilled in PostgreSQL monitoring and alerting tools, particularly PEM. Familiarity with observability tools like Splunk and Dynatrace is a plus.
Experienced in setting up, configuring, and monitoring PostgreSQL binary and logical replication (e.g., Binary Streaming, Bi-Directional Replication - BDR).
Strong skills in collecting diagnostics and tuning PostgreSQL and SQL performance.
Proficient in PostgreSQL procedural languages (PL/pgSQL, PL/Tcl, PL/Perl, PL/Python) and SQL.
Excellent troubleshooting and debugging skills.
Experience in performance tuning and automation for Postgres and AWS platforms.
Proficient in Linux, especially Oracle Linux Enterprise.
Familiarity with scripting languages such as Bash, KSH, and Perl.
Requirements:
Strong PostgreSQL skills in administration, tuning, and troubleshooting.
Solid SQL/PLpgSQL and debugging experience.
Familiar with Teradata-to-PostgreSQL migration challenges.
Good training, documentation, and communication skills.
Bachelors in CS, Engineering, or equivalent experience.

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.