Misdemeanor Prosecutor

Summary ****SELECTION PROCESS: Applications should include an application, resume, and answers to the Supplemental Questionnaire. Applications will be screened for qualifications, clarity and completeness. The most competitive candidates may be contacted for an interview.

QUESTIONS: Questions about this position may be directed to Ruben Rivera, at [email protected] or 206-296-4123.

WORK LOCATION:** King County Administration Building , 500 4th Avenue, Suite 553, Seattle, WA 98104. However, employees may be required to work at other locations in the county depending on specific work assignments.

WORK SCHEDULE: This position is exempt from the provisions of the Fair Labor Standards Act, and is not overtime eligible. The regular workweek is full-time, Monday through Friday 8:00 a.m. to 5:00 p.m. but work assignments may require variable schedule for meeting with business partners.

This position's assignment begins March 2009 and continues through the 1st quarter of 2011.

POSITION PURPOSE:** This position will work as part of a technical application development team supporting the ABT implementation of Oracle E-Business Suite financial applications (EBS). This position will provide specialist level, technical expertise on technical solutions to support the complex business operations including the integration with other Non-ERP business applications.

Job Duties PRIMARY JOB DUTIES INCLUDE:

• Develop technical specifications, code and unit test solutions to support interfaces, conversions, modifications, reports and workflows for the Oracle Financials implementation.
• Implementing new functions and development of several new extensions and interfaces as well as modification & re-deployment of several existing ones currently in use in the 10.5.10 instance.
• Perform extensive data conversion and migration from mainframe legacy systems.
• Fully understand system requirements and process flow analysis, perform technical design analysis and development.
• Work closely with the Financial Tech Lead, PeopleSoft Tech Lead, budget solution Project Manager, the Test Manager, and the Integration Manager to develop solutions appropriate to meet technical requirements throughout the prototype, development, testing, QA staging and Production Implementation phases of the Program related to Oracle Financials implementation.
• Provide technical expertise to Analysts to help develop enhancements & report requirements and help identify business process improvements.
• Provide estimates of the total resources required to complete any development work proposed in the requirements documents.
• Perform deliverable reviews and provide sign-offs in a timely fashion.
• Perform quality control reviews with the Applications Technical Lead for each custom object group.
• Ensure data integrity by developing and running queries to assess data quality.
• Provide support to the Applications Consultants to help identify and resolve hardware and software problems.
• Ensure system performance issues are communicated and resolved with the technical DBAs.

Qualifications Experience, Qualifications, Knowledge, Skills

• EBS Application Developer EXPERIENCE in EBS Modules 10.5.10 and higher including General Ledger, Cash Management, Fixed Asset Accounting, Project Costing/Grants Billing, Accounts Receivable, Purchasing, iProcurement, Inventory, Accounts Payable, iExpense, iSupplier, and Purchasing Daily Business Intelligence (DBI)
• Oracle development experience that includes
• Metalink
• SQL, PL/SQL, and database procedures and packages.
• Oracle Discoverer
• JDeveloper
• COBOL
• XML Publisher
• PLSQL
• Oracle Forms
• Understanding of the Oracle EBS data structures, APIs and interfacing
• PeopleSoft integration experience
• Oracle EBS upgrade experience
• Java programming language, UNIX, data conversions, and Oracle Workflow
• Ability to formulate requirements and design specifications and code development reviews

Supplemental Information

Qualifications DESIRABLE QUALIFICATIONS:

