Database Administrator

Diverse Lynx, LLC; Charlotte (NC); Hybrid; USD 62,000 - 83,000; Full time

Job summary

Diverse Lynx LLC is seeking an experienced Database Administrator in Charlotte, NC (Hybrid). The role requires 12+ years of experience with Amazon Aurora PostgreSQL and MSSQL, plus DB2 LUW knowledge. Certification in MSSQL and Postgres is preferred.

The position supports large-scale, high-transaction environments and involves performance tuning, backup/recovery, and automation tasks. The candidate will work with CloudWatch, Zabbix, Dynatrace, Datadog, and FogLight to monitor and optimize

Qualifications

• Required skillset: Aurora Postgres, MSSQL Admin.
• Additional skillset: DB2 LUW.
• Certification needed: MSSQL, Postgres related.
• Minimum years of experience: 12+ years.

Responsibilities

• Hands-on with Amazon Aurora PostgreSQL and Amazon RDS.
• Build and support large-scale, high-transaction DB environments.
• Tune database performance and perform deep-dive analysis.
• Configure, support, and tune PostgreSQL databases.
• Backup and recovery strategy planning and execution.
• Write and debug Shell and Python scripts.
• Collaborate with business, technical teams and management.
• Manage DB platforms for high availability and performance, including failover and replica lag monitoring.
• Perform daily health checks on disk, CPU, memory, and logs.
• Conduct on-demand backups and restore at table/schema level.
• Identify long-running queries and share findings with developers.
• Perform basic user and access management.
• Troubleshoot infra, performance, and availability issues.
• Provide basic query and performance support.
• Monitor weekend job alerts and escalate as needed.
• Perform database refresh activities during weekends.
• Participate in maintenance windows and tuning to meet SLA.
• Handle incident, change, and service tasks per SLA.

Skills

PostgreSQL Admin

MSSQL Admin

Tools

CloudWatch

Zabbix

Dynatrace

Datadog

FogLight

Job description

Job Title: Database Administrator

Work Location & Reporting Address: Charlotte, NC 28217 (Hybrid)

Contract duration: 17+ months

Rate: $50/hr

Does this position require Consultant 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.

1. Hands-on experience with Amazon Aurora PostgreSQL and Amazon RDS.
2. Experience building and supporting large-scale, high-transaction database environments.
3. Strong expertise in database performance tuning, Eligible to workimization, and deep-dive analysis.
4. Hands-on experience configuring, supporting, and tuning PostgreSQL databases.
5. Knowledge of database backup and recovery strategies.
6. Ability to write and debug Shell and Python scripts.
7. Excellent communication skills, with the ability to collaborate effectively with business teams, technical teams, and senior management.
8. Manage database platforms to ensure high availability and performance, including start, stop, restart, failover operations, and replication-lag monitoring on replica nodes.
9. Perform daily health checks for disk, CPU, memory utilization, and PostgreSQL logs, using AI-driven automation where applicable.
10. Perform on-demand backup and restoration activities, including table- and schema-level backups.
11. Identify long-running and repetitive queries, run execution plans, and share findings with the development team for further analysis.
12. Perform basic user and access management.
13. Troubleshoot infrastructure, performance, and availability issues.
14. Provide basic query and performance support.
15. Monitor weekend job alerts, troubleshoot issues, and elevate to the Compass SME as per SOP.
16. Perform database refresh activities during weekends.
17. Participate in planned maintenance windows and outage activities, and perform database tuning and Eligible to workimization to meet SLA requirements.
18. Handle incident management, change management, and service tasks in accordance with SLA requirements.

Disclaimer:

Diverse Lynx LLC is an Equal Opportunity Employer. All applicants and employees are evaluated without discrimination, based solely on their qualifications, ability, competence and performance. This email and its attachments may contain confidential or proprietary information and is intended only for the recipient(s). If you received this message in error, please disregard it and notify the sender. If you no longer wish to receive our communications, you may unsubscribe at any time.

Security Notice:

Our official website is www.diverselynx.com We do not operate or authorize any other websites representing Diverse Lynx LLC.