Summary:

• Over 14 years of experience with oracle database administration, Exadata, RAC, data guard, golden gate,, oracle apps, forms, reports and obiee, odi, edq, fusion middleware, Weblogic, grid control, installation, configuration, administration, migration, upgrade, backup recovery, opatch, adpatch and custom patches, performance tuning, database health check, security setup, for production, developments and QA environments and production support
• Worked with administration migrated database to Exadata X2-2, X2-8 X3-8, X4-8
• Worked with real application clustering RAC installation, configuration administration
• Worked with golden gate 11g replication solutions to facilitate data flow between databases
• Replicated with oracle streaming, golden gate, data guard and active data guard MAA
• Worked with database performance tuning , SQL Plan Management, Explain Plan, SQLT, Tkprof, Histogram, OSWathcer, Indexing, SQL Hints, ADDM, AWR, ASH
• Worked with data warehouse design and architect, ETL, ODI, ,EDQ, OBIEE, informatics, Golden Gate, SOA, SSIS, SQL loader, f5 and apache
• Worked with Weblogic 10g/11g, fusion middleware 11g, grid control 12c/11g/10g
• Worked with oracle 11gr2/10g/ 9i/8i, MSSQL Server 2008/2005/2000 and MySQL
• Worked with database security, files, directory, user, group, and database profiles security
• Worked with bug fixing, patching of oracle database, middleware, EBS 11i/R12, applications
• Extensive experience with performance tuning of instance tuning and good knowledge on database waits events and oracle internals, EBS and fusion middle ware and weblogic
• Experience with alter log, iostat, vmstat, netstat, sar, top, glance performance monitoring
• Extensive DBA experience with export/import, datapump, indexing and administration tool like dbca, netca, asmca, dcli, cellcli srvctl, crsctl, opmnctl, emctl, ggsci, sqlplus etc
• In depth understating of oracle architecture, SGA PGA memory and background process, oracle data dictionary, explain plan, logical and physical structure of database
• Experience in Oracle Table partitioning range, list partition and 45TB large database
• Expertise with UNIX shell scripting and automated task scheduling using crontab
• Worked with designing logical and physical backup/recovery procedure of database
• Worked with diagnosing and reporting critical errors to oracle support services
• Worked with capacity planning of database, server, storages and infra-structure
• Experience with all phases of software development life cycle

Skills

Works experiences:

Confidential

Sr. Lead Exadata Oracle DBA

Duties and Accomplishments

• Worked with Oracle Exadata migration project from X2-8 to X3-8 full rack 15 to 25TB database using data guard for OLTP and data warehouse databases and solid understanding of Exadata architecture, db servers, cell servers and InfainiBand and switches
• Worked with oracle super cluster T5-8 and SAP 45TB database migration from HPUX superdome to oracle super cluster T5-8 Exadata X4-8 using OGG Triple O and 020.
• Worked with data warehousing database architect, design and developed stage, warehouse and data mart database and worked with ODI,OBIEE, EDQ
• Worked with Exadata storage servers, database servers and InfiniBand switches maintaining, patching and upgrading to higher versions, troubleshooting with Cell servers and firmware
• Worked with performance tuning, cell offloading and smart scan, storage indexes, hybrid columnar compression , OLTP table compression and parallel operation
• Installed, configured and administer oracle cloud grid control 12c and deployed agent monitor targets and setup dynamic group and matrix and polices
• Installed, upgrade and administration of 11gR2 RAC databases and data guard MAA setup and worked with grid upgrade and database upgrade
• Performance tuning the database by using sql plan management, explain plan, SQLT, tkprof, histogram, OS Watcher, indexing, sql hints, ADDM, AWR ASH defragmenter, shrink table space and gathering statics, and using wait events
• Wrote Shell scripts for RMAN backup, databases and monitor physical standby databases
• Restored recovered database from the RMAN full back up to making sure backups are good
• Performed and designed enterprise level backup/recovery plan and strategy to backup database
• worked with oracle fine grained auditing FGA and oracle total recall to managed audit log
• Worked with very large over 15 to 25TB OLTP databases on Exadata X3-8 and X4-8 platforms

