SUMMARY

• Senior Oracle Database Administrator with 8+ years of experience in administration, installation, configuration and upgrades ofOracle 12C, 11gR2, 10G, 9idatabases including applying patches under Linux, HP - Unix, IBM-AIX and Windows platforms.
• Experience includes managing Oracle9i, 10g, 11gR2 and 12c RAC and ASM environments using the OEM Grid Control. Experience includesOracleUtilities Data Guard, Flashback and RMAN.
• Good experience of setup & configuration, implementation of (Oracle11gR2 and 12c RAC two-node on Linux with ASM).
• Experienced in Installation of High availability RAC environment (2, 3 and 4 node clusters), upgraded standalone databases to RAC environment and adding a node to the cluster database for high availability.
• Set up Active Data Guard Configurations fororacledatabase for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Experienced in setting up/installation and configuration of release 11g,12c RAC with ASM and CRS.
• Proficient inOracleDatabase Administration activities such as Upgrades, Patches, TAR support and Performed Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation.
• Migrating and Upgrading the Databases between different environments and versions.
• Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases. Good knowledge in creating RMAN Duplicate Databases, Data Guard and FLASHBACK recovery features.
• Design, document, implement, and maintain all backup, recovery including disaster recovery. Procedures using RMAN Backup.
• Have strong pl/sql programming experience in creating Packages, Stored Procedures and Functions, Database Triggers.
• Experience in implementing Automatic Storage Management for simple storage interface.
• Experience in installing and configuring/Monitoring Enterprise Manager Grid Control. Strong knowledge and experience in usingOracleConfiguration and Provisioning Pack.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems. Performed complete multi-master replication with updateable Materialized views.
• Extensive experience in Data guard configuration, implementing and monitoring standby databases.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable table spaces.
• Good experience in applying PSU and Critical Patch Update (CPU Patches) using OPATCH Utility on Databases, Application Servers and Middle Tiers.
• Applied patches in rolling fashion using OPatch auto and Upgraded RAC Grid Infrastructure from 11.2.0.4 to 12.1.0.2 and documented the procedure for standard documentation.
• Worked in Data Warehouse environment, involved in activities like partitioning tables, Creating materialized views and reorganizing index’s.
• Table Partitioning, creating Index Organized tables, Creating Locally Managed Table spaces and Responsible in configuring and backing up database using hot backups, Cold backups and Logical backups. provided 24/7 on call support for mission critical databases.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/9i, Oracle 10g/11gR2 /12c Real Application Cluster (RAC), ASM, SQL SERVER 2005/2012/2008.

Operating Systems: HP-UX 10.x,11.x, Sun Solaris 9,10, AIX 5.1,5.2,6.1, Red Hat Linux 4.x,5.x, O.E.L 5.8, 6.4,6.7 and windows 2000/XP

Languages: SQL, PL/SQL, UNIX Shell Scripting

Oracle Tools and Utilities: Data Guard, GoldenGate, Logdump, Defgen, Veridata, RMAN, OEM, Tuning Advisors, TOAD, SQL*Loader, Export/Import, Data pump, Net Backup

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

Web Technology: BMC Remedy, GIRA, Service Now, HP Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Brooklyn, NY

Sr. Oracle Database Administrator

Responsibilities:

• Installing and configuring Grid Infrastructure & Database software.(Troubleshooting & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, de-installation & cleanup of Cluster ware).
• Installation of 11.2.0.3 RAC (4 node) from the Scratch and the maintenance of the high available Databases.
• Worked on RAC and ASM, building and supporting 11GR2 / 12C RAC clusters using ASM storage.
• Applied patches on Oracle 11gR2/12c Cluster ware and RAC databases.
• Migrated OCR and VOTING disks to newer disks by adding newer disks from SAN and dropping the old disks by using ASM's native rebalancing feature.
• Set up ActiveDataguard Configurations fororacledatabase 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Setup physical standby's (DATAGUARD) for several Databases (via OEM as well).
• Created and monitored Physical standby databases on maximum protection, performancemode using Data guard for Disaster Recovery and performing production databases Maintenance.
• ImplementedPhysical and Logical StandbySetups Dataguard Configurations.
• ConfiguredOracledata-guard (ADG) forOracleDisaster recovery on standalone databases using11g ACTIVE DUPLICATION.
• Applied PSU quarterly on 11g/12c GRID & RDBMS homes and Up-gradation of 11g/12c databases
• Performed migration of theoracledatabases whose database sizes vary from 750 GB to 1.5TB from Oracle 11.2.0.3/11.2.0.4 toOracle12.1.0.2 using Expdp/Impdp.
• Performed cross platform migration with minimal downtime of databases from Solaris 11g to RHEL 6.7 12C using Golden Gate.
• Worked on Oracle Golden gate installation, configuration, troubleshooting Golden Gate Extract and Replicate files and used Defgen utility to create definition files in Golden gate.
• Documented and logged errors in GOLDENGATE environment and worked on OLTP Compression
• Extensively used Log dump utility and define utility for resolving issues in GoldenGate
• Extensively used data pump for migratingdata between platforms
• ConfigureOracleAdvanced Security to implement Transparent Data Encryption at table space, table and column levels and also configured Redaction using OEM's Policy expression builder.
• Monitoring and performance enhancement using sessionTracing, Stats pack and CPU utilization.
• Monitoring databases and setting alerts usingOracleGrid Control/Enterprise Manager.
• Planning, implementing and validating various versions ofOracleDatabases to 11gR2(11.2.0.4) & 12c 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 forOracle11g upgrades.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues helping to transform business requirements into environment specific databases.
• Setup the standby via OEM cloud control 12c for several databases.
• Closely Worked withOraclesupport in identifying some long standing issues. Also extensively used oracleMetal ink.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB.

