Database Administrator (MSSQL, Aurora PostgreSQL

Location:
Charlotte, NC, 28217 (Hybrid)

Type:
Long Term Contract

Need Independent Candidates On W2 Only

Must Have

Skills:

Aurora PostgresSQL, MSSQL

Database monitoring tools: Cloud Watch, 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 elevate to the Compass SME as per SOP.
• 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.