LeapFrog Services

• Key member of the team which was supporting the eLearning Apps
• Multi Terabyte Environment with Data Guard Replication to Active Data Guard
• Quarterly Patching of Exadata , GI and DB Patches.
• Working with Oracle Engineers to support the Engineered Systems
• Identified many SQL Tuning Recommendations to application teams.

Fresh Direct 12c Migration & Ongoing Support

• Oracle Clusterware Support of Very Large Datawarehouse & Store Environments
• Mission critical warehouse operations having more than 1 TB
• Migrated a large set of Databases from 10g to 12c with acceptable downtime.
• Involved in Seamless upgrades of periodic Database Patches and fixes
• Transition of Legacy Servers to a new Data Center
• Set up monitoring of critical environments to ensure a friction less performance for large Data warehouses,
• Set up numerous Standby Databases for migration and activated them

ALDO – Store front Application Support

• End to End Support of Storefront application
• Customized tuning for high load market areas,
• Very Large Database replication of more than 4 TB

Fox Sports – AWS Migration

• Was involved in a team to set up AWS Instances and perform migration from Oracle RAC to Amazon RDS
• Ensured business continuity by performing a series of tests prior to going Live
• Set up Cloudwatch for AWS Monitoring and custom monitoring for specific checks.

Giant Tiger – SAN Migration

• Migration SAN from for Giant Tiger Production servers from legacy to IBM SAN
• Involved in a Live migration to new SAN with “Zero” downtime by making use of ASM rebalance features in Oracle ASM
• The new SAN technology helped Giant Tiger to facilitate SAN Snap backups and enabling snap’s to move to DR site

Star Health Insurance – 12c Fusion Middleware

• End to End Implementation of Claims DMS on Oracle Database, for Dev, Test , UAT and Production Environments SOA/BPM Environments.

Star Health Insurance Claims DMS Database Environment,

• End to End Implementation of Claims DMS on Oracle Database, for Dev, Test , UAT and Production Environments.
• Setup and Managed Shift Engineers to engage Day to Day Activities once Environment has been built.
• Engage in critical activities Escalations.
• Environment Red Hat Linux 6.2,VMWare 5, Oracle 11.2.0.4 RAC, Alfresco 6
• Duration : 3 years and ongoing support till date

Star Health Insurance Claims DMS DR Setup

• Setup Active Data Guard for Standby Read Only Use
• Manual Archive Log setup to perform DR Drills
• Duration : 1.5 years and ongoing support till date

Star Health Insurance DMS Monitoring Alerts

• Setup Active Data Guard for Standby Read Only Use
• Monitoring tools which does the following
• Identify Top Resource Intensive SQL and provide to Developers
• Find Pattern of Potential Problems and proactive monitoring of processes that run regularly
• OS Monitoring of CPU and I/O details every 5 minutes and hourly reporting
• Manual Archive Log setup to perform DR Drills
• Duration : 1.5 years and ongoing support till date

Star Health Insurance Premia Performance Tuning

• Identify Database Bottlenecks in Premia Core Insurance Application, Provide Alternative solutions for any possible issues, presented a Short Term Long Term Approaches to AVP IT and IT Infra Head, Solutions were taken and implemented.
• Environment Solaris M5000, Oracle 10.2.0.4, Oracle Application Server 10
• Duration: 3 Months

Star Health Insurance FLOFAX BLOB Migration of Data from DMS

• Identify selected BLOB Data of about 3 TB from One Environment to another using Data Pump utilities,
• Environment IBM x3650 RHEL 6.2 with Hitachi Storage, Oracle 10.2.0.3
• Duration: 2 Months

Star Health Insurance Environment Analysis of Premia Application Suite

• Environment Analysis of Premia Application by preparing a Clustered Network Diagram of all Interconnected Applications, Database and interaction with various 3rd Party Applications
• Environment Solaris M5000, Oracle 10.2.0.4, Oracle Application Server 10
• Duration: 2 Months

SallieMae Bank Oracle/PeopleSoft Administration

• Environment setup of SallieMae due to Company Split, set up all Oracle & PeopleSoft Environments from scratch to a new Data Center hosted by CenturyLink . Migration of Production to new Environment was done smoothly with Managed Delivery Process.
• Regular Support of Maintenance Pack/Bundles for Finance
• Environment -PeopleSoft 8.49 Finance Oracle 11.2.0.4 RAC
• Duration – 1.5 years and ongoing support

Parkview Hospitals Oracle/PeopleSoft Administration

• PeopleSoft HR Environment setup of Parkview MyHR, HRMS and PeopleSoft Finance, Regular Support of Maintenance
• Pack/Bundles for HRMS and Finance
• Environment PeopleSoft 8.51 HRMS PeopleSoft 8.51 Finance Oracle 11.2.0.4
• Duration – 1.5 years and ongoing support

DISYS/HAYS Oracle/PeopleSoft Administration

• Disys Environment setup of and PeopleSoft Finance,
• Regular Support of Maintenance Pack/Bundles for HRMS and Finance
• Environment PeopleSoft 8.51 Finance SQL Server 2008
• Duration – 2 years and support on going till date HAYSOracle/PeopleSoft Administration

markitSERVSybase to Oracle Migration

• Database Migration of Sybase to Oracle
• T SQL to PL/SQL Migration Performance Tuning of Queries
• Environment Oracle 11.2.0.2 Sybase ASE 15
• Duration – 3 months

Northern Trust Bank – Data Archival

• Archival of Several years data to abother database via PL/SQL 

ESI – SQL Tuning

SQL Tuning of Data Warehouse Queries, with the help of Partition Features and analytical SQL Functions. Identified Potential Bottlenecks in Database Parameters

Environment Oracle 11.2.0.1

Duration – 2 months