Senior Oracle Developer

** The incumbent may be based in any of our service territories or in Texas.
** The Sr Analyst Application Services/Technical is a high-level individual contributor in the Application Services area of the Information Services (I/S) department. This position leads, modifies, configures, tests, implements, and maintains third-party computer application software and/or designs and develops specialized fit-to-purpose programs utilizing Company standards and practices. The position analyzes business needs, translates needs into requirements, and develops or recommends software solutions with the aim of optimizing operational efficiency.

This position also supports business operations by providing guidance, training, and system support while continuously analyzing current business processes against related policies and procedures to promote technology innovations aimed to maximize productivity and standardization across the organization. This position performs work with a high degree of latitude and independently at times and handles the most complex issues and problems using advanced theories, methods, and techniques to complete work.

Provides leadership, coaching, and/or mentoring to Analyst I/Application Services and Analyst II/Application Services.

POSITION DIMENSIONS The incumbent does not have accountability for budgets but may have accountability for direct reports. The incumbent frequently exchanges information with senior management, Information Services support staff, vendors, and consultants.

QUALIFICATIONS There are clear precedents and practices which the incumbent uses to determine how this job is performed. Possesses expert technical knowledge of subject matter. Requires four to six years of relevant work experience and a bachelor’s degree in a related field from an accredited university, or equivalent combination of education and experience sufficient to successfully perform the essential job responsibilities.

Competencies required:
Ability to work as part of a team;
Problem management;
Problem-solving skills;
Analytical thinking skills;
Technical expertise;
Debugging skills;
Computer skills;
Detail oriented;
Ability to meet deadlines;
Project management skills;
In-depth experience with two or mo reprogramming languages or frameworks.

Industry recognized certification(s) relevant to responsibilities are preferred. Incumbents performing activities requiring government, regulatory or vendor certification must keep those certifications current.

ESSENTIAL JOB RESPONSIBILITIES Design, develop and maintain front end GUI screens for a custom application using Oracle Fusion Middleware Development Tools.  Proficiency and experience with Oracle Forms and Oracle Reports is required for this position.

Design and maintain Oracle RDBMS and related objects (tables, views, stored procedures, triggers, packages).Design, develop and maintain complex PL/SQL code within procedures, functions, packages, triggers.

Design, develop and debug complex SQL queries including dynamic SQL.Participate in established software system testing and validation procedures and documentation.

Plan, design, and conduct appropriate levels of application or infrastructure testing, including preparation of test plans, scripts, data, and expected results.

Support production environment by troubleshooting issues and working rapidly to provide a workaround or resolution to the stated issue.

Consult with business support group and application users to understand business requirements and translate those concepts into a formal technical design.

Select and utilize appropriate troubleshooting approaches to address customer specific issues in a comprehensive and useful manner, display a broad grasp of the relevant technical concepts, and…