SUMMARY:

• Over 15 years of experience in Oracle database administration of ( 8i, 9i, 10g, 11g) 10g/11g RAC, Golden Gate, Data guard including designing, installing, administering, upgrades and migrations, backup, recovery, performance tuning, automation and daily maintenance in health care, retail and telecommunication domains
• Certified Oracle RAC Certified Expert and Oracle Certified Professional 10g, 9i
• Exposure to a variety of operating systems like Solaris, LINUX, HP - UX, AIX in production as well as development environments of Very Large Databases (VLDB)
• Successfully led several projects to upgrade Oracle Databases and Oracle Cluster Ready Services to 11gR2, conversion from NON-RAC to RAC
• Hands on experience in leading DR build to Azure cloud using Azure Site Recovery (ASR) and Cloud Endure, failback and failover testing and documentation of entire Disaster Recovery Documents
• Part of the engineering team, conduct Proof Of Concept and take decisions to choose the kind of storage for the databases, the kind of hypervisor and the best solution for DR on cloud and platform migration tools
• Proficient in performance tuning including extensive AWR report analysis, understanding explain plans and query tuning, identifying fragmentation of tables, suggesting indexes on type of table and column's cardinality, creating baselines and migrating SQL profiles from one instance to another
• Involved in automating several tasks using shell scripts like:
• HTML Report of Database Health Checklist after new DB builds
• HTML Report of Database Health Check (24hrs) for pro-active monitoring of critical databases
• Automating Backup and Refreshes Lead
• Effectively led several platform migration projects which involved moving complex E-Business suite application and database from Solaris to Linux, involving several months and iterations of migration, testing, coordination with various application teams and end to end support post go live
• Expertise in Exadata configuration, maintenance & support and implementing security best practices to Harden Oracle Databases
• Conducted seminar in Oracle University on Oracle Clusterware
• Extensive experience in end to end Datacenter Migration, 12c OEM, Multitenant databases, setting up and testing in DR Failover, Failback scenarios, Automating application reconfiguration for DR and meeting tight RTO and RPO schedules
• Profound working knowledge of Oracle RAC, ASM, Platform migration, Shell scripting and Performance tuning

TECHNICAL SKILLS:

Database: Oracle 12c,11g, 10g, 9i, 8i, PostgreSQL

Platforms: Solaris, Linux, HP-UX, AIX, Windows 2000

Applications: E-Business suite R11,R12, Informatics ILM, SOA BPEL 10g

Tools: Auto DBA, Grid Control, Toad, SQL Developer, Approx., Commvault

Virtualization: OVM, Nutanix, ESX

PROFESSIONAL EXPERIENCE:

Confidential

Lead Consultant

Responsibilities:

• Migrating datacenter from Cloud to its own datacenter which includes understanding the existing architecture, integration points between multiple applications, proposing new architecture and best practices
• Setting up infrastructure for multiple DCs and DR planning
• Implementing Backup Strategy using Commvault
• Planning and implementing Cascaded Standby DB setup to plan for minimal downtime during cutover
• Administering OVM and multipath setup
• Installing CRS and RAC setup
• Coordinating with vendors and local DC for setting up DR across cloud
• Managing Exadata X2-8 with nodes ranging from 2 to 8 and incorporating data guarded Exadata clusters for maximum availability
• Setting up alignment critical for all flash arrays and tweaking ASM allocation units based on the type of databases
• Testing the right kind of storage by doing I/O generation tests using ORION tools and other RDBMS packages used to judge the throughput, latency and IOPS for the storage
• Tuning databases using each application's best practices document like OBIEE, Siebel Loyalty, EBSO that suits best for the specific environment they would be migrated to
• Planning timelines and activities for the project
• Identifying dependencies and setting proper expectations
• Coordinating and setting up daily meetings with offshore teams and client to sync resources and activities within the project timelines
• Onboard resources remote and onsite
• Working with vendors for different tasks with dependencies

Confidential

Performce Tuning SME

Responsibilities:

• Analyzed AWR reports including find out performance bottle necks, identifying problem queries and make appropriate recommendations
• Tuned database and queries based on wait events
• Involved in in-depth query tuning of understanding explain plans like Joins, Query Re-writing, using hints, creation of new indexes and modifying existing indexes
• Guided developers in writing SQLs efficiently
• Resolved collisions, monitored lags and fixed EXTRACT and REPLICAT issues
• Created and managed database maintenance plans
• Designed and implemented backup and disaster recovery plans

