Roles and Responsiblities:͏
As a L2 resource of his /her team, he /she:
- Takes up technical tasks and support day to day BAU tasks/Incidents/RFC’s.
- Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.
- Proposes service improvements for all Oracle/EBS services supported throughout the organization.
- Provides technical knowledge, supports services both proactively and reactively to maintain the availability and reliability of database system infrastructure in accordance to the SLA.
- Works in line with policies based on LEAN-Client best practices.
- Actively engages during any high severity issue and drives for issue resolution.
- Reviews technology changes to identify potential risks.
- Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.
- Is aware of the global IT structure so that he/she anticipates interrelationships within the organization.
- Engages with technical peer, Development team, Service managers, Architect and project teams on technology roadmap and projects.
- Facilitates transformation projects and suggest future directions for new areas of improvement and enhancements.
- Guarantees the production readiness.
- Is available and able to drive technically, any complex or high severity incidents that occur within the scope of their role.
- Actively engages to understand new technologies and technology trends and reviews them with a view to incorporate them into Bank operations.
Technical Expertise:͏
MUST HAVE
- Oracle Core & Apps DBA with expertise and working knowledge on R12.1.x / R12.2.x environment.
- should have working experience on Oracle Exacc ,RAC and DG.
- Exacc patching (DOM0,DOMU,GRID,DATABASE)
- Sound Knowledge on 12c & 19c EBS databases along with RAC.
- Troubleshooting knowledge on critical problems and areas like CM, Apache, Database etc.
- Performed at least one database upgrade from 11g to 12c / 12c to 19c & EBS Upgrade from 12.1.3 to 12.2.x.
- Oracle Applications 11i/R12 Support and maintenance activities like refresh and patching on multi-node environments.
- Hands on experiences on Oracle application versions R12.2.0 and above versions.
- Hands on experiences on Oracle Security Patches on Application and databases.
- Ability to perform installations, software upgrades, and apply patches (Opatch and ADOP patches).
- Database upgrade to 19c and E-Business Suite Application upgrade to 12.2.
- Support & Maintain Oracle EBS Suite High Availability Design Spanning Data Centers - Database Node (RAC, Active Dataguard,
- Physical Standby, Snapshot Standby, Switchover, Failover). Web Node (Load Balance Web Nodes, DNS/Network Configuration)
- Forms Node (Load Balance Forms Nodes, Servlets), Parallel Concurrent Processing (Distribute load),
- Adding an EBS Node in a Shared Application Tier Filesystem .
- Capable of delivering under critical environment pressure, resolve complex production issues & provide support when required;
- Proven track record for BAU tasks
- Expertise in query fine tuning and troubleshooting.
- Excellent verbal and written communication skills;
- Independent and strong team player with good inter-personal skills.
GOOD TO HAVE
- Good scripting(shell/ANSIBLE/PYTHON) skills to automate regular DBA admin tasks.
- Strong experience on configures and troubleshoot golden gate replication components.
- Banking domain experience will be added advantage
- Knowledge on OCI,DBASS utilities
Shift/Oncall & Weekend Support͏
Flexible to work in shifts/ weekends/On-Call support as follows:
|
Shift |
Timings |
|
Morning Shift |
4.30AM to 1.30PM |
|
Afternoon Shift |
11.30AM to 8.30PM |
|
Afternoon Shift 1 |
12.30PM to 9.30PM ** |
|
Evening Shift |
2.30PM to 11.30PM |
|
Evening Shift 1 |
3.30PM to 12:30AM ** |
** Day light savings Period- Nov to Mar ( 1hour ahead) **
On-Call Support- To provide On-Call support services on rotational basis
- 11.30 PM Night to 4.30 am on weekdays after end of the evening shift work (Apr to Oct).
- 12.30 Midnight to 4.30 am on weekdays after end of the evening shift 1 shift work (Nov to Mar).
- 00:00 AM to 11:59PM on both Saturday and Sunday.
- Weekend Support - Mandatory to work on every 3rd Saturday of given month. ( Timings From time to end time to be mentioned )
Public Holiday Support – Paris Holidays (Client Holiday) will be followed as public holidays and not India holidays.
Process & Tools͏
- ITSM tool- HP Service Now – Ticketing tool for INC/SR/Change/Problem tickets
- In-house tools
- HP OMI for monitoring
- Strong knowledge on ITIL Process & Practices
Key Competencies:
- 5yrs (Min) to 8yrs (Max) of relevant experience in Oracle.
- The candidate should have worked in a SLA driven environment.
- Ability to work in a flexible, team-oriented and constantly changing environment.
- Good Oral and Written communication skills.
- Basic knowledge on shell/Python scripting.
- Having Oracle RAC/OCI certification will be added advantage.
- Having previous banking BAU support will be added advantage.
Experience: 5-8 Years .
Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention.