PROFESSIONAL SUMMARY:

• Oracle DBA with around 8 years of professional experience in large - scale production environments across multiple platforms.
• Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery.Hands-on experience withOracleReal Application Clusters (RAC), 10g/11g/12c, Golden gate and Data Guard.
• Experience as anOracle DBAin various domains to deliver new products, upgrades withOracle 12c/11g/10g/9ion Sun Solaris, Red Hat Linux, SUSE, HP-UX, IBM-AIXandWindows platforms.
• Experienced in Installation of high availabilityRACenvironment(2, 3 and 4 node clusters)and upgradedstandalone databases to10g/11g/12c RACenvironment.
• Experience with data migration from physical server to virtual machines.
• Familiar with fitting up virtual machines for oracle 12c/11g/10g installations.
• Experience inReal Application Clusters (RAC)setup, configuration, and cluster interconnection withAutomatic Storage Management (ASM), configured user log on load balancing and failover onRACdatabase for high availability.
• Experience in upgrading databases (10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1).
• Planned and implementedDR & high availability solutionsusingOEL 10g Standby DatabaseusingOracle Data Guard,11g and 10g RAC.
• Experience in building Standby databases. ImplementingFSFO(Fast start failover) on databases and configuringdisaster recovery siteusingDataguard. Also proficient with new 11g features such asActive DataguardandSnapshot standby database.
• ImplementedGoldenGatefor Standby Configuration and developed procedures for Replication.
• Performed data replication, transformation and delivery of database transaction usingGoldenGatereplication tool.
• Implemented Active-Active Oracle Streams Replication for 99.99% database high availability over WAN.
• Worked with Golden Gate Active-Active (Bidirectional) Replication.
• Proficiency with Installation and maintenance of replication toolGoldenGateby creating extract process, extract pump, and replicate.
• ImplementedGoldenGatefor data recovery and data migration forOracle 11gR1 RACmulti nodes onIBM AIXand debuggingGoldenGateissues such as extract, replicate rebuild and abend.
• Proficiency with creatingGoldenGateextracts process, extract pump, fan out pump, and replicate.
• Laid hands on new tools and experienced features likeData Replay, Log MinerandFlashback data Archive, Schema Management, Data guard and RMANin Oracle 11g.
• Experienced in using11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid monitoring, and Recycle Bin.
• Experience in using OEM, TOAD, and Data Migrations using export/import, ATG, benchmarking using Load testing tools.
• Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
• Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, contention Resolution and Defrag scenarios across diverse environments.
• Extensive knowledge in Database Cloning usingRMAN, VERITAS, Net Backup, IBM Tivoli Storage Manager (TSM).
• Strong experience inHot/Cold BackupsandPoint-in-time Recoveryproceduresusing RMAN.
• Proficient in administration activities likeInstallation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.
• Experience inbasicandadvanced replicationusingOracle Streamsand experience in usingOEM, TOAD, data Migrationsusingexport/import, benchmarkingusingload testing tools.
• Hands on experiencein SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
• DeliveredSQLand Database performance tuning services viaV$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM) Grid control, analyzed SQL trace dumps for9i/10g/11g.
• Extensive experience onOEM, TOAD(Tools for Oracle Application Developers),SQL*PlusandSQL*Loaderas well as traditional UNIX command that requires for Oracle DBA.
• Worked on POC on OEM 12c Cloud, installed in all our non - prod databases, have good knowledge on 12c.
• Worked on building and rolling out new 12c databases for test/dev./qa environments.
• Documented all Oracle 12c installation/upgradation work and derived KT to all team peers
• Experience inData Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM.
• Engineeringof the existing databases and provide both a Physical and Logical/Physical data model to maintain an existing Database.
• Experienced with installing, configuring and administeringSQL server 2000/2005/2008 databasesincluding migration fromMS SQL server to oracle.
• Good experience inMSSQL server 2000/2005/2008 , T-SQL with knowledge ofServer Clustering, SQL Profiler, Execution plan,LogShipping,andDatabase Mirroring.
• Experienced in day-to-day DBA activitiesincluding schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs,UNIX Shell Scripting.
• UsedCronjobs to automate many DBA tasks.
• Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.
• Transferring compressed files onFTP servers, onUNIXplatform.
• Participated in24x7on-call rotation, off-hour production problem resolution activities.
• A self-motivated, responsible and reliable team player with a set of strong technical skills.
• Excellent analytical, interpersonal and communication skills.
• Eagerness towards learning new technologies.

TECHNICAL SKILLS:

RDBMS: Oracle 9i/10g/11g/12c, Oracle 10g/11g RAC, Performance Tuning, Backup and Recovery using Cold, Hot and RMAN and Other Utilities

