Job Description:
Senior Oracle DBA with strong technical skillset supporting PeopleSoft ERP system on Oracle Exadata machine. The engineer will work on critical Oracle database Enterprise systems like PeopleSoft, Ariba, Oracle SOA suite etc.
Senior Oracle Database Adminstrator with strong technical skillset supporting PeopleSoft ERP system on Oracle Exadata machine. The engineer will work on critical Oracle database Enterprise systems like PeopleSoft, Ariba, Oracle SOA suite etc., the duties include database patching, testing, designing and planning for Oracle database deployment. This senior role involves monitoring, trouble shooting database issues, PeopleSoft Payroll and Batch jobs performance tuning, maintenance, backup and disaster recovery support for the production, testing, staging and development of Oracle databases. Will also provide database support for data warehousing environments and other business applications utilizing Oracle as the database platform; effectively communicate, adhere to Change Control Board processes, interact with stake holders to assure information that affects operations is communicated to the proper recipients in a timely manner.
Soft Skills:
• Strong oral and written communication skills.
• Ability to work cooperatively with engineers and system administrators.
• Experience with PeopleSoft HCM components like App Engine, SQR, Cobol, Process Scheduler and Application server.
Knowledge and Skillset requirements:
At least 8+ years of experience with high volume Oracle database administration in the following areas:
• Strong technical skills working with Exadata machine and other Oracle Engineered Systems
• Install, setup & configure Oracle 12c and 11g databases
• Create and setup PeopleSoft HCM databases, Schemas and Tablespaces
• Perform Oracle Grid Control installation (OEM12c and OEM13c), configuration, monitoring, provisioning, patching and maintenance
• Performance Tuning and Monitoring of PeopleSoft Payroll and nightly Batch jobs.
• Experience with troubleshooting PeopleSoft Application Engine, SQR and Cobol processes.
• Experience with different component of PeopleSoft PIA components like Application Server, Process Scheduler etc.
• Real Application Clusters (RAC), Automatic Storage Management (ASM)
• Disaster Recovery, RMAN backup & recovery planning and design
• Administer and troubleshoot Oracle databases including security patching, SQL tuning, capacity planning, and schema design.
• Implement, maintain, Golden Gate Replication and Active Data Guard.
• Experience with Oracle database security TDE encryption and implementation
• Load balancing, Query optimization, Schema design and database performance tuning
• Write UNIX shell scripts for Oracle software and patch installations
• Experience with optimizing and supporting large multi-terabyte production database
• Strong understanding of Linux operating system, storage solutions and
• System architecture, Data Base & Schema design as well as high availability concepts.
• Experience in change management process for managing changes in ERP environment.
• Exceptional Analytic/Problem-solving/Troubleshooting expertise and attention to detail.
• Strong skills in SQL, PL/SQL, Perl and Linux shell scripting
---------------------------------------------
CONTRACT JOB DESCRIPTION
Responsibilities:
1. Provides assessments of technical and operational practices based on leading industry standards specific to the requested technology.
2. Plans, organizes, and conducts research in a variety of areas, such as new or existing products, science, social science, law or business in support of an IT initiative.
3. Searches sources such as reference works, literature, documents, newspapers, statistical records, and other sources of information. May use Internet, Intranet, magazines, periodicals, journals, and other media to perform research.
4. Analyzes information and statistical data to prepare reports and studies for use by professionals.
Minimum Education/Certification Requirements:
Master’s degree in Information Technology or related field or equivalent experience.
Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.
SKILL
YEARS USED
LAST USED
Overall IT Exp. (16 + yrs.)
Education:
Certifications:
16+ yrs. as SME in complex enterprise projects. (Required 16 Years)
Master’s degree in IT or related field or equivalent experience. Desired. 8 Years.
Experience with Exadata machine and other Oracle Engineered Systems. Required. 5 Years.
Hands on experience with Install, setup & configure Oracle 12c and 11g databases. Required. 8 Years.
Expertise with Oracle database performance tuning including PeopleSoft Payroll and
nightly Batch jobs. Required. 8 Years.
Master level experience with Oracle database Disaster Recovery, Active Data Guard, RMAN backup & recovery planning and design. Required. 8 Years.
Experience with Administer and troubleshoot Oracle databases including security patching, SQL tuning, capacity planning, and schema design. Required. 8 Years.
Experience with PeopleSoft HCM PIA components like App Engine, SQR, Cobol, Process Scheduler and Application server. Highly desired. 8 Years.
Perform Oracle Grid Control installation (OEM12c and OEM13c), configuration, monitoring, provisioning, patching and maintenance. Required. 8 Years.
Experience with Implement, maintain, Golden Gate Replication. Nice to have. 3 Years.
Experience in change management process
for managing changes in ERP environments.
Required. 8 Years.
Strong expertise / experience with strong skills in SQL, PL/SQL, Perl and Linux shell scripting. Required. 8 Years.