SUMMARY:

• Over 5+ years of strong experience in Oracle database administration in heterogeneous system environment including WINDOWS, HPUX, UNIX and LINUX amongst others.
• Worked as a dedicated team member responsible for monitoring/support of oracle databases performing release upgrades including overall performance tuning/patch management.
• Documented all technical details including operations, maintenance and end user application issues.
• Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.
• 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 Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
• 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.
• Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 11g, 10g) for the purpose of monitoring multiple databases and application servers.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Implementing 10g Data guard with one physical database.
• Experience in configuration and administration of Data Guard (Physical/Logical standby Databases).
• Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
• Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purpose.
• Process/workflow analysis, project management from analysis and design for implementation.
• Conceptual data modeling, logical and physical data modeling.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, StatsPack, and SQL Trace.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Standby Databases, Backup and Recovery procedures.
• Worked closely with the application, development and middleware teams for bug fixes and escalation of critical issues related with WAS.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*Loader.
• Worked with team of DBAs in migration of databases from oracle 10g to 11g, 12c.
• Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
• Wrote scripts to inform the DBA team on the status, performance and space management of the database
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.
• Experience in Logical backup using and full/ partial export/import and Data Pump.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP

RDBMS: Oracle 10g/11g

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Agents, Real Application Clusters (RAC), ASM, Sql Developer, TOAD, Exp/Imp, DataPump (expdp/impdp),SRVCTL,SQL*Plus, Recovery catalog, Autosys, Crontab, HP Manager, My Services, OTG etc

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM etc

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Oracle Database Administrator

Responsibilities:

• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)
• 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.
• 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.
• Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.
• Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and standalone database
• Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC)
• Experience in setting up Oracle ASM storage for Oracle RAC databases.
• Performed database replication through Golden Gate.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
• Performed Query tuning, Instance/Memory tuning by using various performance tools Tkprof, Explain Plan, ADDM, AWR etc.
• Planned Backup/Restoration Strategy planned and scheduled Backups, taking Logical Backups with Export/Import utilities RMAN and Data Guard
• Database Tuning - Tuning Applications, Memory Tuning and Tuning Disk Usage.
• Involved in Installation and configuration of Oracle 12c SGI, 12c RAC--2 node cluster with OCFS2 on Linux/Solaris using ASM storage for testing and development.
• Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• 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 Oracle 11g, 12c Automatic Storage Management (ASM) required to fulfill the storage needs.
• 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.
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Used hints for SQL tuning and optimization
• Performed Explain Plan analysis for Query Optimization and SQL tuning

Confidential Chicago, IL

Oracle Database Administrator

Responsibilities:

• Performed monthly and annual performance reports for trend analysis and capacity planning.
• Provided Development DBA support for developer queries and requests, Which includes query tuning, server tuning, identifying problematic code, etc
• Suggested and improved system design and architecture, this includes built New Oracle 10g/11g RAC Databases, ASM Physical and standby systems, enabling LDAP authentication and configuring RMAN backups.
• Monitored the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, IOSTAT and TOP.
• 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, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting
• Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.
• Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin 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 (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Implemented and configured 10g grid control on Production server and 11g grid control on
• Responded to all database alerts, warnings, errors in a timely, consistent manner.
• Escalated complex issues to internal team members and third party group members as appropriate.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing 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 11g environments.
• 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).
• 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 Sun Solaris platform.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases..
• Utilized TOAD for database management.

Confidential, Chapel Hill, NC

Junior Database Administrator

Responsibilities:

• Install oracle software and create databases on Linux, Solaris, and Windows platform.
• Logical and physical database design performs capacity planning, and trend analysis. Implementing online/offline database backups and managing database recovery.
• Disaster recovery planning and testing, various on site recovery experience.
• Use performance tuning utilities like SQL trace, tkprof, explain plan, dbms profiler and statspack to monitor performance and made the appropriate changes to improve performance.
• Rebuild database to improve overall database performance in idle time such as rebuild index, reorganize table by most useful index, and divide data to different fixed size table spaces/disks.
• Unix shell scripting to automate different process such as data loading, and data analyze.
• Manage application development rollovers to production. Implement data security using database roles and views. Creation of user-ids, passwords and granting privileges.
• Monitor database growth and enable a process of archiving historical data and backing the same to tapes.
• Implement better data management using data and index partitions, creating index-organize tables for look up and static tables.
• Use log miner to identify DML statements issued by users. Work alongside application developers in resolving application issues and implementing new database features.
• Work closely with development DBA team on trouble shooting SQL issues impacting database performance and uptime.