Summary

• 15 years of IT experience in analysis and design.
• 5 years as an oracle instructor teaching Oracle 8i and 9i 10g certification programs
• 15 years experience as an Oracle DBA using Oracle 6.x, 7.x, 8.x,9.x ,10g and 11gr1 11gr2 and 12c
• 12 years experience using Oracle tools such as Toad, quest and enterprise manager
• 10 years experience writing scripts in SQL, PL/SQL packages, procedures, functions and triggers in multiple Oracle environments.
• Experience using oracle replication tools like Streams and Golden Gate
• 8 years of Unix script programming using SED, AWK and korn shell
• Extensive database administration in Linux, Solaris, HP, AIX and windows
• Experience with VERITAS volume manager and VERITAS cluster server.
• Some experience with PERL scripting and Java programming language
• Excellent written and verbal communications skills plus strong analytical and problem solving skills
• Good understanding of NoSQL databases MongoDB
• 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 Unix Windows
• Exadata X2-2, X3-3,X4-2 Database Machine installation and administration experience
• Experience with SAN and RAID technology
• 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 managing and supervising DBAs and developers
• Experience with 24 7 support of production systems and applications with strong troubleshooting skills

TECHNICAL SKILLS:

Experience

Confidential

Title: Lead Oracle Exadata

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
• 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 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 infiniband over ZFS for various customers
• 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

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

Confidential

Title: Lead oracle DBA/ RAC, Golden Gate Architect

Responsibilities

• Successfully compressed over 30 v490's, v880's,v440's v240's into Sun SPARC 3 T4-2 Prod and DR and 2 T4-1 UAT data center
• Saved FHLB 500k over 12month period, with savings in cooling, power, weight and space of over 83
• Successfully designed and installed oracle 11gR2 Clusterware and ASM on top of oracle 10g RAC database
• Successfully managed multiple oracle RAC databases on oracle VM server for SPARC LDOMS and zones
• Successfully managed both single instance zones and RAC LDOMS from development, UAT, go-live, to production support
• Resolved RAC performance issues on oracle VM server for SPARC LDOMS
• Successfully implemented and utilized Oracle real applications testing RAT for workload management and analyzing and optimizing SQL performance
• Implemented, setup and utilized oracle cluster health monitor for diagnosis and fixing cluster issues
• Utilized RACcheck utility to also diagnose CRS, ASM and RAC database setup issues
• Successfully designed, implemented and managed oracle physical and logical dataguard solutions
• Implemented RMAN strategy for all backups, refreshes and restores
• Designed, installed and configured oracle golden gate on both Unix and windows platform
• Designed, implemented, and supported both unidirectional and bidirectional replication leveraging multiple features within the Oracle goldengate product suite
• Tuned extract and replicate lags and implemented golden gate monitoring scripts
• Wrote several PL/SQL procedures and SQL scripts, used by golden gate processes for data filtering, computation and transformation
• 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

Environment: Solaris 10 11, Oracle RAC 10g, 11gr2, Solaris Zones, LDOMS, Windows 8, Oracle data guard, Oracle golden gate 11x, Oracle VM for SPARC

Confidential

Title: Lead oracle DBA/Architect

Responsibilities

• Managed multiple databases on both RAC and single instance on Linux
• Successfully migrated several QA/test, staging and multi-tera byte production 9i/10g HP/Solaris DB to oracle 11gr2 DB using RMAN TTS on Linux and documented migration procedures
• Managed and updated several automated Unix scripts used for the migration project to expedite the migration process with minimal manual intervention
• Resolved numerous performance issues like top wait events, sub-optimal execution plans, outdated statistics, data fragmentation, latch contention, CPU constraints, physical logical I/O, disk usage, query optimization, hard/soft parsing by application tuning, disk I/O and memory tuning.
• Regularly planned and scheduled physical hot/cold backups, logical import/ export, data pump backups, and incremental backups using RMAN on daily, weekly and monthly basis.
• Performed troubleshooting duties on Oracle production databases and determined RCA Root Cause Analysis and resolved known issues
• Handled performance tuning and application monitoring with Quest TOAD, Oracle enterprise manager, AWR and Explain plan and greatly reduced execution times of several problematic queries
• Applied quarterly CPU and PSU patches to over 100 mission critical databases
• Diagnosed Oracle bugs and coordinated with oracle support to resolve them in timely manner and applied patch sets to make application environment up-to-date.
• Involved with streams administration for data replication purposes
• Developed fully optimized SQL and PL/SQL scripts that successfully assisted with timely offloading of reporting data and analytical data

