Oracle Manager

CLINTON TANIFORM ATAHSIRIA

Oracle Database/Administrator

240-***-**** /// *************@*****.***

PROFILE

A talent and resourceful Oracle DBA professional with 6 plus years of diligent experience. I have supported the complete system development life cycle (SDLC). I have worked on Oracle 9i, 10g, 11g and 12c versions. I have done database administration duties including production support, installation and configuration, database upgrades, patch management, database migration, backup and recovery, performance tuning, database cloning, golden gate and security management. I have supported some PEOPLESOFT and ORACLE E BUSINESS SUITE applications.

SKILLS SUMMARY

Have excellent knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.

Experienced in Performance Monitoring tools like OEM, AWR report, DBMS_PROFILER to troubleshoot some PL/SQL codes.

Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, OEM Grid, monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

Experience with SQL coding including DDL, DML and fine-tuning those SQL's for better performance.

Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring. 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)

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

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

Install, configure and upgrade to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle 12c features.

Performed database monitoring and tuning to ensure databases run at peak performance; troubleshooting production performance issues.

Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).

Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.

Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.

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

Expertise in maintaining Database Security using auditing and High level Security using Transparent Data Encryption(TDE),

EDUCATION

Government Technical High School (Advanced Level Certificate in Computer Science)

Bachelors of science in Civil engineering

WORK EXPERIENCE

MEDLINE (Richmond, VA) Nov 2014 – Jan 2018

Oracle Database Administrator

Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.

Worked on Multitenant Databases (Oracle 12c Container and pluggable databases)

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

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.

Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.

Database reorganizations and refresh schema-using Export/Import.

Creating the database, tablespaces, tables, indexes, setting privileges and user logins.

Creating physical databases with multiple tablespaces from logical and physical data model

Configured and Managed Golden gate for Unidirectional and Bidirectional Replication.

Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.

Used Oracle 12c Enterprise manager to monitor and report the Database health for over 500+ databases

Upgraded databases from 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades.

Upgraded 10g and 11g Standalone databases to 11g and 12c 2-node RAC respectively

Installation and creation of 11g databases for Testing & Development on both IBM-AIX and Linux environment in OLTP, Decision Support System Data Warehousing environment.

SQL tuning - AWR history of sql execution, index recommendations, SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Interpret Execution plans, Re-write more efficient SQLs.

Some experience working with Microsoft SQL Server to create databases, creating and managing users accounts and Migration.

Handled High volume production databases around 25 TB size along with Physical standby databases

Worked on Teradata in Data warehousing to maintain huge amount of data used for analytical purpose.

Experienced in managing Change Data Capture (CDC) in Data warehousing from OLTP to OLAP.

Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.

Performed Data file recovery from logical and physical block corruptions

Expert on Cluster management, event management, application management, connection management, storage management, load balancing and availability.

Continuous monitoring of performance during peak and non-peak loads using AWR reports, ASH, ADDM and Optimization SQL code using SQL Trace, tkpof, Explain plan.

Partitioning strategies for very large tables. Implemented Range, List, Hash and various Sub Partitions, Create and schedule refresh for materialized views.

Work with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.

Management of schema objects, partitioning of tables & indexes and performing SQL*Loader jobs for loading data from flat files (ETL) and Oracle Database monitoring, troubleshoot and resolve the issues.

Monitoring growth of tables and undertaking necessary re-organization of database, capacity planning.

Designed the logical and physical database structure and involved in Logical, Physical data modeling.

Provide support to developers to enhance their SQL, PL/SQL code and responsible for setting up of new user accounts, schema Deployments and related user administrative tasks.

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.

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

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

Experienced using GOLDEN GATE for UNIDIRECTIONAL AND BI DIRECTIONAL Replication.

Worked on AWS to create VPC, EC2 Instances, Security Groups,S3 Buckets and AWS Hub to migrate from on premise to Cloud.

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

Bank of America (Richmond, VA) Jul 2011 – Oct 2014

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.

Creating Materialized views and Materialized View Logs for Data Replication.

Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.

Worked on building and rolling out new 12c databases for TEST/DEV/QA environments.

Implemented oracle 12c active standby database for test database environment

Handled my group of 4 people in all and lead them for getting best results

Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.

Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat and crs_profile.

Responsible for setup and implementation of 2Node RAC on IBM-AIX in log and 11gR2 using Veritas clusterserver.

Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.

Performed various tasks like Administering RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Developed compliance reports and performed auditing at higher levels.

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

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

Extensively used Data pump, conventional export/import utilities for loading data to & from databases, logical backups and migration of 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.

Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer.

Installation and configuration of Oracle databases environments (10/11g), upgrades, patching for security vulnerabilities (CPU and PSU).

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.

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

Used GOLDEN GATE for Zero Downtown Upgrade and Migration.

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/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

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, NX client, WinSCP.

Database Utilities

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

TWS Scheduler

ADF

APPLICATIONS

PEOPLESOFT, ORACLE E BUSINESS SUITE.

Contact this candidate