Database Developer

Job Description:
Develops, implements and maintains policies, procedures, and programs for ensuring the security and integrity of company data, databases, information systems, and technology. Conducts risk management analysis and creates business continuity, contingency, and disaster recovery plans. Develops and executes the testing processes utilized to validate the disaster recovery plans and to identify weaknesses and failure points in the plans. Develops the organization's resumption plan including identifying and securing necessary off-site resources and ensuring action plans are in place and communicated to IT and operations teams.
* Performance hours - flexible based on needs of USPS management. The supplier should be able to work nights, weekends, or holidays as needed.
* The work must be performed according to USPS policies based on the Software Delivery Framework and secure coding practices.
* USPS requires the Supplier to provide resources to support Finance & Payment Technology Services for application and system development, maintenance, and overall technical support as required. The contractor must enhance and support these production applications and create new applications as the need arises.

Required Experience:
* Oracle eBS Financials knowledge centering around accounts payable, accounts receivable, general ledger, iSupplier, Oracle Projects, and Fixed Assets.
* Experience in RICE (Reports, Interfaces, Conversions and Extensions) for Data Migration and Data Conversions.
* Extensive experience using SQL, PL/SQL, Oracle Developer Suite (Forms, Reports, JDeveloper, OAF), Workflow builder, XML Publisher, RICE Components (Data Conversions, Interfaces, Reports, Form Customizations and Personalization's)
* Design and Develop Interfaces using Oracle Open Interfaces and Oracle Public API's.
* Extensive experience in programming with Oracle Tools such as XML Publisher, and SQL*Loader.
* Experience developing using WebADI.
* Experience in Unix Shell Scripting.
* Experience in Advanced Oracle SQL querying and performance tuning.
* Expertise in creating Packages, Procedures, Functions, Triggers, views, Materialized Views.
* Expertise in customizing reports using XML Publisher.
* Worked registering PL/SQL Packages as Concurrent Programs, Request Sets.
* Worked on interfaces using Oracle SOA gateway.
* Experience in working with Oracle Support for tickets resolving.
* Effectively present ideas and concepts to upper management in a clear and concise manner.
* Preferred knowledge of the following modules (specific to Oracle eBS Financials)
* iProcurement
* Accounts Receivables
* Accounts Payables
* Fixed Assets\PEAS
* Sub-Ledger Accounting
* General Ledger
* Foreign Post Settlement (FPS)
* Treasury Offset Program (TOP)
* iSupplier
* Finance Number Control Master (FNCM)
* Journal Entry Voucher (JEV)