Oracle Management

Mekone Sone

Oracle Database Administrator

**********@*****.*** 443-***-****

I have over five plus years of hands-on experience in Oracle Database Administration/Management, Design, Deployment, Testing and Production support performing tasks such as 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, Oracle Streams.

SKILLS SUMMARY

Excellent experience in managing large-scale OLTP databases 6+TB size in HA and DR setup.

Managed 30+ TB Oracle 10g & 11g databases in Data warehousing environment.

Solid experience in oracle database migration, upgrades, applying patch sets, code reviews, database release and deployments and data center consolidation activities. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Extensive Experience with RMAN Backup & Recovery, Hot Backups and Logical Backups.

Provide weekly metrics to team lead for documentation on the health of Oracle databases.

Create SRs, administer and execute Change Requests(CR) for Oracle Database support

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

Highly experienced in performance monitoring/tuning/troubleshooting using AWR, ADDM, EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.

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 implementing Oracle's Transportable Tablespaces (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing quick movement of user Tablespaces across Oracle databases.

Experience in creating/administering partitioned tables using the new partition features of 10g/11g and handling Space Management for Oracle DBs.

Experience in Database Security Administration, Oracle Transparent Database Encryption (TDE), Auditing, Oracle Alert and Patch Management.

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

Worked with development and operations staff in resolving problems quickly and efficiently

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.

Worked extensively on creating development, testing, staging, production RAC and standby databases for OLTP and Data Warehousing using customized scripts and stepwise.

Excellent knowledge of Full and Incremental Backup & Recovery, Cloning of databases using RMAN, OEM Grid Control 12c, Net Backup, PL/SQL, UNIX Shell Programming.

Design, development, and testing of backup and recovery to ensure complete recoverability.

Perform proactive checks using OEM Grid Control 12c & TOAD to manage, tablespace usage, memory structures, rollback segments, logs, alerts etc.

UNIX Systems Administration - Database and application integration efforts. UNIX shell scripting, scheduling Autosys & CRON jobs.

Team player with excellent interpersonal, analytical, problem-solving and communication skills

TECHNICAL SKILLS

OPERATING SYSTEMS:

Red Hat Linux RHEL 5.x, 6.x, AIX v6.1, Solaris 10 and Windows XP

RDBMS:

Oracle 10g, 11, 12c

LANGUAGES:

SQL, PL/SQL,UNIX Shell Scripting, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS:

Recovery Manager (RMAN), Data Pump, OEM Grid Control 12c, Oracle Data Guard, Real Application Clusters (RAC), ASM, Sql Developer, TOAD, Sql Loader.

TUNING TOOLS:

EXPLAIN PLAN, AWR, ADDM, TKPROF, STATSPACK

PROFESSIONAL EXPERIENCE

SHAW UNIVERSITY -Raleigh, NC. March 2012 - Present

Oracle Database Administrator

Responsibilities:

Managed Oracle Databases on Linux and Solaris platforms.

Backup/Restore of oracle databases using RMAN.

Setup Auditing/Oracle Transparent Data encryption (TDE) for security management.

Tuning and troubleshooting databases (improving existing SQL and PL-SQL code, creating triggers, procedures, and packages) - tuning instances for optimal performance. Tuning database for better performance using AWR/ADDM/OEM report and manual scripts. Tuning the SQL queries using explain plan and TKProf. Use DBMS_SQLTUNE, DBMS_SQL_MONITOR packages for real-time SQL monitoring.

Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability

Involved in installation/configuration/maintenance of Oracle RAC/ASM databases and troubleshooting RAC performance issues. Adding/Removing the nodes for a better architecture.

Troubleshooting Replication, RAC and other Oracle related issues and implementing resolutions.

Performing day-to-day database administration tasks including installation, upgrades, backup/recovery, monitoring, disaster recovery procedures (switchover/failover) and database cloning across environments, patching.

Upgrading/Patching oracle databases from 10g, 11g, 12c and applying latest PSU patches.

Identifying long-running queries, tuning them for better performance, and working with end- users to implement changes

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 12c Grid Control & SQL*Plus, as well as UNIX shell scripts.

Monitored the alert logs and troubleshot the errors.

Scheduled the backup jobs using Autosys or Crontab in UNIX environment.

Rebuilt indexes and analyzed tables to ensure good performance of database.

Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.

Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and AWR snapshots and reports.

Tuning the SQL statement by analyzing the EXPLAIN PLAN, SQL Tuning Advisor, SQL Profile and ADDM reports

Setup and utilized 12c Grid Control (OEM) to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.

Monitoring space, wait events, locks and long operations running on the database.

Monitoring the session waits for the database performance and resolving the performance issues.

Monitoring the database for growth and added space to the table spaces as per demand.

Implemented scripts to monitor and get information on free space, alert log errors. Provided maintenance of user accounts, privileges, profiles and roles.

Upgrade/Migration of Databases from Oracle 10g to 11g, Cross platform migration from different platforms.

Experience on working with dataguard physical/logical standby databases.

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).

Documented the Standard Processes for peers to follow.

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.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of OLAP environments

Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.

Provided 24X7 support for all the production and development databases.

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

Environment: Oracle 10g/11g RAC, Solaris 10, Windows Server 2008, Red Hat Linux 6.5, TOAD, RMAN, SQL server, OEM Grid Control 12c.

SCHNEIDER NATIONAL - Green Bay, WI Jun 2010 – March 2012

Junior Oracle Database Administrator

Responsibilities:

Applying RDBMS patches, security patches for improving the security and functionality of the databases.

Plan and schedule RMAN backups (hot, cold and incremental backups)

Created tables, views, indexes and synonyms required to meet developer needs.

Database reorganization and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.

Proactive monitoring/tuning databases using OEM Grid Control 11g, ADDM, AWR, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN to optimize performance

Automated the processes like moving files, tailing alert log, efficient backup by developing UNIX scripts.

Involved in the installation and configuration of two node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL platform.

Involved in configuration of Oracle Streams on Oracle 10g, 11g databases for data replication and monitoring them using Grid Control.

Involved in team effort to evaluation of Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.

Automated the Data Replication process using ETL and Materialized Views for reporting databases.

Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

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 switchovers on primary and standby databases as a part of planned maintenance activities.

Implementing Datapump, conventional export/import utility of Oracle 10g, 11g 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.

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

Used TOAD and OEM Grid Control for database management.

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

Provided remote technical support using SSH and terminal services

Involved in design and enforcing standards in place to ensure that all application design and code is produced with proper integrity, security and performance

Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.

Performed proactive and reactive tuning/managing database space utilization and growth

Administering Oracle RAC 11g databases

Implementing Oracle ASM and resolving ASM related issues

Performed bulk data loads using SQL Loader.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Environment: Oracle 11g, 10g, IBM AIX V6.1, RHEL 5.5, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM Grid 11g, TOAD

EDUCATION

Bachelors Degree University of Buea

Contact this candidate