SUMMARY

• 11+ years of experience Oracle, EXADATA, Gloden Gate & SQL database administration in heterogeneous system environment including Solaris, AIX, Confidential UX, Linux and Windows.
• Supported variety of mission critical production applications in Enterprise and Financial environment.
• Extensive Experience in Oracle Database administration of DATAGUARD & ADG 9i & 10g & 11g, 12c.
• Extensive Experience in RAC, EXADATA, ASM, DATAGUARD, Patching, Upgrades&Migrations.
• Extensive Experience in 11g, 12c, ASM Migration on mission critical databases.
• Extensive experience on Exadata and migration from Solaris, AIX to EXADATA.
• MonitoringExadatasystems using OEM 12c, SundiagandExachkutility
• Extensive Experience in SQL Database administration on 2000, 2005, 2008.
• Setting up PhysicalStandby&Logical Standby for the databases.
• Extensive experience in DataGuard switchover and failover test using flashback and snapshot standby.
• Extensive Experience in ORACLEFAILSAFE, implementation, configuration & administration.
• Experience in Implementing & Setup of ORACLEGRID CONTROL (OMS) &OEM. And Also Setup up Backup Jobs for Databases via OEM.
• Extensive experience with Oracle database administration of Oracle 10g, 11g & 12c RAC with multiple nodes covered all aspects of administration like installation, configuration, migration, replication, sizing and space management.
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN, cloning databases using RMAN Active database duplication.
• Skilled in developing RMAN scripts for database backup including hot and cold backup options for both RAC and standalone instances.
• Experience in Gloden Gate, Veridata, Gloden Gate Monitor on 11g
• Has setup backup and recovery with expertise in performance tuning and troubleshooting of database.
• Understand the challenges of Production Environment, combined with outstanding leadership ability, team player and creative problem solving skills in both strategic and tactical areas.
• Worked on Extensive Data Warehouse environments sizing around 15 - 50TB
• Expertise in Oracle 12c/11g/10g/9i/8i database administration in high availability 24*7 production environment
• 12c/11g/10g/9i DATAGUARD & Active DataGuard&PHYSICALSTANDBY & Gloden Gate implementation & maintenance.
• 12c/11g/10g/9i Real Application Clusters (RAC) installation and maintenance on UNIX and Windows
• Experience in setting up EXADATA X3-2, X2-2, X2-8, X4-2 environments and also Migration of databases to Exadata, Patching & all maintenance activities.
• Experience in building ODA’s, Migration, and Patching of ODA’s.
• Solid experience in Oracle Recovery Manager (RMAN)
• Configured DataGuard Broker and worked on gap resolution between Primary and Standby sites.
• Worked on setting the physical standby database on a 2 node RAC
• Experience in installing Oracle 12C Grid Control including monitoring/setup and performance tuning purposes.
• Expertise in RDBMS Tools like SQL Loader, Import/Export, Data Pump, RMAN, OEM Grid Control and TOAD
• Good experience in using TransportableTablespace, SQL Tuning Advisor, Data Pump, Flashback Table, Tablespace Management, Materialized Views, and Oracle Streams.
• Expertise in MS SQL database 2000, 2005 & 2008.
• Familiar with patching, configuration and implementing best practices
• Performance monitoring/tuning/troubleshooting on Oracle, UNIX, Linux, and Windows Excellentinterpersonal, analytical and problem-solving skills.
• Production Support is the main specialization.

TECHNICAL SKILLS

Operating System: UNIX (Solaris/ Confidential /AIX/Redhat), Sun Sparc servers / Confidential Enterprise Class Servers, VMware ESX Server, Windows

Databases: Oracle 10g, 11g, 12c Databases.

Dev. And Admin Tools: Oracle Enterprise Manager, PL/SQL, SQL*LOADER, TOAD, Veridata, RMAN

Languages: SQL*Plus, PL/SQL, UNIX Shell Scripting, HTML, XML.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Sr. Oracle / EXADATA DBA Database

Responsibilities:

