Job Title: Lead Analyst - Database Administration Oracle DBA
Company: AVANGRID SERVICE COMPANY
Location: CT, NY Vestal, Rochester, Maine
Reports to (Title): Supervisor - Infra Middleware & DB
The base salary range for this position is $107,254 to $139,431and is dependent upon experience.
Job Description
Purpose
Provides database support for AVANGRID's Outage Management System (OMS) and other proprietary applications.
Support systems development & testing of functional requirements of the Outage Management System (OMS) and Focal Point Application.
Creating RDBMS environments for projects and business requirements.
Proactively monitor and maintain all database and application systems for an uninterrupted service.
Document all database system designs, maintenance, and enhancement work.
Section Title: Key Technical Working Skills
Strong background in Oracle database administration in Oracle 19c, Oracle 12c and Oracle 11g.
Strong background in administering Oracle Real Application Cluster (RAC), ASM technology, and Oracle DataGuard in all the above versions of Oracle.
Strong background 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.
Experience in database tuning and SQL tuning for applications.
Experience working with RedHat Enterprise Linux and Oracle Solaris UNIX.
Experience working with Exadata Servers and Oracle Linux on Exadata Servers
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.
Section Title: 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 oral. Experience in making sound decisions while working in a high-pressure environment.
Working during a 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.
Section Title: Requirements
Education and Experience: (Must meet at least one of the following)
Bachelor's Degree with 5+ years in RDBMS experience
Associate Degree with 7+ years in RDBMS experience
7-10+ 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
