SUMMARY

• Versatile and great team member, solution finder, high in spirit.
• Over Six years of hands - on experience in Oracle Database Administration.
• Expert knowledge in Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modelling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams.
• Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup.
• Unix Administration and shell scripting
• Managed 11+ TB Oracle 10g, 11g & 12c 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.
• Upgrade/Migration of Databases from Oracle 9i to 10g, 10g to 11g and 11g to 12c.
• Expertise in Database Space Management, Memory Tuning and Application Tuning, Expertise in troubleshooting and performance tuning. Have experience in Oracle Golden Gate 10.x, 11.x installation, Configuration, up gradation and administration.
• Configured parameters for the unidirectional, Bi-directional replication.
• Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
• Installed Oracle 11g with ASM and OCFS2 File systems.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Knowledge in configuring ASM (Automatic Storage Management)
• Experience in doing upgrades including maintenance & monitoring implementation.
• Provide weekly metrics to team lead for documentation on the health of Oracle databases.
• Create user accounts, unlock accounts, grant roles and privileges to users.
• Administer and execute Change Requests(CR) for Oracle Database support
• Executed and implemented user helpdesk tickets of various issues via REMEDY database from creating user accounts, read-only accounts on a database & table down to assisting them with logging into the database. Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
• Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.
• Implemented various backup strategies for Large / Medium sized databases using RMAN
• Worked extensively on Cloning /Duplicate of databases using RMAN.
• Expert in performing Cold and Hot database cloning.
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
• Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience with SQL coding including DDL, DML and fine tuning those sql's for better performance.
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• 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.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 12c, 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 Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL SKILLS

Databases: Oracle 10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Top, DBCA, DBUA, ADDM, Remedy

Operating Systems: UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450 , Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800 , HP/UX-9000, Red Hat Linux 6.2

Middleware: BEA Weblogic 10.2.3

Remote Tools: Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, VMware Virtualization

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Oracle 12C database software installation and configuration
• Oracle 12C Client installation and configuration
• 12C database creation and configurations using dbca, scripts
• Database upgrades from 10g to 12c
• Applied patches with OPatch utility and upgrade scripts
• Database monitoring and Management with OEM 12c Cloud grid control.
• Creation of pluggable databases and container databases in 12c.
• Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.
• Shell scripting, writing and customizing for automation jobs.
• Unix environment configurations, bash settings and troubleshooting and customisations.
• RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11G R2. Configuring Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM. Trouble-shoot Resource related issues. Cluster-wide Resource management such as create resource plan, Service configuration, parallel instance group, Application Isolation. Stress testing, benchmarking of clustered database.
• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Installation and creation of 11g databases for Testing & Development on both IBM-AIX and Linux environment in OLTP, Decision Support System Data Warehousing environment.
• SQL tuning - AWR history of sql execution, index recommendations, SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Interpret Execution plans, Re-write more efficient SQLs.
• Data Refresh of large production data warehouse environment to setup test, development environments using SAN level storage mirroring: Gold image copy and cloning.
• Partitioning strategies for very large tables. Implemented Range, List, Hash and various Sub Partitions, Create and schedule refresh for materialized views.
• Work with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Management of schema objects, partitioning of tables & indexes and performing SQL*Loader jobs for loading data from flat files (ETL) and Oracle Database monitoring, troubleshoot and resolve the issues.
• Monitoring growth of tables and undertaking necessary re-organization of database, capacity planning.
• Designed the logical and physical database structure and involved in Logical, Physical data modeling.
• Provide support to developers to enhance their SQL, PL/SQL code and responsible for setting up of new user accounts, schema Deployments and related user administrative tasks.
• Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.
• Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Stand by databases to ensure high availability, data protection and disaster recovery.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Worked on setting up Physical Standby Data Guard environment for Prod & non-prod databases.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security.
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Handled High volume production databases around 25 TB size along with Physical standby databases.
• Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.
• Performed Data file recovery from logical and physical block corruptions.
• Good understanding and Implementation expertise in RAC, ASM, Data Guard like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
• Installation of 3 nodes 10g RAC on Linux & Solaris with veritas cluster. Configured ASM, OCFS and RAW devices. Troubleshooting & tracing of RAC processes & CRS components. Relocate service. Tuning of RAC environment. Managing fail-over of instances. Resource utilization on each node. Monitor top objects in cache fusion and traffic.
• Exp on Cluster management, event management, application management, connection management, storage management, load balancing and availability. Continuous monitoring of performance during peak and non-peak loads using AWR reports, ASH, ADDM and Optimization SQL code using SQL Trace, tkrpof, Explain plan.
• Experience working with SQL, PL/SQL coding, stored procedures, functions, packages, triggers.
• 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 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).

Confidential - Chicago, IL

Oracle DBA

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.
• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
• Install and configure block change tracking to work with RMAN Merged incremental backups.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
• 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.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• 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.
• Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Experience on working with data guard physical/logical standby databases.
• 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.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• 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, Sizing of tables and indexes.
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.