Overview
Skills
Job Details
Job Title: Oracle Applications DBA
Location: Portland, OR (Onsite)
Rate: $DOE
Type: Contract
Duration: 12 Months
Client is open for candidates who are interested in relocation Portland, OR (Onsite)
Design, install, upgrade, create, and support Oracle e-Business Suite (EBS) and other Oracle databases. EBS patch management and version control. Perform System Architect responsibilities for EBS, ERP Oracle cloud solutions, third party products that interface with EBS. Cloning production EBS to non prod environments for testing & QA. Design and administer high-availability database solutions using Oracle Real Application Clusters, Oracle Data Guard and RMAN. Perform administrative activities backup/restore, and RDBMS patching. Develop database schemas in coordination with application programming staff. Ensure quality control and auditing of databases to ensure accurate and appropriate use of data and PCI compliance. Work with management to develop EBS and database strategies to support company needs. Consult with and advise users on access to various Oracle databases.
Essential Functions
- Serve as Oracle Applications Database Administrator for Oracle EBS 12.2.x Applications and technology stack ecosystem. Patch and clone EBS production to non prod environments; install and configure Oracle Applications modules and Applications Server modules.
- Oversee the development of data design elements, of the development of applications, in coordination with Information Technology planning. Work closely with vendors and contracted staff to evaluate software upgrades for their effect on database integrity and performance. Assist in technical support of integrated database design.
- Ensure maximum system availability using Oracle High-Availability tools and design including Oracle Real Application Clusters and Oracle Data Guard for non EBS environments.
- Analyze database performance, reorganize database as needed, monitor current and projected database disk space usage, develop reliable and timely backup, export and upgrade procedures.
- Take on System Architect role regarding Oracle EBS and its interaction with other 3rd party products and in house developed applications. As System Architect also help in design & interface of Oracle EBS with cloud solutions and other electronic devices such as hand held scanners.
- Enforce guidelines that result in an orderly development of the database. Define database structures. Develop and document standards for database administration and PCI DSS compliance.
- Create and maintain descriptors for data, users, and resources. Conduct database training. Provide database support for software applications developers. Provide resources to assist users in data retrieval techniques.
- Coordinate with other agency Database Administrators with regards to definition and use of enterprise data and databases. Monitor and restrict access to authorized users.
- Establish and maintain procedures for review and control of all requests for additions and deletions to the central database. Ensures change management process for production changes follow compliance and governance policy.
- Fully use System Administrator responsibility and related tasks in Oracle EBS
- Architects new solutions, redesigns existing systems, and provides proactive strategies around opportunities pertaining to continuous improvement.