SCADA SYSTEMS DATABASE ANALYST

This position primarily is responsible for maintaining and developing GRU’s EMS computer software. The primary function of the EMS is to monitor and control the GRU's Bulk Power transmission, generation and distribution system. Monitors all EMS workstations and servers and interpret the logs, on 5 different systems namely, primary EMS (PCC,) backup EMS (BCC,) Quality Assurance System (QAS,) and PI reporting system, on a 24X7 basis, to ensure the system's compliance with NERC CIP requirements. Make continuous improvements to EMS systems to ensure the GRU’s grid control center has necessary tools to sufficiently operate the GRU’s transmission grid. Contribute to developing new, enhanced and improved applications and monitoring software to improve the reliability and availability of GRU’s transmission grid operations. Work on maintaining the GRU’s real-time EMS (Energy Management System), including system upgrades, integration, databases, and software and applications support. Positions allocated to this classification report to a designated supervisor and work under limited supervision. Work in this class is distinguished by its advanced technical and operational skills.

 

Job Description:

SUMMARY

This is professional and moderately complex technical work analyzing, designing, implementing and maintaining departmental SCADA systems.

Positions allocated to this classification report to a designated supervisor and work under limited supervision.  Work in this class is distinguished by its advanced technical and operational skills.

EXAMPLES OF WORK*

*This section of the job description is not intended to be a comprehensive list of duties and responsibilities of the position.  The omission of a specific job function does not absolve an employee from being required to perform additional tasks incidental to or inherent in the job.  Performance of lower level duties may be required.

ESSENTIAL JOB FUNCTIONS

Monitors, updates, and develops the SCADA system to ensure the proper performance, function and control of the EMS.

Performs daily monitoring, analyzing and problem resolution within any of the OSI Monarch platform software.

Creates and updates system displays and substation one-lines used by the system operators using OSI Display Builder and Tabular Builder.

Acts as the lead administrator for the OSIsoft PI database responsible for updates and additions of new data tags using PI SMT and PI Builder.

Provides technical assistance and training to system operators.

Schedules and manages projects with engineering and other departments as required.

Attends work on a continuous and regular basis.

NON-ESSENTIAL JOB FUNCTIONS

Reviews compliance to NERC Critical Infrastructure Protection and Cyber Security.

Programs encryption modules and cellular modems used for remote network communications.

Prepares and maintains configuration control documents.

May require on-call responsibilities.

May require after-hours and weekend responsibilities.

Performs other related duties as assigned.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential job function satisfactorily.  Below are the required education, experience, knowledge, skills and abilities to perform the essential functions.

EDUCATION AND EXPERIENCE

Bachelor’s degree from an accredited college or university with major course work in electrical engineering, information technology, computer sciences, computer programming, information science, networks, system engineering and five(5) years of progressively responsible SCADA or EMS related fields; or An Associate degree from an accredited college or university with major course work in information technology, computer sciences, computer programming, information sciences or system engineering, and seven (7) years of progressively responsible SCADA or EMS related field, or

Graduation from high school or possession of an acceptable equivalency diploma, and current generally accepted certification in an IT area of expertise, and nine (9) years of progressively responsible SCADA or EMS related field.

CERTIFICATIONS OR LICENSES

Licenses

Valid driver license required.  Valid Florida driver license required within 30 days of appointment.

Certifications

None.

      KNOWLEDGE, SKILLS AND ABILITIES

Thorough knowledge of advanced problem-solving techniques.

Thorough knowledge of systems administration and performance management.

Thorough knowledge of the administration of Server Platform 11 Monarch System trained by OSI.

Thorough knowledge of the OSIsoft PI database software.

Thorough knowledge of Windows server and Active Directory.

Knowledge of computer networks.

Knowledge of web-based design and programming.

Knowledge of real-time or relational databases.

Knowledge of database design.

Working knowledge of database application software, data mining and reporting.

Ability to plan, develop, and test a wide variety of programs and software used by system control and their operators.

Ability to prepare and maintain records for configuration management.

Ability to perform repairs on RTU units within the electric substation.

Ability to communicate effectively, both orally and in writing.

Ability to work effectively in a team-oriented environment.

Ability to interface systems accurately and independently.

Ability to work effectively with coworkers and the general public.

Ability to work under limited supervision.

PHYSICAL AND ENVIRONMENTAL REQUIREMENTS

To perform this job successfully, an individual must possess certain physical abilities and be able to withstand work related environmental conditions.

PHYSICAL REQUIREMENTS

Work is sedentary and requires prolonged hours of sitting.

WORK ENVIRONMENT

May be required to travel locally to other general government or GRU locations within the Gainesville area.

May be required to work after-hours and provide weekend support.

 

Note: 

May Require Assessment(s).

May fill multiple positions.

May establish an eligibility list.

 

Come join our team! The City of Gainesville offers a competitive benefits package and opportunities to grow both professionally and personally.

 

All ‘regular’ employees are eligible for traditional benefits such as health insurance, life insurance, paid leave, 11 paid a holidays a year, a pension plan and a deferred compensation plan, but we also offer great things like on-site fitness centers, tuition reimbursement, on-site medical staff and a wellness program to keep you healthy and happy. Please note; benefits are not available for temporary employees.

 

Equal Opportunity

The City of Gainesville is an equal opportunity/affirmative action employer and does not discriminate in hiring. Minorities, women and individuals with disabilities are encouraged to apply. Individuals with a disability, who require special accommodations during the selection process, should notify the Human Resources Department at 352-334-5077 or TDD/TTY at 352-334-2292.

 

Veterans' Preference

Veterans are encouraged to apply. Veterans’ Preference ensures that veterans and eligible persons are given consideration at each step of the selection process. However, preference does not guarantee that a veteran or other eligible person will be the candidate selected to fill the position. Section 295.07, Florida Statutes (F.S.) specifies who is eligible for Veterans’ Preference. State of Florida residency is not required for Veterans’ Preference.

 

If you are unable to apply online due to a disability, contact recruiting at HR@cityofgainesville.org or by calling 352-334-5077.