SUMMARY:

• Oracle Exadata Certified Implementation Specialist
• OCP, MySQL 5.6 Database Administrator
• 20+ years of experience in Database Architectures, Administration & Support, Monitoring & Performance Tuning in Business Continuity settings that include Oracle Engineered System and Enterprise SAN & NAS
• Expertise in Oracle Real Application Clusters (RAC) on Exadata Database Machine using Oracle CRS, ASM and SCAN
• Expertise in Oracle GRID Control as a central command center to monitor databases & database hosts
• Extensive use of Oracle Recovery Manager (RMAN) & MySQL Enterprise Backup for backup and recovery of databases (RAC, non - RAC, singleton & replicated MySQL)
• Configured RMAN backups to Oracle ZFS Storage Appliance for Exadata Databases to improve backup performance and recovery to meet SLA (RTO & RPO)
• Expertise in replication technologies including GoldenGate, Active Data Guard and Materialized Views
• Extensive experience with MySQL as part of Open source eCommerce architecture - including systems clustering for high availability and integrations with Linux apache/tomcat and SOA products
• Configured MySQL Enterprise Monitor for InnoDB, disks, performance monitoring and alerts and find & fix expensive queries etc.
• Defined and Managed the development and implementation of overall data warehouse Architecture and System Design (e.g., ETL process, ODS, EDW, and Data Marts)
• Advanced use of Microsoft Standard & Enterprise SQL Server, including integrations with Tibco ESB
• Excellent Project Management and Presentation skills as well as coordination with third party support in an onshore/offshore outsourcing model

TECHNICAL SKILLS:

Database Systems: Oracle, MySQL, DB2, MS-SQL, NoSQL, CASSANDRA

Storage Systems: Exadata, EMC, HDS, NetApp, Nimble

Enterprise Servers: Linux, AIX, HP-UX, Solaris, Windows, VMware

ERP Systems: Oracle EBS, SAP, PeopleSoft

Middleware: Tibco ESB, SOA by Software AG, BEA Tuxedo

Backup and Recovery: Oracle RMAN, EMC SRDF/BCV, Netbackup, Commvault, Networker, TSM

Tools and Scripting: IBM-APM, HP OpenView, Quest Central, Erwin, BMC Patrol, Shell, Perl

PROFESSIONAL EXPERIENCE:

Confidential

Database System Architect

Responsibilities:

• Lead the initiative for a rapid assessment and migration planning of 35 databases to Oracle Database Appliance (ODA) and 75 databases to Oracle MiniCluster(Solaris) - to achieve desired level of cost control & risk mitigation
• Determine application context and impact
• Identify risks and plan for remediation with upgrade recommendations where needed
• Collect the processor, memory and storage requirements
• Examine the performance thresholds of current Red Hat implementations
• Validate the hardware costs and software licenses savings for the migration
• Ensure continuation of backups with EMC Avamar / DD Boost
• Optimize use of Oracle Data Guard for Disaster Recovery
• Update monitoring with Oracle OEM as appropriate

Confidential

Sr. Principal Engineer

Responsibilities:

• Developed and managed multiple Oracle Exadata deployments for a leading pharmacy store chain in the United States
• Applied quarterly patch in Exadata (Storage Server, Database Server & InfiniBand Switches) conforming with Oracle’s best practice
• Demonstrated and delivered technology roadmap for 10X performance of Oracle financial system designed around oracle EMC to Oracle Engineered system (Exadata). Solution engineered based on a comparative analysis of 3 alternatives: Linux Oracle on 3-PAR, Linux Oracle on ZFS and Linux Oracle on Exadata.
• Developed and lead Data Center (DC) consolidation (Oracle & SQL Server database) project for a leading money remitting organization
• Implemented VMWARE Site Recovery Manager (SRM) and EMC SRDF (Symmetrix Remote Data Facility) for disaster recovery and business continuity
• Configured RMAN backups to Oracle ZFS Storage Appliance for Exadata Database Machine
• Deployed & configured Oracle Exadata plug-ins for OEM to monitor health and performance of all components of Oracle Engineered System
• Worked closely with Oracle Support and deployed Oracle ZFS Storage Appliance
• Executed on behalf of a Semiconductor company to demonstrate a viable migration path from Linux/Oracle/EMC to Exadata platform
• Tasks were categorized in the following order:
• Analyzed Exadata Database Machine setup (ASM-volume, GridDisk, Flashcache etc.)
• Executed and documented database migration strategy to Exadata
• Run Exachk to identify any issue with database/Exadata setup
• Adjusted any parameters recommended by exachk utility
• Applied database patches
• Collected & analyzed statistics using Oracle AWR report
• Deployed multi-node & multi datacenter Cassandra clusters
• Used Cassandra-stress tool to benchmark schema performance, database scalability and production readiness
• Use nodetool to add/remove node/data center in a Cassandra cluster
• Worked closely with Data Architect to design conceptual, logical and physical Cassandra data model
• Setup consistency and replication factor based on client's business requirements
• Capacity planning
• Data load/unload to & from Cassandra databases

