Job Title: Analyst – Database Administration – Oracle DBA
Location: Vestal NY, Orange CT, Rochester NY or Augusta ME
Work type: Office
Reports to: Supervisor, Database & Middleware
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 19c, Oracle 12c and 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
5-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, 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 careers@avangrid.com
Job Posting End Date: