SQL DBA - Azure & On-Prem, Performance & DR

atcllc; City of Pewaukee (WI); On-site; USD 96,000 - 112,000; Full time

Job summary

ATC is seeking a hands-on Database Administrator to support and strengthen our Microsoft SQL Server environments across on-premises and Azure. You will monitor, maintain, and optimize the health, availability, and performance of critical databases, participate in migrations, security, DR planning, and collaborate with application and infra teams.

The role requires 1–3 years in a dedicated DBA role, strong T-SQL skills, and a bachelor’s degree in CS or MIS.

Qualifications

• 1–3 years of progressively responsible experience in a dedicated Database Administrator role.
• Strong expertise with Microsoft SQL Server and T-SQL.
• Experience with SQL Server installations, Azure SQL deployments, database maintenance and database access security.
• Demonstrated capability in performance monitoring and tuning, capacity planning, backup and recovery, and fault-tolerance planning.
• Experience planning database migrations and troubleshooting production database issues.
• Knowledge of physical database design, database modeling and application database development.
• Experience with disaster recovery planning and testing in environments where database availability is business critical.
• Strong written, verbal and interpersonal communication skills.
• A bachelor's degree in Computer Science, Management Information Systems or a related discipline is preferred.

Responsibilities

• Administer and support multiple Microsoft SQL Server instances across on-premises and Azure SQL environments.
• Proactively monitor database health, performance and capacity, addressing potential issues before they disrupt production.
• Manage database maintenance, access security, backup and recovery, and fault-tolerance practices.
• Troubleshoot production database issues and partner with application and infrastructure teams to drive resolution.
• Plan and execute database migrations while helping ensure stability and continuity.
• Translate logical data designs into effective physical database designs and develop databases that support new applications.
• Support disaster recovery planning and testing for business-critical database environments.
• Establish and reinforce database standards, controls, documentation and best practices.
• Provide database design consultation to application teams throughout development and deployment.
• Work within established Change, Incident and Release Management processes when supporting production environments.
• Participate in an on-call rotation, including off-hours support, for critical database needs.

Skills

Microsoft SQL Server

T-SQL

Azure SQL

Performance monitoring

Disaster recovery planning

Database design

Communication skills

Education

Bachelor's degree in Computer Science / MIS or related

Job description

ATC is seeking a hands-on Database Administrator to support and strengthen our Microsoft SQL Server environments across on-premises and Azure. You will monitor, maintain, and optimize the health, availability, and performance of critical databases, participate in migrations, security, DR planning, and collaborate with application and infra teams.

The role requires 1–3 years in a dedicated DBA role, strong T-SQL skills, and a bachelor’s degree in CS or MIS.