SUMMARY

• 8+ years of experience in IT Industry as an Oracle Database Administrator in Installation, Configuration, Patch Installation, Migration, Up gradation, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams, golden gate& Exadata.
• Installation and administration of Oracle 12c/11g/10g/9i on OEL, RHEL, Windows, Unix and Sun Solaris in OLTP environment.
• Installation and configuration of Oracle Server 11g RAC with ASM on multinode systems, 11g, 10g and 9i in different operating systems for OLTP environment on Very Large Databases(VLDB).
• Expertise in building RAC environments on RHEL using ASM block level storage
• Expert in converting single instance databases to RAC using RCONFIG, MANUAL CONVERSION and RMAN.
• Experience on Oracle 11g/ASM/RAC and up gradation of standalone databases to 11g RAC environment.
• Installation and configuration of oracle Golden gate on 12c & 11g.
• Configuration and troubleshooting of Golden Gate EXTRACT, Unidirectional and BIDIRECTIONAL REPLICATissues.
• Configured Database File System (DBFS) on EXADATA.
• Migrated NON - ASM databases to ASM on EXADATA.
• Installed, configured and maintained RAC databases on EXADATA.
• Storage Migrations: Solely responsible for migrating the Prod/Test/Dev Databases from NetApp to HNAS and also to block level storage on EXADATA. (Migrating the databases from Non-ASM to ASM)
• Involved in moving databases in EXADATA RAC environment.
• Worked on databases on EXADATA various compression methodologies including OLTP compression, HCC, EXADATA Query specific.
• Involved in configuring Exadata X2-2, X2-8and have a good knowledge on smart flash cache, storage index, storage management and migration.
• Configuration and Management of Data Guard on RHEL, OEL and Windows.
• Setup, Configured and Maintained Oracle Data Guardto control Primary and Standby.
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via DGMGRL and GUI.
• Converted physical standby to Snapshot standby and back to physical standby.
• Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.
• Installation and Configuration of Oracle enterprise Manager Cloud control 12c on RHEL, Troubleshooting of several Oracle tools and Utilities on OEM 12c.
• Expertise in oracle OEM architecture and experience with High Availability implementation of OEM.
• Implemented backup strategies using OEM 12c and configured oracle active dataguard using OEM 12c.
• Performed Migration and Upgrade of databases to 12c, 11g and 10g.
• Up gradation of databases by applying patches, patch sets and critical patch updates.
• Applied patches like CPU, PSU, security database patches using OPatch utility.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Configuration of Automatic Storage Management (ASM).
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• Design and implementation ofBackup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental).
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, data pump export/import.
• Implemented data transfer using Data Pumps and Export/Import utilities.
• Migrating the databases from one platform to another platform.
• Implementation of Flashback Technology.
• Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data loading.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Experience in SQL Tuning, Optimization, cost based optimization and Hints.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACKand SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING.
• Interacting with the Oracle support on Service Requests and implementing the solutions provided for successful completion of the tasks.
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• 24*7 on-call production database support and maintenance including remote database support.
• Experience in advanced Oracle features such as table partitioning, Oracle Streams (Replication).
• Extensively used BMC Remedy and Service Now Ticketing systems for monitoring.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.
• Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.

TECHNICAL SKILLS

Operating Systems: HP-UNIX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2,6.1 Red Hat Linux 4.x,5.x,6.x and windows 2003/2005

RDBMS: Oracle 12c, Oracle 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i

Tools: and Utilities: RMAN, OEM, TOAD, PUTTY, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, log miner, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, RAC, ASM, Golden gate,Cloning, Exadata, Migrations

Languages: SQL, PL/SQL, UNIX/NT Shell Scripting, XML, Awk Scripting, Perl.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

PROFESSIONAL EXPERIENCE

