Lead Analyst - Database Support

AVANGRID Inc.; Augusta (ME); On-site; USD 106,000 - 132,500; Full time

Benefits offered by this job

Competitive benefits

12% 401(k) match

Comprehensive health insurance

Tuition reimbursement

Professional development opportunities

Job summary

AVANGRID Inc. is seeking a Lead Analyst - Database Support (SQL Server DBA) in Augusta, Maine. This role involves supporting SQL Server database environments, monitoring systems for availability, and ensuring compliance with Cyber Security requirements. Candidates should have a strong SQL Server management background, with a degree in a relevant field and at least 2 years of experience. The position offers competitive salary and benefits, including a generous 401(k) match and tuition reimbursement.

Qualifications

• Minimum 2 years of RDBMS experience for Bachelor's Degree holders.
• Strong background in SQL Server database administration.
• Experience with applying database patches and managing security.

Responsibilities

• Support SQL Server database environments and applications.
• Monitor and maintain database systems for uninterrupted service.
• Analyze and extract system data for engineers as needed.

Skills

SQL Server management

Query Optimization

Performance Tuning

High availability methods

Disaster Recovery (DR)

Database security

Education

Bachelor’s Degree in related field

Associate Degree with relevant experience

Tools

SQL Server 2019

SolarWinds DPA

Veeam

Veritas backups

Job description

Department: Infrastructure Middleware & DBThe base salary range for this position is dependent upon experience and location, ranging from: $106,000 - $132,500**What We Offer:*** **Competitive benefits and growth opportunities*** **Generous performance‐based bonuses*** **12% 401(k) match*** **Comprehensive health, dental, and vision insurance*** **Tuition reimbursement*** **Professional development and clear career‐advancement pathways****For more information, please visit:****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 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 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#LI-Onsite#LI-VF1**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 [e-mail] 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.Avangrid employees may also be assigned a NERC Reliability Standards compliance role supporting Critical Infrastructure Protection (CIP) and/or Operations and Planning (O&P) responsibilities. This is applicable to employees that will work in electric transmission, operations, and cyber security business areas in Connecticut, Maine, Massachusetts, and New York within Avangrid Network and Corporate business areas. NERC Reliability Standards compliance roles and responsibilities may include additional access protections, training, audit engagement, and required evidence retention, and will be communicated by the employee’s management.**Job Posting End Date:**July-4-2026**Job Title: Lead Analyst - Database Support** **SQL Server DBA**Reports to: Supervisor - Infrastructure Middleware & DB Location: **In Office**, Augusta ME