SUMMARY:

• 9 years’ experience as an Oracle DBA using Oracle 9.x, 10g,11gr1,11gr2 & 12c
• 9 years’ experience using Oracle tools such as Toad, SQL Developer and enterprise manager
• Experience in all stages of systems development life cycle including business requirements gathering, design, data conversions, programming, system/integration/user acceptance testing, documentation, production support in Oracle Database Management Systems.
• Experience using oracle replication tools like Streams and Golden Gate
• Eextensive database administration in Linux, Solaris, HP, AIX and windows
• Experience in Database Installations, Configuration, Monitoring, Maintenance, Patches, Data Migration, Database Upgrade, Database Security and supporting Oracle RAC and DB Applications.
• Experience in Performance Tuning, Troubleshooting, SQL Tuning, Query Execution Plans, AWR reports, ADDM, ASH reports, Stats Pack Reports, UNIX base monitoring, STATS gathering and Data retention.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)
• Monitored and tuned Rollback segment, temporary tablespace, redo log buffer, sort area size.
• Maintained Users and Roles with Appropriate Privileges and Profile.
• Expert in Backup and Recovery, Performance Tuning, Data Guard, Real Application clusters, Data Architecting, Database Design and Capacity Planning of database administration.
• Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
• Performed backups, recoveries, installations, database performance tuning, tuning applications, database monitoring and operating system configurations.
• Laying out database tables and database schema design, startup and shutdown of databases.
• Experience in writing proactive monitoring scripts like monitoring the disk usage, memory usage of the server and monitoring tablespaces and alert log etc.
• Installing the Oracle software and creating test, pre-prod, DR and production databases including configuring Oracle RAC. Hands on experience in OEM Oracle 11g, RAC, Data guard and Flashback technology.
• Extensively participating in the slotting, planning meetings, working with application engineers and development to collect the requirements for the application upgrades, patch installs, Hotfix installs.
• Participating in Oracle software and application upgrades, setting up disaster recovery and participated in DR exercise.
• Experience in Performance Tuning, Scripting, Disaster Recovery Techniques, Backup & Recovery for Oracle 10g/11g databases.
• Implemented best practice scripts to monitor the databases health check.
• Implemented security protocols for the database.
• Excellent written and verbal communications skills plus strong analytical and problem solving skills
• Full life-cycle software development of OLTP and data warehouse databases
• Experience using Golden Gate for data replication and migration
• Experience with implementing HA Solutions using oracle dataguard and Oracle Real Application clusters (RAC)
• 11g(r1&2) & 10g RAC and grid installation and implementation expertise (Linux & Windows)
• Exadata X2-2, X3-3,X4-2 Database Machine installation and administration experience
• Experience with upgradation and patching
• Experience with SAN and RAID technology
• Experience using Perl Script and Unix Shell script programming
• Extensive Knowledge of 10g,11g & 12c grid control and OMS
• Extensive knowledge of Utilizing REAL APPLICATION TESTING
• Managing oracle databases in a EXADATA environment
• Experience with Oracle E-Biz 11i & R12
• Experience with MS SQL Server 2005,2008,2012
• Experience with 24*7 support of production systems and applications with strong troubleshooting skills

TECHNICAL SKILLS:

Operating Systems: HP: UX,SUNSOLARIS,AIX, RHEL, WINDOWS 95/98/ME/NT/2000/XP/Vista

RDBMS: ORACLE 8i,9i,10g,11g,12c MS SQL SERVER 2005,2008,2012

Languages: SQL, PL/SQL, C, C++, Java, UNIX SHELL SCRIPTING, PERL SCRIPTING, COBOL, HTML, XML

Tools: Utilities: RMAN, OEM, SQL*Loader, expdp, impdp, TOAD, Crystal Report Generator, TKPROF, SQL TRACE, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM GRID CONTROL, GOLDEN GATE, REAL APPLICATION TESTING (RAT),ERWIN

Oracle Apps EBS: 11.5.10, 12.2.2,12.2.3

Network & Storage: EMC TIMEFINDER, VERITAS NETBACKUP, IBM TSM, HP DATA PROTECTOR, HP SERVICEGUARD, IBM HACMP, SAN, ASM

Webservers: WEBLOGIC, TOMCAT.0, IIS WEBSPHERE, WEBMETHODS

PROFESSIONAL EXPERIENCE:

Confidential, CA

Lead Oracle Exadata/RAC/Goldengate

Responsibilities:

• Part of team that supporting Exadata X3-2 quarter and half rack for various clients
• Migrated over 20 RAC and single instance database to Exadata for multiple clients
• Successfully utilized golden gate and data pump for 40 TB database migration to Exadata half rack server
• Configured DBFS file system on exadata test, dev and production databases
• Successfully utilized ILOMs for managing and troubleshooting storage cells and compute nodes
• Upgraded GRID and Databases from 11.2.0.3 to 11.2.0.4
• Developed and implemented Exadata software patches across all components of Eaxadata database Machine
• Successfully implemented Oracle character set migration using streams and Goldengate for multiple clients
• Successfully maximized database performance on Exadata using smart scan technologies such as storage index, Hybrid columnar compression and predicate filtering
• Developed golden gate scripts to achieve zero downtime production migration of mission critical systems to oracle Exadata database machine
• Level 3 escalation point of contact for all critical outages and performance issues on Exadata platforms.
• Registered all exadata components with Enterprise Manager Cloud Control 12c to monitor and manage Exadata machine and regular databases
• Installed ASR and activated Exadata ASR assets for hardware fault monitoring
• Designed and implemented database backup and recovery strategy using compression features on Exadata
• Successfully setup and managed oracle active dataguard on Exadata between two Data Centres
• Implemented backups with mirrored images using ZFS 7320 storage appliances worked on Oracle ZFS Storage web-based management interface to configure storage system worked on Oracle ZFS Storage web-based management interface to Track the different statistics available
• Configured Alerts on the Oracle ZFS Storage Appliance
• Created/Changed User Role and Permissions on the Oracle ZFS Storage Appliance
• Added Drives to a Pool on the Oracle ZFS Storage Appliance
• Configured bi-directional topology based replication using GoldenGate for exadata databases
• Configured and managing oracle cloud using 12C OEM

Environment: Oracle Linux, Oracle RAC, 11gr2, 12c, X3-2Exadata database Machine, Windows 8, Oracle data guard, Oracle golden gate 11x, EM12c, ZFS 7320 series

Confidential, Summit, NJ

Lead Oracle Exadata/RAC/Goldengate

Responsibilities:

• Part of team that successfully installed, validated and deployed Exadata X2-2, X3-2 and X4-2 quarter, half and full rack for various clients
• Migrated over 500 databases Exadata, RAC and single instance database for multiple clients
• Successfully utilized rman restore, external tables, golden gate and data pump for several multi-tera byte database migration to Exadata and other databases
• Utilized DBFS to stage data migration into test, dev and production databases
• Successfully utilized iLOMs for managing and troubleshooting storage cells and compute nodes
• Implemented backups using Sun ZFS Storage appliance (Backup time 12TB/hr)
• Developed and implemented Exadata software patches across all components of Eaxadata database Machine
• Successfully implemented Oracle character set migration using streams and Goldengate for multiple clients
• Successfully maximized database performance on Exadata using smart scan technologies such as storage index, Hybrid columnar compression and predicate filtering
• Developed golden gate scripts to achieve zero downtime production migration of mission critical systems to oracle Exadata database machine
• Level 3 escalation point of contact for all critical outages and performance issues on Exadata platforms.
• Successfully upgraded databases from 11.2.0.1 to 11.2.0.3 on EXDATA Servers
• Successfully Installed, configured and maintained Enterprise Manager Cloud Control 12c to monitor and manage Exadata machine and regular databases
• Installed ASR and activated Exadata ASR assets for hardware fault monitoring
• Designed and implemented database backup and recovery strategy using compression features on Exadata
• Successfully setup and managed oracle dataguard on Exadata utilizing multiple networks for redo transport
• Wrote conflict resolution scripts for bi-directional support to maintain data integrity in high performance, high volume databases
• Implemented DDL replication, resolved performance tuning issues on extract and replicate processes
• Created scripts for monitoring of Goldenagate operations using shell and perl script programming

Environment: Oracle Linux, Oracle RAC, 11gr2, 12c, X2-2,X3-2,X4-2 Exadata database Machine, Windows 8, Oracle data guard, Oracle golden gate 11x, Oracle VM for SPARC, Sun ZFS Storage 7120 appliance

Confidential, Summit, NJ

Lead Oracle Exadata/RAC/Goldengate

Responsibilities:

