Oracle DBA Admin

Role : Oracle DBA Admin

Location : Near Brussels, Belgium ( hybrid role 2-3 Days/Week)

Near Brussels, Belgium ( hybrid role 2-3 Days/Week)

Experience Level 5 – 8 Years

Primary Skill (Technical Skill) Oracle DBA

Secondary Skill (Optional) OS - Solaris/Linux/AIX/HP UNIX & Windows

Database - MySQL/MS SQL & Windows OS / Sybase /

DB2 / PostgreSQL/MongoDB/SAP HANA

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

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

• Strong verbal and written communication skills

• Team management and motivation

• Flexibility, good attitude