• Installed Oracle 9i/10g/11g/12c DATAGUARD on PROD Environments & also RAC on a 2, 3& 4 node clusters on Redhat& Oracle Enterprise Linux - Prod Environment.
• Handled 12c upgrades, GRID, Database migrations & upgrades.
• Installed and configured Gloden Gate, Veridata, and Gloden Gate Monitor 12c.
• Configured, built, planned and installed EXADATA.
• AdministeringExadatastorage servers usingcellCLIanddCLI.
• Experience on Exadata Full rack/Half rack/Quarter rack
• Migrated databases to EXADATA’s (cross platform), Patching& Exadata maintenance activities
• Worked on X3-2, Quarter RACK Half RACK. X2-2 half RACK &X2-8 Full RACK
• Handled migrations from AIX to X4-2’s and also working on patching.
• Consolidated alerts and Reports - like tablespace, ONCALL &Backup reports for RMAN&SQL Server
• Erwin Diagrams, Creating Subject areas &Dev.scripts for implementation for Apps teams.
• Created and maintained Multiple ORACLE Instances / Databases for porting databases under various operating system platform (UNIX, Windows environment)
• Setup DataGuard on RAC having DR as RAC too.
• Worked on Migrations&Upgrades of 10g, 11g, 12c Databases - and on DataGuard too.
• Worked on OEM & GRID CONTROL 11gR2 - Scheduling Alerts setting up metrics, Scheduling RMAN Jobs VIA OEM.
• Migrated databases from File System to ASM and from Single Instance to RAC.
• Establishing and monitoring database RMAN backups and datapump export of schemas (hot/cold).
• Configured Physical standby database using Oracle 11gR2 Dataguard for high availability and disaster recovery solution.
• Worked on Data Warehouse systems of very large sizes.
• Worked on partitioning of tables.
• Worked on Stage and Prod Data Warehouse systems.
• Extensively used RMAN for Backups and Restores.
• Applied Oracle PSU's on regular Basis.
• Created ACFS File systems for Glodengate
• Configured Data Guard using OEM - POC.
• Served as an ONCALLDBA for all Production databases 24*7 STAR Support.
• Collaborated with UNIX Support, Web Group and Migrations Team to make sure all operating system and migrations issue are addressed in a timely fashion.
• Created various database objects and implementing referential integrity rules for complex databases
• Worked on Materialized Views and DW loads.
• Wrote ShellScripts&PL/SQL procedures for automation.
• Wrote up process & technical Documentation.

Confidential, Irving, TX

Sr. Oracle DBA

Responsibilities:

• Installed Oracle 9i/10g/11gDATAGUARD, PHYSICALSTANDBY on PROD Environments & also RAC on a two node & 3 node clusters on Redhat Enterprise Linux - Prod Environment.
• Created and maintained Multiple ORACLE Instances /Databases for porting databases under various operating system platform (UNIX, Windows environment)
• Handled Migrations&Upgrades of 10g & 11g Databases and DataGuard.
• Installed and Maintained environment including Creating Databases, Buffer pools, logical andPhysical design of database storages
• Scheduled alerts and set up metrics for OEM & GRID CONTROL 11gR2
• Served as Oracle DBA on large-scaleData Warehouse systems, including Stage and Prod Data Warehouse systems.
• Provided 24*7 Support for Production Databases as an on-call DBA.
• Ensured all operating system and migrations issues are appropriately addressed by working pro-actively with UNIX Support, Web Group and Migrations Teams.
• Created various database objects and implemented referential integrity rules for complex databases
• Handled Security Administration including: handling Instance / Database Level Authorities and Object Privileges; creating and maintaining users, user groups and schemas for porting applications as well as controlling database access.
• Supplied product support: Data reorganization, Backup & Recovery of VLDB (version and roll-forwardrecovery) and Managing Log files.
• Cloned entire database and refreshed production with new database name for testing and development purpose.
• Supplied performance monitoring / Tuning with Event, Snapshot Monitoring and troubleshooting database issues by enabling various Diagnose level settings.
• Performed tuning through SQL monitoring and working with application developers to gather information, explain data and advise on SQL tuning tips.
• Handled database loading, Migration and Maintaining data with SQL*LOADER, EXPORT, IMPORT and RMAN utilities.
• Developed some stored procedures, DB triggers in PL/SQL for customization works.
• Configured and handled fine tuning of Oracle configuration parameters for better response, throughputs and proper utilization of Global memory.
• Implemented ASM on RAC Systems and also on the single node instances.
• Establishing and monitoring database RMAN backups and datapump export of schemas (hot/cold).
• Configured Physical standby database using Oracle 11gR2 Dataguard for high availability and disaster recovery solution.
• Architected RAC Systems on RHEL Systems.
• Applied Oracle PSU's on regular Basis.
• Administered and monitored performance issues of RAC on Production systems.
• Completed database loading, migrating and maintaining data with LOAD, EXPORT, IMPORT and RMAN utilities.
• Performed Oracle RDBMS software installations.
• Created the database, tables, tablespace, data objects, setting privileges, indexes, user logins, and passwords.

