Oracle Systems and Database Design Specialist

Ampcus Incorporated
Washington, DC
Nov 20, 2021
Nov 29, 2021
Full Time
Job Description Title: Oracle Systems and Database Design SpecialistDuration: Long term AssignmentLocation: Washington DCDescription:Systems and Database Design maps and maintains traceability of the design to the requirements.* Identifies the major components and interfaces of the system; * Determines impact on workflow processes; * Develops user interfaces, test strategies, test cases and test plans; * Conducts design reviews to clarify design drivers; * Selects an IT platform and/or architecture; * Identifies and weighs portability considerations and potential capacity and performance implications; and* Identifies existing systems that may be reused; identifying any integration issues with legacy systems; and other pertinent design information. Unique database design tasks will include creating the logical and physical database design for a system using data modeling and data normalization techniques.DC Water uses Oracle Fusion SaaS service as the financial, procurement and HCM systems. Along with that there are around 10 Oracle databases, in support of 3 critical production systems, including Fleet Wave and datamarts. In the near future DC Water will migrate these databases to Oracle cloud. Reporting expertise include OTBI. DC water uses Oracle's Primavera (P6 v 19) contract management system for managing capital projects and programs, with in our engineering department and Unifier in Oracle Cloud. The support program envisions future workflow and report creations/updates, assist SMEs, periodic add-ons/msi installations on the end user system as well as assist internal team in developing reports and troubleshooting technical issues if anything arises.Minimum Experience:* 7 - 10 years relevant experience* supported multiple IT projects in technology areas of Oracle ERP, * Experience in infrastructure and cloud migration project will be an added advantage.Required Skills:* Bachelor's degree* Experience with one or more of the following Technology Components:* Oracle Database and Oracle Fusion * Oracle Unifier & * Primavera * BizTalk, * IIS, * Microsoft SilverLight, * Git Hub * SAP BO, * OTBI, * OBIEE, SSRS * T-SQL, * Hadoop, * PL-SQL, * Maria DB