Lead Technical Operations (DBA-Azure SQL)
This job posting is no longer active.
Location: WASHINGTON, DC, United States
Organization: Exelon Business Servcs Co, LLC
Job ID: 240241
Date Posted: Oct 27, 2022
Job: Information Technology - Staff
Job Description
Description
Be a part of something powerful at America's premier energy provider!
At Exelon, we are united by our values and shared vision for a cleaner and brighter future. We encourage curiosity, value diverse perspectives and we never stop looking for ways to be, work and do better. We know the future is in our hands. That's why we're looking for people like you, who have the power to make a difference.
As the nation's largest utility company, we serve more than 10 million customers through six fully regulated transmission and distribution utilities; Atlantic City Electric (ACE), Baltimore Gas and Electric (BGE), Commonwealth Edison (ComEd), Delmarva Power & Light (DPL), PECO Energy Company (PECO), and Potomac Electric Power Company (Pepco). All 18,000 of us are committed to delivering safe, reliable and affordable energy to our customers, strengthening our communities, supporting a clean energy future and reducing our impact on the changing climate.
Our people are the heart and soul of our business. Whether it's powering lives, supporting communities or collaborating with colleagues, an Exelon employee is talented, compassionate, forward-thinking and inspired. We are empowered to evolve and advance our careers in an open and inclusive environment. We pride ourselves on being the kind of place where people want to come and stay. We know that investing in our employees' futures strengthens ours, which is why we offer competitive compensation, incentives and health and retirement benefits.
Position may be required to work extended hours, including 24 x 7 coverage during storms or other energy delivery emergencies.
PRIMARY PURPOSE OF POSITION
Provide subject matter support delivery and maintenance of IT solutions. Provide IT teams and business personnel with technology solutions by weighing advantages of technology standards, market availability of products, and risks and benefits of technology to meet business/IT needs. Maintain significant customer engagement, work planning, project management services provided to IT customers.
PRIMARY DUTIES AND ACCOUNTABILITIES
- Manage Microsoft SQL Server databases on-premises and in the cloud.
- Build, configure and maintain database servers, processes, configuration, patches, and backups
- Provide expertise to effectively monitor database platform health and performance
- Maintain database inventory information to ensure accuracy of configuration management DB.
- Support the production release management system for documenting, planning, and implementing IT changes.
- Plan, coordinate, communicate and implement database patching activities for database platforms.
- Refine, script, and automate regular processes for continuous improvement, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Provide 24x7 support and participate in on call rotation for critical production systems
- Perform scheduled maintenance and support release deployment activities after hours
- Provide technical database expertise and/or solution delivery support for documenting and maintaining performance and reliability of database solutions.
- Maintain and enhance engagement with business and IT partners to sustain service levels and high availability of database services. Visible and accessible to clients providing guidance for how to successfully request database services.
- Coordinating and implementing planned database and database infrastructure changes, refreshes, and upgrades for business and/or IT clients.
- Ensures appropriate implementation of technology both within the production and the development environments.
- Acts as a source of direction, training, and guidance for less experienced staff. Approachable and leads by example.
- Maintains deep knowledge of SQL database technology and its application across Exelon
- Finds ways over, around and through barriers to success. Self-starter. A results-oriented doer.
- Promotes and encourages Diversity, Equity & Inclusion
Qualifications
POSITION SPECIFICATIONS
Minimum:
- Bachelor’s degree in Computer Science or related discipline and typically 5 to 8 years hands-on experience with Microsoft SQL Server or equivalent combination of education and work experience. In addition,
- Broad technical expertise with deep technical knowledge in current versions of Microsoft SQL Server, SQL failover clustering, always on availability group, and database replication technologies on-premises and in cloud hosting providers such as Azure.
- General RDBMS, Database tuning, SQL tuning, Database Statistics, Database upgrades, Data Guard
- Solid working level knowledge: Microsoft Windows Server OS, SAN and NAS storage
- Experience scripting SQL DBA activities with PowerShell
- Excellent communications skills - Able to effectively communicate, diagram and document highly technical information in non-technical terminology (written and verbal).
- Makes well-thought-out decisions on complex or ambiguous database issues. Comprehends the big picture.
- Understanding of change management principles associated with sustaining high availability of systems and preventing change related incidents due to human performance factors.
- Understands and applies project management principles when leading and directing work
- Independence level: works under minimal supervision while providing frequent status updates.
Preferred:
- Experience administrating Microsoft SQL databases on-prem (physical and virtual) and in Microsoft Azure
- Experience scripting Windows and SQL Server