SUMMARY

• 8 years of professional experience as Oracle Database Administrator having good experience in database administration, database installation, up - gradation, migration, installing patches, performance tuning, RAC installation and maintenance, setting up and configuring Data-guard, performing all kinds of backups and recoveries, cloning databases, replications using golden gate, auditing and product support
• Hands on experience on Oracle (9i/10g/11gR1/11gR2/12C), installing and configuring, maintaining Oracle databases on different operating systems like UNIX (RHEL 4/5, AIX 6.1, OEL 5/6, Solaris10, HP-UX 7) for OLTP & OLAP environment.
• Having good experience in 10g/11g/12c database administration Real Application Cluster.
• Experience in configuring high availability systems like Real Application Cluster 10g/11g on RHEL 4 / 5.8, OEL 6.1.
• Experienced in managing RAC environment 11g/12C OEM Grid Control.
• Experienced in Installing, monitoring and managing of Oracle instances using Enterprise Manager Grid Control 10g/11g/12c.
• Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.
• Having good experience in working with World Fastest Machine Exadata (x2-8) Dataguard and Golden gate
• Planned and Implemented Disaster Recovery databases using Dataguard.
• Experienced in configuring, managing, trouble shooting and monitoring Physical standby using Data Guard 10g/11g/12c.
• Have hands experience in 11g new features Active Data-guard & snapshot standby.
• Installed, Configured and replicated databases using Oracle Golden Gate.
• Installed patches using Opatch utility and upgraded databases on 9i/10g/ 11gR2 and expertise in applying Oracle PSU and CPU patches Up-gradation and migration.
• Upgraded databases from 10g to 11gR2 on Solaris and Linux platforms.
• Performed up-gradation of grid infrastructure from 11.2.0.2 to 11.2.0.3.
• Having good experience in migrating databases with zero downtime using golden gate & Dataguard.
• Performed cross platform migration of databases from IBM - AIX, Solaris, Hp-Unix to Linux 11g RMAN, FLASHBACK and Data pump.
• Experience in implementing and planning backup and recovery strategies using Recovery Manager, created clone databases for development and test environments using RMAN.
• Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN.
• Configured catalog database and registered databases in catalog using RMAN.
• Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.
• Implemented User managed cloning and Flashback Technology Performance Tuning and Oracle Security.
• Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing.
• Performance Tuning of the database (I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for the Better performance.
• Performed various Transparent Data Encryption Operations.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Experience using Erwin as a Data Modelling tool & Designing the ETL processes.
• Good knowledge on Oracle support process for technical requests using Metal link and other support features.
• Good written and verbal communication skills, self-motivated team player and good analytical thinking.
• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues.

TECHNICAL SKILLS

Databases: 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i.

Oracle Products: Oracle Real Application Cluster 10g/11g, Golden Gate, Data guard, Import and Export, Data pump, Oracle Wallet Management, Automatic Storage Management, Recovery Manager, Oracle 10g/11g/12c (Grid Control), Oracle Exadata, RMAN, Transparent Data Encryption.

Operating System: Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, AIX 6.1, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008

Languages: SQL, PL/SQL, Unix shell scripting, Java

Tools: & Utilities: SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, TKPROF, AWR, ASH, Toad, Oracle SQL Developer, DB Artisan Putty, ERWIN, ETL

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SR. Oracle DBA

Responsibilities:

• 24x7 Database Administration Support
• Upgraded databases from 11.2.0.4 to 12C in QA and Prod environments
• Installed and implemented 11gR2 3 node RAC with Dataguard/DG broker
• Setting up/Installation and configuration of 11g RAC R2 with ASM and Raw Devices, 11g CRS
• Planning and implementing DR & high availability solutions using Oracle 11g Standby Database using Oracle Data guard, 10g and 11g RAC
• Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site
• Created scripts and scheduled backups in Autosys for RMAN database backups and recoveries
• Cloned databases using RMAN Utility
• Performed Golden Gate replication monitoring, tuning, and capacity planning.
• Replication of data using Oracle Goldengate.
• Creation of Materialized views and partitioned the oracle tables to improve reporting performance.
• Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.
• Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly.
• Creating and managing database objects such as tables, indexes, partition tables and views.
• Refreshing of databases using datapump utilities expdp/impdp.
• Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.
• Wrote Shell Scripting for managing day-to-day activities and automation of backup.
• Configured 11g R2 RAC Data Guard.
• Assisted in integration of Exadata applications into current IT actionable events and solutions
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions
• Experience ensuring the high availability, integrity of databases & database designing.
• Doing cross platform migration using Export/Import from Sun Solaris to Linux server
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL* NET connectivity
• Diagnosed and troubleshoot database problems such as errors and bugs, performance problems, runaway processes, connectivity problems, poor SQL statements, etc
• Looking into day-to-day activities of Production database, Monitoring its growth and performance.
• Daily incremental backups and weekly cumulative backups using RMAN.
• Performed SQL tuning, System tuning, Database and Instance tuning by root cause analysis.
• Data partitioning & tuning queries on large Oracle RAC databases.
• Monitoring the instance statistics and tuning the database to improve performance.
• Use of tools like OEM, STATSPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports to proactively monitor performance.
• Backup procedures using RMAN
• Management of databases on multiple servers.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.
• Managing and providing 24X7 supports for various versions of databases.
• Performed on-call technical support to minimize the impact of system disruptions.

Environment: Oracle 10g,11gR2,12C, Linux 6.3, Oracle Enterprise Manager, Grid Control, Sun Solaris, HP-UX, OEM Database control, PL/SQL, Oracle SQL Developer, Shell Scripting, TOAD, ASM, RAC, Golden Gate, Data Guard.

Confidential, Piscataway, NJ

SR. Oracle DBA

Responsibilities:

• Installation, configuration, and maintenance of Oracle 10g, 11g on RHEL 4 and 11g on RHEL 5, HP-UX, AIX and Windows 2003 Server and Upgradation from Oracle 10g to 11g.
• Database upgrade from 11g to 12C
• Responsible for setup and implementation of two node and three node RAC on Oracle 11g.
• Configured Oracle Dataguard for Oracle Disaster Recovery.
• Performed switchover/switchback from primary database to standby database for testing purpose for the application teams when required.
• Worked on SQL SERVER 2005, 2008.
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Migration of large number of databases from 10g to 11g.
• Implemented ASM on RAC and stand-alone databases.
• Migration of non ASM database to ASM database.
• Using list partitions for large tables and bitmap indexes for the OLAP databases.
• Cloned databases using RMAN Utility.
• Installation and configuration of Goldengate.
• Replication of data using Oracle Goldengate.
• Worked on some stages in Exadata performing Smart scan, Storage Index, DBFS mount points and Flash cache
• Focusing on Exadata administration.
• Applied Interim patches & Critical patches in both 10g & 11g.
• Looking into day-to-day activities of Production database, Monitoring its growth and performance.
• Creation of users and granting them their roles and privileges.
• Configuration of Listener and TNS names using NETCA and NETMGR.
• Daily incremental backups and weekly cumulative backups using RMAN.
• Done exports and imports of tables, schemas and tablespaces with datapump.
• Archive weekly all production database exports to Tapes.
• Developed and enforced both database and OS-level security policies for data protection.
• Monitored all the databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Installed and configured OEM 12c and monitored databases from OEM 10g/12c.
• Post installation process, kernel upgrade, applying support packs and add-ons.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Efficiently used Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, AWR, ADDM, STATSPACK, Data Pump, FLASHBACK and RMAN.
• SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on daily basis.
• Developed Scripts for transferring data from production server to testing/development servers.
• Cloning of databases using RMAN and also user managed.
• Management of databases on multiple servers.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.
• Managing and providing 24X7 supports for various versions of databases.
• Performed on-call technical support to minimize the impact of system disruptions.

Environment: Oracle 10g,11g,Linux 6.3, Oracle Enterprise Manager, Grid Control, HP-UX, AIX, Windows 2003, OEM Database control, PL/SQL, Oracle SQL Developer, Shell Scripting, TOAD, ASM, Golden Gate, Data Guard.

Confidential, Omaha, Nebraska

SR. Oracle DBA

Responsibilities:

• Installed, configured and maintained databases on high availability systems like Data Guard and Real Application Cluster environments performed fresh installation of 11.2.0.3 RAC on Automatic storage Management and created databases in RAC environment
• Installed OEM repository database, 12c agents on hosts and discovered targets and created new Groups, Templates, Incident Rule sets in OEM 12c
• Configured Physical standby, Snapshot Standby and Active data-guard and performed Troubleshooting data guard environment
• Up-gradation / MIGRATION of dev/test/prod databases from 10g to 11g
• Migrated applications from Unix to Linux using golden gate with minimum down time and resolved issues in golden-gate
• Applied patch set and interim patches whenever required to make the database software up to date
• Involved in measuring smart scan, storage index and measuring offload statistics for individual SQL Cursors on Exadata
• Implemented Hybrid columnar compression in Exadata
• Focusing on Exadata administration used Flashback mechanism for logical corruption of databases
• Installed and Implemented Backup & Recovery procedures, Implement Hot, Cold and Logical backup plans
• Performed tasks like Database Sizing, Table space Management and Rollback Tablespace Management, Transaction Management and Security Administration cloned databases for development and test environments using RMAN
• Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS Net-backup Team
• Creation of Users and granting them the required Roles and Privileges accordingly and Involvement in space management, rectification of lock problems, managed quotas
• Managed Oracle space, performed Oracle table space management tasks, maintained tables, database objects and Rebuilding indexes for better performance of Oracle database.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning
• Used oracle tools like AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for the Better database performance
• Extensive Performance Tuning, Memory (SGA) Tuning, RAID, RAW Devices
• Involved in Writing SQL scripts to monitor table space and extent growth
• Familiar with ORA-600 error & Involved with this ERROR
• Provided support to Application Database Administrators in designing the database
• Tested many scenarios in RAC, Dataguard and RMAN environment prepared documentation for maintenance, knowledge transfer and Mentoring level 2 DBA's
• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues

Environment: Oracle 10g/11gR2, Sun Solaris 5.9, RHEL 5.x, OEL 6.3, OEM 11g/12C, EXADATA, RAC 10g/11g, ASM, Data guard 10g/11g, Data pumps, RMAN, TDE, AWR, ADDM, ASH, TTS.

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 11g databases
• Estimated growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Performed up-gradation of grid infrastructure from 11.2.0.2 to 11.2.0.3
• Performed health checks of RAC instances using Crsctl and Srvctl utility
• Worked on X3-2 machine (half RAC)
• Monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 11g/12C
• Configured pfile, Listener and Net service names manually for production and physical standby databases in Data-guard environment
• Migrated databases from File system to ASM & troubleshooting issues in ASM 11g
• Installed Golden Gate for replication between cross platforms
• Configured parameters files for extracts, replicat's
• Applied patches on standalone servers using Opatch utility
• Performed Migration of databases from 10g Unix to 11g on Linux
• Implemented data transfer using Data Pumps and Export/Import utilities
• Registered databases in catalog server and Performed Cloning of databases using RMAN from production to test and dev environment
• Involved in scheduling incremental, cumulative and full backups and configured retention policy using RMAN
• Configured listener for external procedure calls, Worked closely with ETL applications team
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas configured network components like TNSNAMES, Names Server, Connection Manager, for easy and effective management of Oracle networking
• Extensively used AWR, ADDM and EXPLAIN PLAN for Generating reports
• Develop and enforce both database and OS-level security policies for data protection.
• Involved in Setup the Oracle Wallet for Encryption Functions and Expertise in protecting the Oracle wallet with ACFS access controls
• Created Tables That Contain Encrypted Columns and Oracle Wallet Management for Transparent Data Encryption
• Involved in administration of all databases in the areas of maintenance, tuning, performance, and troubleshooting and debugging SQL/PL SQL involved in Application development
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN
• Involved in writing for shell scripts for monitoring health checks and also for taking RMAN backups and Developed Scripts for transferring data from production server to testing/development servers

Environment: Oracle 10g, 11gR1,11gR2 AIX 6.1, HP-Unix 7i, OEM, DBUA, RMAN, People-soft, Golden gate, Grid, RAC, ASM, Data guard, SQL*LOADER, AWR, ADDM, ASH, TTS, Oracle Wallet, TDE, Data pumps

Confidential, Long Beach, CA

Oracle DBA

Responsibilities:

• Responsible for setup and implementation of 2 NODE RAC on 10g.
• Added a new node for 2 Node RAC for minimizing the downtime, maximizing availability and also achieved load balancing by minimizing the interconnect traffic
• Used CRSCTL and SRVCTL commands for the stop / start Cluster operations.
• Worked on database Sizes >= 3TB
• Responsible for capacity planning, database security, recovery planning and installing patches
• Involved in UP-GRADATION of databases from 10.2.0.2 to 10.2.0.4 on Sun Solaris
• Installed 10.2.0.4 agent and involved in registering of databases in OEM
• Installed STANDALONE servers on ASM and migrated databases to ASM
• Worked extensively on monitoring 10g grid control database, configuration of error notifications, installing listeners, and adding them to the grid control
• Collected ADDM recommendations using OEM 10g/11g to tune the TOP running SQL Query's
• Implemented Disaster Recovery Plan for critical databases using DATAGUARD
• Worked on physical and snapshot standby 11gR1 databases in Data-guard environment
• Involved in construction of Disaster Recovery (DR) for all the production databases using DATAGUARD
• Performed Database Refresh from production to testing and development environment and used EXPDP for schema level
• Worked closely with PL/SQL developers for fine performance tuning
• Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF
• Experienced in scheduling the database backup jobs using Crontab
• Created a Clone database using RMAN on remote server
• Involved in database design and used Erwin as a Data Modeling tool & Designing the ETL processes
• Involvement in space management, rectification of lock problems, managed quotas
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Created and monitored database objects like Tables, Indexes, Views, Users and DB links
• Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 11g/10g, Windows 2008, Sun Solaris 5.x, Oracle RAC, TOAD, VERITAS, OEM, LOGMINER, Informatica, DB Links, SQL, PL/SQL, TKPROF, EXPLAIN PLAN.

Confidential

Oracle Developer/DBA

Responsibilities:

• Involved in Up-gradation of databases from 9i to 10g
• Configured listener and TNS names manually
• Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.
• Achieved High availability, Data protection and maximum performance by maintaining physical standby databases
• Implemented Oracle database backup & recovery solutions using RMAN
• Configured and Tuned RMAN for better performance and backup strategies
• Involved in writing for shell scripts for taking RMAN backups
• Worked extensively on performance tuning of queries by maintaining Aggregates, Compression, partition, indexing and use of statistics
• Restored and Recovered database at the times of occurrence of critical failures.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing
• Performed large batch jobs and tuning of SQL queries and database systems
• Monitored Oracle Instances, Users, Tables, Table-spaces, Memory structures, and Rollback segments, Redo-logs, Archived Redo-logs and Alerts
• Performed automated backups and scheduling using scripting
• Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved in gathering requirements from end users
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference

Environment: Oracle /10g/9i, Sun Solaris 5.x, HP-UX 7.x, OEM 10g, Shell Scripting, TOAD, putty, STATSPACK,EXPLAIN PLAN.