Environment: Linux, HP, Windows XP, 9i,10g,11gr2, Dbconsole, Grid control, Dataguard, VERITAS cluster, streams

Confidential

Title: Lead RAC oracle DBA/Architect

Responsibilities

• Successfully upgraded, installed and managed proprietary clinical applications
• Successfully Installed and implemented multiple oracle 11gr2 RAC databases on customer client sites
• 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
• 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

Environment: Linux, Windows XP, 10g, 11gr2, Dbconsole, Grid control, Dataguard, VERITAS cluster, Golden Gate 11.x.

Confidential

Title: Lead RAC oracle DBA/Architect

Responsibilities

• 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
• 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
• 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 with Exadata Snapper
• 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

Confidential

Title: Advanced Customer Service Engineer

Responsibilities

• Diagnosed and resolved oracle RAC performance issues using SQLT and AWR
• Upgraded 10g RAC database to 11gr2 RAC databases
• Used OEM, CVU SRVCTL, and CRSCTL commands extensively to maintain the RAC environment like add/remove node, start/stop clusterware app services on node and add TAF services.
• Involved in performing several quarterly CPU PSU patches on multiple databases
• Diagnosed and resolved client RAC related data corruption, ASM and clusterware corruption issues and resolved cache fusion related contention issues
• Supported multi-tera byte oracle 10g, 11g RAC databases and data guard DR solutions on multiple platforms
• Involved in SQL query tuning and optimization for client on multiple applications and databases and reduced query performance times to acceptable levels
• Successfully installed and deployed oracle golden gate in unidirectional and bidirectional modes on Linux platform
• Developed and implemented administrative scripts for supporting, monitoring and tuning golden gate replication and monitoring replication lags
• Worked on various conflict detection and resolution scenarios for different types of DML, including quantitative resolution and transactional resolution
• Resolved all ongoing support and problem determination of data replication issues, including identifying and resolving data inconsistencies and data replication lag
• Supported and deployed goldengate in a heterogeneous replication environment
• Successfully configured and deployed and managed goldengate director and veridata.
• Documented and published RAC, ASM best practises and procedures for client.
• Served as SME subject matter expert and project lead in a variety of areas including Oracle streams, database security and auditing, backup and recovery, performance tuning and Unix shell scripting.
• Initiated media recovery, Instance and crash recovery using RMAN and performed database point-in-time recovery and TSPIT recovery during scenarios like loss of RLF, system/non-system DBF, Control file, table drop and whole DB Crash.
• Created and published standards and operational procedures to provide continuity of operations between geographically distributed DBA groups.

Environment: AIX, HP, Linux, Oracle 10g, 11gr1, 11gr2, RMAN, Dbconsole, Grid control, Dataguard, GoldenGate 10

Confidential

Title: Lead oracle RAC DBA

Responsibilities

• Successfully installed and configured several oracle 11gr2 RAC on Linux platforms
• Successfully upgraded several 10gr2 RAC databases to 11gr2 RAC databases
• Developed physical and logical designs for databases and implemented effective capacity planning procedures in both development and production environment
• Co-ordinated and implemented quarterly CPU PSU patches
• Employed 10g data guard broker to configure and manage the primary database with two physical standby databases
• Developed and implemented Unix shell scripts, Kron scripts and crontab jobs to automate daily tasks including backups, exports/Imports, monitoring tablespace growth, gathering CBO statistics, analyzing tables and indexes, trimming the alert log files, monitor backup logs and monitor the alert logs for errors.
• Managed and maintained several partitioned tables and maintained associated global and local index
• Diagnosed and resolved clusterware, ASM, interconnect and RAC related performance issues using v GC views, oswatcher and AWR reports
• Performed data replication using materialized view Snapshot and Oracle streams for table level, schema level replication and transferred data in unidirectional and bidirectional by checking with data Synchronization and no latency.
• Developed several PL/SQL functions and stored procedures and triggers
• Provided 24 7 oncall support for all production databases
• Performed several database cloning from production to test/staging using RMAN duplicate. RMAN and sqlbacktrack were also used for backup/recovery

Environment: AIX, HP, Linux, Windows XP, Oracle 9i,10g,11gr2, sqlbacktrack, Dbconsole, grid control, Dataguard, VERITAS cluster

Confidential

Title: Lead oracle RAC DBA/Architect

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 O.C.F.S 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
• Developed and deployed Perl scripts to replace ETL functionality for various in-house data load processes

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