Iberdrola SA
Lead Analyst - Database Support page is loaded **Lead Analyst - Database Support****Lead Analyst - Database Support**locationsEstados Unidos, Maine, AugustaNY - Rochester - Scottsville RdNY - Vestal - Binghamton ECCCT - Orange - 180 Marsh Hill Rd
posted onPublicado hoy
time left to applyFecha final: 26 de febrero de 2025 (Quedan 27 días para realizar la solicitud)
job requisition idR-09759
**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 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**Información Movilidad**
Tenga en cuenta que cualquier solicitante que no sea ciudadano del país de la vacante estará sujeto al cumplimiento de los requisitos de inmigración aplicables para trabajar legalmente en ese país.
Las prácticas y políticas de empleo de AVANGRID están orientadas a la contratación de una plantilla diversa y al mantenimiento de una cultura inclusiva.
En AVANGRID ofrecemos oportunidades de empleo y promoción justas y equitativas a todos los empleados y candidatos independientemente de su raza, color, religión, nacionalidad, sexo, orientación sexual, edad, estado civil, discapacidad, condición de veterano protegido o cualquier otra condición protegida por la legislación federal, estatal o local. Obtenga más información sobre igualdad en el empleo en este enlace
Si usted es una persona con una discapacidad o un veterano discapacitado que no puede utilizar nuestra herramienta en línea para buscar o aplicar a un empleo, puede solicitar una adaptación razonable poniéndose en contacto con nuestro departamento de Recursos Humanos en el 203-499-2777 o en careers@avangrid.comFebruary-26-2025 #J-18808-Ljbffr
posted onPublicado hoy
time left to applyFecha final: 26 de febrero de 2025 (Quedan 27 días para realizar la solicitud)
job requisition idR-09759
**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 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**Información Movilidad**
Tenga en cuenta que cualquier solicitante que no sea ciudadano del país de la vacante estará sujeto al cumplimiento de los requisitos de inmigración aplicables para trabajar legalmente en ese país.
Las prácticas y políticas de empleo de AVANGRID están orientadas a la contratación de una plantilla diversa y al mantenimiento de una cultura inclusiva.
En AVANGRID ofrecemos oportunidades de empleo y promoción justas y equitativas a todos los empleados y candidatos independientemente de su raza, color, religión, nacionalidad, sexo, orientación sexual, edad, estado civil, discapacidad, condición de veterano protegido o cualquier otra condición protegida por la legislación federal, estatal o local. Obtenga más información sobre igualdad en el empleo en este enlace
Si usted es una persona con una discapacidad o un veterano discapacitado que no puede utilizar nuestra herramienta en línea para buscar o aplicar a un empleo, puede solicitar una adaptación razonable poniéndose en contacto con nuestro departamento de Recursos Humanos en el 203-499-2777 o en careers@avangrid.comFebruary-26-2025 #J-18808-Ljbffr