Confidential

Enterprise Manager

Responsibilities:

• Installation of Enterprise Manager 12c & 13c
• Upgrade/Migration of Enterprise Manager 11g to 12c (in-place and new installation)
• Best practice monitoring templates
• Configure OEM for alerting and performance trending

Confidential

Responsibilities:

• Consolidated/Migrated 11gR2 databases to 12c Multitenant Architecture
• Migrated Oracle databases (10.X & 11.X) to 11.2.0.4 on Exadata using combination of oracle tools/options
• Implemented of GoldenGate to replicate data between databases to provide minimal downtime for migration and rapid, no data loss, back out option
• Provided round the clock on-site support prior, during, and after database migration to address any issues that arose
• Worked closely with SA to configure and test DR site using VMWARE Site Recovery Manager (SRM)
• Implemented EMC SRDF (Symmetrix Remote Data Facility) for disaster recovery and business continuity
• Implemented Oracle Active Data for DR and to off-load production traffic for reporting

Confidential

Responsibilities:

• Upgraded SQL Server database from (2005,2008,2012,2014) to SQL Server 2016
• Configured SQL Server auto jobs for rebuilding indexes, updating database statistics and database & transaction log backups
• Implemented SQL Server mirroring for HA
• Implemented SQL Server Log shipping for HA and read-only database for reporting
• Implemented SQL Server Always ON for HA
• Migrated SQL database to Azure using Azure SQL Database Import & Export Service
• Deployed SQL Databases in AZURE
• Worked extensively with SQL Database Migration Wizard (SQLAzureMW) to analyze database before migration

Confidential

Manager, Database Administration

Responsibilities:

• Delivered a new framework for inter-dependent databases - DB2 on AIX & Linux, Oracle on Windows, MySQL on Linux and MS-SQL on Windows -, in support of Direct Marketing and Ecommerce solutions
• Worked with cross-functional teams while evolving the database schemas for customers, products, sales campaigns, order entry, correspondence systems, distribution centers, inventory returns, service-oriented architectures and ETL transformations
• Provided cost savings of $250K in the process of migrating DB2 from AIX to Linux platform, while establishing standards and processes for monitoring, tuning and recovery with the outsourced data center operations
• Established a high availability solution for Ecommerce based on .NET and Oracle on Windows with proper segregation of applications and databases on network segments as part of PCI strategy
• Architected GoldenGate (10.x and 11.x) replication solutions to facilitate data flow between OLTP & DW database
• Upgraded multiple databases from 9i to 11gR2 & 12c and implemented Oracle RAC as HA solution
• Established a DR site using oracle Data Guard and configured Data Guard Broker for one-click failover
• Partnered with systems team to reduce operational costs through refresh to newer server hardware and revised auditing of database (Oracle&DB2) licensed processors on the newer hardware platform.

Confidential

Senior Database Administrator

Responsibilities:

• Responsible for Oracle Database Administration
• Installed RHEL on HP blade servers
• Implemented a three nodes Oracle 11gR1 RAC on RHEL using CRS and ASM
• Integrated VERITAS NetBackup with RMAN script to backup the RAC database
• Implemented Fast Connection Failover (FCF) with JDBC Thin driver used by JBOSS middle tier app
• Implemented DR (Disaster Recovery) site managed by outsourced partner
• Architected GoldenGate (10.x and 11.x) replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments.
• Also responsible for SQL Server Database Administration
• Installed and configured SQL Server 2005 database on Windows 2003 server
• Configured SQL server database mirroring for High Availability
• Implemented database and transaction log backups using SQL server database agent
• Worked with developers to tune SQL queries using SQL Profiler
• Reorganized SQL server database datafiles using “ Detach and Attach” option in MS SQL Server Management Studio
• Provided MySQL Database Administration
• Installed and configured MySQL on RHEL in a Virtualized environment (VMWARE)
• Designed and implemented robust backup and recovery strategy based on business requirements
• Integrated MySQL database with Jboss and Tomcat application
• Implement MySQL replication for High Availability

