Resume

Sign in

Oracle Manager

Location:
Silver Spring, Maryland, United States
Posted:
November 14, 2017

Contact this candidate

Oracle Database Administrator

ac3blz@r.postjobfree.com

(202) ***-****

Professional Profile

I have over 5 years of experience as an Oracle Database Administrator. I possess complete life cycle knowledge including Installation. Worked on Oracle 12c, 11g, 10g versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, database refreshes and security management.

Expert in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.

Have good experience in configuring OEM 12C cloud control and have hands on experience in monitoring databases using OEM 10g/11g and 12c.

Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 6.x for Clustered Environments.

Performed installation, configuration and maintenance of oracle 11g/12c, 11g RAC databases.

Experience in configuring oracle 10g, 11g Real application cluster (RAC) (2 and 3 nodes) using cluster ware and automatic storage management (ASM).

Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

Experience in writing UNIX/SHELL scripts for providing the reports.

Experience in patching RAC databases in rolling fashion to maintain high availability.

Experience in partitioning such as Range partition, List partition and Hash partition.

Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.

Installing Oracle patches, Migration of database across releases.

Excellent experience in Installation, administration and troubleshooting of Oracle […] for OLTP (multiple instances)/ OLAP environment on Very Large or Highly Transactional Databases.

Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Data Guard.

Solid experience in disaster recovery, database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies

System administration, Oracle Problem analysis and resolution and active cloning of databases from one server to another server.

Utilized RMAN recover table functionality and created proof of concepts for our pre-prod environment.

Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Testing and implementing different physical (hot/cold), logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.

Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.

Created database & database objects like table, index, table space, rollback/undo segments and views & analyzed relevant objects to collect statistics to tune the system performance.

Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of Disk I/O, Sizing of tables and indexes.

Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.

Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.

Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.

Implemented oracle 12c flexi ASM for pre-prod environment.

Experience with large databases (1.5 Tb) for OLTP and OLAP applications.

Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) on 10g/11g.

Performed migration of oracle 10g/11g non RAC single instance to RAC database instances.

Experience with 11g cluster maintenance using CRSCTL command.

Experience in using SRVCTL command for Oracle 11g RAC database.

Implemented Disaster Recovery database 10g/11g Data Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.

Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and to ensure disaster recovery using various data protection modes.

Implemented oracle 12c active standby database for test database environment.

Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate issues.

Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.

Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

Providing DBA support to multiple Cluster, Non-cluster and ASM Database in production, development and Testing Servers in Exadata, UNIX, Linux, Windows, and Solaris Environments.

Providing database administrative support and 24x7 on call support for production, development oracle 12c/11g databases on Red Hat Linux 5.0 and oracle enterprise Linux 5.5.

Have Hands on working in both Application and Production support environment.

Extensive experience with Change Board Meetings and Change Control Management for all database changes.

Excellent analytical, problem solving, communication and interpersonal skills.

Work Experience

The Home Depot - Atlanta, GA August 2014 – Present

Oracle DBA

Responsibilities:

Automated hourly, daily, weekly system health reporting using Crontab, PL/SQL and shell scripts.

Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.

Developed custom scripts and implemented standard procedures to troubleshoot Live Production issues by leveraging ORACLE ASH and AWR and ADDM Data.

Writing SHELL SCRIPTS for the system and database for effective functionality and report generation.

Wrote scripts for Backup of databases, maintenance of archive logs for databases.

Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases.

Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)

Extensively worked on setting up auditing in many databases we supported.

Installed the Oracle software using silent feature also created databases.

Worked on designing, installing & maintaining OCR, 11gRAC and Dataguard components of Oracle.

Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.

Monitoring the availability of system, listener, database, alter log file, trace file.

Performed numerous ORACLE software upgrades from 10g to 11g by managing whole process.

Performed Hot Backups, Cold Backups.

Performed incremental backups using Recovery Manager (RMAN).

Created recovery catalog, performed complete and incomplete recovery using RMAN.

Used Data Pump for export and import.

Performed Schema level and Table level data refreshes from Production to Development environments using Datapump EXPDP/IMPDP.

Streamlined backup procedures and implemented RMAN for backup and disaster recovery.

Database Refreshing/Replication from production to testing using Exp/Imp.

Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.

Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.

Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.

SQL Query tuning on the OLTP Environments with the techniques like SPM (SQL plan management) fix by taking the advantage of cell offload efficiency.

Maintaining ORACLE Software (RAC and standalone) by upgrades, Apply PSU patches on regular basis, test and Implement Applicable new feature during each upgrade.

Maintain 24/7 Availability by implementing standard processes and troubleshooting live issues within defined tight SLA times.

Manage High Availability Architecture (ORACLE RAC and ORACLE Data guard).

Perform Database cutovers using ORACLE Data guard switchover

Troubleshoot and maintain ORACLE Data guard environment where TBs of log shipping and apply happen every day.

Troubleshoot Database Performance issues using OEM, AWR, ASH, TKPROF 10046 traces etc.

Monitor Production Databases using various internal tools and custom scripts.

Optimal Database parameter, Capacity Design for Heavy loaded High End OLTP systems.

Database Capacity Management (Working with Storage teams for ASM Disks) using automated scripts/processes and Reports.

Configured Golden Gate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.

Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.

Experience on working with data guard physical/logical standby databases.

Installed and configured GoldenGate Agent to work with OEM GoldenGate Plugin.

Design and implement Application aware ORACLE RAC Active/Active Service based infrastructure

Troubleshooting ORACLE RAC issues using ORACLE cluster ware and Database logs.

Supported & maintained the Production/Development databases on various servers.

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g

Bank of Oklahoma - Tulsa, OK Jan 2012 - August 2014

Oracle Production Support Database Administrator

Responsibilities:

Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.

Used TOAD for database management.

Implemented and configured 11g grid control on RHEL.

Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled jobs (Cron Job).

Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.

Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.

Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.

Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing.

Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.

Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).

Experience in using 11g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.

Involved in Defragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.

Efficiently performed installation, setup and creation of 4 nodes cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

Installation, configuration and maintenance of Oracle 10g/11g Real Application Clusters (RAC).

Implement Grid based monitoring solution for large Databases and Installation of Cluster ware, configuring public, private and VIP.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.

Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.

Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Technical Skills

Operating Systems

HP-UX 10.x, 11.x. Sun Solaris 8, 9, 10. AIX 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000

RDBMS

Oracle 10g, 11g, 12c

Languages

SQL, PL/SQL

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

Education

Montgomery College, Rockville, MD

Associates Degree - General Studies

University of Buea – Cameroon

Bachelor of Science - Biochemistry



Contact this candidate