SUMMARY

• Over 9+ years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software /11g/10g/9i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c with experience in very large scale database environment and mission critical large OLTP and OLAP systems
• RAC Installation and Maintenance, setting up and configuring Dataguard, performing all kinds of Backups and Recoveries, Cloning databases.
• Hands on experience in Oracle 10g and 11g RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup, adding a node to this cluster database for High Availability and Recovery.
• Migrated Single Instance databases to RAC Environment.
• Extensive experience in Dataguard Configuration, Implementing and Maintaining Standby Databases.
• Sound knowledge of database patching (PSU, CPU, bugfix, Rolling patching) methods in RAC and non RAC DB’s.
• Good experience in UPGRADATION from 10.2.0.x to 11.2.0.x & 11.2.0.x to 12.1.0.x
• Installed and configured Golden Gate in a prod and non-prod env, configured extract, data pump and replicate.
• Standby/Failover Administration. Creating standby database, data guard and performing DR simulation.
• Have good knowledge about Physical and Logical structure of a database.
• Configured and Maintained RMAN Catalog Database and schemas and involved in registering the Databases to RMAN Catalog.
• Experience in Performance Tuning, Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-TRACE, TKPROF, ADDM and Explain Plan Methods.
• Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Experience in Database migration using tools like DATA PUMP, Export/Import and Transportable Tablespaces and RMAN Duplication.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network Attached Storage (NAS).
• Experience in database cloning with RMAN, Database Refresh and Patch management.
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.
• Experienced in maintaining databases on large Production, Testing and DEV environments.
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• Proficient in working with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
• Excellent oral and written Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams
• Up-gradation and patching of oracle home for SAP DB’s.
• Accountable for Database Servers Administration including DB binaries installation, post installation and troubleshooting. Supporting more than 200 Database’s, as primary DBA, including both Production and Development ranging from 500 GB to 50TB.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery.
• Cloning and refresh of Oracle Database.
• Knowledge onOracleSupport Process for Technical requests using Metalink and other support procedures.
• Good work exposure on Remedy/Innotas, a ticketing tool for Incident / Request / Change Tickets.

TECHNICAL SKILLS

Databases: Oracle 11g R1 and R2, Oracle 10g and Oracle 9i

Administration Tools: RMAN, Export/Import, Datapump, OEM, TOAD, SQL*LoaderSTATSPACK, TKPROF, SQL*PLUS, AWR, ADDH, ASH, Shell Scripting, Crontab utility tool

Languages: PL/SQL, SQL, Java, C

Web Tools: XML, HTML, TCP/IP

Operating System: Oracle Enterprise Linux (OEL), RHEL, Unix, Sun Solaris & Windows

Technologies: RAC - Real Application Clusters, ASM - Automatic Storage Monitoring, Dataguard, DG Broker, RMAN

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential, Dallas, TX

Responsibilities:

• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Managing Data Guard, Replication, Backup and Recovery support and performance tuning etc.
• Applying Quarterly patches and Version change patch bundles.
• Building Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.
• Worked on Disaster Recovery by converting physical standby databases to Snapshot standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
• Also tested disaster recovery with database failover and switchover also tested Golden gate (OGG) replication using DBFS Filesystem and ACFS for GG binaries.
• Responsible for setting up and maintaining the user accounts and providing required privileges for database access.
• Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Datapump and Normal ) for restoring the specific objects Confidential the database level.
• Responsible for installation of Oracle Clusterware (CRS) also referred as Grid Infrastructure from 11g, and 12c Oracle Re-start (standalone grid Infrastructure) and creating the RAC and Standalone databases.
• Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4). As part of performance improvement by utilizing the new features.
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Cloned and refreshed development and staging databases from production for development and testing.
• Providing the Go-live and Post - go live Support for the database performance related issues and ensure that all the work is documented for future reference.
• Determine time estimates and schedule for own work and resolve issues in timely manner.
• Providing assistance in activities such as knowledge sharing and knowledge transfer.

