What are the responsibilities and job description for the Senior Consultant | Database Administration | PostgreSQL position at Expedite Talent Solutions?
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.
Name: Intake Call Requested
Value: true
Name: Intake Call Completed
Value: true
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 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.
Name: Intake Call Requested
Value: true
Name: Intake Call Completed
Value: true