• Recognized Technical Certification or Degree (e.g. Oracle Financials Certifications);
• Senior level Oracle Financials application development experience
• Highly proficient in the use of requirements analysis, functional design, technical design, development and testing techniques and tools
• Able to architect custom objects for performance, maintainability and re-use common logic routine
• Knowledge of all aspects of the Oracle Financials Architecture from both a technical and functional perspective
• Advanced problem solving capabilities
• Good verbal and written communication skills
• Specific knowledge of Workflow Extensions & Interfaces
• Specific knowledge Labor Distribution Integration, Workflow Integration, Project and Grants Module and Work Order Integration highly desirable
• Specific knowledge of Crystal Reporting, Business Objects Reporting is also highly desired.
• Specific knowledge of XML Publisher and BI Warehouse is also highly desired.
• Experience with certain aspects of Oracle Apps (11.0.3/11i) & Oracle Database (8i/9i/10g//10g RAC) in large scale UNIX & Linux environments
• Experience or equivalent knowledge of BPEL Integration with PeopleSoft.
• Experience in managing & working through Oracle's TAR escalation process, applying software patches & upgrading the Oracle Apps environment
• Experience with Oracle Portal
• Experience with Oracle Single Sign-On and Oracle Internet Directory

Benefits King County offers a highly-competitive compensation and benefits package designed to meet the diverse needs of our employees and support our employees' health and well-being. Eligible positions receive the following benefits and have access to the following programs:

• Medical, dental, and vision coverage: King County pays 100% of the premiums for eligible employees and family members
• Life and disability insurance: employees are provided basic coverage and given the opportunity to purchase additional insurance for both the employee and eligible dependents
• Retirement: King County employees are eligible to participate in a pension plan through the Washington State Department of Retirement Systems and a 457(b) deferred-compensation plan
• Transportation program and ORCA transit pass
• 10 paid holidays each year (plus 2 personal holidays)
• Generous vacation and paid sick leave
• Paid parental leave, family and medical leaves, and volunteer leave
• Flexible Spending Account
• Wellness programs
• Onsite gyms and activity centers
• Employee giving program
• Employee assistance programs
• Flexible schedules and telecommuting options, depending on position
• Training and career development programs

For additional information about employee benefits please visit our Benefits, Payroll, and Retirement Page.

This is a general description of the benefits offered to eligible King County employees, and every effort has been made to ensure its accuracy. If any information on this document conflicts with the provisions of a collective bargaining agreement (CBA), the CBA prevails. Also, in the event of any incorrect information in this document, applicable laws, policies, rules, CBAs, or official plan documents will prevail.

NOTE: Benefits for Term Limited Temporary (TLT) or Short Term Temporary (STT) positions, including leave eligibility and/or participation in the pension plan through the Washington State Department of Retirement Systems, will vary based upon the terms and details of the position. Short Term Temporary positions are not eligible for an ORCA transit pass.

For inquiries about the specifics of this position, please contact the recruiter identified on this job posting.

01

Please describe your EBS Application Developer experience with EBS modules 10.5.10 and higher. Please be as complete and specific as possible.

02

Please select from the EBS modules list below and check the box(es) that you have experience with. Check all that apply.

• General Ledger
• Cash Management
• Fixed Asset Accounting
• Project Costing/Grants Billing
• Accounts Receivable
• Purchasing
• iProcurement
• Inventory
• Accounts Payable
• iExpense
• iSupplier
• Purchasing Daily Business Intelligence (DBI)

03

Please describe your uderstanding of the Oracle EBS data structures, API's and interfacing. Please be as complete and specific as possible.

04

Please describe your PeopleSoft integration experience. Please be as complete and specific as possible.

05

Please describe your Oracle EBS upgrade experience. Please be as complete and specific as possible.

06

Please describe your experience with Java programming language, UNIX, data conversions, and Oracle Workflow. Please be as complete and specific as possible.

07

Please describe your ability to fomulate requirements and design specifications and code development reviews. Please be as complete and specific as possible.

08

Please select from list below and check the box(es) that you have knowledge of and experience with. Check all that apply.

• Oracle Forms Developer
• Oracle Reports Developer
• IAD
• SQL
• CDE Forms
• Oracle Forms
• Developer 2000
• Forms Builder
• Oracle 10g
• Technical Analysis
• Development
• Technical design (technical specifications)
• PL/SQL
• Unit Testing
• Unbundling of code
• Customization
• Documenting code
• database procedures and packages
• Oracle Discoverer
• Web Cache
• COBOL
• BPEL
• XML
• Required Question