Avangrid

Lead Analyst - Database Support

LocationRochester, NY
Job Typefull_time

About This Job

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

Reports to: Supervisor - Infrastructure Middleware & DB

Location: In Office

, Augusta ME, Orange CT, Rochester NY, Vestal NY

The base salary range for this position is dependent upon experience and location, ranging from: $111,544.80 - $139,431

SQL Server DBA Job Description Purpose

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.


Key Technical Working Skills

Proficiency in Various SQL server installation and configurations on SQL Server 2019 and Experience in migrating from early versions of SQL Server to SQL Server 2019 and above.
Strong background in SQL Server database administration including Query Optimization, Performance Tuning, Troubleshoot and Identify the issues on MS-SQL 2016/2019.
Experience in high availability methods like clustering and/or mirroring, Always ON Availability Groups on a Multi-site environments.
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 the issues with Permissions, Networking, firewall, AD group, Ad Authentications and VMware etc.,
Ability to review the Audit requirement and apply the fixes if required.
Experience with scheduling backups restoring databases using SQL native backups also knowledge on Veeam and/or Veritas backups.
Experience on SQL Mail configurations and Notification for any Job failures as well proactive notifications like blocking, Deadlock, space issues, etc.,
Strong Experience in Disaster Recovery (DR) tasks, design, implement and manage.
Strong background in database and application Tuning and optimizing SQL statements in applications, batch jobs, and reports.
Very good, In-depth know of database security, privilege assignment and design role-based security.
Experience in SolarWinds DPA is a plus.
Experience in Datacenter Migrations is a plus.


General Knowledge & Skills

Working with the understanding of relevant Industry Compliance Regulations and Policies.
Performing scheduled maintenance and support release deployment activities after hours and/or during maintenance windows.
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Monitoring performance issues and for availability on all production and non-production databases (as applicable).
The ability to demonstrate good communication skills both written and orally. Experience to make sound decisions will working in a high-pressure environment outside normal working hours.
Working 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.


Requirements

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

Company

CENTRAL MAINE POWER CO

Mobility Information

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 accommodation by contacting our People and Organization department at careers@avangrid.com.

Avangrid employees may be assigned a system emergency role and in the event of a system emergency, may be required to work outside of their regular schedule/job duties. This is applicable to employees that will work in Connecticut, Maine, Massachusetts, and New York within Avangrid Network and Corporate functions. This does not include those that will work for Avangrid Power.

Job Posting End Date

July-29-2025

Similar Jobs

company-logo

Lead Analyst - Database Support

Avangrid
Job Typefull_time
 
Rochester, NY
3 days ago
company-logo

Lead Analyst - Database Support

New York State Electric & Gas
Job Typefull_time
 
Binghamton, NY
18 days ago
company-logo

Lead Analyst - SAP Support

Avangrid
Job Typefull_time
 
Portland, ME
19 days ago
company-logo

Lead Analytics Analyst

NextEra Energy Resources
Job Typefull_time
 
Juno Beach, FL
2 days ago
company-logo

Lead Analytics Analyst

NextEra Energy
Job TypeFull-time
 
Juno Beach, FL
15 days ago
company-logo

Lead Change Management Data Analyst

CenterPoint Energy
Job TypeFull-time
 
Evansville, IN
19 days ago
company-logo

Database Analyst

ACRT
Job Typefull_time
 
Denver, CO
17 days ago
company-logo

Database Analyst

ACRT, Inc.
Job TypeFull-time
Salary
$56160 - $56160
Denver, CO
17 days ago
company-logo

Lead Financial Analyst (hybrid)

NiSource
Job Typefull_time
Salary
$93800 - $140700
Columbus, OH
25 days ago
company-logo

Enterprise Technology Lead Analyst

Florida Power & Light
Job Typefull_time
 
Juno Beach, FL
15 days ago
company-logo

Lead Master Data Specialist

CenterPoint Energy
Job TypeFull-time
 
Houston, TX
18 days ago
company-logo

Lead Analyst - CCS Business Support

Avangrid
Salary
$85900 - $107375
Binghamton, NY
19 days ago
company-logo

Lead Analyst

National Grid
Job TypeFull-time
Salary
$126000 - $148000
Syracuse, NY
10 days ago
company-logo

Lead Data Scientist (Hybrid)

Eversource Energy
Job Typefull_time
Salary
$157040 - $174490
Westwood, MA
18 days ago
company-logo

Lead Analyst, Finance Services

National Grid
Job Typefull_time
Salary
$120000 - $141000
Hicksville, NY
23 days ago
company-logo

Business Intelligence & Analytics Lead - Operations

Charter Steel
Job Typefull_time
 
Saukville, WI
5 days ago
company-logo

Process & Data Analyst Lead (Tech Business Analyst Staff - Lead)

American Electric Power
Job TypeFull-time
Salary
$112869 - $146730
Columbus, OH
15 days ago
company-logo

Business Intelligence and Analytics Lead - Operations

Charter Steel
Job Typefull_time
 
Saukville, WI
22 days ago
company-logo

Lead Analyst, Product Systems

The AES Corporation
Job Typefull_time
 
Louisville, CO
15 days ago
company-logo

Lead Analyst, Product Systems

AES Corporation
Job TypeFull-time
 
Charlotte, NC
15 days ago

Trending Jobs

company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, PA
5 months ago
company-logo

Division Order Analyst

Coronado Resources
Job TypeFull-time
 
Dallas, TX
about 2 months ago
company-logo

Professional Landman

Penterra Services, LLC
Job TypeContract
 
Lovington, NM
29 days ago
company-logo

Accounts Payable Clerk

LPR Energy
Job TypeFull-time
Salary
$65000 - $65000
Dallas, TX
2 months ago
company-logo

Division Order Landman

R. Lacy Services, Ltd.
Job TypeFull-time
 
Longview, TX
about 1 month ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, LA
4 months ago
company-logo

Oil and Gas Land and Title Analyst - SAM Associate II

Bank of America
Job TypeFull-time
 
Dallas, TX
3 months ago
company-logo

Attorney

Toeppich & Associates
Job TypeFull-time
 
Houston, TX
over 1 year ago
company-logo

Title Landman

Sustain Land Services
Job TypeFull-time
 
Norman, OK
4 months ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, TX
3 months ago
company-logo

Title Reviewer

Innovation Land Services
Job TypeFull-time
 
Pittsburgh, PA
5 months ago
company-logo

Oil and Gas Title Attorney

Oliva Gibbs PLLC
Job TypeFull-time
 
Houston, TX
2 months ago
company-logo

Electrical Designer

Dudley Staffing
Job TypeFull-time
Salary
$45 - $60
Canonsburg, PA
5 months ago
company-logo

contract Landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Midland, TX
4 months ago
company-logo

Landman

Stockyards Energy Land Services
Job TypeContract
 
Akiachak, TX
6 months ago
company-logo

Civil/Structural Designer

Dudley Staffing
Job TypeFull-time
Salary
$30 - $60
Canonsburg, PA
5 months ago
EH

Project Management Specialist - Entry

Job TypeFull-time
 
West Palm Beach, Florida
4 days ago
company-logo

contract Landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Cheyenne, WY
4 months ago
company-logo

Mechanical/Piping Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, PA
5 months ago
company-logo

Senior Division Order Analyst

Formentera
Job TypeFull-time
Salary
$110000 - $130000
Austin, TX
about 1 year ago