Who: Seattle Public Utilities
Position: Senior SCADA Developer
Where: Seattle
What: Seattle Public Utilities (SPU) has an exciting opportunity in its Application Services Business Development team. This is for a Sr. SCADA Developer, which provides critical analysis, development expertise and system administration of the SPU’s Supervisory Control and DATA Acquisition (SCADA) system. This key position will act as a primary contact and liaison with SPU IT’s customers, which include Drainage and Wastewater, Water, Solid Waste, Operations and Control Center, and the watersheds.
Responsibilities:
• Maintain and enhance I-SCADA IMS Water line of business web site portal application (Oracle OLTP and OLAP), its collection process (Oracle/PL/SQL) and presentation of its content;
• Maintain and enhance I-SCADA IMS Drainage and Wastewater Wonderware Portal (SQL Server, TSQL) and presentation of this site content;
• Configure/manage the Reading Points/Wonderware tag creation in the IMS databases;
• Maintain and enhance .NET developed system application to include support for all lines of business; design, develop and maintain .NET Services for internal/external data collection, management and sharing;
• Provide end user support of I-SCADA applications and monitor them and their performance to ensure they are operating as intended;
• Develop and manage reports (Oracle Portal & SL Reporting Services);
• Assist the extended IT team in troubleshooting application issues using general knowledge of the flow of application data through network, database and servers;
• Maintain and update application technical and user documentation; coordinate the documentation collaboration site that will keep users appraised of scheduled outages and maintenance;
• Ensure code and designs meet all specifications, quality, architectural and security standards;
• Comply with SPU’s configuration management/version control policies;
• Communicate effectively and build strong relationships with team members and customers on technical and business tasks;
• Develop and execute software test plans (unit, backend, integrations testing); coordinate user acceptance testing;
• Comply with Software Development Life Cycle (SDLC) standards for SPU IT;
• Develop end user training materials and conduct training sessions for business power users when necessary;
• Apply technical knowledge and experience to identify options, costs and benefits;
• Translate requirements into clear. concise documentation for scalable, robust and flexible designs;
• Guide internal customers through problem and issue definition, business process review and analysis to identify and document data, functional and technical software requirements for complex systems development;
• Maintain in-depth knowledge of SPU’s business, strategic and technology plans.
Requirements:
A BA/BS degree in Computer Science, Civil Engineering, Environmental Sciences, or a related field or additional qualifying experience.
Experience
· Qualified candidates will have demonstrated the following skills, knowledge and experience working with applications systems and development teams:
• 5 years combined experience as an analyst-developer on various technologies in a large project environment, including client /server applications, relational databases, web-based applications and data warehouse applications;
• 4 years of experience writing complex T SQL using Oracle PL/SQL and packages;
• 3 years of experience developing .Net applications and/or services;
• 2 years of experience developing applications that connect cross-database platforms (Oracle, SQL Server);
• Experience developing or maintaining operational systems and applications in an Object-oriented development environment;
• Experience using Microsoft office 2013 applications (Word, Excel, Access, Project, Visio and SharePoint online);
• Experience working with a Software Development Life Cycle (SDLC), including participation in the entire process (requirements and analysis through testing, implementation and closeout).
Equivalency
A combination of education and/or training and /or experience which provides an equivalent background required to perform the work of the class.
• Experience working with utility industry systems;
• An understanding of SCADA (Supervisor Control and Data Acquisition) systems;
• Experience using Oracle 11G environment;
• Experience with current state-of-the-art architectures and development languages including: AJAX, JQuery, MVC3, HTML5, WSDL, and WCF;
• Experience with SQL Reporting Services;
• Ability to communicate with all technical skill levels (entry level to skilled);
• Experience with source control-type tools for change management;
• Excellent verbal and written communication skills with the ability to tailor content and delivery based on the target audience including excellent technical and business writing skills;
• Ability to produce high quality deliverables while maintaining schedule commitments;
• Experience creating strong working relationships with co-workers in business units, technology teams and across all levels of the organization;
• Strong business ethics;
• Ability to work independently and as part of a team.
How: Apply Here