Work with us
Title: Oracle Database Administrator
Requisition ID: 15598
City: Dublin
Country/Region: IE
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
Mandatory Skills:
* 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 technologies
* 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: Manage the global infrastructure customer and projects
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
* 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.
#J-18808-Ljbffr