Job Description
Company: ConstructConnect
Location: Atlanta, GA
Workplace Type: Hybrid
Employment Type: Full-time
About the Role
This hybrid role within the IT Infrastructure division requires the Sr. Database Administrator to be the principal technical authority for ConstructConnect’s 24/7 database platforms, spanning on-premises and cloud environments. The role focuses on the platform beneath the databases, encompassing architecture, building, and operation of high-availability solutions.
What You’ll Do / Key Responsibilities
- Administer and maintain SQL Server, PostgreSQL, and MySQL environments in a 24/7 production setting.
- Architect, build, and operate WSFCs and FCIs, including shared storage and failover testing.
- Design and implement Availability Groups (AGs) across on-premises and cloud environments.
- Own disaster recovery and backup strategies, including cross-site recovery using Distributed AGs.
- Lead database security and SOX compliance efforts, managing access and audit requirements.
- Monitor and optimize database performance using SolarWinds and Idera, proactively resolving bottlenecks.
- Automate routine administration using PowerShell, dbatools, and infrastructure-as-code tooling.
- Partner with development teams on query optimization, indexing strategies, and source-controlled schema change management.
Requirements & Qualifications
- 6+ years of database administration experience, including 4+ years administering Microsoft SQL Server in a 24/7 production environment.
- Hands-on experience building and supporting WSFCs and FCIs.
- Hands-on experience designing, implementing, and supporting AGs.
- Proven ownership of disaster recovery planning, backup/restore operations, and DR testing.
- Experience implementing and maintaining database security controls in a SOX-compliant environment.
- Working knowledge of the infrastructure that database platforms depend on, including Windows Server, storage, networking, and virtualization.
- Working familiarity with PostgreSQL administration.
- Proficiency with Transact-SQL, stored procedures, functions, triggers, and SQL Agent automation.
- Scripting and automation experience (PowerShell, dbatools, or equivalent).
Preferred / Bonus Qualifications (if applicable)
- Experience administering MySQL, Azure SQL, or AWS RDS.
- Experience with SolarWinds/Idera monitoring platforms.
- Experience using CDC (Change Data Capture) for incremental data loads.
- Familiarity with Jira for task and incident tracking.
Benefits & Perks (if applicable)
- Opportunity to utilize AI coding assistants (e.g., Claude Code, GitHub Copilot) to accelerate administration.
- Technical mentorship and guidance within the team.
ConstructConnect utilizes the E-Verify program with every potential new hire.