Confidential, Ft worth, Texas

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) databases including a 3 Node RAC.
• Installed 11g 2 node production and development RAC CLUSTERWARE and DATABASE on Linux server.
• Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.
• Migrated databases on standalone server to 2 node RAC cluster.
• Setup physical standby’s (DATAGUARD) for several Databases.
• Setup the standby via OEM cloud control 12c for several databases.
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via DGMGRL and GUI.
• Converted physical standby to Snapshot standby and back to physical standby.
• Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.
• Configured Database File System (DBFS) on EXADATA.
• Migrated NON-ASM databases to ASM on EXADATA.
• Involved in moving databases in EXADATA RAC environment.
• Worked on databases on EXADATA various compression methodologies including OLTP compression, HCC, EXADATA Query specific.
• Involved in configuring Exadata X2-2, X2-8and have a good knowledge on smart flash cache, storage index, storage management and migration.
• Storage Migrations: Solely responsible for migrating the Prod/Test/Dev Databases from NetApp to HNAS and also to block level storage.
• Migrating the databases from Non-ASM to ASM.
• OEM Cloud Control12c Agent installations, plug-ins installations and adding targets to OEM. Monitoring the databases using OEM 12c.
• Troubleshooting Golden Gate EXTRACT, Unidirectional and BIDIRECTIONAL REPLICAT issues.
• Implemented PARTITIONING using EXCHANGE PARTITION method.
• Data pump (expdp/impdp) usingdatabase links and network links.
• Problem diagnosis and Performance tuning by implementing Partitioning, Parallelism, Compression.
• Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor,ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN analysis for query optimization.
• Built databases with different block sizes and tested the performance with various parameter settings.
• Capacity planning for the projects owned in the environment.
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using data pump.
• Provided backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.
• Performing DR drill activity.
• Upgrade the binaries by applying patch set and interim patches using OPatch.
• Creation of new PL/SQL procedures and triggers based on the project requirement.
• UNIX shell scripting as and when required based on the requirement.
• Provided 24*7 production supports as was always on call for maintenance activities.

Environment: Oracle 12C, 11gr2, OEL 5.8, OEM 12c, RAC, Dataguard including DGMGRL, Golden Gate, Exadata, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, TOAD for oracle 11, Storage Migrations.

Confidential, KANSAS

Oracle DBA

Responsibilities:

• Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Extensive experience in RMAN recovery in RAC and standalone database.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Performed Upgrades, Enhancements, and regular maintenance to system by researching, planning, as well as applying patches to databases and E-Business suite to keep them up-to-date.
• Kept databases, applications, and operating systems up-to-date through assessing, planning, and implementing upgrades and patches.
• Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data.
• Installation, configuration and maintenance of Oracle 10g and 11g database on OEL.
• Supported more than 130 production and development databases.
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Successfully implemented Backup & Recoveryusing RMAN, Hot and Cold backups.
• Implemented data transfer using Data Pumps and Export/Import utilities.
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using Crontab.
• Implemented DRP (Disaster recovery plan) for critical databases using Streams.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Always monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Responsible for capacity planning, recovery planning and installing patches.

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM.

Confidential, CHARLOTTE, NC

Oracle DBA

Responsibilities:

• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Installed and upgradedOracle10.2.0.1 database to 10.2.0.4.
• Developeda bunch of Index monitoring scripts in order to sort out the unused space occupied in table spaces.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance. Modified and updated the Performance tuning scripts.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.
• Created custom services for RAC database for distribution of load across the nodes.
• Performed Tuning, coding and Monitoring for OracleReal Application Clusters (RAC)nodes, Production Standalone Servers via Toad.
• Creation of materialized views and fine-tuned them for better performance.
• Working Experience with latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.
• Tuning SQL statements using Explain Plan and STATSPACK.
• Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.
• Installed & managed 10g OEMgrid monitoring solution and deployed agents.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed Schema as well as Table level Replication using Oracle Golden Gate and also did set up Disaster Recovery solution using Golden Gate.
• Created bit-map Indexes for data warehouse databases.
• Worked with ETL group for understating mappings for dimensions and facts.
• Configured Physical and Logical Standby database for reporting environment.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Clear documentation was prepared on all the processes like program specification, bugs fixing log & change requests for future reference.
• Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the databases.

Environment: Oracle 11g/10g, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 10g RAC, TOAD

Confidential

Developer/Jr Oracle DBA

Responsibilities:

• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and Statspack.
• Installation, Maintenance and administration of Oracle 10g on Red hat Linux.
• Implemented Data guard and administered the production database.
• Installed Oracle 10g RAC database on RHEL and applied all current patches.
• Database Restore using RMAN, Cold Backup and Export/Import.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Used Flashback tableto restore tables which is a new feature of Oracle 10g.
• Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Extensive application tuning through STATSPACK, explain plan, SQL*Trace.
• Implemented scripts to capture high resource utilization queries.
• Implemented Oracle Advanced Security Options.
• Maintained multiple terabyte databases on Oracle.
• Cloned the production database periodically to the testing databases through RMAN.
• Used Enterprise Manager on Oracle 10g for diagnostic summary, host CPU utilization, finding wait events, alert Log errors etc.
• Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping.
• Tuned the SGA. Monitored the shared Pool, Database buffer cache and Redo log buffers. Monitored Tablespaces and Segment fragmentation. Performed trouble shooting activities, created new users and assigned privileges and roles to users.

Environment: RHEL, Oracle 9i/10g PL/SQL, SQL*PLUS, SQL * LOADER, Oracle Enterprise Manager 9.2.0/10g,VERITAS Cluster, RMAN.