NOMBUSO CHIYA

Oracle Database Administrator

ac43tu@r.postjobfree.com

Phone: 240-***-****

* ***** ** ********** ** the field of Database Technology with experience in designing, developing, and managing Oracle Databases.

EDUCATION

PIETERMARITZBURG,

KwaZulu-Natal,

South Africa

TECHNICAL

PROFICIENCIES:

Operating Systems:

HP-UX, Sun Solaris,

AIX, Linux Enterprise

Server, Windows 2010

RDBMS:

Oracle 10g, 11g, 12c

Languages:

SQL, PL/SQL,

Tools:

TKPROF, EXPLAIN

PLAN, STATSPACK,

AWR, and ADDM.Toad,

Winscp, Remote

Desktop, VNC, and

Cisco VPN Client

Database Utilities:

SQL*Plus, Oracle

Enterprise Manager,

Real Application

Cluster, ASM,

Transportable

Tablespaces,

SQL*Loader, RMAN,

DataPump, Export,

Import

SKILLS SUMMARY

Administer over 600 databases across Development, QA, UAT and PROD environments via use of command line and Oracle tools-Oracle Enterprise Manager Cloud 12c.

Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.

Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams. Manage large complex Oracle RAC clusters with 50+ applications. Installed Oracle 11g RAC and Upgrading Oracle 10g RAC databases.

Upgraded databases from 11g to 12c.

Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 10TB to 30TB on a 6 node RAC.

Designed GoldenGate configuration for databases & implemented filters with rules to meet the business usage which will reduce load on the production databases for better performance with replication on multiple sites.

Migrated and upgraded Oracle 11gR2 Databases from Sun Solaris 10 to Red hat Linux 5 using Goldengate.

Worked on SQL Tuning and how to use the available tools outside of Oracle Enterprise Manager.

Worked on Performance Tuning, identifying large objects, analyze those objects and recommend changes to improve performance. Updated MVIEWS and test code to improve performance. Identifying objects no longer accessed and remove those objects which results in saving space in the databases. Worked on moving data from one storage area to another. Installed and Administered Oracle 11g & 10g RAC software with ASM.

Had fixed several performance tuning issues which relates to RAC & standalone databases by recommending better solutions that could save cost, virtualization, and resources.

Implemented fast start failover on databases and configuring disaster recovery site using dataguard. Also proficient with new 11g features such as Active Dataguard and Snapshot standby database.

Implemented & Managed Physical Standby and even Configured Automatic Storage Management (ASM).

Applying Patch set, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run Installer under UNIX and Windows.

Performance Tuning of Oracle database using OEM, SQL analyzer, Stats pack, AWR, ADDM, ASH, RDA, Explain plan, TKPROF, SQL TRACE and Ordebug.

Data transferring using Export/Import utilities and SQL*Loader. Expertise in creating and maintaining databases to Oracle Optimal Flexible Architecture (OFA) standards in very large scale database environment (VLDB) and mission critical OLTP and DSS systems.

Performed database tuning by using various tools such as ADDM (Automatic Database Diagnostic Monitor) from AWR

(Automatic Workload Repository), OEM (Oracle Enterprise Manager) and STATSPACK.

Performed SQL Tuning using Explain Plan, TKPROF with SQL trace and STA(SQL Tuning Advisor).Coordinated with System administrators, application developers and other DBAs. Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

Installed Oracle 10g,11g RAC software with ASM & ACFS File systems

Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility.

Involved in writing stored Procedures, Functions and Triggers in PL/SQL to interface application with database system. PROFESSIONAL EXPERIENCE

Volvo Financial Services - Greensboro, NC

Feb 2015 – Present

Oracle Database Administrator

Performance tuning, Schema creation, maintenance, and trouble shooting.

Migrated Oracle 11gR2 RAC databases and non-RAC databases to in-house Datacenter. Maintain Oracle 11gR2 RAC (ASM Real Application Cluster), Non-RAC (ASM) and File System based databases of varying sizes.

Upgrade databases from 11g to 12c.

Developed Oracle PL/SQL Packages to Scrub Data to refreshes internal lower environment databases.

Implemented Oracle database 12C RAC databases using Oracle Clusterware for achieving high Availability.

Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc

Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In- Nombuso Chiya / 2

Memory Aggregation features.

Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature. Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC

Install and configure Golden Gate, trouble shoot Golden Gate and monitor replicate lag and check point.

Designing & implementing Oracle Golden Gate 11g/12c replication to remote sites (active/passive and active/active) for disaster recovery.

Installed Golden Gate using Zero Time Migration, Integrated and Classic Capture/Extract

Configured Golden Gate 12c against RAC and non RAC databases using Cluster Ware Database file system.

Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC & 12C environment for the Production databases.

Configured and managed Data Guard extensively for Production databases of sizes ranging from 50GB to 5TB.

Experiencing in Installing OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.

Cloning/duplicate of database with RMAN and user-managed

(hot/cold) backups.

Migration of databases to 12C from Oracle 10g&11g. Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes. Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

Also worked on Network data encryption to improve the security and also implemented SSL wallet to secure the connections. Database Services creation for distributing the applications across multiple nodes, Extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,

Redefinition of tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.

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)

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

Nombuso Chiya / 3

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 Implemented 11g Interval Partitioning for monthly partitioning of large tables..

Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active- active duplication.

Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.

Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.

Handled Chained Rows and Row migration, and solved the database performance issues.

Experienced with ASM, adding, deleting disks to the disk group. Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster. Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.

Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries

Tools Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

CenturyLink Inc - Monroe, LA

May 2012 – January 2015

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.

Nombuso Chiya / 4

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 Recyclebin 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.

Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database. 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 inresolving 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.

Nombuso Chiya / 5

Contact this candidate