Siri InfoSolutions Inc

Short Cuts
For Consultants
  Arrow Success Story
  Arrow Schedule Meeting
  Arrow Information Request
  Arrow Submit Your Resume
  Arrow Refer A Colleague
For Clients
  Arrow Request for Services
In 2010, Srinivas Mandipudi has joined Masco Cabinetry as an development DBA (designer / implementer/ Supporter) for their need to support the implementation of Oracle EBS 12.0.4 instance and was one of the main Oracle Applications DBAs architecting behind the successful implementation of a clustered environment with 8 Node Application Cluster and 2 Node RAC. Here's the story.... As a known challenge in the industry, performance efficiency is one of the major sort out constraint even at Masco for a 2TB/OLTP/1200 UB/ASCP Database. Heavily customized ASCP application, high availability, Data Security, Large Data transaction Volume are among the top most concerns for this North America based company that have many distributed warehouses across the United States. Adopting to the trending technologies and bringing onboard tremendous background knowledge on Oracle Applications Implementations, Srinivas Mandipudi and the team of DBAs have worked towards the instance go-live. Oracle applications with OEM databases having 8 Node Application Cluster and 2 Node RAC was a successful implementation and went live in the month of Mar-2010. However, with the growing data for the critical ASCP system, performance improvements are still in the park. While the system is efficiently implemented with shared APPL_TOP, Load Balancing of the Database Nodes, Data Guard for High Availability and Disaster Recover, RMAN for scheduled encrypted backups, Srinivas as a production support/enhancement DBA, provided extensive tuning using JVM Tuning, PCP, Partitioning and Partition archiving, working in collaboration with Oracle Support to identify and implement indexes, utilizing tuning for ASCP performance improvement, Parallel Concurrent Processing and many other solutions as required. In addition, to the regular maintenance activities during 2 and half Years of his tenure at Masco Cabinetry, Srinivas has acted as a primary DBA for various standalone Oracle Databases and Oracle application Instances as well. Srinivas is proud to state that Success owned by the client Masco Cabinetry is an effort achieved collaboratively, with a well-rounded architecture and best practice implementations.