Oracle DBA

Posted: 1 week ago

Role : Oracle DBA
Location : Saint Louis, MO

Job Description:
Should be proficient in installation, configuration & administration of Oracle E-business Suite R12.1.3/R12.2.x
Responsible for installation, upgrades and administration of (E-Biz, Database and RAC), patches, SR support, database tuning, concurrent manager administration, cloning.
Should have experience working under Oracle Engineered Systems.
Experience in installation, setup and administration of Oracle Fusionware Weblogic
Should be proficient in Oracle Enterprise Manager 11g/12c installation, configuration & administration
Planning and implementing backup solutions
Supporting EBS 12.2 Application and 11g/12C Database
Working on ticketing system and tool on production/development EBS Database/Application issues.
Coordination with Oracle, Application Support team, Unix/Linux/storage and other Application interface teams.
Perform Patching, cloning, taking backups, managing archives and regular maintenance activities
Customer facing and ability to clearly explain technical matters.

Requirement:
At least 6 to 8 years of Oracle Applications DBA work experience.
At least 6 to 8 years of working experience on Oracle Database (10g,11g,12C)
Excellent knowledge in PL/SQL
DB Performance tuning
Query tuning
Excellent knowledge in Golden Gate installation, configuration
Extensive experience in installing, upgrading Oracle Applications 11i, Release 12.2.6 in a multi-tier environment.
Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
Manager DB users (Create, update, Grant permissions etc)
Experience operating on UNIX environment and writing shell scripts, Operating Systems include AIX, Solaris, and Redhat Linux.
Hands on experience in working cloud and clustered environment
Good understanding of the 11i, release 12.2.6 architecture and the various application tier and database tier components including Concurrent Manager processing and troubleshooting.
Good experience with cloning system test and development environments from Production Oracle Applications environment.
Patching and Maintenance of 11i, Release 12.2.6 Oracle Applications Environments.
Applications system administration and troubleshooting.
Perform database transaction and security audits.
Establish and appropriate end-user database access control levels.
The DBA should be familiar with recommending industry-leading practices to IT management team.
Good experience with RMAN (Catalog) installation interfaced with tape storage (preferably with EMC Enterprise Data Management software).
Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
Oracle Certified Professional is a plus
Experience in Technical configuration of Oracle Configurtor and Value Chain Planning
Experienced in troubleshooting Oracle Application configuration and infrastructure issues
Exposure and hands on Performance tuning of instance and application
Experience and hands on scripting and cron job creation.
Good understanding on Architecture and infrastructure (servers).
At least 3+ years of working experience on Oracle RAC/ASM/ Data Guard/ RMAN Backups and Restore/OEM
Should be a good team player with good communications skills.
Should have knowledge of ITSM / ITIL Processes.
Should lead/ worked on major/complex Implementation project.

dy>