Analyst - Database Support
📋 Role Overview & Responsibilities
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 environmentsGood Knowledge/Understanding of Network communication and services.Knowledge of at least one of the following is desirable: Shell Scripting, Python, C, Java ScriptBe 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 experienceAssociate Degree with 4+ years in RDBMS experience5-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
Frequently Asked Questions
How do I apply for the Analyst - Database Support position at Avangrid? ▼
Click the “Apply for this Position” button on this page to submit your application directly to Avangrid without recruitment intermediary fees.
Is this position eligible for remote work or visa sponsorship? ▼
This position is located in Vestal, NY with potential relocation and sponsorship assistance depending on candidate qualifications.
Are there any candidate fees on Hirely? ▼
No. Hirely is completely free for candidates. We never charge registration fees or placement fees.
Legitimate employers will never ask you to transfer funds, purchase equipment from unauthorized vendors, or pay application/visa fees. Hirely rigorously monitors listings, but always verify communication is from official corporate email domains.
Learn how to protect yourself against employment fraud →