Avangrid · 22 hours ago
Lead Analyst - Database Support
Augusta, ME
Full-time
Onsite
Mid, Senior Level
$106K/yr - $132K/yr
5+ years expAvangrid is a company focused on providing energy solutions, and they are seeking a Lead Analyst for Database Support. The role involves supporting SQL Server database environments and applications, ensuring uninterrupted service, and maintaining database systems for the Energy Control Center.
Charity
Responsibilities
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
Qualification
Required
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
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
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
Preferred
Experience in SolarWinds DPA is a plus
Experience in Datacenter Migrations is a plus
Company
Avangrid
Avangrid, Inc.
Founded in 1997Orange, Connecticut, USA
5001-10000 employees
H1B Sponsorship
Avangrid has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (9)
2024 (5)
2023 (6)
2022 (5)
2021 (3)
2020 (3)
Funding
Current Stage
Late StageLeadership Team
Alfredo del Canto
SVP Chief of Staff to CEO
Bob Kump
Deputy CEO and President
Recent News
Company data provided by crunchbase