• Consolidated databases from 6 data centers (Schering-Plough) into 3 data centers( Confidential ) which involved P-P,V-P,P-V,V-V Migrations
• Successfully Installed and implemented multiple oracle 11gr2 RAC databases on customer client sites
• Successfully upgraded,installed and managed proprietary clinical applications
• Diagnosed and resolved performance and workload issues using Oracle real application testing tool and documented best practise procedures.
• Provided troubleshooting expertise for both clinical application tier and database tier and resolved several SQL, OS and application tier issues
• Used Oracle enterprise manager (OEM) to monitor, diagnose and resolve database performance issues
• Managed Oracle active data guard & standby database and provided critical solution with strategic disaster recovery plans with different recovery procedures and methods
• Cloned development databases from PROD using RMAN plus configured and scheduled RMAN Backups as per business requirements
• Successfully upgraded oracle 10g RAC databases to 11gr2 RAC databases
• Developed and deployed SQL, PL/SQL stored procedures, functions and triggers for several in-house projects
• Created and maintained physical, logical and snapshot standby databases for disaster recovery, near real-time reporting, load-testing and production database backup
• Performed Upgradation of databases from 9i/10g to 11g
• Managed Oracle active data guard & standby database and provided critical solution with strategic disaster recovery plans with different recovery procedures and methods
• Cloned development databases from PROD using RMAN plus configured and scheduled RMAN Backups as per business requirements
• Utilized Oracle automatic storage management (ASM), Oracle managed files (OMF) and recovery manager (RMAN) to improve I/O performance, reduce administration overhead and provide a comprehensive backup and recovery strategy.
• Utilized cluster health monitor utility to manage and clusterware and OS resources and resolved known issues
• Successfully implemented and utilized Oracle real applications testing (RAT) for workload management and analyzing and optimizing SQL performance
• Installed and deployed oracle golden gate on Linux server for data replication
• Experience with installing and managing golden gate with DDL support
• Proven Knowledge of golden gate architecture and database replication using golden gate technology
• Experience with replicating big source environments with multiple initial load methods and managing big transactional volumes
• Diagnosed and resolved extract, replicate and network issues during goldengate replication
• Developed monitoring scripts to monitor goldengate and report issues proactively
• Employed Logdump utility to troubleshoot and fix goldengate replication issues
• Designed implemented, and supported both unidirectional and bidirectional replication leveraging multiple features within the Oracle goldengate product suite
• Identified and resolved causes of slow startups, monitored process lag and statistics, identified network and disk bottlenecks, and performed tuning of key components
• Monitored and resolved different process problems, such as extract and replicat process issues
• Utilized Oracle goldengate troubleshooting tools such as knowledge documents, documentation, SHOWSYNTAX parameter, and the Logdump utility
• Participated in logical and physical database design reviews to ensure application design integrity
• Unix shell scripting, SED, AWK scripting for automating several DBA tasks
• Configuration and administration of full rack Exadata databases
• Resolved smart scan performance problems, like passthrough mode and selective fallback to block IO
• Utilized performance tools like V$SQLSTATS, ASH and SQL monitoring views to resolve Exadata performance related waits
• Effectively utilized Exadata Hybrid columnar compression on historical data which led to realizing 6-7 times SQL performance gains

Environment: Linux, Windows XP, 10g, 11gr2, Dbconsole, Grid control, Dataguard, VERITAS cluster, Exadata v2, Goldengate 10,11.x.

Confidential

Sr. Oracle (RAC) DBA

Responsibilities:

• Successfully completed cross platform oracle 10g database migration from 32bit Solaris to 64bit Linux
• Successfully installed and managed oracle real application clusters (RAC 10g) on a 4 node Linux cluster using Oracle cluster file system (OCFS) and automatic storage management (ASM).
• Successfully installed, configured and deployed oracle applications express 3.1 for managing database infrastructure such as users, servers, passwords and applications.
• Diagnosed and resolved clusterware, ASM and database issues with all new RAC installations
• Migrated non-RAC 10g oracle databases to instances to 11g release 1
• Implemented key RMAN 11g features such as block change tracking, use of flashback recovery area and taking incrementally updated backup to meet backup and recovery goals
• Worked extensively on identifying high load SQL queries and troubleshooting to find underlying causes and took appropriate actions to improve performance.
• Involved in partition administration: creating, managing, pruning, merging, global and local index management
• Reviewed automated workload repository (AWR) and automatic database diagnostics monitor (ADDM) report for proactive performance tuning & monitoring
• Recovered database from media failure, accidentally dropped tables, missing data files and block corruption using flashback recovery, TSPITR and from previous RMAN backups.
• Managed star schema and 3NF design, implementing effective strategies for data transformation, extraction and loading
• Applied multiple patches and patch sets, CPU and PSU to over 300 oracle test, staging and production databases in Linux and Solaris
• Communicated and coordinated with oracle support regarding major database issues and applied required patches on unit test/ system test and rolled out and implemented patches into production
• Provided 24x7 on-call supports for more than 70 mission critical OLTP and OLAP (RAC and single instance) production databases on multiple OS platforms

Environment: Windows 2003 server, Linux, Solaris Sunsparc, oracle 10g and 11g, 10g Grid, 10g RDBMS, Apex 3.1, Vista

Confidential

Senior oracle (RAC) DBA

Responsibilities:

• Configured, installed and deployed multi-node 10g RAC databases .
• Managed various RAID storages including LUN management of storages EMC
• Scheduled jobs, alerts, blackouts, patch application, rolling upgrades via OEM
• Detected and resolved performance issues on RAC databases using grid control and v$GC views
• Managed schemas, objects & partitioning the tables & indexes.
• Developed and maintained multiple Unix scripts for various automated tasks
• Configured and deployed oracle 10g grid control to manage all RAC and single instance databases
• Managed OEM, TOAD, and data migrations using, RMAN clone, export/import, benchmarking using Load testing tools
• Managed oracle ASM and disk groups for all RAC instances
• Successfully implemented oracle backup and recovery strategy using RMAN
• 24*7 support for production systems and on-call rotation
• Successfully performed backup and recovery testing on production databases
• Performed upgrades and applied patches to multiple oracle instances
• Supported SAN hardware and software volume manager for disk space allocation
• Managed VERITAS netbackup 4.5 running on Solaris using Sun SureStore.
• Efficiently implemented DR solution by successfully setting up and managing physical standby databases

Environment: Solaris, Windows XP, Linux, 10g RAC, 10g Grid 10g RDBMS, VERITAS cluster server and volume manager, DBartisan