SQL Database Administrator – Azure & On-Prem Reliability

American Transmission Co.; City of Pewaukee (WI); On-site; USD 96,000 - 112,000; Full time

Benefits offered by this job

Annual incentive bonus

Pension plan

401(k) match

HSA contribution

Life & disability insurance

Health care benefits

Generous time off plans

Flexible work arrangements

Job summary

American Transmission Co. is seeking a hands-on Database Administrator to support and strengthen our Microsoft SQL Server environment across on-premises and Azure platforms. You will help ensure health, availability, and performance of critical databases supporting business operations.

You will monitor, tune, and secure databases, plan migrations, and collaborate with application and infrastructure teams. A Bachelor's degree in CS or MIS is preferred, and there is an on-call rotation for

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

SQL Server

T-SQL

Azure SQL

Performance monitoring

Backup & recovery

Disaster recovery planning

Database maintenance

Capacity planning

Migration planning

Physical database design

Education

Bachelor's degree in Computer Science or MIS

Tools

SSMS

Azure Data Studio

Job description

American Transmission Co. is seeking a hands-on Database Administrator to support and strengthen our Microsoft SQL Server environment across on-premises and Azure platforms. You will help ensure health, availability, and performance of critical databases supporting business operations.

You will monitor, tune, and secure databases, plan migrations, and collaborate with application and infrastructure teams. A Bachelor's degree in CS or MIS is preferred, and there is an on-call rotation for