Sr. Database Administrator

ConstructConnect; Atlanta (GA); Ibrido; USD 140.000 - 190.000; Tempo pieno

Vantaggi offerti da questo lavoro

Hybrid work model

In-office presence when required

Descrizione del lavoro

ConstructConnect, Inc. in Peachtree Corners (Atlanta area) seeks a Sr. Database Administrator to lead on-premises and cloud database platforms (SQL Server, PostgreSQL, MySQL, Azure SQL, AWS RDS) in a 24/7 hybrid environment.

You’ll architect, build, and operate WSFCs/FCIs, AGs, and DR strategies, while guiding developers on data access and optimizing queries. This technical lead role focuses on security, compliance (SOX), performance, and automation using PowerShell and dbatools, with on-call

Competenze

• 6+ years of database administration experience, including 4+ years administering Microsoft SQL Server (2017-2025) in a 24/7 production environment.
• Hands-on experience building and supporting WSFCs and FCIs.
• Hands-on experience designing, implementing, and supporting AGs.
• Hands-on experience with log shipping and transactional replication.
• 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.
• Experience hosting databases in cloud environments (e.g., Google Cloud, AWS, Azure).
• Working familiarity with PostgreSQL administration.
• Strong command of Transact-SQL, stored procedures, functions, triggers, and SQL Agent automation.
• Proficiency with database performance monitoring and tuning.
• Scripting and automation experience (PowerShell, dbatools, or equivalent).
• Strong communication skills; ability to collaborate with developers and non-technical stakeholders.
• Technical lead experience with the ability to operate as both a leader and individual contributor.

Mansioni

• Administer and maintain SQL Server (2012-2025), PostgreSQL, MySQL, Azure SQL, and AWS RDS environments in a 24/7 production setting.
• Architect, build, and operate WSFCs and FCIs, including shared storage, quorum, networking, patching, and failover testing.
• Design, implement, and troubleshoot AGs across on-premises and cloud environments, including listeners, synchronization health, and planned and unplanned failover.
• Configure and maintain log shipping and transactional replication, including monitoring latency, resolving replication errors, and managing publisher, distributor, and subscriber components.
• Design and provision relational database environments, including instance configuration, storage layout, high availability and clustering architecture, backup strategy, and security design.
• Own disaster recovery and backup strategies, including cross-site recovery using Distributed AGs and log shipping, with responsibility for design, testing, and documentation.
• Lead database security and compliance efforts, including SOX controls, internal audit requirements, and access management.
• Monitor and optimize database performance using SolarWinds and Idera; identify and resolve bottlenecks proactively.
• Plan capacity across all database platforms, forecasting storage, compute, and licensing needs.
• Automate routine administration such as patching, health checks, deployments, and provisioning using PowerShell, dbatools, and infrastructure-as-code tooling.
• Design and review database schemas, stored procedures, functions, and triggers to meet business requirements.
• Partner with development teams on query optimization, indexing strategies, data access patterns, and source-controlled schema change management.
• Maintain runbooks and documentation for high availability, disaster recovery, and recovery procedures.
• Manage and track database-related tasks and incidents using Jira.
• Participate in the on-call rotation for after-hours production database issues.
• Provide technical mentorship and day-to-day guidance to DBA and engineering team members.
• Evaluate and support cloud database migrations and hybrid infrastructure improvements.
• Use AI coding assistants (e.g., Claude Code, GitHub Copilot,) to accelerate day-to-day administration, scripting, and troubleshooting.
• Ensure database platforms are ready for AI-driven application workloads, including vector search and high-concurrency data access, in support of the company’s AI strategy.
• This job description in no way implies that the duties listed here are the only ones team members may be required to perform.

Conoscenze

SQL Server

WSFCs/FCIs

AGs

Log shipping

Replication

DR planning

SOX compliance

PowerShell

dbatools

Performance tuning

T-SQL

Automation

Leadership

Cloud experience

Formazione

Bachelor's degree

Strumenti

Windows Server

Azure

AWS

GCP

SolarWinds

Idera

Jira

Descrizione del lavoro

Overview

This position is hybrid in Peachtree Corners, Georgia and sits within our IT Infrastructure division, which handles the combined set of software, hardware, networks, and facilities used to develop, test, deliver, monitor, control, or support IT Services.

The Opportunity