Confidential

Sr. Lead Oracle Exadata DBA Exadata Cell Admin

Duties and Accomplishments

• Oracle Exadata X2-2 half rack migration project plan, design and implementing Exadata solution for OLTP and data warehouse databases and solid understanding of Exadata architecture
• Worked with Exadata storage servers, database servers and InfiniBand switches maintaining, patching and upgrading to higher versions, troubleshooting with Cell servers and firmware
• Worked with performance tuning, cell offloading and smart scan, storage indexes, hybrid columnar compression and parallel operation and integrated Exadata with the grid control 12c.
• Installed, upgrade and administration of 11gR2 RAC databases and data guard MAA setup and worked with grid upgrade and database upgrade, scan listener and ASM upgrade
• Installed, configured administration of data replication solutions using Oracle Golden Gate 11g and worked with logdump, blowfish encryption, initial load and performance and tuning.
• Worked on replication and upgrade production databases zero downtime with oracle Golden Gate
• Performance tuning the database by using sql plan management, explain plan, SQLT, tkprof, histogram, OS Watcher, indexing, sql hints, ADDM, AWR ASH defragmenter, shrink table space and gathering statics, and using wait events
• Migrated and upgraded oracle 10g forms, reports and discover application to oracle 11g RAC database, 11g fusion Weblogic server, apache on Linux platform
• Worked with MAA setup for weblogic and fusion middleware and deployed forms and reports applications and J2EE application and configured jdbc, JMS and security
• Installed, configured and administer oracle cloud grid control 12c / 11g and deployed agent monitor targets and setup backup jobs for the data domain rman backups
• Worked with prod, dev, QA, databases for schema refresh and scripts apply and hot patch apply
• Wrote Shell scripts for RMAN backup, weblogic server and monitor physical standby databases
• Restored recovered database from the RMAN full back up to making sure backups are good and worked with storage move form Hitachi to EMC
• Performed and designed enterprise level backup/recovery strategy, backup, Incremental backup, Hot backup, full Back up exp, data-pump , RMAN in disk and tape , data domain and GC
• Worked with data warehousing database to developed staging, warehouse and data mart database and worked with ODI,OBIEE
• worked with all phases of software development life cycle

Confidential

Sr. Lead Oracle DBA/Architect

Duties and Accomplishments

• Installed, managed and administration of 11gR2 RAC, ASM, databases and scan listener on Linux and RAC physical data guard MAA
• Managed and administration of 10gr2 RAC and CRS, ASM and databases on Linux
• Administration, configure and manage replica1 for replicate data from ICOMS to staging server
• Worked with data warehouse database design and architect, ETL, replica1, ODI, OBIEE EDQ
• Worked with Weblogic server to managed oracle grid control GC and OBIEE
• Administration and configure of oracle 11g grid control for monitoring database, file system, CRS and listener and setup database jobs and backups
• Monitored the databases using sql plan management, explain plan, histogram, trace file, alert log files, v view, AWR, ADDM, grid control, index re-index, defragmenter, shrink table space and explain plan, Hints, and using wait events
• Worked with prod, dev, QA, databases for schema refresh and scripts apply and hot patch apply
• Rewrote of shell scripting of RMAN backup and database monitor scripts
• Restored recovered database from the RMAN full backup for testing of backups works
• Worked with large database of 15TB in size data warehousing for reporting purpose
• Worked with setup cleaning up of backup storage server and setup new backup strategy
• Worked with production server ASM disk group to reorganize the disk group and storage
• Worked with oracle grid control to setup server, ASM and database metric thresholds policies
• Worked with MS-SQL and MySQL database production developments and QA environments

Confidential

Sr. Lead Oracle DBA

Duties and Accomplishments

