Post Job Free

Resume

Sign in

sr Oracle DBA

Location:
Stadtteil Dubai Internet City, DU, United Arab Emirates
Posted:
March 16, 2017

Contact this candidate

Resume:

Experience Summary

I am Oracle Certified Expert (11gR2 RAC and GRID, 12c OCP) with over 7 years’ experience as Senior Oracle Database Administration. I am actively Installing Oracle 11gR2 on Standalone and RAC environments along with GI and ASM. Expert on monitoring system and instance resources (i.e., database storage, memory, CPU, network usage, and I/O contention) using shell scripting to ensure continuous database operations. I usually used to Apply ORACLE security patches, developing RMAN’s Backup and Recovery strategies for High Availability of application, setup new server, database creation/sizing and review user requirement. Development, implementation, Troubleshooting and maintenance of large systems using ORACLE 10g,11gR2,12c on Sun Solaris, Red Hat Linux, Windows and HP-UX platforms. I am also involved in Data Migration Performance tuning (DB/OS/Aplications), capacity planning with Storage and System administrators.

Work Experience – 6+ years of experiences as Oracle database administrator)

Oracle Database Administrator and Senior Java developer at Megasoft Sarl (Cameroon) from October 2009 to November 2010.

Work as DBA by providing technical support for the Oracle 11g database environment at TBC Consulting (Cameroon) from November 2010 to June 2014.

Worked with IBM for Airtel Africa account as Senior Oracle DBA consultant (Burkina Faso) from June 2014 to June 2016.

Educational Qualification

2012 Master’s degree in computer science engineering.

2009 Bachelor degree in computer sciences.

2006 GCE Advanced level at DSCHANG High School.

Certifications

-Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator, May 2016.

-Oracle Database 12c Certified Professional, May 2016.

-Oracle Database SQL Certified Expert, Dec 2013.

-Oracle Database 11g Administrator Certified Associate, Aug 2015.

-Oracle Real Application Clusters (RAC) 11gR2 and Grid Infrastructure Certified, Mar 2016.

-Red Hat Certified System Administrator (RHCSA), Feb 2014.

-Red Hat Certified Engineer (RHCE), Feb 2014.

Trainings

-Oracle Database 12c: Performance Management and Tuning (License: 7828320. OU India )

-Oracle Real Application Clusters (RAC) 11gR2 and Grid Infrastructure administration (License: 7815172. OU India )

-Oracle 11g Golden Gate classroom training.

-Project Management Professional workshop (PMP)40 contacts Hours/PDUs ( India )

-Oracle Exadata Database Machine X6-2 administration training (Uclid IT school India)

Technical Expertise

Database : Oracle 10g, 11g & 12c, RAC 11Gr2, Exadata X6-2, Golden Gate, Data Guard

Languages : Java, Shell scripting, SQL, PL/SQL,

Operating Systems : UNIX, Linux, MS-DOS, Windows.

Tools : Putty, SQL developer, OEM.

Oracle Projects and Experiences

Working for IBM as Senior Oracle & MSSQL database administrator, Burkina Faso

Project : IBM Oracle DBA & Linux Admin Consultant

Database : Oracle 10g, 11g & 12C, MySQL, MSSQL

O/S : Linux Red Hat, Sun Solaris, IBM AIX, Windows.

Duration : June 2014 – June 2016

Responsibilities:

Production support for existing Oracle and DB2 Databases. Actively involved in Data Migration, performance tuning (DB/OS/Applications), capacity planning with Storage and System administrators.

Installed Oracle 11gR2 on Standalone and RAC environments along with GI & ASM.

Monitoring system and instance resources ( i.e.. database storage, memory, CPU, network usage, and I/O contention ) to ensure continuous database operations using shell scripting

Applied ORACLE security patches, Developing RMAN’s Backup and Recovery strategies for High Availability of application.