The Sr. Database Administrator is the principal technical authority for ConstructConnect’s database platforms, a hybrid on-premises and cloud environment running 24/7 across SQL Server 2012-2025, PostgreSQL, MySQL, Azure SQL, and AWS RDS. The role owns the platform beneath the databases, not just the databases themselves: architecting, building, and operating Windows Server Failover Clusters (WSFCs), SQL Server Failover Clustered Instances (FCIs), Availability Groups (AGs) and Distributed AGs, log shipping, and transactional replication. The Sr. DBA owns disaster recovery planning and RTO/RPO accountability, database security and SOX compliance, performance monitoring, and capacity planning, and sets the standard for how engineering teams use the database: reviewing schemas, developing and refactoring stored procedures, and guiding developers on query optimization and data access patterns. This is a technical lead role without direct reports.

Responsibilities

What You’ll Be Doing

• Administer and maintain SQL Server (2012-2025), PostgreSQL, MySQL, Azure SQL, and AWS RDS environments in a 24/7 production setting
• Architect, build, and operate WSFCs and FCIs, including shared storage, quorum, networking, patching, and failover testing
• Design, implement, and troubleshoot AGs across on-premises and cloud environments, including listeners, synchronization health, and planned and unplanned failover
• Configure and maintain log shipping and transactional replication, including monitoring latency, resolving replication errors, and managing publisher, distributor, and subscriber components
• Design and provision relational database environments, including instance configuration, storage layout, high availability and clustering architecture, backup strategy, and security design
• Own disaster recovery and backup strategies, including cross-site recovery using Distributed AGs and log shipping, with responsibility for design, testing, and documentation
• Lead database security and compliance efforts, including SOX controls, internal audit requirements, and access management
• Monitor and optimize database performance using SolarWinds and Idera; identify and resolve bottlenecks proactively
• Plan capacity across all database platforms, forecasting storage, compute, and licensing needs
• Automate routine administration such as patching, health checks, deployments, and provisioning using PowerShell, dbatools, and infrastructure-as-code tooling
• Design and review database schemas, stored procedures, functions, and triggers to meet business requirements
• Partner with development teams on query optimization, indexing strategies, data access patterns, and source-controlled schema change management
• Maintain runbooks and documentation for high availability, disaster recovery, and recovery procedures
• Manage and track database-related tasks and incidents using Jira
• Participate in the on-call rotation for after-hours production database issues
• Provide technical mentorship and day-to-day guidance to DBA and engineering team members
• Evaluate and support cloud database migrations and hybrid infrastructure improvements
• Use AI coding assistants (e.g., Claude Code, GitHub Copilot,) to accelerate day-to-day administration, scripting, and troubleshooting
• Ensure database platforms are ready for AI-driven application workloads, including vector search and high-concurrency data access, in support of the company’s AI strategy
• This job description in no way implies that the duties listed here are the only ones team members may be required to perform.

Qualifications

Required

• 6+ years of database administration experience, including 4+ years administering Microsoft SQL Server (2017-2025) in a 24/7 production environment.
• Hands-on experience building and supporting WSFCs and FCIs
• Hands-on experience designing, implementing, and supporting AGs
• Hands-on experience with log shipping and transactional replication
• 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
• Experience hosting databases in cloud environments (e.g., Google Cloud, AWS, Azure,)
• Working familiarity with PostgreSQL administration
• Strong command of Transact-SQL, stored procedures, functions, triggers, and SQL Agent automation
• Proficiency with database performance monitoring and tuning
• Scripting and automation experience (PowerShell, dbatools, or equivalent)
• Strong communication skills; ability to collaborate with developers and non-technical stakeholders
• Technical lead experience with the ability to operate as both a leader and individual contributor

Preferred

• Experience administering MySQL, Azure SQL, or AWS RDS
• Experience with SolarWinds/Idera monitoring platforms
• Experience with Cohesity or similar enterprise backup platforms
• Experience using CDC (Change Data Capture) for incremental data loads
• Experience using source control (GitLab or similar) for database scripts and schema changes
• Experience using AI coding assistants in day-to-day engineering work
• Familiarity with Jira for task and incident tracking

Physical Demands and Work Environment:

• The physical activities of this position include frequent sitting, telephone communication, and working on a computer for extended periods. Visual acuity is required to perform activities close to the eyes.
• Team members are expected to maintain a dedicated and ergonomically appropriate remote workspace.
• Team members who live within commuting distance of one of our office location (Atlanta, Georgia) are expected to work in a hybrid capacity, with regular in-office presence as determined by the team or department.
• All team members must reside and perform their work within the United States

E-Verify Statement

ConstructConnect utilizes the E-Verify program with every potential new hire. This makes it possible for us to make certain that every employee who works for ConstructConnect is eligible to work in the United States. To learn more about E-Verify you can call 1-800-255-7688 or visit their website. E-Verify® is a registered trademark of the United States Department of Homeland Security.

Privacy Notice