Urgent Client Need: Sr PostgreSQL DBA at Hartford, CT or Minneapolis, MN (Onsite); Long Term Contract

[Niranjan Kumar]

Please share your resumes at nira...@sidmans.com

 

Hi 

This is Niranjan from Sidmans. Hope you are doing well.

Please go through the below job description and respond with your resume, contact details and current location, If you feel comfortable with the below job description. 

  

Position: Sr PostgreSQL DBA

Location: Hartford, CT or Minneapolis, MN (onsite)

Duration: Long Term Contract

Only H1B Candidates with Passport Number

Job Description:

We are seeking an experienced PostgreSQL Database Administrator to serve as a subject matter expert for our database ecosystems. You will be responsible for the health, performance, and security of our PostgreSQL instances across both on-premises data centers and cloud environments (GCP/Azure). The ideal candidate is a proactive problem-solver who excels at performance tuning, high-availability architecture, and seamless cloud migrations.

Key Responsibilities

• Core Administration: Lead the installation, configuration, and lifecycle management of PostgreSQL. Manage database refreshes, security patching, and version upgrades to ensure 99.9% uptime.
• Performance Engineering: Actively monitor and optimize database performance. You will analyze execution plans, tune postgresql.conf parameters, and manage indexing strategies to resolve bottlenecks.
• High Availability: Design and maintain robust HA clusters using repmgr. Take ownership of failover testing, node recovery, and split-brain prevention.
• Cloud & Migration: Design and execute low-downtime migration strategies from legacy on-premises hardware to Cloud SQL or Azure Database for PostgreSQL.
• Data Protection: Oversee comprehensive Backup & Recovery (PITR) and Disaster Recovery (DR) strategies using both native tools and enterprise solutions.
• Replication Management: Configure and troubleshoot streaming and logical replication to support data synchronization and reporting offloads.

Technical Qualifications:

• Postgres Internals: Deep understanding of WAL (Write-Ahead Logging), MVCC, Autovacuum tuning, and memory architecture ($shared\_buffers$, $work\_mem$).
• Clustering: Proven hands-on experience with repmgr for automated failover and cluster management.
• Tooling: Proficiency with standard tools like pg_dump, pg_restore, pg_basebackup, and pg_upgrade.
• Cloud Platforms: Working knowledge of GCP (Google Cloud Platform) or Microsoft Azure database services.
• Infrastructure as Code: (Preferred) Experience automating deployments with Ansible or Terraform.
• Observability: Familiarity with monitoring stacks such as Prometheus, Grafana, or pgAdmin

Thanks & Regards,
Niranjan Kumar Chikkala

Sr Lead Recruiter

3333 Warrenville Rd, Ste # 200 Lisle, IL 60532

Phone: 630 242 2375, 525546244545
Email: nira...@sidmans.com

Web: www.sidmans.com