SUMMARY:

• I have over 5 years of hands - on experience as an Oracle Database Administrator. I possess complete SDLC life cycle knowledge. I have worked on Oracle 12c, 11g and 10g versions. Duties include production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning and security. I am also proficient in high availability solutions like Dataguard, Golden Gate and RAC.
• Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Worked on Data transferring with export/import utilities and Data pump.
• Highly experienced in performance monitoring/tuning/troubleshooting.
• Configured and replicated databases using oracle Golden gate.
• Experienced with cross site (active-active) data replication using Golden gate.
• Hands on experience working with Golden gate director and configured ODI to use oracle Golden gate for change data capture.
• Implemented zero downtime migration and upgrade of 10g to 11g database using oracle Golden gate.
• Replicated certain columns from a table and also certain values from columns by using oracle Golden Gate.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
• 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.
• 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.
• Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.
• UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
• Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
• Installed Oracle 11g with ASM and OCFS2 File systems.
• Involved with installation and maintenance of ORACLE 10g/11g RAC 2 node and adding a node to this cluster database for high availability.
• Hands on experience in Oracle RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)
• Good experience RAC Clusterware administration, Configuration and Patching, RAC Backup and Recovery.
• Managed RAC Cluster using SRVCTL and CRSCTL and applied patches in rolling Fashion
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• 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”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.
• Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Hands on Experience in using Active Dataguard and Snapshot standby databases
• Good knowledge on Logical Standby databases
• Upgraded databases from 11gr2 to 12C using DataGuard.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
• Done migration from non ASM database to ASM database.
• Responsible for maintaining every day backups and also to maintain ASM and disk space.
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 9, 10. AIX 5.3, 6.1 RHEL 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 2010

RDBMS: Oracle 10g, 11g and 12c

Languages: SQL, PL/SQL

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:

Confidential -Chicago,IL

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.
• RMAN point in time recovery and Instance recovery done on 11g.
• Developed compliance reports and performed auditing at higher levels.
• Implemented 12c RAC Clusters and created POC for failures and performance in the environment and troubleshooting using clusterware Alert Log Monitoring every day in the production environment
• Perform health checks using crsctl and managing services using srvctl
• Performance Tuning for the SQL queries which are running slow and taking more CPU cost
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Query optimizing using CBO (Cost Based Optimization) and Scheduled Oracle Jobs and Backups using CRONTAB.
• Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• 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
• 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.
• Creating OEM alerts that provides notifications through emails.
• Monitoring rollback segment and temporary table space use.
• Table partitioning to improve I/O access
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump
• Implemented 12c RAC Clusters and created POC for failures and performance in the environment and troubleshooting using clusterware Alert Log Monitoring every day in the production environment
• Performing housekeeping tasks like checking log and trace files.
• Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• 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, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• 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.

Confidential -Greensboro, NC

Oracle Database Administrator

• Install and Managed Physical Standby databases Data Guard for disaster recovery.
• Experience in Backup and Recovery techniques using RMAN.
• Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PLSQL
• With help of EXPORT/IMPORT utility of database to do table level and full database Defragmentation.
• Experience in working high transacted OLTP systems.
• Creation of monthly IOT, creation and management of partitioned indexes and tables. Performance Monitoring and Tuning Databases and Application.
• Partitioning for improving big tables to improve the Performance of the database.
• Identifying bottleneck and rectifying it fine-tune store procedures to improve performance, database loads, performance improvements, proper setup of database files.
• Performance tuning at database level for the parameters like SGA, PGA, PGA AGGREGATE TARGET.
• Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance
• Maintaining data integrity and tune database for optimum performance and availability.
• Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
• Good experience of Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).
• Good skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
• Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers.
• Good knowledge on the Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.
• Extensive experience in P erformance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• 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.
• Experienced in full life cycle of database administration in Oracle. Worked as a Development Support DBA in Oracle.
• 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 purposes.
• Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard)
• Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard.
• Experience in upgrading and configuring OEM Grid Control from 11g to 12c.
• Experience in utilizing 11g, 12c Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Provided database related services to their development & QA environments.
• Team player with excellent interpersonal, analytical and communications skills
• Monitored and managed various database components (logical & physical) like tablespaces, segments
• Worked extensively on Shell scripting for backup, recovery and maintenance for databases
• Expertise on Installation/Configuring/Maintenance of Oracle Streams for replication, integration and transmission of data between different databases and applications.
• Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g.
• Configured physical and logical Standby Database (Data Guard) and tested for business continuity/Disaster recovery plan.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.
• Experience in Logical backup using and full/ partial export/import and Data Pump.