Environment: Prod, Stage &Dev Environments, working on Oracle 9i, 10g, 11g working on technologies like ASM, RAC and Streams, DataGuard, Glodengate, OEM, Grid Control, Veridata Grid Control.

Confidential, Plano, TX

Lead Oracle DBA

Responsibilities:

• Installed Oracle 10gR2 with RAC on a two node clusters on Redhat Enterprise Linux.
• Created and maintained Multiple ORACLE Instances /Databases for porting databases under various operating system platform (UNIX, Windows environment)
• Installed and Maintained different environments including Creating Databases, Buffer pools, logical and Physical design of database storages
• Implemented referential integrity rules and created various database objects for complex databases
• Provided Security Administration: user / user group creation & maintenance for database access and handledInstance / Database Level Authorities and Object Privileges.
• Created database clones for testing and development and refreshed production with updated database name.
• Used Event, Snapshot Monitoring and enabled diagnose level settings to troubleshoot database issues for Performance Monitoring & Tuning.
• Collaborated with application developers in SQL turning efforts.
• Utilized SQL*LOADER, EXPORT, IMPORT and RMAN utilities for database loading, database migration and data maintenance.
• Created shell scripts &Cronjobs and collaborated with Unix Support, Web Group and Migrations Teams on OS and migration issues.
• Involved in writing stored procedures, DB triggers in PL/SQL.
• Improved response, throughputs and proper utilization of Global memory through configuring and fine-tuningOracle configuration parameters.
• Implemented ASM on single node instance and RAC Systems.
• Utilized LOAD, EXPORT, IMPORT and RMAN utilities for database loading, migration and data maintenance.
• Completed Oracle RDBMS software installations.
• Applied Oracle PSU's on regular Basis.
• Handled creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.
• Created and Implemented Oracle Apps 11i on the Test bed. Planned for Production implementation and capacity planning
• Created backup strategies, Maintenance plans, as well as handled job scheduling and user maintenance on MS SQL,
• Applied patches to Production and completed DB releases on MS SQL Databases.

Environment: s: Production and implementation of RAC on RHEL4, and Support for Prod Databases.

Confidential, New York

Oracle & MS SQL DBA

Responsibilities:

• Provided Production support for Oracle database 9i/10g/10g RAC and SQL server 2000
• Involved in the Process of enhancement of various CRM modules, remodeling the Database backup plans for all MS SQL Database production servers, and remote monitoring of the App and the DB Server onDaily basis.
• Wrote customized shell scripts to monitor the stats of performance issues.
• Created database triggers in PL/SQL for data security.
• Handled ASM implementations for RAC Systems and single node instances.
• Worked on DataModeling concepts and development of Oracle Databases.
• Installed and maintained environment including Database creation, Buffer pools, logical and Physical design of database storages and Creating and maintaining Multiple Oracle Instances / Databases for porting databases under various operating system platforms (UNIX, Windows environment).
• Worked with SQL*LOAD, EXPORT, IMPORT and RMAN utilities.
• Worked on Oracle Streams Replication.
• Applied Oracle PSU's on regular Basis.
• Completed DB releases on MS SQL Databases and applied patches to Production.
• Performed Data Analysis and Modeling on all databases.
• Monitored and Tuned Oracle Database for optimum performance using oracle provided utilities and tools (TKPROF and Explain Plan utilities)
• Completed implementation and Testing of 10gR2 RAC on test bed.
• Handled Database Security Procedures (Create and Maintain Users, profiles, Roles with System and Object level Privileges) and periodical evaluation of security model.
• Implemented backup and Crash Recovery Procedure using Oracle suggested Online/Offline and logical Methodologies.
• Handled work for MS SQL: creating backup strategies, maintenance plans, job scheduling and user maintenance.

Environment: s: Worked on Oracle 9i & 10g on prod & stage environments and also SQL 2000, OEM, Grid Control, SQL Developer, TOAD.