Operating Systems: HP: UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Red Hat Linux 2.1, 3.x, 4.x, MS SQL Server 2000 & 2005, Windows 98/ME/NT/2000/XP

Languages: C, C++, Java, VB, PHP, XSLT, XML, SQL, PL/SQL, UNIX Shell Scripting

Oracle Tools and Utilities: RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, Golden Gate, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Oracle Virtualization, Migrations.

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

EXPERIENCE:

Confidential, Ann Arbor, MI

Sr. Oracle DBA

Responsibilities:

• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)&11g Release 2(11.2.0.2,11.2.0.3) upgrades on all the environments (in a procedural approach Dev., Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Setup Oracle VM 2.2 and 3.0 environments for Development and Production. Installed Oracle VM manager, setup and configured all VM Server hosts and VM Server guests.
• Managed VM's using VM Manager and OEM Grid 12c. Production was initialized using OEM 12c Virtual Pack.
• Setup management of Virtual Environment with OEM Grid 12c. Upgrade 2.2 to Oracle VM 3.3 configured all Monitoring via Grid Control and VM Manager.
• Experience with data migration from physical server to virtual machines.
• Supported Oracle 11g databases for Sap and PeopleSoft applications.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.
• Experience in Oracle OEM Grid Control 12c.
• Experienced in installing and setting up Oracle12c, 11g R1/R2, 10g, 9i databases.
• Worked on POC on OEM 12c Cloud, installed in all our non - prod databases, have good knowledge on 12c.
• Experience in Oracle RAC 11.2.0.3, built and supported 45 RAC Databases with 2-node Cluster for MCA Applications.
• Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafiles testing.
• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Setup and Configured 11.2.1.0 GoldenGate replication on Exadata V2.
• Oracle Golden Gate 11g replication (implement & manage active/passive & active/active)
• Setup Active-Active (bi-directional) replication using Golden gate with conflict resolution.
• Softwareand firmware maintenance of the Exadata storage servers in the Database machine including upgrades and patching.
• Softwareand firmware maintenance of the InfiniBand switches in the Database machine including upgrades and patching.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Upgraded oracle database on Exadata V2 cluster using oracle export/import utility.
• Experience with Replication concepts and used Golden Gate Software to do the replication.
• Implemented backup policy using oracle RMAN.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose
• Was involved in developing a disaster recovery (DR) plan.
• Performed Switchover and failover using both OEM and Dataguard broker.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Performed RMAN backups including Full, and level 0and level 1 Incremental Backups as required.
• Expert scripting experience in Perl and all UNIX shell scripting variations.
• Experience on Storage migration from SSD to ZFS appliance.
• Reading Alert Logs and User trace Files and Diagnosing the Problem.
• Created Physical Standby Database for Active Production Databases.
• Managed Golden Gate Databases and worked with application team/Development Team in Troubleshooting Issues.
• Reading Alert Logs, GGS Error Logs and User trace Files and Diagnosing the Problem

Environment: Oracle 12c, 11g, 10g, RAC, OLTP, EMC Storage, Oracle Golden Gate, LINUX - Redhat, UNIX - AIX, Grid Control, Oracle Virtualization, AWR, Spotlight, TOAD, SQLT and SQL Backtrack. Import/Export,Datapump, Oracle dataguard.

Confidential, Dallas, TX

Sr. Oracle DBA

Responsibilities:

• Involved in the installation, configuration and support ofOracle 11g R2databases.
• Supported production and 300 plus development and testing databases with database ranging from 2TB to 16TB.
• Installed Oracle VM Manager 2.2 and 3.0.2, installed VM Servers, configured networking and SAN Storage, setup multi-pathing.
• Installed HA availability with Server Pools to enable failover and live migration.
• Setup Oracle OEM Grid 11g to monitor and provision VM servers. Setup backup and recovery and all performance tuning. Upgraded VM 2.2 to 3.0
• Experienced in utilizingGolden gate replicationtechnology for ORACLE Upgrades.
• Installed Oracle 10g onProduction DB Servers, applied Opatch to fix the known bugs.
• Involved in assessing client’sData Warehousing requirements, system analysis, and simulation of events using aDecision support system.
• Involved in System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System
• Demonstrated experience in managing Oracle9i and 10g RACenvironments using theOEM Grid Control tools.
• Actively participated in installing of11g RACon Linux environment with two nodes andASMas storage.
• Upgrade and Migration of Databases from10g R2 to 11g R1and applying patches as per requirement.
• Worked withGolden Gateto move large volumes of data between oracle servers.
• InstallingASMenvironment and migrating database from NON-ASM to ASM
• Performed advanced replications using Oracle Streams
• Worked on Distributed Database Configuration, Creation of Database links and Snapshots usedStreamsfor 2 wayreplicationof data.
• Extensive experience inGoldenGateinstallation/setup/administration/troubleshooting and tuning.
• UsedGoldenGatein moving large amounts of transactional data with minimal impact to online systems and performingGoldenGateon process of extract and replication of single instance as well asRAC Databases
• ImplementedGolden Gatefor data recovery and data migration for Oracle 11gR1 RAC 2 nodes on IBM AIX and debuggingGolden Gateissues such as extract or replicate rebuild and abend.
• Performed documentation forClusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g Standby Documentation.
• Highly experienced in usingSTATSPACK, AWRreports to check health of database & hardware.
• Good Intensive Knowledge in using operating system command line utilities likeSAR, TOP, MPSTAT, VMSTAT
• Proficiency in using tools suchas TKPROF; EXPLAIN PLAN, ORADEBUGandTRACE FILEto tune SQL Queries.
• Performed databaseCloningusing hot backup and cold backup to setup test and development database.
• Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)
• Monitoring and optimizing system performance using index tuning, disk optimization, advanced database techniques, and other methods, including the use of automated tools.
• Created Parameters and Environment variables to run the same job for different schemas
• Experienced with all kinds(Status, Performance, Trend Analysis) ofDB MONITORING
• Experienced withSRVCTLfor monitoring and configuring RAC Environment.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Designed and Generated shell scripts to automate the processes and to proactively monitor the database.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Appliedcritical patch updates (CPU)released by oracle quarterly.
• Experienced withDATA GUARDimplementation and Point in time Recovery.
• Implemented oracle high availability solution usingoracle 10g PHYSICAL STANDBY.
• Importing data from flat files into database using SQL loader and External Tables.
• Designing and implementation of database backup/restore methodologies,troubleshooting performanceandnetworking issues. General OS administration.
• Developed scripts for startup/shutdown, Disk Monitoring health check of databases and scheduling of backups.
• Installing 12c grid and monitoring PROD databases/applications.
• Provide support in the daily administration of SOX monitoring tools deployed within the client Oracle Applications environment.
• Provide after-hours support during critical activities such as month end closing/opening procedures.
• Was involved in developing a disaster recovery (DR) plan.

