Resume

Sign in

Oracle Database Engineer

Location:
Dallas, Texas, 75254, United States
Posted:
May 31, 2017

Contact this candidate

Over * years of hands-on experience as an Oracle Database Administrator with experience on 24x7 production and mission critical database support, including RAC and Data Guard. I possess strong analytical and problem solving skills, self-motivated, results-driven, team player with excellent verbal and writing communication skills. I have worked on Oracle 12c, 11g, 10g versions involving database administration, production support, installation, configuration, security management, space management, backup and recovery, upgrades, patches, migration, performance tuning and cloning.

Professional Summary

Expertise in Performing Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning, Cluster Interconnect tuning using Oracle's regular performance tuning tools like EXPLAIN PLAN, STATSPACK, SQL*Trace, TKPROF.

Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.

Created Indexes to facilitate user interface implementation and tuning.

Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Golden Gate.

High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.

Adept at installation of OEM Database Control, OEM grid control and Deploying Agents

In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.

Experience in using Oracle's Transportable Tablespace (TTS) to migrate Tablespace across Oracle databases.

Also responsible for well functioning of the database by Checking and Applying Patch set and Interim patches, Upgradations thereby making the database software up-to-date. Upgraded databases from 10g and 11g to 12c.

Worked extensively on Oracle Migrations. Migrated database from Windows to Linux, HP-UX to AIX.

Proficient in using Recovery manager (RMAN), Flash-Back Technology, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).

Performance Tuning of the database (Memory Tuning, I/O Tuning)

Performed RMAN backups (Full, Incremental and Cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.

Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading to Oracle 12c to the latest Oracle 12c and Applied Patches as required.

Installed, Configured and administered GOLDEN GATE.

Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC.

Worked on large-scale databases with size around 10TB in large system environments.

Involved in construction of DR sites for all the Production and TST environments.

Performed Database Refresh from Production to TST, UAT and Development databases. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC.

Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.

Cloned Database from Production to Test and Development.

Expert in RMAN backups including full, incremental and cumulative.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.

Extensively worked on Import/Export and Data Pump Import/Export tools.

Knowledge in configuring ASM (Automatic Storage Management)

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

Database Security using Oracle Security Features (roles, privileges), Auditing & Network encryption, Transparent data encryption (TDE), Data Masking and Data Redaction.

Education

University of Yaounde I Cameroon, Masters in Educational Administration

University of Yaounde I Cameroon, Bachelor’s in Psychology

Oracle Certified Associate 11g (OCA)

SQL Fundamental Certified

Microsoft Office Certified

Technical Proficiencies

Operating Systems

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 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, UNIX Shell Scripting, PERL.

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, Winscp, DBArtisan.

Database Utilities

SQL*Plus, Oracle Enterprise Manager, RAC, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

Professional Experience

Northwest Mutual - Milwaukee, WI July 2014 – present

Oracle Database Administrator

Renaming and Resizing the databases and Configured and implemented Oracle Streams (Advanced Replication) for high availability.

Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle11g Golden Gate on RHEL 5 platform.

Performed Schema as well as Table level Replication using Oracle Streams.

Implemented downstream capture at the destination database using Oracle Streams.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Worked on Multitenant databases 12c.

Performed Database Refresh from Production to UAT and Development databases.

Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Extensive experience in RMAN recovery testing, RAC and stand alone database

Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC).

Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.

Responsible for the smooth functioning of all ecommerce activities of the organization.

Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC.

Upgraded the databases to version 12c from 11g and 10g

Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6

Up-gradation and Migration of Database from 10g to 11gand then to 12c and also applying patches whenever required.

Applying upgrade patches, maintenance and interim patches on all the databases.

Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.

Successfully implemented 10g RAC on nodes for high availability.

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

Loading data from flat files to database using SQL*Loader, External Tables.

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.

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

Involved in construction of DR sites for all the Production environments.

Installed 12c database

Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.

Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the database.

Performing monthly and annual performance reports for trend analysis and capacity planning.

Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

Worked on both VMS and UNIX environments.

Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

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

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

Environment: Oracle 11g/12c, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Eastern Illinois University - Charleston, IL Mar 2010– Jun 2014

Oracle Production Support Database Administrator

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

Installed Oracle 11g on Linux platform using ASM.

RMAN point in time recovery and Instance recovery done on 11g.

Developed compliance reports and performed auditing at higher levels.

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

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.

Performed Data refresh activities using the export data pump utility.

Installation of 2 node and 3 node RAC, Migrating of database to RAC database. Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).

Excessively worked on performing database backup and recovery using RMAN. Key player in troubleshooting backup issues. Taking the RMAN incremental and cumulative backups.

Good hands on performance tuning related issues with Experience in query analyzing and Performance Tuning for the SQL queries, which are running slow, consuming high resources.

Worked on converting bigfile to small file tablespace conversion for very large data (included 2T of data).

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Restoration of Data for users in the event of requirement or system crash.

Written SQL scripts to monitor tablespace and extent growth.

Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints. Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

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 (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

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

Used TOAD for database management.

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.



Contact this candidate