We are engineers, high line workers, power plant managers, accountants, electricians, project coordinators, risk analysts, customer service operators, community representatives, safety and security specialists, communicators, human resources partners, information technology technicians and much, much more. We are 3,300 people committed to enhancing the lives of the communities we serve. Together, we are powering the growth and success of our community progress every day!
PAY GRADE: 14
Extended to Apply: Open Until Filled
The Developer Apex position is responsible for Oracle APEX/Oracle development and administration of easy to use and intuitive database applications, performance tuning, security, auditing, metadata management, capacity planning, connectivity and other data solutions of mission critical application systems. The developer will participate in all phases of the development lifecycle including requirements gathering, specifications development, design, development, testing, implementation, documentation, training, maintenance, upgrade, migrate, and reverse engineering. Develops applications with APEX, SQL, PL/SQL, stored procedures, triggers, transactional modeling, dimensional modeling, normalization, indexing methods, constraints, object usage, Linux shell script and PowerShell.
Tasks and Responsibilities
Builds and maintains the ongoing operational functionality and efficiency of CPS Energy APEX and Oracle solutions ensuring Development, system performance, availability, reliability, security, recoverability and efficient usage of code and resources.
Formulates SQL (Structured Query Language) queries, functions and processes as per customization requirement for APEX customers.
Supports APEX applications and conducts performance tuning for SQL, PLSQL.
Develops and creates database designs and assists in decreasing response time for APEX reports.
Designs application frameworks and helps develop Oracle APEX Applications.
Provides APEX guidance and support to technical staff on application maintenance and SDLC processes.
Reviews peer code and documents proof of concepts and database schemas.
Performs the capacity planning required to create and maintain corporate APEX applications, databases, and processing demands.
Provides all facets of APEX development, administration, quality assurance, and production systems support.
Provides APEX solutions to solve complex business issues including data processing, data loading, automation improvements, data integrity, and data presentation.
Diagnoses, troubleshoots and resolves APEX application and database related issues including development, performance, availability, data integrity and application security.
Performs and automates APEX application and database management, maintenance and data processing activities.
Develops scripts to perform system maintenance, monitor applications, automate routine tasks, etc.
Performs as a technology subject matter expert for APEX applications database such as Oracle APEX 5/19/20 (Oracle Application Express) administration/Development, SQL Developer, PL/SQL, Toad, modeling tools, etc.
Modifies existing databases and database management systems to make changes with appropriate database objects such as code, forms, indexes, tables, partitions, triggers, constraints, stored procedures, large objects, views, etc.
Works as part of a project team to coordinate APEX database development and determine project scope and limitations.
Trains users, documents systems and answers questions.
Specifies users and user access levels for each segment of APEX application and database. Setup of APEX groups, monitoring, and templates to effectively monitor critical applications.
Reviews project requests describing APEX user’s needs to estimate time and cost required to accomplish projects.
Administers all APEX objects, code, forms, including tables, indexes, views and sequences, packages and procedures.
Evaluates releases of Oracle APEX and it's tools, and third-party products to ensure that the organization is running the products that are most appropriate.
Collaboration with various technical/non-technical resources such as citizen developers, application teams and co-workers regarding project work, POCs (Proofs of Concept) and/or troubleshooting exercises.
On-call rotation is required to support 24/7 environment and is also expected to be able to work outside business hours to support corporate needs.
Performs other duties as assigned.
Minimum Knowledge and Abilities
Experience in a Production Oracle APEX ecosystem or higher education equivalent.
Experience in Application Administration/Development using Oracle SQL, PL/SQL, and Developer Oracle Application Express (APEX).
Hands-on experience with Oracle APEX 4.0/4.1/5.0/19/20 (Oracle Application Express) administration/Development.
Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
Skilled in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
Hands on experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
Experience in developing External Tables, Joins, Indexes and sequences.
Worked with third party database tools like TOAD and SQL Developer
Excellent knowledge of Oracle APEX 4.0/4.1/5.0/19/20 (Oracle Application Express) administration/Development, Oracle Database, PL/SQL and SQL.
Experience in Database design using Normalization and Entity Relationship Diagrams.
Experience in using built-in database packages (DBMS_SCHEDULER).
Experience in developing forms based on views, tables and procedures in tabular and form layouts.
Experience in developing both web layout and paper lay out reports in various styles based on the user requirements.
Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
Creating users and maintaining their roles and responsibilities.
Experience in writing Technical design documents and developing unit test documents.
Strong ability to organize information, manage tasks and use available tools to effectively contribute to a team and the organization.
Strong communication and interpersonal skills, ability to interact with people at all levels.
Valid Class C Texas Driver's License
Makes independent technical recommendations.
Proficient in Microsoft Office Package, including word processing, spreadsheets, database, presentation software, electronic mail and scheduling
Master’s degree in Information Systems or related field from an accredited university.
Image Oracle certifications are a plus. Examples include: Oracle APEX Developer Professional, Oracle Autonomous database, Oracle Cloud Infrastructure, Oracle Certified Associate, Oracle Certified Professional.
Utility Industry experience.
NERC (North American Electric Reliability Corporation) background and experience.
Hands on experience with Oracle database administration in UNIX and virtual environments.
Skilled in performing detailed performance analysis and resource utilization of systems.
Proficiency with Oracle backups, restores and recovery models.
Hands on experience with High Availability (HA) and Disaster Recovery (DR) options for Oracle (RAC/Data Guard).
Know-how in migrating code and database changes through the various stages of the development life cycle.
Skilled in troubleshooting and performance tuning skills with Oracle databases.
Experience in project management concepts, tools (MS Project) and techniques.
Hands on experience as technology subject matter expert for at least three versions of relational database management systems such as Oracle 9i, 10g, 11g, 12c, 18c and 19c.
Installation, configuration and administration of Oracle Golden Gate replication that includes troubleshooting of extracts, pump, and replication processes.
OEM (Oracle Enterprise Manager) troubleshooting of database performance tuning and generating reports using Information Publisher and BI Publisher reports.
Skilled in using Recovery Manager (RMAN) and ASM (Automatic Storage Management) for backups and storage management.
Using Computers and Technology
Bachelor’s degree from an accredited institution in Information Systems, Computer Science, Electrical Engineering or a related field
Indoor work, operating computer, manual dexterity, talking, hearing, repetitive motion. Use of personal computing equipment, telephone, multi-functioning printer and calculator. Ability to travel between business related events. Work hours may be extended.
monthly, or more frequently as needed. Overnight travel may be required.
Exerting up to 10 pounds of force occasionally, and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.
Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.
CPS Energy does not discriminate against applicants or employees. CPS Energy is committed to providing equal opportunity in all of its employment practices, including selection, hiring, promotion, transfers and compensation, to all qualified applicants and employees without regard to race, religion, color, sex, sexual orientation, gender identity, national origin, citizenship status, veteran status, pregnancy, age, disability, genetic information or any other protected status. CPS Energy will comply with all laws and regulations.