Environment: Oracle 11g,10g, RAC, OLTP, EMC Storage, Windows 2000, Oracle Golden Gate LINUX - Redhat, UNIX - AIX, Grid Control, AWR, Oracle Virtualization, Spotlight, TOAD, OSW, SQLT and SQL Backtrack. Import/Export, Datapump, Oracle dataguard.

Confidential, Jersey city, NJ

Sr. Oracle DBA

Responsibilities:

• 24x7Oracle Production Database Administration including Oracle10g/11gRAC.
• Installed, configuredand maintained Oracle Databases.
• Installed and configuredOEM GridControl to monitor all databases.
• Establishing standards, policies and procedures forGoldenGatereplication administration.
• Responsible for installing and configuringGoldenGate 9.5 on Oracle Servers
• Managing, troubleshootingand resolving oracle database, RACand applications issues.
• Involved inUpgrade/Migrationof the oracle databases from Oracle10g to Oracle 11g and Sun Solaris to OEL (Oracle Enterprise Linux).
• Implementation of High Availability solutions withOracle 10g RAC,Physical and Logical StandbyDatabases(Data Guard)andReplication using Golden Gate.
• Developed back-end logic for business applications, e.g.Views, procedures, functions, packages, triggers.
• Developedscripts and reportsusing SQL, PL/SQL andPerl.
• Designed and implemented OracleReal Application Clusters (RAC)on Solaris withEMC Storagefor anOLTP applicationwithTransaction Application Failoverandhigh transaction volume.
• Established best practices and best procedures for database administration. Responsible for Software life-cycle support to includemigrationof all custom application changes through four different instances to production.
• Standby Database (Data Guard)setup and configuringDB links.
• Developed 2 node RAC environments for a 1TB database and Implementing Data guard on this RAC environment with another RAC Standby Database.
• Monitored/managed2 node RACenvironments, databases usingOEMGridcontrol, and RMAN database backup and recovery.
• Migrated databases using cross platform transportable tablespace feature and RMAN convert functionality to perform database conversion.
• Worked on agent related issues inOEM.
• Working alongside programmers and contributing to the development process; Enabling and analyzingtrace files
• Defining and Settingbackup and recoveryprocedures.
• Performed and tuned using AWR,OEMGridand tkprofOracleDatabases.
• Tuningthe database usingstatspackand custom scripts.
• Responsible for continuous database monitoring and reorganization for ensuring performance
• Tuningand balancing I/O by monitoring file system and tablespace I/O statistics.
• Experienced inTuning SQLstatements usingExplain Plan, SQL Trace, TKPROF and STATSPACK
• WritingShell Scriptsfor managing day-to-day activities andautomation of backup.
• Optimal Space utilizationin tablespace by avoidingfragmentation.
• Usage ofPartitionsto improve the queryperformance and manageability.
• Installation ofOracle RDBMSserver software andversion upgrades.
• Backup of Database(Making Backup Schedules depending upon Business Strategy: DailyBackup, weeklyBackupetc.)
• SQL and PL/SQL Programming.
• Installation and configurationof Oracle Client software and Tools.
• Analyzed the user requirements anddesigned partitioned tablesfor improving performance of Data marts.
• Analyzed the user requirements andDesigned views using STAR schemafor improving performance of Data marts.
• Performedpartition maintenanceand automated the process ofcreating new partitionsas and when required.
• Automated the process of analyzing table spaces every night.

