Senior Consultant | Database Administration | PostgreSQL

Description:

Job Title:

Database Administrator

Work Location & Reporting Address:
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 (Is face to face required?) Video Interview

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

Required skillset:
Aurora Postgres, MSSQL Admin

Additional skillset : DB2 LUW

Database monitoring tools:
Cloud Watch, Zabbix, Dynatrace, Datadog, Fog light.

• 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.
• Excellent communication skills, with the ability to collaborate effectively with business teams, technical teams, and senior management.
• 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 escalte 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.

Name:
Intake Call Requested

Value: true

Name:
Intake Call Completed

Value: true