SUMMARY:

• 7+ years of experience as a OracleDataBaseAdministration in implementing large - scale production environments across multiple heterogeneous system environment including UNIX, Linux, AIX, HP-UX and Windows.
• Experience as an Oracle DBA in various domains to deliver new products, upgrades with Oracle 12c/ 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, SUSE, HP-UX, IBM-AIX and Windows platforms
• Experience in Real Application Clusters (RAC) setup, configuration, and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.
• Planned and implemented DR& high availability solutions using OEL 10g Standby Database using Oracle Data Guard,12c, 11g and 10g RAC.
• Experience in building Standby databases, implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Dataguard. Also proficient with new 11g features such as Active, Dataguard and Snapshot standby database.
• Experienced in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid monitoring, and Recycle Bin.
• Strong experience in working with OracleAPEX to design and develop the applications.
• Extensive knowledge in Database Cloning using RMAN, VERITAS, Net Backup, IBM Tivoli Storage Manager (TSM).
• Proficient in administration activities like Installation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.
• Experience in basic and advanced replication using OracleStreams and experience in using OEM, TOAD, data Migrations using export/import, benchmarking using load testing tools.
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
• Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM)Grid control, analyzed SQL trace dumps.
• Experience in resolving the Severity 1, Severity 2, and Severity 3 according to the Service Level Agreements (SLA's).
• Experienced in day-to-day DBA activities including 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.

TECHNICAL SKILLS:

Web Services: Soap, Restful

Database: Oracle 12C,11gr2, Oracle 11gr1, Oracle 10gr2, Oracle 9i,8i, MYSQL, SQL Server 2008

ETL Tools: SQL Server Integration Services (SSIS), DTS

Oracle Products: Oracle Real Application Cluster 10g/11g/12C, OEM 12C, Golden Gate, Data Guard, Import & Export, Data Pumps, Data Masking, Oracle Wallet Management, Automatic Storage Management, Oracle 10g/11g/12c (Grid Control), Oracle Exadata, Oracle Fail Safe, RMAN, Transparent Data Encryption.

Oracle Tools: Toad, SQL Developer, PL/SQL Developer, SQL*PLUS, SQL Navigator

Reporting Tools: SQL Server Reporting Services (SSRS)

Languages: SQL, PL/SQL, Unix shells scripting, PostgreSQL 8.0+

Scripting: Microsoft Command Shell Scripting, UNIX Shell Scripting

SQL Server Tools: SQL Server Management Studio Toad, Business Intelligence Development Studio, SQL Profiler, Query Analyzer s Server Management Studio TOAD 10.6, SQL Developer, PL/SQL Developer, SQL*PLUS, SQL Navigator, BIDS

Operating Systems: Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.X, 5.X, 6.X, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008, AIX 5.X

PROFESSIONAL EXPERIENCE:

Confidential, Miami City, Florida

Sr. Oracle DBA

Responsibilities:

• Provided 24x7 on call DBA support for over 3500 Oracle 12c production, QA, DEV databases on RHEL, HP-UX, and Solaris.
• Involved in the installation, configuration of multi node -- 2, 3, 4 Node Oracle 10g/11g/12c RAC with ASM .
• Architect for the cross-platform database migration comprising of VLDB multi-terabyte databases from Sun Solaris, HP-UX to RHEL using Cross platform Transportable Tablespaces ( XTTS ).
• Migrated Oracle 10g/11g RAC and non-RAC Single instance databases with ASM using Transportable Tablespaces ( TTS ), Data pump.
• Upgraded production, Development databases from Oracle 9.2.0.8, 10.2.0.2, 10.2.0.4 to 11g/11g RAC .
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non- RAC servers for issues when upgrading, DR switchover testing.
• Setup, reconfigured and monitored single instance and multimode RAC to RAC Dataguard for DR .
• Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• Created new databases/ instances on 12c RAC and single instances using customized scripts, DBCA.
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
• Redesigned table and index partitioning strategies, using HINTS to improve the query performance.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.

Environment: Oracle 12c RAC, 11g, ASM, Toad, AWR, ADDM, ASH, SQL, Data Pump, TDE, Database design flow charts, ACL, OEM, RMAN, SQL*Loader, NETBACKUP, OLTP, Datacenter, SAN and NAS Migrations.

Confidential, Temecula, CA.

Oracle DBA

Responsibilities:

• Involved in configuring Exadata X5-2, X5-8 and having hands on the smart flash cache, storage index, storage management and migration.
• Worked on ExadataDatabaseMachine X2-2 Half Rack, X3-2.
• Experience in Migrating NON-ASM databases to ASM and maintained RAC databases on Exadata.
• Extensive experience in RMAN recovery in RAC and standalone database.
• Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.
• Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
• Delivered training to other DBAs in Oracle RAC, Backup/Recovery, Oracle GoldenGate, Performance Tuning and general database administration tasks.
• Performed Tuning, coding and Monitoring for OracleReal Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Performance tuning and optimized the knowledge modules to improve the functionality of the process and worked on Cluster ware troubleshooting, CRS-ERRORS, CRS-4639, CRS-4530 and CRS-4535 and wait events in RAC environment.
• Worked extensively on monitoring 10G/11g/12c grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Installing OracleGoldenGate on RHEL and setup table level replication as well as DDL replication too.
• Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using LogDump utility.
• Troubleshooting GoldenGate issues with error reports and ggserror.log.
• Developed Shellscripts for monitoring Goldengate processes and their stats running on 60+ servers from one single database repository and thus maintain history of all Goldengate processes.
• Implemented DataGuard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Performed Zero Downtime DatabaseData Center Migration using Goldengate and Datagaurd.
• Monitored Dataguard status periodically and Maintained DRserver and troubleshooting issues in Data Guard environment.

Environment: Oracle 12c, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager, RMAN, Goldengate, Data guard, Data Pump, Tuning, Stats Pack, TKPROF, and AWR, ADDM, PL/SQL, Shell Scripting, Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, UNIX, AIX, IBM, ASM.

Confidential - Irvine, CA

Oracle DBA

Responsibilities:

• Extensively worked on Golden Gate implementation like installation, configuration GOLDENGATE unidirectional, Bi-directional and broadcast data distribution in classic capture mode on Oracle 11gLINUX .
• Migrated oracle databases using oracle11g GOLDENGATE.
• Worked on upgrading of oracle databases from 11g to 12c.
• Installed ORACLE 12c database and Cloud control (12.1.0.3) on Linux64-bit server.
• Implemented OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM .
• Monitoring all the databases using OEM 12c cloud control .
• Worked in troubleshooting 2node and 4node RAC and implemented 11g New ASM features.
• Extensively worked in setting up physical standby database using Data guard and implemented new 11g feature such as Active Dataguard and Snapshot standby database.
• Implemented switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Configure OEM12c monitoring with customized templates and email alerts.
• Configured ASM and handled issues and suggested feasible workarounds for ASM metadata corruption.
• Applying patch set and interim patches using OPATCH for upgrading the binaries.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF, SQL Tuning Advisory .
• Installed SQLTXPLAIN (SQLT) Tool that helps to diagnose SQL statements performing poorly.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.

Environment: Oracle 12C, 11gr2, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, OEL 5.8, OEM12c, RAC, Golden Gate, Oracle Exadata, Oracle Fail Safe 3.x, RMAN, EXPDP/IMPDP, Partitioning, ASM, DBFS, Data guard including DGMGRL, Performance tuning, OPATCH Utility, TOAD, DB Artisan, SQL Developer, Shell Scripting.

Confidential - Colorado Springs, CO

Oracle DBA

Responsibilities:

• Installation, configuration and administration of Oracle 10g/11g databases
• Implemented Oracle 10g RAC, 11g RAC and Standby Databases including Active Data Guard for HighAvailability and DisasterRecovery.
• Extensive experience in RMAN recovery in RAC and standalone database.
• Performed database Cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgradation and Migration of Database from 9i to 10g and 10g to 11g, applying patches whenever required.
• Developed physical and logical models of the databases using ERWIN
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Written shell scripts for the automation of backups and routine tasks.
• Migrated databases from Windows to Linux, SunSolaris to AIX.
• Creating table spaces, tables, and users for custom applications.
• Involved in design and layout for the database structures and implemented them
• Performance monitoring and tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF, AutomaticWorkloadRepository (AWR) and Automatic Database Diagnostic Monitor (ADDM)
• ColdBackup, HotBackups, LogicalBackups and RMAN Backups (Incremental Backups)
• Design and implementation of backup and recovery procedures.
• Implemented OracleStreams for the replication of data.
• Capacity planning and benchmarking
• Partitioning of large table for better performance and management.
• Installation and configuration of Golden Gate.
• Replication using Golden Gate
• Managing OLTP/Data Warehousing Databases
• Logical, Physical Database Design, Normalization.
• Developed PL/SQLFunctions, ProceduresPackages and Triggers.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.

Environment: Oracle 11g RAC/10g RAC/9i, Sun Solaris, Red Hat Linux, HP-UX, Windows, OEM(Grid Control), SQL, PL/SQL, TOAD, RMAN, ASM,TKPROF, STATSPACK AWR, ADDM, SQL* Loader, ERWIN.

Confidential

Oracle Developer

Responsibilities:

• Developed stored procedures to extract the data from different sources and load it in to data ware house.
• Used Oracle PL/SQL for implementing business rules and do performance tuning procedures.
• Created data mapping files for the data coming from different web services.
• Coded PLSQL packages and procedures to perform data loading, error handling and logging. Tied the procedures.
• Developed procedures using Dynamic SQL.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Importing and exporting the data into multiple environments.
• Involved in handling the changes in compiling scripts according to the database changes
• Developed reports using complex queries as per client request as a part of production support
• Performed SQL tuning using Explain Plan, Hints and indexes
• Responsible for performing code reviews
• Created SQL*Loader scripts to load data into temporary staging tables

Environment: 9i, TOAD, PL/SQL, SQL, TERA DATA, CRYSTAL REPORTS, SQL* LOADER, UNIXINFORMATICA 8.6

Confidential

SQL Developer

Responsibilities:

• Developed functions, procedures and packages as re-usable application programs that translated complex business logic using PL/SQL and SQL to transform data between source staging area to target staging area. Extensively used PL/SQL tables, cursors and exception handling.
• Created database objects like Tables, Sequence, Synonyms, Views, and Materialized Views.
• Involved in developing interactive forms and customization of screens using Oracle Forms .
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Maintenance included enhancing the existing stored programs, forms and reports with additional procedural and non-procedural programming logic to meet complex user requirements and fixing the bugs on priority basis.
• Importing data from different varieties of sources like flat file, excel file or Oracle dump file into Oracle database source schema tables using SQL*loader.
• Responsible for creating and maintaining the Table spaces, Users and assigning Roles and Privileges.
• Developed, Tested and Migrated the Oracle PL/SQL scripts to Production.
• Worked on tuning the SQL Queries for better performance and troubleshooting development problems.
• Extensively worked on developing KORN shell scripts for scheduling the jobs using CRONTAB and invoking the procedures through shell scripts.
• Involved in implementing bug fixes and enhancements within packages, forms, and reports.
• Responsible for preparing user manuals and quick reference guides.

Environment: Oracle, Forms, Reports, PL/SQL, SQL Navigator, Oracle Enterprise Manager, SQL, PL/SQL.