Environment: ORACLE, SQL*Plus, OEL 10g/11g, Red Hat Linux 4.x, RAC, Solaris 10, IBM AIX 5.3,Data Guard, Golden Gate, ASM, PL/SQL, RMAN, Toad, OEM GRID, EMC, NetApp.

Confidential

Oracle DBA

Responsibilities:

• Supported 24x7 Oracle Production Databases of RDBMS10g/11g on SAN with different RAID levels.
• Installed and configuredOEM GridControl and centralized the monitoring for all databases.
• Managing, troubleshooting and resolving oracledatabaseissues.
• Refresh/Cloning of Database for development and testing purpose.
• Setup and configure MSSQL Server2005 for other business functions.
• Performed Oracle Database upgrades from10g R1 to 11g R1.
• Involved inUpgrade/Migrationof the oracle databases.
• MigratedDatabasefrom Oracle10g to 11g R1 RAC to achieve high availability of production database.
• Standby Database(Data Guard) setup and configuration.
• Working with programmers at early design stage to choose right data model relationships, creating required indexes and materialized views.
• Developed back-end logic for business applications, e.g.views, procedures/functions, triggers.
• Coded and implementedPL/SQL packagesto perform ApplicationSecurity and batch job scheduling.
• Performing monitoring and performance tuning
• PerformedOracle Streamsreplication monitoring and tuning.
• Implementation of High Availability solutions withOracle 11g RAC,Physical and Logical StandbyDatabases(Data Guard)andReplication using Oracle Streams.
• Played active role inmigrating database servers from Solaris 11.5.8 to 11.5.10 version.
• Defining and Setting backup and recovery procedures.
• Enabling and analyzingtrace files for any errors occurred while database runtime.
• Performing monitoring and performancetuning using different tools like AWR, SQL trace, TKPROF, Explain plan.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Made use of the REF CURSORS in stored procedures for report generation.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Expertise in Tuning SQL statements usingExplain Plan, SQL Trace, TKPROF and OEM.
• WritingShell Scriptsfor managingday-to-day activitiesandautomation of backup.
• Optimal Space utilization in tablespace by avoiding fragmentation
• Usage ofPartitions to improve the query performance and manageability.
• Installation of Oracle RDBMS server software and version upgrades.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files).
• SQL and PL/SQL Programming
• Installation and configuration of Oracle Client software and Tools.
• Data migration from legacy systems to Oracle Database for large Data warehouse with Multiple Data marts.

Environment: Oracle /10g/11g, PL/SQL, Oracle 11g RAC, Solaris, HP-UX,IBM AIX,EMC, Red hat Linux, NetApp, Streams, MS SQL Server 2005.

Confidential

Oracle DBA

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Developed PL/SQL packages to capture end of day transactions.
• Implemented UTL HTTP oracle built in package to acquire data from external websites.
• Preparation of design specifications document.
• Involved in designing the database, identification of the objects and creating tables.
• Designed and created database objects such as Tables, Views and Indexes.
• Tested and corrected errors and refined changes to data base.
• Implementing Database Security, Management of role-based security.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Wrote scripts for Loading Data using SQL*Loader and Import/Export Assisting the developers in tuning the SQL for optimized performance.
• Handling day to day activities along with schema and space management.
• Creating primary database storage structures (tablespaces, datafiles, tables, indexesetc)
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Cloning databases using scripts as well as HOTBACKUP.
• Extensively used Explicit Cursors in stored procedures.
• Established database backup/recovery strategy for different databases.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.

Environment: Oracle 8i/9i OEM, Linux, HP-UX, TOAD, Database Tools/Utilities, STATSPACK, TKPROF, UTL SMTP, SQL*LOADER, Cronjob Oracle forms.