Confidential

Senior Database Consultant

Responsibilities:

• Involved in several migrations and maintenance projects related to high-end Oracle databases.
• Reduced failover time from hours to less than 20 minutes by migrating a singleton 2.6 TB Oracle databases to Oracle RAC solution (for HA) on Windows 64-bit platform using Oracle ASM & CRS in conjunction with EMC SAN for storage
• Managed and maintained a 4 node LINUX Oracle 10gR2 RAC database. Used EMC SAN as backend storage and also has Physical Standby database in SunGard location as a DR site
• Instituted a reporting solution with a Logical Standby database created using HOT backup without any downtime to production database located in Texas. Integrated Data guard broker with Oracle Grid Control for one click switchover option and guaranteed database integrity.
• Upgraded Oracle GRID Control from 10g Release 2 to Release 4 and deployed Management Agent to over 120 servers (LINUX and Windows) using agent Download and Grid control’s deployments option worldwide through its leading international network of accredited campus-based and online universities.

Confidential

Database Architect / Project Manager

Responsibilities:

• Develop feasibility report and project plan for minimum service disruption.
• Develop a strategy for the migration and consolidation project
• Recommend hardware and software solutions for the project
• Analyze Ingres database
• Develop a project plan
• Oversee three offshore indirect report developers
• Mitigate any issue in timely manner without jeopardizing the project deliverables
• Conduct weekly and ad hoc meeting with offshore developers for the issues and progress of the project
• Provide weekly feedback to the stakeholder of the project
• Oracle 10g Real Application Clusters implementation including:
• Design Oracle10g RAC architecture
• Install & configure Oracle Cluster Ready Services (CRS)
• Configure the raw disks for Oracle RAC
• Installing Oracle 10g RAC software
• Configure ASM for RAC
• Implement Transparent Application Failover (TAF)
• Performance tuning for Oracle Real Application Clusters (RAC)
• Integrate RMAN with VERITAS NetBackup to Backup the RAC databases
• Oracle 10g Grid Control implementation
• Responsible for design and implementation of Oracle's Grid Control. It monitors over 100 targets, 3 RAC Clusters, 25 Databases dispersed all over the USA. Designed alerts and escalation procedures to match SLA of individual projects. Oracle versions range from 9.2.0.6 to 10.2.0.3.0
• Performed business case analysis for implementing Oracle RAC (9iR2) in a Linux (SuSe) environment using Polyserve Clustering for High Availability.
• Designed, implemented and supported data protection and disaster recovery architecture for 3 hub sites in a Hub-and-Spoke configuration for Pre-media mission critical databases with standby databases using Oracle Data Guard in Oracle 9i R2 environment. Setup Oracle database hot and cold backups using BCV volumes.
• Performed Oracle database server consolidation on HP Superdome for Peoplesoft HR, Peoplesoft Financials, Data Warehouses and Print Information Management Systems to reduce database license cost. Designed and implemented dimensional Data Warehouse database and used materialized views, function-based indices and table partitioning to boost performance of data warehouse database.
• Implemented Product Tracking system using Oracle FORMS and Report services with CGI / servlet options. Also included multi-tier implementation of client/server database applications and Oracle 9iAS.
• Configured Oracle Tuning, Diagnostics and Change Management Packs across multiple platforms - UNIX and Win 2000 and setup Oracle MTS for effective resource utilization. Tracked long running SQR using Precise (DB Tuner) tools as well as Explain plan, Oracle trace and Tkprof.
• Defined standards & procedures for DBA Services for the Development and Production environments. Lead the effort to upgrade all Oracle 8i databases to 9iR2 companywide in multiple environments (UNIX & NT). Applied patches and install software for Oracle databases and Unix Operating System. Installed and configured Oracle Designer 6.0 & Developer 6.0