SCADA HMI engineer/developer, SCADA security architect, container developer, Senior Oracle DBA, Oracle Applications DBA, Oracle Pharmaceuticals DBA, Oracle Trainer, SQL Server DBA, database architect/designer. Program/Project manager, and computer systems engineer with over 20 years in the computer industry. Areas of expertise include database administration, database tuning, backup/recovery, Oracle RAC/ASM, Oracle Data Guard, Cloud Computing, Virtualization, database migration, data warehouse/data marts, VLDB/Big Data, IoT, training, UNIX scripting, technical writing, systems engineering, data analysis, ITIL processes, system administration, data communications, client/server technologies, VM environments, Graphical User Interface design/programming, and imaging systems.
I am experienced in the architecture, design, implementation and migration of database management systems including SCADA HMI programming, Virtual Machines, Decision Support Systems (DSS), Data Warehouse, Cloud computing, Containers, and On-Line Transaction Processing (OLTP) systems using the Oracle/Oracle Applications and Microsoft SQL Server relational database management systems.
I have also directed the training of personnel in user oriented environments, including course development and layout as well as the development of lesson plans and student hand-outs. Business related background also includes training personnel with nearly 3,500 classroom hours as an instructor, teaching such disciplines as Ignition HNI, Oracle DBA, Oracle developer, Microsoft Office Suite, and various programming languages (C, C++, Java and Python). Object oriented analysis and design (FURPS+, UML, Use Cases, User stories, SOW’s, class diagrams, sequence diagrams, etc.)
I have directed budgets, task scheduling, strategic project planning, risk management, new systems development, financial reporting, and cost accounting.
? Follow-up customer issues and perform necessary troubleshooting, fault finding and diagnostics
? Maintain SCADA systems in Southern California Water/Electric districts subject to conditions of Operation and Maintenance contracts
? Coordinate field efforts to support the new product introductions and the validation of these products during field trials
? Coordinate with SCADA product support teams to design and configure market specific enhancements to SCADA systems
? Drive prompt closure of field issues, interfacing with various engineering groups on known issues and solutions, and promptly issuing feedback to the SCADA product development teams
? Work with other field support organizations, acting as the "top-tier" field support for the SCADA and Water/Electric Management products including Wonderware, Ignition, WIN911, SCADATek, Kepware, SEL and ISA 101 Human Machine Interface (HMI)
? Develop and maintain standardized work procedures for PLC’s, testing, and other automated equipment
? Develop and maintain spare parts inventory with reorder points
? Developed AI troubleshooting Wiki for cataloging SCADA problems, troubleshooting methods, and remedies
? Active maintenance team member in assisting in all areas of inspection, development, troubleshooting, and maintenance
? Conduct continuous improvement projects related to PLC, testing and protecting automated equipment
? Provide leadership and guidance for SCADA automation technicians
Page 2 of 6
? Define and improve internal procedures to manage the systems maintenance within the company guidelines and compliance framework
? Perform detailed problem analysis on critical incidents to prevent reoccurring issues and improve resolution time
? Complete SCADA assessments, develop SCADA Master Plans, and develop control system design documents. Program, test, and commission control systems
? Technical management, planning and controlling of one’s own engineering work packages
? Coordination of SCADA system service delivery (troubleshooting, development, upgrades and training) with operations and other automation groups
? Support of sales departments and project management during both, the bid phase and the project execution phase.
? SCADA Security and penetration testing (Logical and Physical)
? Database planning, scaling, and capacity planning
? Database design, database/index creation, database optimization, backup/recovery, and performance tuning.
? Design and implement new data models, tables, and schemas to support new functionality
? Administration and management of all database software patches and upgrades
? Ensure high availability, scalability, backup and recovery of production databases
? Manage physical standby/failover servers in remote facilities
? Support the database application programming activities of development groups
? Work with developers to test, de-bug and migrate test code into production
? Develop PL/SQL stored procedures and triggers to support applications
? Develop and support SQL forms & reports as well as reporting methods and tools (including web-based tools)
? Experienced oracle trainer teaching such disciplines as oracle DBA and oracle developer
? HMI Programming (Ignition/InTouch, WIN911, Kepware, AccSELerator)
? Cyber security and SCADA intrusion expert
? Container Development/Deployment
? Manage multiple oracle database instances in high transaction/high availability/high volume environments.
? Ability to maintain several development, test, and production database simultaneously.
? Cloud Computing, Virtualization, Data Warehouse, PL/SQL, stored procedures, and database triggers design/development
? RAC/ASM, Data Guard, Cloud Computing, VM virtualization environments
? UNIX/Linux scripting, Windows scripting, Batch processing (UNIX/DOS)
? Strong database maintenance and protection (security), backup/recovery/disaster recovery (RMAN, Data Guard, oracle replication, etc.), and disaster planning/recovery
? Object oriented analysis and design (OOAD)
? Experience with oracle RAC/ASM and other high availability architectures, including Oraback, Veritas, etc.
? Tools: oracle APEX, Erwin, T.O.A.D., oracle SQL*Plus/SQLcl, Crystal reports, oracle SQL Developer/Data Modeler, oracle Enterprise Manager, Win Batch, C/C++, Visual Basic, Java, Python, oracle SQL*Forms, UNIX shell scripting, DOS batch, and most Quest software tools
? Large scale databases (> 25 terabytes) Big Data (Petabytes), and ILM processes and policies
? OOAD (FURPS+, UML, Use Cases, User stories, SOW’s, class diagrams, sequence diagrams, etc.)
? General UNIX/Linux systems administration and strong UNIX/Linux programming experience (Shell scripting).
? Excellent written and oral communications skills with demonstrated commitment to the production of high quality documentation