SUMMARY

• Over 5 years of experience as an Oracle Database Administrator having hands on experience in database installation, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Managed 11+ TB Oracle 10g & 11g databases in Data warehousing environment.
• 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, 10g Automatic Storage Management (ASM) required to fulfill teh storage needs.
• Installation and configuration of oracle Golden Gate.
• Experience in using Golden Gate to support data replication in teh Oracle database environment.
• Experience in applying PSU patch on standalone as well as RAC databases.
• Experience in Golden Gate upgrade from 10.4 to 11.2.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for teh 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 shell scripts for hot backups, SQL*Loader, export and import of database.
• Proficient wif Database Cloning, Migration, and Patching of Oracle Databases.
• Installed Oracle 11g wif ASM and OCFS2 File systems.
• Extensive Experience wif RMAN Backups, Hot Backups and Logical Backups.
• 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.
• Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN wif 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 noledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
• Knowledge in configuring ASM (Automatic Storage Management)
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• Worked wif EXP/IMP, EXPDP/IMPDP to refresh teh schemas and to
• Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
• Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone
• Experience in Upgrading databases, applying patches.
• Managing Security Management, Schema Management, Instance Management, Storage/Space Management.
• Checking and resolving Database corruptions using DBVERIFY utility. 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.

PROFESSIONAL EXPERIENCE

Oracle Database Administrator/ production support

Confidential, Bloomington, IL

Responsibilities:

• Applied Database (RDBMS) Patches that is PSU patches and one-off patches (for Bug resolution) using opatch.
• Upgraded 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) and 11g to 12c as part of performance improvement by utilizing teh new features. Also upgraded 11g (11.2.0.3) Databases to 12c (12.1.0.1).
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases wif teh Catalog.
• Worked on setting up of Goldengate 12c Integrated Capture on Exadata Servers for replication purposes from OLTP system to downstream systems. And on Non-EXADATA servers we used separate mining database Goldengate replication and on EXADATA source databases is used as mining database too.
• Installed Goldengate version 11 and version 12 wif latest patches applied on DBFS filesystem and ACFS filesystem, also working testing new OGG 12.2 new features available.
• Implemented Goldengate integrated replicat and co-ordinated replicat(available from OGG 12c) to improve teh performance of data replication to targets
• Troubleshoot and maintain ORACLE Dataguard environment where TBs of log shipping and apply happen every day.
• Troubleshoot Database Performance issues using OEM, AWR, ASH, TKPROF 10046 traces etc.
• Developed custom scripts and implemented standard procedures to troubleshoot Live Production issues by leveraging ORACLE ASH and AWR Data.
• Monitor Production Databases using various internal tools and custom scripts.
• Optimal Database parameter, Capacity Design for Heavy loaded High End OLTP systems.
• Database Capacity Management (Working wif Storage teams for ASM Disks) using automated scripts/processes and Reports.
• Experience managing Tablespaces, Data Files, Archive Logs, Redo Logs, and Standby Redo Logs and Logical Database Objects.
• Performing tuning of application using CBO, SqlTrace, Tkprof, Explain Plan, Statspack, AWR and ASH/ADDM.
• Proficient in writing UNIX Shell scripts to automate business process and daily backups.
• Involved in capacity and resource planning.
• Exposure to new 12c Features, Container and Pluggable Database, FAR-SYNC Instance, Cascade Redo Transport Destination, Allowed usage of SYNC and NOAFFIRM to extend Data Guard Range, Moving online Data file, etc.
• Perform failover failback testing.
• Applying upgrade patch, maintenance and interim (opatch) patches on all teh databases.
• Refreshing Dev and Test instances wif data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.
• Migration of database from one server to another server.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Sanitize behavior of SCAN.
• Troubleshooting ORACLE RAC issues using ORACLE cluster ware and Database logs.
• Follow up on SRs for different issues (SCAN behavior, Node eviction, Failover etc.)
• Implemented ASM on RAC and stand-alone databases.
• Managing disks and disk groups wif ASM.
• Done migration of non ASM database to ASM database.
• Responsible for configuring datagaurd physical standby database setup for high availability and handling synchronization issues between primary and standby.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Managing, Monitoring and optimizing teh performance of teh databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• Handling and debugging of high priority and sudden database service interruption issues like service interruption due to ORA-600 errors in teh dump and database hung due to ORA 7445 errors and restoring teh service to normal and providing efficient root cause analysis.
• Upgraded standalone and RAC databases from 11.2.0.3 to 12c on QA database for proof-of-concept
• Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Experience wif testing and pre-production and production of Oracle 10gR2 wif 2 node RAC on Red Hat Linux wif ASM
• Vast Experience wif RMAN to implement Backup/Recovery strategies and clear understanding of teh data structures and architecture provided by Oracle for Recovery in all kinds of Disasters.
• Capacity Planning for OLTP environment- Allocating system storage and planning future storage requirements for teh existing and new databases.
• Proactive performance monitoring by implementing UNIX scripts and automated jobs (Grid) for alerts.
• Refreshing databases and Migration of databases from various environments for Testing, Development work.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Sizing teh SGA, db buffers, shared SQL area, log buffer based on teh requirements.

Environment: Oracle 10g, 11g, 12C, Unix shell script, Grid Control, DataGuard, IBM AIX, Sun Solaris, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories, AWR and Statspack Reports, EXPDP/IMPDP, EXP/IMP, PL/SQL, RMAN, Crontab, Tivoli Storage Management for DB tape backups, BMC Patrol for DB monitoring.

Oracle Database Administrator

Confidential, Lake Success, NY

Responsibilities:

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all teh databases.
• Refreshing Dev and Test instances wif data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough noledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• RMAN point in time recovery and Instance recovery done on 11g.
• Developed compliance reports and performed auditing at higher levels.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Efficiently performed installation, setup and creation of four node cluster RAC wif Oracle 11.2.0.3 database using GRID infrastructure wif ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining teh best Cluster architecture, choosing teh best hardware configuration for Oracle RAC.
• 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
• Monitoring and optimizing teh performance of teh database/application using OEM along wif homespun scripts.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Creating OEM alerts that provides notifications through emails.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
• Worked on both VMS and UNIX environments.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Experience in writing UNIX/SHELL scripts for providing teh reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

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