Database Administrator (MSSQL, Aurora PostgreSQL)

Enterprise Solutions Inc.; Charlotte (NC); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Restaurant d'entreprise

Job summary

Enterprise Solutions Inc. in Charlotte, NC seeks a hands-on Database Administrator focusing on Amazon Aurora PostgreSQL and MSSQL for large-scale, high-transaction environments.

This long-term contract role is hybrid, located in Charlotte, and requires strong scripting and performance tuning. You will configure, monitor, and optimize PostgreSQL databases, manage backups and recovery strategies, automate health checks, and collaborate with business and tech teams to meet SLA targets.

Qualifications

• 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.

Responsibilities

• Manage database platforms to ensure high availability and performance.
• Perform daily health checks and monitor replication lag on replicas.
• Coordinate backups and recovery activities per SOP.

Skills

Aurora PostgreSQL

MSSQL

Tools

CloudWatch

Zabbix

Dynatrace

Datadog

Foglight

Job description

Location: Charlotte, NC, 28217 (Hybrid)

Type: Long Term Contract

Need Independent Candidates On W2 Only

Must Have Skills: Aurora PostgresSQL, 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 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.