Lead Analyst - Database Support Job Title: Lead Analyst - Database Support 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 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 installations 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 identifying issues on MS-SQL 2016/2019. Experience in high availability methods like clustering and/or mirroring, Always ON Availability Groups in multi-site environments. Experience in applying database patches, security patches, and application patches. Maintain stored procedures, indexes, SQL jobs, alerts, special procedures, views, functions, and 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 audit requirements and apply fixes if required. Experience with scheduling backups and restoring databases using SQL native backups; knowledge of Veeam and/or Veritas backups is a plus. Experience in SQL Mail configurations and notifications for job failures, as well as proactive notifications for blocking, deadlock, 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. Very good, in-depth knowledge 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 understanding of relevant industry compliance regulations and policies. Performing scheduled maintenance and supporting 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. Monitoring performance issues and availability on all production and non-production databases (as applicable). The ability to demonstrate good communication skills both written and orally. Experience making sound decisions while working in a high-pressure environment outside normal working hours. Working in storm or other emergency conditions for 24x7 system support. Prior experience 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 Mobility Information Any applicant who is not a citizen of the country of the vacancy will be subject to applicable immigration requirements to work legally in that country. AVANGRID's employment practices and policies are aimed at hiring a diverse workforce and maintaining an inclusive culture. AVANGRID provides fair and equitable employment opportunities and promotions to all employees and candidates regardless of race, color, religion, nationality, sex, sexual orientation, age, marital status, disability, protected veteran status, or any other condition protected by federal, state, or local law. December 2, 2024 Avangrid is a leading sustainable energy company transitioning America toward a clean and connected future. Headquartered in Orange, CT, Avangrid has a footprint in 24 states with $41 billion in assets. Our primary businesses are Networks, which serves 3.3 million electric and natural gas customers in the Northeast, as well as Renewables, which is the third-largest renewable energy company in the U.S. with a diverse onshore and offshore renewable energy portfolio. J-18808-Ljbffr
