Skip to main contentA logo with &quat;the muse&quat; in dark blue text.

Lead Administrator

AT Wipro
Wipro

Lead Administrator

Mumbai, India

Job Description

Position Title

Oracle Database Administrator L2

BAND

Location

India

Department

Middleware

Role Summary

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-CA-CIB best practices.

Want more jobs like this?

Get jobs in Mumbai, India delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.


• 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.

Key Responsibilities

Technical Expertise

• Architect HA and DR Solutions for PAAS services like Exadata, Autonomous Databases (ATP,ADW),

RAC & Data guard).

• Installation, Upgrade & configuration of Oracle/EBS software.

• Should have knowledge of Oracle RAC installation and configuration & management.

• Must have Oracle ASM/ACFS implementation skills.

• Good scripting skills to automate regular DBA admin tasks.

• Expertise on backup utilities like RMAN, EXPDP/IMPDP, CRSCTL, SRVCTL, Netbackup and Networker.

• Patching of Oracle DB/EBS Apps (EXACC and Non-EXACC DB).

• Good understanding on performance tuning in Oracle database.

• Should have knowledge of Oracle OEM 12C/13C.

• He will be customer facing for all operational issues and activities.

• Should have capability to install and configure RAC Servers under Oracle DB and EBS Apps technology.

• Expertise in query fine tuning and troubleshooting.

• Implement backup and recovery of Oracle DB/EBS Apps.

• Administration over DB Objects including Tables, Clusters, Views, Procedures etc.

• Good in Impact Analysis of DB Change / DB Design Change etc.

• Strong experience on configure and troubleshoot physical standby database using dataguard broker.

• Strong experience on configure and troubleshoot golden gate replication components.

• Implement backup and recovery of Oracle databases for various scenarios.

• In-depth understanding of Advanced Architectures (Multi-Node, RAC, ASM, EXACC, GoldenGate).

• Good understanding of core support processes and change management, maintain documentation standards.

• Must have experience in Database tuning including I/O, Load Analysis, ADDR, AWR, SQL Profiling etc.

• Responsible for installation, upgrades (EBS, Database, EXACC and RAC), patches, SR support, database tuning,

concurrent manager administration, cloning

Oracle EBS knowledge/experience added advantage.

• Capable of delivering under critical environment pressure, resolve complex production issues & provide support when required;

• Excellent verbal and written communication skills;

• Independent and strong team player with good inter-personal skills.

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

Educational Qualifications

• Bachelor's degree or Master's degree in Information/Computer technology preferred.

Key Competencies:

• 5yrs (Min) to 8yrs (Max) of relevant experience in Oracle/EBS administration.

• 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.

If you encounter any suspicious mail, advertisements, or persons who offer jobs at Wipro, please email us at helpdesk.recruitment@wipro.com. Do not email your resume to this ID as it is not monitored for resumes and career applications.

Any complaints or concerns regarding unethical/unfair hiring practices should be directed to our Ombuds Group at ombuds.person@wipro.com.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, caste, creed, religion, gender, marital status, age, ethnic and national origin, gender identity, gender expression, sexual orientation, political orientation, disability status, protected veteran status, or any other characteristic protected by law.

Wipro is committed to creating an accessible, supportive, and inclusive workplace. Reasonable accommodation will be provided to all applicants including persons with disabilities, throughout the recruitment and selection process. Accommodations must be communicated in advance of the application, where possible, and will be reviewed on an individual basis. Wipro provides equal opportunities to all and values diversity.

Client-provided location(s): Mumbai, Maharashtra, India
Job ID: Wipro-1140087255
Employment Type: Other