Confidential

Principle Consultant

Responsibilities:

• Handled 4 mission critical production databases, over 8TB in size in a 24x7 environment
• Coordinated routine maintenance activities with offshore team in India for seamless support
• Led a upgrade 10g to 11g DB project and converted active-passive setup to RAC
• Archived old data using Informatics’ - Information Lifecycle Management
• Tuned slow running jobs, enabled SQL profiles on critical SQL statements to provide better plan stability and migrated SQL profiles from one environment to other
• Designed and implemented onsite and offsite robust database backup and recovery systems and disaster recovery
• Conducted regular maintenance activities like one off patching, CPU patches, minimum baseline patching, techstack patching, code deployment, production weekend maintenance
• Wrote shell scripts to backup production database using flashcopy, automate clones using transportable table spaces and monitoring database, application and server
• Resolved escalations for database issues and conducted root-cause analysis
• Planned capacity and provided database infrastructure for future growth of the business
• Handled major releases from scratch to go live
• Worked with DEV, production support and testing team to meet the functional and performance needs
• Added a new BPEL application server to an existing BPEL production environment
• Built new BPEL environments and integrated with custom applications and oracle databases, including installation, upgrade, patching, configuration of BPEL and tuned BPEL, JVM

Confidential

Principle Consultant

Responsibilities:

• Coordinated and scheduled tasks with offshore team
• Attended CAB meetings and coordinated releases between development, production support and DBAs
• Provided WAR room support during critical GO-Live launches
• Set up alert thresholds in grid control for all environments
• Developed UNIX Shell scripts to automate database operation and scheduled tasks
• Resolved escalations for database issues and conducted root-cause analysis
• Conducted regular maintenance activities included patching and cloning
• Troubleshot ad hoc issues like DB Down, listener issues, ORA - errors with oracle support

Confidential

Principle Consultant

Responsibilities:

• Worked in all flavors UNIX - AIX, Linux, HP-UX, Solaris
• Implemented projects like Solaris to Linux platform migration for E-Business suite applications, installing & upgrading Oracle Cluster ware and converting single instance to RAC
• Configured physical standby database including failover and switchover testing
• Resolved abended processes, space and data issues
• Conducted Oracle 11g upgrade project with minimum downtime
• Developed UNIX Shell scripts to automate database operation and scheduled tasks
• Installed & upgraded grid control
• Converted non-ASM to ASM
• Performed application tuning using Oracle Trace and analyzed the execution plans and tuned the queries by creating proper indexes and modifying the PL/SQL procedures
• Patched year end & month end activities and updated Vertex
• Cloned RAC-RAC, RAC-non RAC using RMAN & BCV
• Worked with various development teams to ensure proper use of Oracle Exadata features and best practices

Confidential

Oracle DBA

Responsibilities:

• Administered production databases as large as 4TB on a 4 node RAC installation (Sun SPARC machines), with 11 node application server and provided 24x7 support
• Handled 11.5.x to 11.5.10 point-release upgrades on several developments, testing and production databases
• Implemented shared APPL TOPs
• Upgraded specific tech-stack and applications component to the latest certified versions
• Troubleshot various Oracle apps related issues like login issues (Apache, Jserv), concurrent manager issues, forms tracing and FRD (Forms Runtime Diagnostics)
• Applied several one off application patches on a daily basis, RDBMS patches (Patching databases to the most current release levels), periodical security patches like CPU (Critical Patch Updates) patches on a quarterly basis and DST (Daylight Savings) patches
• Cloned 15 Apps Databases every week APPS databases using various technologies like BC technology, hot refresh, cold refresh, multi node system to single node
• Managed daily backups using Net backup and BC backup
• Developed a program using shell scripts and pl/sql to generate graphical reports for capacity planning
• Installed and maintained database monitoring tools like Auto DBA

Confidential

Agent Support Group

Responsibilities:

• Handled technical escalations in Portables, Wireless Networking, Router Configuration, Operating Systems (Windows XP, 2K)
• Trained technicians on ongoing and recurring technical issues
• Attended global HP conference calls for new product release, known issues and technical issues

Confidential

Technical Support Specialist

Responsibilities:

• Trained new hires appointed for tech support on Desktops, Portables, Operating system, Networking, new technologies, products launched, company’s policies and procedures
• Worked on technologies: Windows administration, hardware assembling and troubleshooting, setting up network - wireless, cross over & parallel cabling