Role: Oracle Database Admin-L3
Location: Dublin (hybrid)
Responsibilities:
- Handled large database estates and managed TB size of databases
- Installation and administration of multiple versions of databases on multiple Unix platforms and Windows servers
- Design and implement the high availability solutions (RAC, Golden Gate and Dataguard)
- Install, configure and manage ASM instances in oracle
- Plan and execute major migrations and upgrades
- Define and configure the disk and diskgroups in ASM and troubleshoot
- Manage and administer the databases on Exadata machine
- Plan the database upgrade, migration and patching
- Plan and implement the backup/recovery on need basis
- Hardware tech refresh (host to host database move)
- Coordinate and work with database vendors for resolution on major incidents
- Database refresh, re-org, backup using RMAN and 3rd party tools
- Install and configure grid control database monitoring tools
- Install, Administer, manage and troubleshoot Oracle grid control
- Define performance benchmarks and metrics
- Periodic database instance performance review and tuning recommendation
- Proactive database analysis and suggestion to application team / business
- Write and troubleshoot shell scripting, SQL and PL/SQL scripts
- Primarily role is supporting the production and non-prod database environments
- Ensure the reduction of repeated errors through implementation of necessary checkpoints
- Contribute towards evaluation of tools, products and software selection
- SLA tracking and reporting to Higher management
- Prepare and Maintain Standard Operating Procedure for all activities
- Proactive identification of risks and mitigation of the same
- Technical presentation on emerging technologies.
- Foresee the need for newer technology based trainings on customer needs and provide suggestions for such trainings to Project Manager.
- Implement and Periodical check on Automation
- Implement and Periodical check on DB Security
- Identify, document and track Technology related risks and mitigation plan in the project
- Technical and Process guidance to L2 and L1 DBA
Want more jobs like this?
Get jobs in New Castle, IN delivered to your inbox every week.
Mandatory Skills:
- Strong database administration
- Database upgrades on multiple versions and releases
- High availability (RAC) setup and administration
- Disaster recovery design, planning, setup and administer the Dataguard (standby)
- Install, configure, maintain and troubleshooting on Golden Gate
- Knowledge on ExaData
- OEM Configuration and management
- Automation through scripting
- Strong performance analysis on AWR, ADDM, SQL Profile, ASH and advisory views
- Experience on OS, Storage, Network and Virtualization activities
- Certification on Primary Technology
- Handled database estate of various technologie
- Service Request and Incident, Problem, Change managements
- Configuration, Capacity planning and Knowledge management
- Experience on ITIL Tools like Remedy, Service Now or any other ticketing tool
Good to have:
• ITIL Foundation certified
• Manage the global infrastructure customer and projects
Wipro is an exciting organisation to work for. We ranked as a "Top Employer" as part of the Top Employer Institute annual listings. We were assessed on several key HR practices including Diversity and Inclusion. This is accompanied by exciting business growth in the last six-quarters.
Benefits: You will receive a competitive salary, a generous benefits package, training, and development, as well as an exciting career within a fast paced and dynamic business. The benefits include;
Contributory pension
Extra holiday purchase
Life insurance policy
Private medical insurance
Equal Opportunities: Wipro is an advocate for positive change and conscious inclusion. As a global employer, we strive to create a diverse Wipro family by remaining committed to the development of our culture, diversity, equality, and inclusion in the workplace. All applicants are welcome.
#LI-AP7
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.