Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Database Architect

Expired Job

Base One Technologies Austin , TX 73301

Posted 2 months ago

Must have experience with Oracle Finance and Retail, Oracle EBS 12.1.3 running on Oracle 11.2 database and Solaris

Our Austin TX based client is looking for a Database Architect, Sr. If you are interested in this opening, please forward a copy of your updated resume to

VIRTUAL: Can be 100% REmote, however, must be onsite for up to eight (8) weeks for onboarding.

description:
A Sr. Database Architect has vast experience in assessing various alternative products, tools, and approaches for data management. Can clearly define risks and benefits of various approaches for a given need. Capable to create overarching strategies for design.

Skills TO BE SUCCESSFUL:
Must have experience with Oracle Finance and Retail

Provide operational support Oracle EBS 12.1.3 running on Oracle 11.2 database and Solaris 10.

Take primary role in upgrading/migrating EBS 12.1.3 environments on Database 11.2.0.3 and Solaris 10 to Database 11.2.0.4 on Solaris 11.

Have prior experience with R12.1.3 upgrade and migrations and make recommendations for EBS and database migration paths to ensure optimal performance and availability.

Install, configure, administer, monitor, tune, troubleshoot, upgrade, patch, and clone Oracle EBS applications.

Develop, maintain, perform, and test backup and recovery procedures.

Provide proactive performance monitoring and capacity planning.

Administer and maintain security policies and procedures.

Monitor and tune Oracle EBS and database tiers to optimize stability and performance.

Upgrade and patch all Oracle EBS tech stack components, including database, concurrent processing and admin tiers. Apply database PSU patches and EBS patches with OPATCH utility.

Develop and implement the technical procedures, standards and security for Oracle EBS and database tiers.

Manage concurrent managers in Oracle EBS including scheduling, tuning, debugging and monitoring.

Manage and troubleshoot Oracle EBS security and performance issues with interfaces and other internal systems such as Oracle Retail.

Manage Applications SYSADMIN tasks such as adding printers, changing profiles, and resetting passwords.

Support application developers and interact with infrastructure teams.

Possess strong knowledge of EBS applications architecture, configuration, and troubleshooting.

Write/edit shell scripts for backup/recovery and maintenance tasks such as coalescing indexes and updating database statistics.

Coordinate EBS and database administration duties with system and network administrators to ensure compatibility with hardware and operating systems configurations.

Diagnose and correct problems that occur within databases and application interfaces.

Analyze EBS and database infrastructure to ensure compliance with VA security standards and database performance considerations.

Develop schedules and plans, communicate progress to management in both verbal and written formats, identify barriers and identify and evaluate alternatives.

Develop and submit EBS and database configuration change management plans for approval.

Perform capacity planning to maintain the EBS system, working closely with applications and system administration staff to account for all performance and scalability requirements to predict trends for hardware usage and user load.

Perform database reorganizations to improve performance and ensure maximum database uptime.

Develop and maintain EBS documentation on data standards, procedures, security, high availability, disaster recovery, backup and recovery, storage, and archiving procedures.

OEM Cloud Control

Handle the pain points to grow, maintain and tune a relatively new, large OEM 13.2 environment on Red Hat Enterprise Linux (RHEL) 7 that will eventually monitor thousands of Oracle 11g and 12c database systems running on Linux, HP-UX, Solaris and zLinux.

Perform all Super Administrator responsibilities, including creating/updating administrators, incident rules, groups, and Agent Gold Images.

Maintain and grant additional target and resource privileges for OEM administrators using the principle of least privilege.

Install and configure the Oracle Golden Gate (OGG) Plug-in on target systems and manage OGG alert notifications.

Keep the OEM Repository database, OMS, Agents, Plug-ins, and Agent Gold Images patched to the latest versions.

Serve as the primary point of contact for all DBA team questions and issues in using/leveraging OEM.

Create and maintain documentation of the OEM architecture, operating procedures, and standards.

Recommend and implement OEM Cloud Control 13.2 features that will enhance the IT infrastructure.

Administer, diagnose, and tune OEM components including Repository database, OMS, and Agents.

Monitor and tune target conditions on database systems using OEM best practice metrics.

Centralize the scheduling of tasks on multiple database systems.

Use built-in reporting to quickly view and analyze information about managed database systems.

Nice-to-Have Skills:
RAP Finance

Identify solutions to meet gaps between existing Oracle architecture and business requirements.

Evaluate new EBS trends and technologies and provide best practices and recommendations.

OEM Cloud Control

Install and configure VA-licensed Management Packs including Database Lifecycle Management Pack and WebLogic Suite Management Pack.

Implement Data Guard physical standby for OEM Repository database.

Add a second OMS server and configure behind an F5 Big-IP load balancer for high availability and scalability.

POSITION SENSITIVITY: HIGH

Location: AITC/100% REMOTE

Travel: NOT REQUIRED

Telework: YES, WITH SUPERVISORS APPROVAL (Three (3)) DAYS A WEEK)

VIRTUAL: Can be 100% REmote, however, must be onsite for up to eight (8) weeks for onboarding.

expected start date: asap

