Database Administrator

Title: Database Administrator

Location: Charlotte, NC, 28217 (Hybrid)

Type: Long Term Contract

Need Independent Candidates on W2 Only

Must Have Skills: Postgres SQL, MSSQL

Database monitoring tools: CloudWatch, Zabbix, Dynatrace, Datadog, Fog light

Job Description:

• Hands-on experience with Amazon Aurora PostgreSQL, MSSQL 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.