Oracle Database Administrator

Role: Oracle Database Admin:

Location: Dublin

Type: Hybrid, 3 Days WFO

Role & 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

· Provide 24x7 and on call support for critical application databases

Must have 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 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

· Identify the service improvement plan

Job Types: Full-time, Fixed term
Contract length: 6 months

Schedule:

• Day shift