Manager Oracle

SUMMARY

I have over * years of hands-on experience as an Oracle Database Administrator. I possess complete SDLC life cycle knowledge. I have worked on Oracle 12c, 11g and 10g versions. Duties include production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning and security. I am also proficient in high availability solutions like Dataguard, Golden Gate and RAC.

SKILLS

Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

Worked on Data transferring with export/import utilities and Data pump.

Highly experienced in performance monitoring/tuning/troubleshooting.

Configured and replicated databases using oracle Golden gate.

Experienced with cross site (active-active) data replication using Golden gate.

Hands on experience working with Golden gate director and configured ODI to use oracle Golden gate for change data capture.

Implemented zero downtime migration and upgrade of 10g to 11g database using oracle Golden gate.

Replicated certain columns from a table and also certain values from columns by using oracle Golden Gate.

Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.

Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.

Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.

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

UNIX shell scripts for hot backups, SQL*Loader, export and import of database.

Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Installed Oracle 11g with ASM and OCFS2 File systems.

Involved with installation and maintenance of ORACLE 10g/11g RAC 2 node and adding a node to this cluster database for high availability.

Hands on experience in Oracle RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)

Good experience RAC Clusterware administration, Configuration and Patching, RAC Backup and Recovery.

Managed RAC Cluster using SRVCTL and CRSCTL and applied patches in rolling Fashion

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.

Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.

Extensive experience in Dataguard configuration, implementing and maintaining standby databases.

Hands on Experience in using Active Dataguard and Snapshot standby databases

Good knowledge on Logical Standby databases

Upgraded databases from 11gr2 to 12C using DataGuard.

Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.

Done migration from non ASM database to ASM database.

Responsible for maintaining every day backups and also to maintain ASM and disk space.

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

Education

Bachelor in computer science (UNIVERSITY OF BUEA 2013)

OCA

SQL FONDAMENTAL

AWS (pending )

SCRUM MASTER CERTIFICATION

Technical Skills

Operating Systems:

HP-UX 10.x, 11.x. Sun Solaris 9, 10. AIX 5.3, 6.1 RHEL 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 2010

RDBMS:

Oracle 10g, 11g and 12c

Languages:

SQL, PL/SQL

Tools:

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, WinSCP.

Database Utilities:

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

Experience

Newedge-Chicago,IL January 2016 – Present

Oracle Database Administrator

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.

Implemented 12c RAC Clusters and created POC for failures and performance in the environment and troubleshooting using clusterware Alert Log Monitoring every day in the production environment

Perform health checks using crsctl and managing services using srvctl

Performance Tuning for the SQL queries which are running slow and taking more CPU cost

Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.

Query optimizing using CBO (Cost Based Optimization) and Scheduled Oracle Jobs and Backups using CRONTAB.

Efficiently performed installation, setup and creation of four node 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.

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

Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.

Capacity planning: Allocate system storage and plan future storage requirements.

Creating OEM alerts that provides notifications through emails.

Monitoring rollback segment and temporary table space use.

Table partitioning to improve I/O access

Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump

Implemented 12c RAC Clusters and created POC for failures and performance in the environment and troubleshooting using clusterware Alert Log Monitoring every day in the production environment

Performing housekeeping tasks like checking log and trace files.

Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

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.

New Breed Logistics-Greensboro NC December 2013 – December 2015

Oracle Database Administrator

Install and Managed Physical Standby databases Data Guard for disaster recovery.

Experience in Backup and Recovery techniques using RMAN.

Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PLSQL

With help of EXPORT/IMPORT utility of database to do table level and full database Defragmentation.

Experience in working high transacted OLTP systems.

Creation of monthly IOT, creation and management of partitioned indexes and tables. Performance Monitoring and Tuning Databases and Application.

Partitioning for improving big tables to improve the Performance of the database.

Identifying bottleneck and rectifying it fine-tune store procedures to improve performance, database loads, performance improvements, proper setup of database files.

Performance tuning at database level for the parameters like SGA, PGA, PGA_AGGREGATE_TARGET.

Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance

Maintaining data integrity and tune database for optimum performance and availability.

Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.

Good experience of Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).

Good skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.

Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers.

Good knowledge on the Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.

Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.

Wrote scripts to inform the DBA team on the status, performance and space management of the database

Participated in planning and implementation of off-site Disaster-Recovery planning and testing

Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.

Experienced in full life cycle of database administration in Oracle. Worked as a Development Support DBA in Oracle.

Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.

Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes.

Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard)

Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard.

Experience in upgrading and configuring OEM Grid Control from 11g to 12c.

Experience in utilizing 11g, 12c Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.

Provided database related services to their development & QA environments.

Team player with excellent interpersonal, analytical and communications skills

Monitored and managed various database components (logical & physical) like tablespaces, segments

Worked extensively on Shell scripting for backup, recovery and maintenance for databases

Expertise on Installation/Configuring/Maintenance of Oracle Streams for replication, integration and transmission of data between different databases and applications.

Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g.

Configured physical and logical Standby Database (Data Guard) and tested for business continuity/Disaster recovery plan.

Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.

Experience in Logical backup using and full/ partial export/import and Data Pump.

Contact this candidate