Senior SQL Server Database Administrator

Requisition ID: 18836

 

Join us in building a better future for Arizona!

SRP is one of the largest public power and water utilities in the U.S. providing electricity to approximately one million customers in the greater metropolitan Phoenix area. Since its founding in 1903, SRP has fostered a culture of stewardship and customer service consistently ranking as an industry leader in customer service according to J.D. Power and named one of Arizona's best employers by Forbes. SRP continues to adapt to its changing business environment by seeking innovative ways to reimagine utility service and the provision of critical resources essential to the life and economy of Arizona.

 

Why Work at SRP

At SRP, we foster an inclusive work environment and believe everyone should have a fair chance to work, regardless of who they are. That’s why we value teams with diverse perspectives, experiences, and backgrounds to help SRP deliver on its mission of providing reliable, affordable and sustainable water and power.

 

SRP's success is rooted in our employees' happiness, health, and safety. That's why we offer a comprehensive benefits package to meet the needs of our employees and enhance their well-being. In addition to competitive pay and performance incentives, eligible employees can take advantage of the following benefits:

 

• Pension Plan (at no cost to the employee)
• 401(k) plan with employer matching
• Available your first day: Medical, vision, dental, and life insurance
• Over 200+ hours of PTO (includes vacation days, holidays, floating holidays, and sick leave)
• Parental leave (up to 4 weeks) and adoption assistance
• Wellness programs (including access to a recreation and fitness facility)
• Short and long-term disability plans
• Tuition assistance for both undergraduate and graduate programs
• 10 Employee Resource Groups for career development, community service, and networking

 

Summary

This position is responsible for the support, management, security and monitoring of over 350  production and non-production Microsoft SQL Server deployments in a team environment.   As a SQL Server DBA, we will rely on you to design and configure high availability environments, perform troubleshooting and performance analysis, test new database features, provide recommendations on future state architecture and automation opportunities and apply new versions, releases, and patches as necessary.

What You'll Do

 

• Provide primary support for SRP's on-premise enterprise SQL Server 2016-2022 environments

• Architect and implement SQL database High Availability and Disaster Recovery strategies using AlwaysOn, replication, etc.

• Perform SQL Server performance analysis which includes reviewing query plans, index usage, and TSQL code reviews

• Work with developers and application support teams to create, modify, and tune database structures

• Collaborate with application and infrastructure teams to identify solutions to complex problems and test/ implement new database features

• Complete requests from application teams for database changes, security changes, data loads, etc.

• Perform SQL Server software installations, patching and upgrades

• Install and support SQL Server BI components including SSIS, SSRS and SSAS

• Manage database backups and maintain disaster recovery policies and procedures

• Support ongoing and future database projects based on technology roadmaps

• Maintain configuration information for the enterprise SQL Server environment, including details for server, storage, software versions, criticality, confidentiality, licensing, capacity, and ownership

• Provide scheduled rotational after hours on-call support

What It Takes To Succeed

Strong problem solving and conceptual thinking abilities

•  Excellent written/verbal communication, organization and documentation skills

•  Able to work independently and deliver high quality results when given a set of objectives/ requirements

•  Experience with Windows Server OS 2016/2019/2022

 

Preferred skills

o  Working knowledge of DDL, DML, TSQL, stored procedures, triggers, views, constraints, cursors

o  Experience with PowerShell, including using PowerShell to automate repeatable tasks

o  Use of PowerShell DSC for automating