DirectJobHub
Jobs · OTHR · North Carolina

Senior Consultant | Database Administration | PostgreSQL

Expedite Talent Solutions · Charlotte, NC · 1 mo ago
On-siteOTHRFull-time

Description

Job Title: Database Administrator
Work Location & Reporting: Charlotte, NC 28217 (Hybrid)
Vendor Rate: ***
Contract duration: 17 months
Target Start Date: 03 Aug 2026
Does this position require Visa independent candidates only? Yes
Interview Process: Video Interview

Job Details

  • Minimum years of experience required: 12+ years
  • Certification needed: Yes, MSSQL, Postgres related

Must Have Skills

  • Postgres SQL admin
  • MSSQL Admin

Nice to Have Skills

  • DB2 LUW

Additional Skillset

  • Aurora Postgres, MSSQL Admin

Database Monitoring Tools

  • CloudWatch
  • Zabbix
  • Dynatrace
  • Datadog
  • Fog light

Required Experience

  • Hands-on experience with Amazon Aurora PostgreSQL and Amazon RDS
  • Experience building and supporting large-scale, high-transaction database environments
  • Strong expertise in database performance tuning, optimization, and deep-dive analysis
  • Hands-on experience configuring, supporting, and tuning PostgreSQL databases
  • Knowledge of database backup and recovery strategies
  • Ability to write and debug Shell and Python scripts

Communication and Collaboration

  • Excellent communication skills, with the ability to collaborate effectively with business teams, technical teams, and senior management

Database Management Tasks

  • Manage database platforms to ensure high availability and performance, including start, stop, restart, failover operations, and replication-lag monitoring on replica nodes
  • Perform daily health checks for disk, CPU, memory utilization, and PostgreSQL logs, using AI-driven automation where applicable
  • Perform on-demand backup and restoration activities, including table- and schema-level backups
  • Identify long-running and repetitive queries, run execution plans, and share findings with the development team for further analysis
  • Perform basic user and access management
  • Troubleshoot infrastructure, performance, and availability issues
  • Provide basic query and performance support
  • Monitor weekend job alerts, troubleshoot issues, and escalate to the Compass SME as per SOP
  • Perform database refresh activities during weekends
  • Participate in planned maintenance windows and outage activities, and perform database tuning and optimization to meet SLA requirements
  • Handle incident management, change management, and service tasks in accordance with SLA requirements

Similar jobs