expected PERIOD OF PERFORMANCE: march 2021

Anticipated SHIFT: TUE SAT (Days)

EDUCATION REQUIREMENT:
Masters Degree in Computer Science, EE, or Business Administration. 10 years additional relevant experience is required.

Skills:
Must have experience with Oracle Finance and Retail, Oracle EBS 12.1.3 running on Oracle 11.2 database and Solaris 10
Contract
3+ years


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Database Architect 3

Sourcematch

Posted 2 days ago

VIEW JOBS 11/11/2018 12:00:00 AM 2019-02-09T00:00 <span style="font-size:14px;"><span style="font-family:tahoma,geneva,sans-serif;">The Department of Information Resources (DIR) requires the services of one or more Database Architects, hereafter referred to as Worker(s), who meets the general qualifications of a Database Architect 3 Category, Emerging Technology Type and the specifications outlined in this document for the Lower Colorado River Authority (LCRA). </span><br /> <br /> <strong>Minimum required skills  </strong></span> <ul> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">12 years of experience trouble shooting and resolving Service Requests (SR) through Unit, System, Integration, and User Acceptance, test phases.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">12 years that demonstrate at least 3 successful implementations of Oracle Business Intelligence applications.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">12 years of experience teaming with customers and technical staff in a complex, large scale ERP and Business Intelligence environment.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">12 years of experience with Microsoft Suite (Projects, Visio, Excel, Word, Power Point).</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">12 years of proven project team building skills.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience developing customizations working closely with the Functional Team.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience writing and reviewing detailed Functional Design Documents (FDDs).</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience writing and reviewing detailed Technical Design Documents (TDDs).</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of demonstrated ability to alter project direction based on PM or Executive Direction.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience integrating RPD initialization blocks with LDAP and single sign-on (SSO).</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience extending out-of-the-box OBIA RPD with custom fact tables and metrics.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience developing ragged hierarchies in the logical layer.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience with opaque views.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience development of custom logic table sources to support performance tuning and/or custom metrics.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience developing custom BI Publisher data models.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience developing custom BI Publisher report layouts.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience scheduling BI Publisher report bursting.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience coding custom SQL to support BI Publisher pixel-perfect reporting.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience migrating ODI, and OBIEE (RPD and Presentation Catalog) metadata from development and test to production environments.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">10 years of experience teaming with customers and technical staff in a complex, large scale OBIEE, OBIA, and ERP (PeopleSoft, Maximo, Tagetik and/or other Planning and Work Order management applications) environment.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">8 years of experience installing configuring, and customizing OBIA (11.1.1.7.1 and above): Financial Analytics, Project Analytics, HR Analytics.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">8 years of experience installing, configuring, administering, and patching Weblogic 10.3.6, Weblogic 12.2.1.1 and above.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">8 years of experience developing custom security model based on PeopleSoft trees.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">8 years of experience integrating BI Publisher security model with LDAP and single sign-on (SSO).</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">5 years of experience developing customizations in ODI 11.1.1.9 and above.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">5 years of experience configuring, running, and customizing Oracle ODI Load Plans from PeopleSoft 9.2 FSCM (GL, AP, AR, BI, Contracts, PO, Project Costing) and HCM (Time and Labor, Payroll).</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">Strong experience with communication, analytical and interpersonal skills at all levels of an organization.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">Strong experience teaming with customers and technical staff in a complex, large scale ERP and Business Intelligence environment.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">Strong demonstrated good judgment and pragmatic approach to delivering software that optimizes architecture activities across company needs, business constraints and technological realities.</span></li> </ul> <span style="font-size:14px;"><strong>Preferred </strong> </span> <ul> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">2 years of experience integrating Essbase with OBIEE 12c and designing cubes to meet identified requirements.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">3 years of experience with a Utility or Energy Based company a plus.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">3 years of experience developing and publishing BI Publisher pixel-perfect reporting.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">3 years of experience developing and publishing OBIEE dashboards and analyses (including Essbase where identified).</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">3 years of experience developing ODI Load Plans from Tagetik or similar planning application 5.2.0 and above.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">3 years of experience developing ODI Load Plans from Maximo 7.6.06 and above.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">5 years of experience with all aspects of Documentation, Planning, Design, Build, Test, and Deploy Phases within OBIEE and OBIA.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">Strong demonstrated ability to set and meet technical team deadlines while maintaining an even disposition under pressure.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">Strong experience working through development of  Interfaces with Technical Team through design, build and test.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">Strong teamwork skills, ability to collaborate with other functional and technical staff on the project.</span></li> <li style="padding: 0; margin: 0;"><span style="font-size:14px;">Strong interpersonal skill and the ability to collaborate effectively on diverse teams.</span></li> </ul> <span style="font-size:14px;"><strong>Terms of Service</strong><br /> Services are expected to start as soon as possible to be completed April 2019.  The duration is expected to be roughly 7 months, 1120 hours.  This service may be amended, renewed and/or extended providing LCRA and vendor agree to do so in writing. </span><br /> <br />   Sourcematch Austin TX

Database Architect

Expired Job

Base One Technologies