Oracle Database Administrator

Confidential, Sugarland, Texas

Responsibilities:

• Setup and supported forOracle9i/10g/11g HA solutions including RAC, Data Guard, installed and configured ofOracle9i/10g/11g Database & RAC (Real Application Clusters) on Red hat Linux 4.0 AS, AIX 6.0/5.3 & HP UNIX.
• Creation of database, Managing Tablespaces and Undo Management, user/role management
• Monitoring the Database growth and Tables growth and increase the table space size in production databases..
• Extensive experience in Cloning ofOracleApplication instances from production instances
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Experience on Recovery Manager (RMAN) scenarios for database backup, restore & recovery.
• Developing and Implementing Disaster Recovery (DR) using Data Guard Plan.
• Perform Logical Backups using Data pump, Exp/Imp
• Migration of databases from Non-ASM (filesystem also referred as Logical Volumes) to ASM i.e. Automatic Storage Management.
• Applied the Clusterware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for Bug resolution) using opatch.
• Implemented archive and Purge strategy for archiving the inactive data in the historical database and purging the archived data from the primary database as a part of performance improvisation using Goldengate and exp/imp using partitions.
• Part of a team that provides 7x24 supports for database related issues.

Oracle Database Administrator

Confidential

Responsibilities:

• Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control (OEM) OMS Installation.
• Migrated Non-ASM databases to ASM environment for high availability using RCONFIG.
• Worked on OEM 11g grid for monitoring the Listeners present in the oracle environment.
• Worked in troubleshooting RAC and implemented ASM features.
• Addition and removal of nodes to RAC.
• Applied necessary Patches during installation and also in up-gradation of databases.
• Applying Quarterly patches and Version change patch bundles.
• Well Experienced in taking Backups for a very huge 15-Tb Database.
• Daily backups using RMAN.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Having good experience in user management, Table space Management, Session Management, undo Management issues.
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and disaster recovery databases.
• Involved and Upgraded Analytical Databases from 10g to 11g.
• Handy in utilizing Data Pump tool for exporting and importing the data between databases.
• Used Data Pump for schema refresh and RMAN for database refresh and used RMAN for backing up databases.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Having good exposure in user management, Table space Management, Session Management, undo Management issues.
• Experienced in managing space issues in the Database Level for table space and Regular file system cleanup Confidential UNIX level.
• Generated AWR, ADDM and ASH reports for database issues
• Installed 12c agents on hosts and discovered targets.

Environment: Oracle 10g, 11gR1, 11gR2, Linux 5.5, RHEL, Sun Solaris, IBM AIX, DBUA, RMAN, RAC,ASM, Grid, Dataguard, Net-Backup, Team quest tool.

Oracle Database Administrator

Confidential

Responsibilities:

• Involved in Installation and customization of Databases (11g &10g).
• Cloning of databases from production to test environments.
• Periodic data refresh from production to testing environments, Re-organizing database structures.
• Involved in Schema management, Table space Management, User Creation.
• Involvement in space management, rectification of lock problems, managed quotas for tablespaces as per needed.
• Implemented Data-Guard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases Confidential the times of up-gradation and migration.
• Upgraded and applied patches as and when required. Database Refreshes from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules.
• Evaluated the hardware requirements before upgrading/migrating the database.
• Good experience with recovery managed backups i.e. RMAN
• Cloning of Databases using RMAN.
• Scheduling the databases backup using Crontab.
• Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
• Maintained and audited Application and data servers.
• Documented the complete project including all pre installation, post installation and database configuration steps.
• Manage users, privileges, profiles, and schemas.
• Experiences in using automatic monitoring and management processes like batch processing using Crontab for processes like import, export databases.
• Used analyze table, analyze indexes to tune queries and increase performance.

Environment: Toad, Oraclecle9i/10g/11g, Linux, AIX5.1, Hp-UX, Sun Solaris, SQL, Shell Scripting.