SUMMARY

• Over 20 years of IT experience and 15 years as DBA experience with project lead, oracle database administration, Exadata, RAC, data guard, golden gate and Weblogic, grid control, installation, configuration, administration, migration, upgrade, backup recovery, oracle cluster, database patches and upgrade, SAP patches, custom patches, performance tuning, database health check, security setup, for production, developments and QA environments.
• Worked with administration upgrade & migrated grid, database to Exadata and superclusters.
• Applied QFSDP to oracle Exadata database and oracle Supercluster T5 - 8, M7 and SAP databases upgrade 11g, 12c, 13c, 19c and applied SAP patches.
• Worked with golden gate 11g and 12c replication solutions to facilitate data flow
• Replicated with oracle streaming, golden gate, Veridata data guard and active data guard
• Worked with database performance tuning, snapper, SQL Plan Management, Explain Plan, 10046 tracing, Tkprof, Oradebug, Histogram, Indexing, SQL Hints, ADDM, AWR, & ASH
• Worked with data warehouse star and snow flake schema, design, architect and implementation, ETL, ODI, Golden Gate, SQL loader, f5 and apache
• Worked with Weblogic 10g/11g/12c, grid control 13c/12c/11g/10g and ODI
• Worked with oracle 19c/13c/12c/11gr2/10g/ 9i/8i, MSSQL Server 2008/2005/2000 and MySQL
• Worked with database security, files, directory, user, group, and database profiles security
• Experience with alter log, iostat, vmstat, netstat, top, glance performance monitoring
• Extensive DBA experience with rman backup restore, INMEMORY, 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

TECHNICAL SKILLS

Oracle Appliances: Oracle Exadata X2-2, X2-8, X3-8, X4-8, ODA, and Super Cluster X5-8, X7-8

Databases: Oracle 19c/13c/12c/11gr2/10g/9i/8i, SQL Server 2000 and MySQL

Web Server: Weblogic 12c/11/10/9, Oracle AS 10g, Apache and oracle apps

Operating Systems: Sun Solaris, Linux, AIX, Windows/2003/8, VMware, Hadoop

Data Ware House Tool: Informatic, ODI, EDQ, replica1, SSIS, OBIEE

Oracle Exadata: Oracle Exadata and oracle supercluster, ODA, ExaCS, OCI, AWS

Cluster Services: VERITAS Clusters Service (VCS), Oracle ASM, CRS. ADRCI

Replication Service: Oracle Data Guard, Oracle Streams, Oracle Golden Gate, Materialized view

Data Modeling: TOAD data modular, ER-Win, Rational Rose, UML, Visio

Reporting Tools: Oracle forms and reports, Discoverer, Oracle OBIEE, SAP BO

Backup Recovery: RAMN IMP/EXP, flashback, data domain, Net Backup, EMC Avamar, GC etc

Languages: SQL, PL/SQL, Java, C#, Shell, VB6.0, ASP, HTML

Monitoring Tools: Grid Control 13c/12c/11g, EM, Toad, Admin tool, Spotlight, Red gate, etc.

Storage Technologies: SAN EMC DMX, BCV, SRDF, OCFS, ZFS, DBFS, Oracle ASM

Others Tools: PL/SQL Developer, jira, Remedy, Clarify, VSS, Veridata, and STIG

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Exadata DBA

Responsibilities:

• Worked with Oracle Exadata migration project from HP super dome to Oracle Super cluster T5-8, X5-8 to X7-8 full rack database size up to 45 TB and solid understanding of Exadata architecture, db servers, cell servers and InfainiBand and switches and knowledge STIG and AWS. up graded SAP and oracle database from oracle 11gr2 to oracle 12c/13c/19c
• Applied QFSDP to oracle Exadata database and oracle Supercluster X5-8, X7-8
• Worked with oracle super cluster X5-8 and SAP 45TB database migration from HPUX superdome to oracle super cluster Exadata X5-8 using OGG and expdp-impdp
• Designed, and Implemented active/active data replication solutions using Oracle Golden Gate
• 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, administer and patches oracle cloud grid control OEM 13c/12c deployed OEM agent monitors targets and setup matrix and polices, knowledge STIG for database 11gr2/12c/13c
• Installed, upgrade and administration of 11gR2/12c/13c/19c RAC databases and data guard (MAA) setup and worked with grid upgrade and database upgrade
• Performance & tuning the database by using snappers, sql plan management, explain plan, tkprof, histogram, OS Watcher, indexing, sql hints, ADDM, AWR & ASH defragmenter, shrink table space and gathering statics, and using wait events, 12c In-Memory, ADRIC, STIG
• Wrote Shell scripts to monitor database, cluster, listener, OGG process, RMAN backup
• 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 very large over 45 TB OLTP databases on Exadata X5-8, X7-8 and T5-8 platforms
• Working knowledge of migrating oracle database to AWS.

Confidential, Sacrament CA

Sr. Oracle ExadataDBA

Responsibilities:

• Worked with Oracle Exadata migration and ungrudging hardware and databasesand patching of oracle exadataX2-8 to X3-8 full rackdatabase size up to 40 TB up graded database cluster from oracle 11gr2 to oracle 12c in oracle Exadata & applied QFSDP
• Worked with data warehousing database start schema, architect, design, developed and implementation and data mart database and worked with ODI, and OBIEE and WebLogic 12c
• 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, upgrade and administration of 11gR2/12c RAC databases and data guard (MAA) setup
• Performance &tuning the database by using snappers, sql plan management, explain plan, ADDM, AWR & ASH defragmenter, shrink table space and gathering statics.
• Wrote Shell scripts for RMAN backup, databasesand 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 tobackup database

Confidential, NJ

Sr. Lead Oracle Exadata DBA

Responsibilities:

• Oracle Exadata X2-2 migration, 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 applied QFSDP to oracle cluster and databases and work with oracle to prepare the patches.
• 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, and validating data using oracle Veridata and working with SSL encryption.
• 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 installed configured and administrations MAA setup for WebLogic form and reports servers, ODI. OBIEE high available environment with cluster managed servers. worked with all phases of software development life cycle

Confidential, West Region

Sr. Lead Oracle DBA

Responsibilities:

• Installed, managed and administration of 11gR2 RAC, ASM, databases and scan listener on Linux and RAC physical data guard (MAA)
• 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, AWR, ADDM, grid control, shrink table space and explain plan, Hints, and using wait events worked with Designer, Operator, Topology and Security, Master and work repositories
• 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