Lead Analyst - Database Support

Overview

Job Title:
Lead Analyst - Database Support SQL Server DBA
Department:
Infrastructure Middleware & DB

Reports to:

Supervisor - Infrastructure Middleware & DB

Location:

In Office
, Augusta ME
The base salary range for this position is dependent upon experience and location, ranging from: $106,000 - $132,500

SQL Server DBA Job Description

• Provides support for the AVANGRID SQL Server database environments & applications using SQL Server databases.
• Participate in all database system design, maintenance, and enhancement work and documentation.
• Proactively monitor and maintain all database and application systems for an uninterrupted service to the Energy Control Center (ECC).
• Analyze, extract and make available system data for the engineers on request.
• Works within the Control Center environment and supports Cyber Security requirements for Control Center operations.

• Proficiency in various SQL Server installation and configurations on SQL Server 2019 and experience in migrating from earlier versions of SQL Server to SQL Server 2019 and above.
• Strong background in SQL Server database administration including Query Optimization, Performance Tuning, Troubleshooting and issue identification on MS-SQL 2016/2019.
• Experience in high availability methods like clustering and/or mirroring, Always On Availability Groups in a multi-site environment.
• Experience in applying database patches, security patches and application patches.
• Maintain stored procedures, indexes, SQL jobs, alerts, special procedures, views, functions, SSIS, in a multi-server environment.
• Ability to identify and troubleshoot issues with permissions, networking, firewall, AD group, AD authentications and VMware, etc.
• Ability to review the audit requirements and apply fixes if required.
• Experience with scheduling backups and restoring databases using SQL native backups; also knowledge of Veeam and/or Veritas backups.
• Experience on SQL Mail configurations and notifications for job failures, including proactive notifications for blocking, deadlocks, space issues, etc.
• Strong experience in disaster recovery (DR) tasks, design, implementation and management.
• Strong background in database and application tuning and optimizing SQL statements in applications, batch jobs, and reports.
• In-depth knowledge of database security, privilege assignment and role-based security design.
• Experience with Solar Winds DPA is a plus.
• Experience in data center migrations is a plus.

• Understanding of relevant industry compliance regulations and policies.
• Performing scheduled maintenance and support for release deployment activities after hours and/or during maintenance windows.
• Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution.
• Monitor performance and availability on all production and non-production databases (as applicable).
• Strong written and verbal communication skills; ability to make sound decisions while working in a high-pressure environment outside normal hours.
• Ability to work in storm or other emergency conditions for 24x7 system support.
• Prior experience in working with Gas Utilities or any other utility industry is an advantage.

• Education and Experience:
  
  (Must meet at least one of the following)
• Bachelor’s Degree with 2+ years in RDBMS experience
• Associate Degree with 4+ years in RDBMS experience
• 5-7 years’ IT and RDBMS related experience

CENTRAL MAINE POWER CO

Please note that any applicant who is not a citizen of the country of the vacancy will be subject to compliance with the applicable immigration requirements to legally work in that country.

At Avangrid we provide fair and equal employment and advancement opportunities for all employees and candidates regardless of race, color, religion, national origin, gender, sexual orientation, age, marital status, disability, protected veteran status or any other status protected by federal, state, or local law.

If you are an individual with a disability or a disabled veteran who is unable to use our online tool to search for or to apply for jobs, you may request a reasonable…