Analyst - Database Support

Posted 8 Days Ago
Be an Early Applicant
5 Locations
78K-107K Annually
Junior
Energy • Renewable Energy
The Role
The Analyst - Database Support role involves administering Oracle databases, providing technical support for Energy Control Systems, ensuring database performance and availability, and assisting engineers in data analysis. Candidates must have strong database administration experience and be willing to work on-call during emergencies.
Summary Generated by Built In

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 $78,091 - $107,375

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 19c, 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

Note: The above Key Responsibilities/Duties are not intended to be all inclusive. Employees in this position may be required to perform other related aspects of the job not listed above or listed under Purpose/Major Objectives as assigned by the supervisor.

#LI-OFFICE
#LI-ER1

Company:

AVANGRID SERVICE COMPANY

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, 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 [email protected]

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:

February-28-2025

Top Skills

C
Java
Oracle
Python
SQL
The Company
Bilbao, , Biscay
25,323 Employees
On-site Workplace

What We Do

With more than 180 years of history, Iberdrola is today a global energy leader, the leading wind power producer and one of the largest electricity companies in the world in terms of stock market capitalisation.

We have been committed to clean energy for more than 20 years with the objective of exceeding 52,000 MW of renewable capacity by 2025.

The group supplies energy to nearly 100 million people in dozens of countries, has more than 600,000 shareholders, a workforce of more than 42,300 employees.

We are leading the energy transition to a sustainable model through our investments in renewables, smart grids, large-scale energy storage and digital transformation to deliver the most advanced products and services to our customers.

Find out more in 'Life at Iberdrola

Similar Jobs

Ahold Delhaize USA Logo Ahold Delhaize USA

Data Management Support Analyst III

AdTech • eCommerce • Food • Marketing Tech • Retail
Scarborough, ME, USA
10000 Employees

Iberdrola Logo Iberdrola

Lead Analyst - Database Support

Energy • Renewable Energy
4 Locations
25323 Employees
112K-139K Annually

Ahold Delhaize USA Logo Ahold Delhaize USA

Enterprise Platform Architect- EUC & Collaboration

AdTech • eCommerce • Food • Marketing Tech • Retail
Scarborough, ME, USA
10000 Employees
132K-204K Annually

Ahold Delhaize USA Logo Ahold Delhaize USA

Enterprise Platform Architect- IT Technology Management

AdTech • eCommerce • Food • Marketing Tech • Retail
Scarborough, ME, USA
10000 Employees

Similar Companies Hiring

UL Solutions Thumbnail
Software • Renewable Energy • Professional Services • Energy • Consulting • Chemical • Automotive
Chicago, IL
15000 Employees
Energy CX Thumbnail
Utilities • Professional Services • Greentech • Financial Services • Energy • Consulting • Business Intelligence
Chicago, IL
55 Employees
InCommodities Thumbnail
Renewable Energy • Machine Learning • Information Technology • Energy • Automation • Analytics
Austin, TX
234 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account