Manager Oracle
Resume:
FRU N. NDE
Oracle Database Administrator
202-***-****, *******@*****.***
Objective: To obtain a DBA position where my resourceful experience and academic skills will add value to organizational operations.
PROFESSIONAL SUMMARY
An accomplished and seasoned professional Oracle Database Administrator with over 5 years’ experience in database security and user management, backup and recovery, disaster recovery and management, and database performance tuning in heterogeneous system environments including WINDOWS, HPUX, UNIX and LINUX amongst others. An expert in:
transparent data encryption, Oracle Wallet, password complexity to ensure database security
RMAN for backup and recovery; and for cloning of databases
Ability to learn new technology (Tech Refresh), methodology, and work routines quickly; excellent in producing the best result under pressure and detail oriented; high personal motivation, self-management, dependable, and enthusiastic; outstanding leadership abilities and great in both team and self-directed settings; strong oral and written communication, organization, and time management.
PROFESSIONAL EXPERIENCE
Jelani Consulting
Oracle Database Administrator October 2012 – Present
Environment: Linux Red hat enterprise 6, Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.
Responsibilities:
Implemented Oracle 11g ‘s Transparent Database Encryption; created and used the Oracle Wallet using the Oracle Wallet Manager
Enforced database password complexity measures using the Oracle provided script named utlpwdmg.sql (from $oracle_home/rdbms/admin directory) to create password verification function called verify_function_11g.
Performed physical backup and recovery using RMAN; also used RMAN to clone databases.
Carried out logical backups using full/ partial export/import and Data Pump.
Instituted disaster recovery measures to ensure continuity of operations; used Data Guard to create standby databases
Worked on 24 /7 environments, responsible for monitoring, upgrading, configuring, managing and troubling shooting over 300 oracle 10g and 11g databases with sizes from 300g to 5TB.
FRU N. NDE Page 2
Jelani (continued)
Performed performance tuning tasks like generating the AWR report; analysis of ADDM snapshots; and the explain plan to query database issues
Installation and configuration of Oracle RAC (Real Application Server) on different nodes with ASM (automatic storage management)
General database administration tasks like installation of Oracle 11g and 12c; creation of users and roles, table spaces; ensuring database functionality
Dedicated care Inc. MD
Oracle Database Administrator June 2011– October 2012
Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN.
Responsibilities:
Performed monthly and annual performance reports for trend analysis and capacity planning.
Successfully installed and configured Oracle 11.1.0.7
Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
Extensively used AWR, ADDM and explain plan for periodic performance tuning.
Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
Database monitoring/maintenance, replication process and performance tuning using OEM
Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC with ASM file system on Sun Solaris platform.
Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
FRU N. NDE Page 3
Holy Health care. MD.
Role: Oracle Database Administrator February 2010 – June 2011
Responsibilities:
Installed oracle database software 10.2.0.1 and 11.1.0.6.0 using oracle universal installer on development, test and production servers in IBM AIX 5.3 environment.
Installed OEM grid control that includes oracle agent, management repository and management service on VMware Red Hat Linux virtual machine.
Upgraded software and databases on development; test and production databases on AIX database servers.
Applied patch set to upgrade software and use database upgrade assistant, export/ import and manual scripts to upgrade databases.
Performed migration of full databases, schemas from Linux environment into AIX, 10.2.0.3 database environment using export/import and data pump utility.
Created development, test and production databases using database configuration assistant- DBCA, manual scripts and sqlplus using Automatic storage management- ASM.
Scheduled cronjob for daily night hot/online backup of production databases on tape using RMAN scripts.
Created physical standby database on remote server to provide high availability.
TECHNICAL ENVIRONMENT
OPERATING SYSTEMS:
Red Hat Linux RHEL 6.x and Windows XP
RDBMS:
Oracle 10g/11g and 12c
LANGUAGES:
SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting
SOFTWARE/ APPLICATIONS/ TOOLS:
DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Agents, Real Application Clusters (RAC), ASM, Sql Developer, TOAD, Exp/Imp, DataPump (expdp/impdp),SRVCTL,SQL*Plus, Recovery catalog, Autosys, Crontab, HP Manager, My Services, OTG etc
TUNING TOOLS:
SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM etc
WEB TOOLS:
HTML, XML
EDUCATION /CERTIFICATION
Oracle Certified Associate (2014)
BSC Environmental Sciences (1998)
University of Yaounde, Cameroon
DiplomaHealthInformation System. (2005)
Computer Career Institute /John Hopkins University
Contact this candidate