SUMMARY:

• Over 6 years of experience as an Oracle Database Administrator having experience in database administration including configuration, production support, upgrades, patches, full SDLC support, performance tuning, backup and recovery, space management, database security, cloning, migration, and documentation.
• 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.
• 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, 10gAutomatic Storage Management (ASM) required in fulfilling the storage needs.
• Oracle Golden Gate experience with Installation, configuration and troubleshooting of Oracle Golden Gate 11g/12c replication setup across heterogeneous database servers and ensure data synchronization.
• Experience in Performance tuning of Oracle Golden Gate Processes to achieve zero lag times.
• Experience in OFSAA Oracle Financial Services Analytical Application.
• Hands on experience on using of macros, conflict resolution, filtering and transformation, exception handlers and Security.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10gRAC servers for the purpose of disaster recovery procedures.
• Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle11g 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 withASM and OCFS2 File systems.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventionalExport/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.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations.
• Experience in doing upgrades including maintenance & monitoring implementation.
• Extensive knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
• Knowledge in configuring ASM (Automatic Storage Management)
• UNIX Systems Administration - Database and application integration efforts. HeavyUNIX shell scripting, CRON jobs.

WORK HISTORY:

Confidential, Lewisville, TX

Oracle Database Administrator

Responsibilities:

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Installation of oracle 11g databases in production, development and test environments depending on project requirements.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications
• Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
• Upgrade DBs from 11.2.0.4 to 12.1. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• 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.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Responsible for support of Oracle Databases of sizes ranging from 100 GB to 40 TB.
• Part of DB support team, providing 24/7 support for Production databases.
• Responsible for design, installation, administration, capacity planning, upgrade, security, management, performance tuning, backup & recovery, patch management, shell scripting, 24/7 technical support of Oracle 12c/ 11g, 10g databases, on Development, Test, QA and Production environments.
• Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, Streams, ASM, RMAN.
• Configured deployed and administered 2 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 5.0.
• Extensively involved in performance tuning of applications, SQL queries and databases using Explain Plan, ADDM and AWR reports.
• Installation and configuration and administration of Oracle Golden Gate
• Replication of data in heterogeneous data environments using Oracle Golden Gate
• Monitor and Configured Oracle 10g/11g/12c databases using OEM and Grid Control.
• Participated in migrating Oracle database server from 10g x-86 RHEL Environment to 10g in Solaris10 Environment and Participated in upgrading Oracle database server from 10g to 11g and to 12c.
• Designed Data Models using ERWIN forward-engineered into DDL and executed on large scale to create database.
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
• Monitored and trouble shouted database issues with OEM grid control.
• Built physical standby using RMAN Active duplication method as well for Disaster recovery site
• Performed database recovery using GRP (Guarantee Restore Point)
• Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues. Setup the unidirectional replication on oracle 11g databases using Goldengate.
• Monitoring and troubleshooting the gaps between source and target databases configured with goldengate.
• Successfully upgraded the databases from 11g to non CDB 12c.
• Successfully migrated 12c Non CDB databases to pluggable databases.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Managed Database Maintenance Activities to achieve optimum database uptime.
• Configuration of Listener and Tnsnames.
• Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Linux Redhat)
• Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 3 nodes RAC architecture in development and UAT running oracle.
• Experience in designing and configuring high-availability systems using DataGuard with physical standby effectively configured and used DataGuard Broker utility.
• Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
• Performed logical backups using Export/Import and Data Pump
• Experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Efficient in SQL query optimization and instance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports, gathering statistics, pinning the objects, Running scripts.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.

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

Confidential, Lexington, MA

Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2.
• Responsible for Datacenter Migration from old Datacenter to new datacenter and Migrated and upgraded single instance database to multiple instance databases using export/import, data pump.
• Configure Data Guard on both standby and primary for 45 production databases.
• Fail over and switch over between standby and primary databases.
• Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Hands-on experience for various performance tuning issues using VM sphere client.
• Experience in working with virtual machine (VM Ware) and oracle virtual machine (OVM).
• Experience in migrating from multiple Oracle 10gR2 database to oracle 12cR2 on virtual machine (VM Ware).
• Hands-on experience in taking snapshots and rebooting the server's and performance monitoring for Oracle databases in virtual machines (VM Ware).
• Experience in adding and expanding the disk volumes to oracle serves on virtual machines (VM Ware).
• Experience in installing oracle software and creating standalone databases on virtual machines (VM Ware).
• Hands-on experience in working with virtual machine (VM Ware) under different operating system like Linux, sun Solaris and windows.
• 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 purposes.
• Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard). Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN