Oracle DBA
Resume:
TANIFUM TERENCE NIBA AZINWI
540-***-**** ac3ky3@r.postjobfree.com
ORACLE DATABASE ADMINISTRATOR
Professional Summary
I have over 6 years of interactive experience in Oracle Database Administration including Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Goldengate. I have worked on Oracle 10g, 11g, 12c versions. Support full SDLC environments.
Experience in Performing database space management, monitoring, Tuning with Oracle 12c Cloud Control, custom automation scripts, etc.
Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration
Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.
Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup
Performed Uni-directional and Bi-directional replication through Golden Gate for zero downtime Database migrations.
Expertise in system Monitoring and Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advisor, Undo Segment, MTTR, Memory.
Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
Expertise in maintaining Database Security using auditing.
Managed Oracle 10g & 11g databases in Data warehousing environment.
Starting/Shutting down the RAC databases and Creating and Relocating RAC database services to instances.
Monitoring of cluster ware files i.e., OCR files & Voting Disk files.
Monitoring the ASM instances on the multiple nodes and adding the disk to the disk group when required.
Experience migration/consolidation of databases using Oracle 12c multitenant.
Designed and implemented Oracle Real Application Clusters (RAC) on Linux.
Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.
Switchover and Failover RAC database with Data guard Broker
Experience in conversion of Single Node Instance to multimode RAC with ASM, and adding instance to existing RAC.
Experience in Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.
Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).
Applied patches (Patch sets and CPU patches) and worked closely
Performed an upgrade of Oracle Database from 11g to 12c.
Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database
Experience in Data Migrations.
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.
Tablespace & Data file creation and Maintenance by Adding and Resizing data file if needed
Monitoring the Database health check and growth with script.
Keeping the databases up to date with respect to Latest PSU's and very comfortable in applying patches.
Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control.
Technical Summary
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, MSSQL SERVER,MYSQL
Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL
Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, sql server management studio(SSMS)
Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import
Experience Summary
CITY OF KEENE
April 2015 – Present
Role: Oracle Database Administrator
Applied patches (Patch sets and CPU patches) and worked closely
Performed an upgrade of Oracle Database from 11g to 12c.
Disaster Recovery (DR) Plan Implemented using DATAGUARD (Physical Standby) for high availability/disaster recovery purpose on Oracle 11g.
Performing DR switchover and failover operations.
Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and High Availability.
Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities
Troubleshooting Golden Gate issues in both development and production environments.
Performed Uni-directional and Bi-directional replication through Golden Gate for zero downtime Database migrations.
Migrating and upgrading Oracle Database from 10gR1 on Solaris/Windows to 11gR2 on Linux environment using Datapump and Golden Gate replication.
Experience of installing, configuring Golden Gate Replication from OLTP databases to Datawarehousing environments.
Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins
Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1
Data migration between databases using both Oracle 10g and 11g
Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), 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. installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.
Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)
Provided valuable inputs for various performance tuning issues.
Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)
Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 10g database control, oracle 10g Grid Control as well as other third party tools (TOAD, SQLDeveloper).
export/import utility and Oracle 11g exp/imp data pump.
Implement Oracle 12c new features in mission-critical production environments.
Administering and setting up of 11g/12c RAC and clusterware and instances.
Upgraded Oracle GRID, ASM and Database from 10g and 11g to 12c.
Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
Applying CPU/PSU Patches on ERP instance and Plain databases.
• Configuration and maintenance of 11g RAC and Single Instance database environments.
Installing ASM environment and migrating databases from NON-ASM to ASM.
Maintained Oracle 11gR2 RAC high availability with ASM file system with Cluster Stat and Grid infrastructure on Linux environments. Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
Upgrading Grid Infrastructure and databases from 11.2.0.1/11.2.0.2/11.2.0.3 to 11.2.0.4.
Troubleshoot installation errors both independently and with Oracle support (via My oracle Support)
Create oracle databases on configured servers using both the DBCA & Database creation scripts.
Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.
Application design and code is produced with proper integrity, security and performance
Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
Cloning of Test/DEV instances from Production systems.
Analyzed SQL queries causing performance problems.
Created, Configured, Upgraded And Administered 10.2.0.4/11.2.03 & 12.1 versions Oracle databases on Linux Red Hat and Cent OS on Vmware and bare-metal environments
Creation and configuration of new database server and database environments.
Performing Monthly Re-org of complete databases using expdp and impdp
Participated in meetings for Project Updates/Project Enhancements/Trouble shooting periodically
Maintaining database and middleware/SOA layer performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases.
DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.3 & 6.1. Database sizes range from 50GB to 3TB (in ODS & EDW environments).
Tools Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN
Weis Market Inc - Sunbury, PA
June 2012 – March 2015
Oracle DBA
Provided Assistance to application team at the time of SQL tuning in applications. Administration of RAC and DATAGUARD databases in Oracle 11g.
Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration
Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration.
Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required.
Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.
Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.
Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Installed Oracle 10g and 11g on multiple platforms.
Performed up-gradation of 10g to 11g.
Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.
Automated routine DBA tasks like backup's and stats by using Grid control job's
Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
Adding and removing nodes to existing Oracle database RAC configurations
Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment
Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT.
Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.
Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates.
Performed activities like monitoring the database and provide maximum uptime.
Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
Created primary database objects (tables, views, indexes) once application developers have designed an application
Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
Environment: RHEL 4.4, HP-UX, 10g, and 11g, Oracle 10g/11g RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, ERWIN 7.2, Autosys, Golden Gate, SQL*Plus, PL/SQL, SQL*Loader
Education
UNIVERSITY OF BUEA - CAMEROON
Bsc in Computer Science
Contact this candidate