Analyst | Database Support

Job highlights
Identified by Google from the original job post
Qualifications
This position requires experience as a DB Admin
Those with a pure Analyst background with not be considered
Experience in Oracle database administration in Oracle 1+c, Oracle 12c, or Oracle 11g
Experience in administering Oracle Real Application Cluster (RAC), ASM technology and Oracle DataGuard in all above versions of Oracle
Experience in the use of database utilities like Oracle Data Pump, RMAN, Oracle Imp/Exp and/or SQL*Loader
Knowledge of database programming, SQL*Plus and PL/SQL, Materialized views, Triggers, using Database Change Notification
General knowledge in using/working on virtual environments
Good Knowledge/Understanding of Network communication and services
Be on call on an on-call roster for database and systems support activity
General Knowledge & Skills
Working with the understanding of relevant Industry Compliance Regulations and Policies
The ability to demonstrate good communication skills both written and orally
Experience in making sound decisions while working in a high-pressure environment
Working during storm or other emergency conditions for 24-hour system support
Able to work independently and contribute proactively to drive results
Prior experience in working with Electric Utilities or with any other utilities 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
High school diploma/GED with 5 to 7+ years’ IT and RDBMS related experience
Benefits
The base salary range for this position is dependent upon experience and location, ranging from $76,186 - $104,756
Responsibilities
Provides support for the AVANGRID Energy Control Systems (ECS) used to operate Electric Transmission & Distribution Systems and Backoffice applications
Support Systems design, development & testing of functional requirements of the Electric Management System (EMS), Outage Management System (OMS), Transmission Network Analysis (TNA) systems and Supervisory Control and Data Acquisition (SCADA) systems
Document and all database system design, maintenance and enhancement work
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
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 AVANGRD Network and Corporate functions
Job description
This position requires experience as a DB Admin. Those with a pure Analyst background with not be considered.

The base salary range for this position is dependent upon experience and location, ranging from $76,186 - $104,756

Job Description

Purpose
• Provides support for the AVANGRID Energy Control Systems (ECS) used to operate Electric Transmission & Distribution Systems and Backoffice applications.
• Support Systems design, development & testing of functional requirements of the Electric Management System (EMS), Outage Management System (OMS), Transmission Network Analysis (TNA) systems and Supervisory Control and Data Acquisition (SCADA) systems.
• Document and all database system design, maintenance and enhancement work.
• 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.

Key Technical Working Skills
• Experience in Oracle database administration in Oracle 1+c, Oracle 12c, or Oracle 11g.
• Experience in administering Oracle Real Application Cluster (RAC), ASM technology and Oracle DataGuard in all above versions of Oracle.
• Experience in the use of database utilities like Oracle Data Pump, RMAN, Oracle Imp/Exp and/or SQL*Loader.
• Knowledge of database programming, SQL*Plus and PL/SQL, Materialized views, Triggers, using Database Change Notification.
• General knowledge in using/working on virtual environments
• Good Knowledge/Understanding of Network communication and services.
• Knowledge of at least one of the following is desirable: Shell Scripting, Python, C, Java Script
• Be on call on an on-call roster for database and systems support activity.
• Experience in database tuning and SQL tuning for applications is a plus.
• Experience working with RedHat Enterprise Linux and/or Oracle Solaris UNIX is a plus.
• Experience working with Exadata Servers and/or Oracle Linux on Exadata Servers is a plus.

General Knowledge & Skills
• Working with the understanding of relevant Industry Compliance Regulations and Policies. (E.g. NERC-CIP, etc. training will be provided)
• The ability to demonstrate good communication skills both written and orally. Experience in making sound decisions while working in a high-pressure environment.
• Working during storm or other emergency conditions for 24-hour system support.
• Able to work independently and contribute proactively to drive results.
• Prior experience in working with Electric Utilities or with any other utilities 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
• High school diploma/GED with 5 to 7+ years’ IT and RDBMS related experience

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

AVANGRID’s employment practices and policies are geared to hiring a diverse workforce and sustaining an inclusive culture. At AVANGRID we provide fair and equal employment and advancement opportunities for all employees and candidates regardless of race, color, religion, national origin, gender, ****** 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 AVANGRD Network and Corporate functions. This does not include those that will work for Avangrid Renewables

Job Posting End Date

December-23-2024