Position Summary:

Under the direction of the Director, the Oracle Developer II provides systems development support for the school district's Oracle ERP system. The work involves moderate to full-range tasks as assigned by the supervisor in the analysis, design/development and testing of Oracle 12i applications and customizations across related functional areas and the development of conversion and system implementation plans that ensures software, developed and deployed to the production environment, adheres to specified requirements, satisfies end-user needs and expectations, and meets the objectives of Prince George’s County Public Schools.

Duties and Responsibilities:

• Designs, builds, and implements changes, extensions and enhancements to Oracle ERP application program and reports according to software standards and conventions;
• Reviews and debugs existing customizations and reports as necessary;
• Meets with non-technical staff to define user requirements;
• Assists with and/or conduct training programs for analysts/developers, consultants and users;
• Coordinates development and maintenance of a test environment including procedures for migration to production environment;
• Coordinates and supports interfaces to legacy systems as required;
• Documents all procedures used in reports and customizations;
• Updates technical skills and knowledge through continuous self-study, self-discovery, tutorials, and classes;
• Troubleshoots programs and issues encountered by system users, suggest resolutions, and resolve those problems and issues; and
• Performs other duties as assigned.

Qualifications:

  ·         Working knowledge of Oracle ERP technical database foundation and table structure and relationships;·         Working functional knowledge of two to three Oracle ERP modules;·         Must be able to use Oracle development tools to prepare reports and extracts for the business and instructional staff to support the school system;·         Working knowledge of Oracle development tools such as Developer 6i (Forms and Reports), APEX, SQL*plus, SQL*loader, Oracle Software Utilities, Workflow and Alerts, Discoverer 10g web, Custom Library (PLL) and SQL performance tuning;

• Working knowledge of third party Oracle development tools such as TOAD, SQL;
• Ability to write interfaces between third party systems and Oracle ERP, Oracle Data Warehouse and SchoolMax which is our student information Management System; and
• Good communications skills to express business and technical concepts.

Education and/or Experience Requirements:

Bachelor’s degree from an accredited college or university in computer science or a related field, required.  A minimum of five (5) years’ experience as an Oracle Developer, required; and Oracle ERP application development experience, preferred.  A minimum of five (5) years’ experience in Oracle PL/SQL development, required.

Certification:

None required.

Supervisory Responsibilities:

No direct supervisory responsibilities.

Physical Demands:

The physical demands are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is frequently required to stand, talk, hear, walk, sit, and use fingers, tools or controls. The employee is occasionally required to reach with hands and arms and stoop, kneel, crouch, or crawl. Specific vision abilities required by this job include close vision such as to read handwritten or typed material, the ability to adjust focus, and depth perception. While performing the duties of this job, the employee may occasionally push or lift up to 25 lbs.

Working Environment:

The work environment characteristics are representative of those an employee encounters while performing the essential functions of the job.

Additional Information:

None.