• Installed, migrated, upgraded Oracle 10g/11gR2 RAC database and CRS on Sun Solaris 10
• Configured and managed oracle 10g physical data guard and 11g active data-guard MAA
• Designed, installed, and configured high-performance active/active data replication solutions using Oracle Golden Gate 11g replication between two data centers across the country
• Worked with data warehousing database stage, warehouse and data mart , ODI, OBIEE
• Worked with replication and upgrade production databases with oracle Golden Gate
• Migrated data replication solution from Oracle Streams to Oracle Golden Gate 11g
• Setup configured maintained and support oracle streaming for active/active replication
• Worked with Weblogic to Installed configured oracle 11g grid control for monitoring database, file system, CRS and OBIEE to support analytic reporting
• Monitored the databases using trace file, alert log files, v views, AWR, ADDM, grid control
• Worked with performance tuning the database by index re-index, defragmenter, shrink table space and gathering statics, explain plan and outlining, Hints, and using wait events
• Worked with prod, dev, QA, databases for schema refresh and scripts apply and hot patch apply
• Worked with custom build python based middle ware for active pre-connection both side
• Setup and maintain support oracle table space partitioning for production database
• Wrote Shell scripts for RMAN backup and database monitor scripts
• Restored recovered database from the RMAN full back up after data file corruption.
• Worked with large database of 5TB in size data warehousing for reporting purpose
• Worked with patched the oracle database in oracle 11g and oracle 10g and CRS

Confidential

Sr. Lead Oracle DBA/ Weblogic admin

Duties and Accomplishments

• Installed Oracle 11gR2 RAC on Linux from scratch and managing oracle 11g2 RAC and MAA
• Provided production support for oracle 10g R2/11gr2 and MS- SQL 2005/2008 Server databases
• Database up-graduated from oracle 10gr2 to oracle 11gr2 cluster and non-cluster
• Monitored, performance tuning the databases using trace file, alert log files, v views, AWR, ADDM, indexing, gathering statics, explain plan, SQL tuning, and Grid Control
• Worked with Weblogic server 11g, oracle 10g forms and reports server and oracle 11g fusion middleware help to migrate 6i forms and reports to 11g and oracle SOA 11g, and J2EE apps
• Managed dblink, MViews table Indexes for efficient and robust access data
• Performed and designed backup/recovery strategy using data-pump and RMAN
• Worked with database security files, user, group access, and database profiles security setup
• Implemented database security to all the production databases and comply with CIS-CAT 2.1.7 benchmarks security assessment reports and install grid control 11g
• Worked with schema objects like tables, functions, store procedure, packages, indexes, views
• Updated and test oracle SQL PL/SQL scripts, shell scripts and automated task scheduling using crontab and windows scheduler for production databases
• Patched of oracle database and oracle forms and reports, weblogic server

Confidential

Sr. Oracle DBA

Duties and Accomplishments Worked as oracle dba to support health clinical trial research databases and worked with oracle stream and RAC and data guard.

Confidential

Sr. Lead Oracle DBA

Duties and Accomplishments Worked as Sr. apps dba to upgraded EBS11i to EBS R12 and Migrated the oracle 10g MAA setup to 11g MAA setup and work with oracle stream.

Confidential

Sr. Lead Oracle DBA/Architect

Duties and Accomplishments Worked as Sr. Lead data warehousing dba to help developed and managed production data warehouse environments for asset back securities ABS system n financial system. oracle 9i/10g databases was running on windows and Linux platform.

Confidential

Sr. Oracle DBA

Duties and Accomplishments Worked as dba and data warehousing dba to help developed and managed production and data warehouse environments on telecommunication domain and migrate oracle 8i/9i databases to 10g data guard and MAA environments

Confidential

Oracle DBA/Weblogic admin

Duties and Accomplishments Worked as oracle product and developments DBA on taller managements system to migrate this project from MS-SQL server to oracle in back end and J2EE application in the front end running on the Weblogic server

Confidential

Oracle DBA

Duties and Accomplishments worked as oracle database administration, and oracle apps DBA and oracle 6i forms and report application support for customer, sales and inventory managements system on sun Solaris.