LIVIA MANKA-A

Oracle Database Administrator

Phone: 214-***-**** / Email:acxu55@r.postjobfree.com

Profile

An Oracle Database Administrator with over 5 years of experience which includes Installation, Configuration, Migration, Database Backup & Recovery, data guard implementation, Tuning at Instance level and SQL level, Cloning, Space Management, Database Security, Auditing, Troubleshooting, Managing Oracle 11g/10g R2 databases and documentation in heterogeneous environments..

Skills Summary

Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.

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.

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

Extensively worked on Import/Export and DATAPUMP Import/Export tools.

Knowledge in configuring ASM (Automatic Storage Management)

Experienced in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.

Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Experienced in performance-tuning, SQL tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ASM and ADDM to collect and maintain performance statistics and improve the database performance.

Expertise in upgrade process from 10g, 11g to 12c and data migration from Non-ASM to ASM and Non-RAC to RAC.

Highly skilled in administering Oracle ASM disk groups (mirroring, compatibility, and configuration) with Oracle ASM Configuration Assistant (ASMCA) including installation of Oracle ASM library modules.

Effectively deployed active data guard standby on 11g database for test and production environments and performed switchover drills for immediate availability.

Implemented FSFO (Fast start failover) on databases through Data Guard Broker. Configured disaster recovery site and Snapshot standby databases.

Configured and administered 11g 2/3 node RAC database clusters through Oracle Clusterware utilities and High Availability Services.

Efficient understanding on Oracle Cluster Resources and configuring the hosts with appropriate cluster service tools like CVU, OCRCONFIG,CRSCTL and SRVCTL, monitoring the cluster resource daemon and the status of CRS and HAS.

Profound knowledge on installation and configuration of GoldenGate with experience in controlling processes such as Extract, Replicate and Manager for migrating huge volumes of transactional data with minimal load to the online systems and handled Oracle ASM Cluster File System (ACFS) for 11g databases.

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

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

Upgraded Databases from Oracle 10g to 11g and 11g to 12c and applied patches according to the client requirement in RAC and NON RAC environments with ASM and Non ASM storage.

Proficient in implementing/configuring and using OEM 10g, 11g and12c Grid control.

Experience in User management, Space Management, Capacity Planning.

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

Highly experienced in using Oracle 10g features Flash-Back Recovery and Recycle Bin.

Experience with Oracle 11g/10g in Installation, Administration, Monitoring, Database Backup and Recovery.

Experience as a Production support/Operations DBA with Multi-Terabyte 24x7/large databases and as a Development Engineer/Data Warehouse DBA.

Expert in maintaining very Large Databases involved in Data warehouse and ERP Applications of various sizes - 5TB.

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

Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC.

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

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.

Technical Proficiencies

Operating Systems

HP-UX 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 6.1, 7.1 RHEL 5.x., 6.x. Linux Enterprise Server 10, 11, 12 Windows 2008, 2012

RDBMS

Oracle 10g, 11g

Languages

SQL, PL/SQL, UNIX Shell Scripting, PERL.

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

Professional Experience

ACS - Lexington, KY

Jun ’13 – Present

Oracle Database Administrator

Supported 24x7 mission critical applications which include different versions of Oracle 10g/11gR1/11gR2/12c for Standalone and RAC Databases.

Installation and configuration of 10g,11g,12c in UNIX/LINUX (RHEL)and Windows server 2008,2012.

Installation and configuration of 12c Container Databases on standalone servers and cluster on windows and unix platforms.

Upgraded multiple Standalone and RAC databases and grid infrastructure from 11gR2 to 12cR1.

Applied PSU on standalone TEST environment using OPatch and same PSU (Grid and RDBMS Patching) on production cluster using the OPatch utility.

Supported in Performing GoldenGate configuration, administration, installation, also configuring pumps and managing trail files by purging old extract files and log files.

Troubleshooting GoldenGate using GGSERR.LOG and logdump utility.

Replication Using GoldenGate for multiple extracts, replication and mapping. Great understanding and usage of advanced parameters in Golden Gate.

Implemented Physical Standby Databases and automated scripts to delete archive logs that already applied to standby.

Duplicating Tablespaces and Databases from Production server to Test server as per customer requirement.

Involved in datacenter migrating large size database in multiple platform.

Expertise in Active DataGuard, Snapshot using Dataguard Broker (DGMGRL) and RMAN.

Generated AWR (Statspack), ADDM, Explain Plan, TKPROF, SQLTRACE, ORADEBUG reports for Performance tuning and also used new tools of 12c for security purpose.

Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.

Monitored CPU usage, I/O contention, memory, paging and identifying the resource and performance bottleneck in both windows and Unix environment.

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 Backup and Recovery including 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 and BACKUPS using crontab.

Experience in writing UNIX/SHELL scripts for providing reports.

Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing.

Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.

Extensively used Datapump, 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.

Monitoring rollback segments and temporary table space use.

Performing housekeeping tasks like checking log and trace files.

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

Performing monthly and annual performance reports for trend analysis and capacity planning.

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

DTE Energy - Detroit, MI

Jun’11 – Jun’13

Oracle Production Support Database Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Documented various recovery scenarios for Data Recovery site and managing the gaps in archive logs to bring the standby in sync with primary database through Data Guard Broker and building Data Recovery environment for the business critical databases.

Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)

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

Identified and tuned poor SQL statements using EXPLAIN PLAN, Hints, SQL TRACE, and TKPROF. Analyzed tables and indexes used Cost Based Optimizer (CBO) for improving the performance of the Query.

Resolved ASM issues like rebalancing, disk additions and managed ASM with ASMCMD.

Loaded data from flat files to database using SQL*Loader and External Tables.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

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

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

Implemented database monitoring/maintenance, replication process and performance tuning using OEM (Oracle Enterprise Manager).

Implemented Flashback technology of Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 10g (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7)

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

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

Used TOAD for database management.

Made optimal use of Oracle Support in resolving 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.4, ASM, RMAN, AWR, ADDM, SQLPlus, SQL*Loader, OEM, TOAD 10.0.

Xcel Energy - Amarillo, TX

Mar ’10 – Jun’11

Oracle Production Support Database Administrator

Installed and configured ORACLE 10g on HP-UX and Windows NT.

Performed Upgrade of databases from Oracle 9i to Oracle 10g.

Implemented physical backup (both hot and cold) & recovery procedures for the database using RMAN utility of Oracle 10g.

Created users and assigned them the required privileges.

Provided 24x7 on-call support as needed.

Implemented coalescing when required by monitoring the database for fragmentation.

Performed table space management, monitored data file additions, extent growth, normalization, indexing as part of day-to-day activities.

Resetting of storage parameters by series of export and import of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.

Created, maintained and troubleshoot PL/SQL objects, shell scripts and utilities.

Implemented proactive monitoring using STATSPACK, SQL TRACE, TKPROF and EXPLAIN PLAN.

Separated the indexes, data, rollback segments and redo log files on separate disks to minimize contention, Monitored the buffer cache hit ratio and the dictionary cache miss ratio. The DB_BLOCK_BUFFERS and SHARED_POOL_SIZE were increased, resulting in tremendous improvement in performance.

Environment: Oracle 10.2.0.5, 11.1.0.7, IBM AIX V6.1, RHEL 5.2, ASM, RMAN, SQLPlus, SQL*Loader, OEM, TOAD 10.0.

Education

Indian Hills Community, Ottumwa, IA

Associate Degree

Texas State Technical College, Sweetwater, TX

Contact this candidate