Environment: Oracle/11g/12c, REDHAT Linux 5.6., AIX 5.,6., Unix 9.,OracleGrid Control RMAN, RAC, DATAGUARD, Golden gate, Data guard including DG Broker setup, OPATCH,OracleAdvanced Security, OEM 12c, SQL Developer

Confidential, Lee’s Summit, MO

Sr. Oracle Database Administrator

Responsibilities:

• Worked in Infrastructure team in designing Disaster recovery and worked with engineering team for building new servers, installation RDBMS, configuring DR databases and setting up brand new clusters etc.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports.
• Detected locks and resolving in-doubt transactions manually. TunedoracleSQL statement by tracing.
• ImplementedOraclePatches (CPU, PSU) on the Compliance databases and devised a plan to patch them quarterly so that we can cover all the databases in a year.
• Configure DR usingOracle11gR2,12C Data-guard & Standby databases
• Performed switchover for DR testing and maintenance, Monitoring, Administrating Primary & Stand-by databases using Data Guard. Resolving Gaps
• Worked on Snapshot standby and coordinated Application testing
• Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues.
• Designed various Backups/Recovery strategies forOracledatabases as per SLA requirements and Implemented backup policy usingoracleRMAN.
• Prepared test environments for backup/recovery using RMAN. And legato TAPE backup management.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Responsible for purging and archiving the production databases.
• Setup Automatic Storage Management to reduce I/O contention and support RAC databases.
• Patched/Upgraded 10g/11g/12c databases and upgraded databases DBUA/Manually.
• Involved in Capacity and Resource planning. Estimated the size of Data files and Redo log files based current transactions rate, time for recoveries etc.
• Configured users into consumer groups and set the resource utilization based upon business activity using RESOURCE MANAGER.
• Recovering Databases when there is any Physical or Logical Corruption.
• Created routines for Daily, Weekly & Monthly partitioning of tables.
• Created/Altered Partitioned tables for large customer related data.
• InstalledORACLEEnterprise Manager GRID CONTROL12c and configured it server targets for a centralized monitoring system and Monitoring database Performance
• Configured OEM 12c monitoring with customized templates and email alerts.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Monitored and maintained Security by managing Roles/Privileges for users of the databases.

Confidential

Oracle Database Administrator

Responsibilities:

• Design, document, implement, and maintain all backup, recovery including disaster recovery procedures.
• Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard, Replication.
• Configured Oracle data-guard (ADG) for Oracle Disaster recovery on standalone databases using11g Active Duplication. Setup backup procedures for various PRODUCTION databases based upon SLA.
• Created physical standby database (for disaster recovery) from hot backup of primary database.
• Resolved gaps between primary and standby databases (Gap Resolution).
• Responsible for purging and archiving the production databases.
• Creating Tables, indexes, & triggers to assist developers.
• Experienced in switching primary databasetostandby and standby to primary during regular maintenances of catalog databases and DR databases.
• Involved in 24x7OracleProduction Database Administration.
• Involved in installation, configuration and support ofOracle11g RAC.
• Detected locks and resolving in-doubt transactions manually. TunedoracleSQL statement by tracing.
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• Took Full/Incremental backups usingORACLERecovery Manager (RMAN).
• Applied various patches on regular basis tooraclesoftware homes.
• Refreshed PROD, DEV, UAT databases using Data pump, RMAN, Transportable Tablespaces etc.
• Developed Shell Scripts and SQL scripts to carry out routine checks on databases and perform various tasks on the database.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrade/Migration of theoracledatabases fromOracle9i toOracle10g.
• Performing Backup/Recovery of all theOracledatabases using RMAN.
• Applied necessary Patches during installation and also in up-gradation of databases onOracle11g database versions.
• Extensive Experience with Change Control Management for all database changes. Scripts for Health Check of Databases.
• Reading Alert Logs and User Trace Files and Diagnosing the Problem.

Environment: Oracle9i,10.2.0.2,11.1.0.7, Maestro 7.0, HP service desk, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3.

Confidential

Oracle Database Administrator

Responsibilities:

• Performed Installations ofOraclesoftware on various Windows and UNIX servers
• Designed and developed Web-enabledOracleForms & Reports. Including Forms based on stored procedures.
• Designed and implemented hot backups using a combination of incremental differential and full backups using RMAN and Hot/Cold.
• Implementation of RAC, ASM, DATAPUMP, FLASH BACK Recovery.
• Installed and configured 2 Node RAC on 10gR2 and Upgraded databases using Database Upgrade Assistance (DBUA).
• Creation of database links, estimating the size of Databases and Creating Databases.
• Supported differentOracle10g and 9i Databases of Production, Testing, Staging and Training.
• Performed Export and Import of databases from one database to another databases.
• Monitoring the performance of production database through Instance Monitor (Quest Tool) and growth of the database and suggesting for change in parameters if required.
• Involved in optimizing SQL statements using Indexes and Hints.
• Planning and scheduling for the backup of database information using Crontab jobs.
• Generated daily, weekly and monthly reports regarding total revenue management.
• Volume management using Verities Volume manager to configure Disk group.
• Controlling and monitoring user access to the database for new and existing databases.
• By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.

Environment: Oracle9i/10g, Sun Solaris, windows NT/2000/2003, RMAN, DBCA, Data guard,Oracle Enterprise.