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

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

Detailed Job Description:

Required skillset: Aurora Postgres, MSSQL Admin

Additional skillset : DB2 LUW

Database monitoring tools: CloudWatch, 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.

Custom Fields:

Name: Intake Call Requested

Value: true

Name: Intake Call Completed

Value: true