Avangrid - Vestal, NY
posted 2 months ago
The Analyst - Database Support position at Avangrid Service Company is crucial for providing support to the AVANGRID Energy Control Systems (ECS), which are essential for the operation of Electric Transmission and Distribution Systems as well as Backoffice applications. This role involves supporting the design, development, and testing of functional requirements for various systems including the Electric Management System (EMS), Outage Management System (OMS), Transmission Network Analysis (TNA) systems, and Supervisory Control and Data Acquisition (SCADA) systems. The Analyst will be responsible for documenting all database system design, maintenance, and enhancement work, ensuring that all processes are well recorded and can be referenced in the future. In addition to documentation, the Analyst will proactively monitor and maintain all database and application systems to ensure uninterrupted service to the Energy Control Center (ECC). This includes analyzing, extracting, and making available system data for engineers upon request. The position requires a strong technical background, particularly in Oracle database administration, including experience with Oracle 19c, 12c, and 11g, as well as familiarity with Oracle Real Application Cluster (RAC), ASM technology, and Oracle DataGuard. The Analyst will also utilize various database utilities such as Oracle Data Pump, RMAN, and SQL Loader, and should possess knowledge of database programming languages like SQLPlus and PL/SQL. The role demands good communication skills, both written and oral, as the Analyst will need to make sound decisions in high-pressure situations, especially during storm or emergency conditions requiring 24-hour system support. The ability to work independently and proactively contribute to results is essential. Prior experience in the electric utility sector or similar industries is advantageous, as is familiarity with industry compliance regulations and policies such as NERC-CIP. The position may also require the Analyst to be on call for database and systems support activities, emphasizing the need for flexibility and readiness to respond to urgent issues as they arise.