Review user requirement. Development, implementation, Trouble shooting and maintenance of large systems using ORACLE 10g,11gR2,12c on Sun Solaris, Red Hat Linux, Windows and HP-UX platforms

Space management & Storage management using shell scripting.

Working on critical databases having huge amount of data.

Installation, configuration and upgrading of Oracle server software and related products

Ensuring DB is compliant with IBM security standards (ISec) by running security scans every quarter.

Working with DB auditors (external and internal) to address DB security leaks.

Ensuring Replication to DR site (Periodic tests to ensure integrity)

Ensure Backups are being done and moved to tape

Test Recovery (Validity of Backups)

Providing On-Call DBA support on rotational basis to ensure databases are operational 24x7

Applying quarterly released Oracle PSU and CPU patches to Dev, QA, UAT and Production environments.

Managing physical and logical storage on Linux (Create partitions : Swap, physical, LVMs)

Worked as DBA for TBC Consulting, Cameroon

Project : Remote DBA and Linux Admin Support

Database : Oracle 10g, 11g & 12C

O/S : Linux Red Hat, Sun Solaris, IBM AIX, Windows.

Duration : Nov 2010 to June 2014

Responsibilities:

Managing and supporting on Oracle databases under various environments.( Windows,Linux Red-Hat, Solaris and AIX )

Space management & Storage management.

Implementation and maintaining Database Security (create and maintain users and roles, assign privileges).

Performing Oracle Database backup and Recovery manually and using RMAN..

Creating new databases under various environments and maintaining different oracle homes in the same servers.

Monitoring and Reorganizing Database objects Tables & Indexes to minimize fragmentation in the database using logical backup and restoration. (Export and import) and Data pump.

Review user requirement. Development, implementation, Trouble shooting and maintenance of large systems using ORACLE 10g,11gR2,12c on Sun Solaris, Red Hat Linux, Windows and HP-UX platforms

Applying patches and working on bug fixes on RAC and standalone servers.

Performing status checks by monitoring the Alert log, Trace files of the database.

Capacity Planning and configuring the backup recommended by oracle using RMAN strategies.

Rebuilding the indexes and Gather statistics of tables to improve the performance.

RMAN cloning, restorations and recover ( block level recoveries, Data file recovery)

Monitoring the table spaces periodically for growth.

Refreshing the test database with the production database.

Worked as Oracle DBA and Senior Java developer for Megasoft Sarl, Cameroon

Project : Database and Java support

O/S : Linux Red Hat, Sun Solaris, IBM AIX, Windows.

Duration : Oct 2009 to Nov 2010

Responsibilities:

Performing Database backup and Recovery manually and using RMAN.

Monitoring and Reorganizing Database objects Tables & Indexes to minimize fragmentation in the database using logical backup and restoration. (Export and import) and Data pump.

Created user information solutions by developing and maintaining components and interfaces.

Defined site objectives by analyzing user requirements and envisioning system features and functionality.

Designed and developed user interfaces to internet applications by setting expectations and features priorities throughout the development lifecycle, determining design methodologies and tool sets.

Installation, configuration and upgrading of Oracle server software and related

Determined, enforced and documented database policies, procedures and standards.

Creating new Oracle databases under various environments and maintaining different oracle homes in the same servers.

Implementation and maintaining Oracle Database Security (create and maintain users and roles, assign privileges).

Exadata database machine administration knowledge.

Expertise on software and firmware maintenance of the DB servers, ESS and InfiniBand switches in the Database machine including upgrades, patching, data guard setup on 1/8th RAC, backup & recovery using RMAN,LVM Snapshots.

Provide business as usual data structure manipulation (add, remove, modify storage) in the Database machine.

Good understanding and actively working with IORM, DBFS, Flash cache, Flash log, DCLI, ADRCI, CELLCLI to manage and configure Exadata storage and database machine.

Good understanding of the concept of smart scan, EHCC, Exadata storage indexes.



Contact this candidate