CASE STUDIES

  1.     Database Migration Seamless Application Separation : Leading Telecom Operator in APAC Region
  2.     DB Migration : Leading Telecom Operator in APAC Region
  3.     DB2 to Oracle Exadata Data Migration : Automobile Company in EMEA Region
  4.     Exadata Consolidation & Migration : Leading Airline Customer in US Region
  5.     Database Migration Transportable TS Migration : Telecom Operator in US Region
  6.     BIDW Platform refresh and DB migration from Sybase to SQL 2014
  7.     Report Automation leveraging SQL and SSIS : Leading Finance and Insurance client
  8.     DB2, Oracle DB Migration to Oracle on Exadata for State Owned Insurance Client in ANZ Region
Share on Social Sites

DBA Support

Know More
X

DBA Support

DBA support to ensure maximum availability of database at optimal cost:

The key DBA tasks include: 

Infographic Alt Text

Case Studies

  • Supporting 3 large Telecom companies, 2 in the US and 1 in APAC, covering more than 300 productions database across Oracle, SQL Server, Informix and DB2 ( MF and LUW) technologies.
  • Providing 24x7 on call DBA support for 2 large banks in APAC region and in the US.
  • 16x5 production DBA support and development database support to a major logistics company in Europe.
  • Proving 24x7 Oracle eBusiness suite administration support for a large Money Transfer company, a leading bakery and an earth movers manufacturing company in the US, with multi node Oracle RAC and Data Guard setup. 
Share on Social Sites

Database Health Check

Know More
X

Database Health Check

A 360 degree health check to identify and alleviate database bottlenecks

The database environment health check looks at the risks and competencies in elements surrounding the database including security, infrastructure, and work management processes. The health check also can provide insight into other IT areas where the Client could use additional Mphasis services.

Following are the three main areas covered in Database Health Check, depending upon the requirement:

Performance Health Check:

The Database Performance Health Check focuses solely on the technical efficiency aspects of one or more databases such as:

  • Database Configuration
  • Database Statistics
  • Object Configuration
  • Database Feature Usage
  • Capacity Management
  • Workload Management


Environment Health Check:

The database Environment Health Check looks at the risks and competencies in elements surrounding the database including security, infrastructure, and work management processes

  • Business Continuity
  • Data Security and Audit
  • Database Design
  • Backup and Recovery
  • Scalability
  • Work Management Processes
  • Storage Management


Application Health Check

The Application Health Check deals with the data, connectivity and other DB related areas from application perspective as given below:

  • Data Architecture
  • Data Quality
  • Data Life Cycle
  • DB Connection Design


Case Studies

A leading Telecom Company, the MF DBA team did a major Health Check and provided recommendations. Mphasis also implemented the recommendations resulting in significant reduction of MIPS.

Share on Social Sites

Data Migration / Database Migration and Upgrades

Know More
X

Data Migration / Database Migration and Upgrades

Seamless methods to migrate homogeneous or heterogeneous data or database with near zero downtime

 Mphasis DE offers Database Migration and Upgrade services for the following scenarios:

Database Migration as part of data center migration, database version migrations / upgrades

Seamless Data Migration / Seamless Database migrations ( near zero downtime) for large size and critical database which can be down for longer time.

  • Database / Database Server consolidation and Virtualization
  • Data Migration (Homogenous and Heterogeneous for Application Modernizations)
  • Data / Database migrations ( Homogenous and Heterogeneous ) for application re-architecture, Application Modernization and application database upgrades ( for e.g. . data migration for ERP application like Oracle eBusiness suite from version 10.x to 12.x )
  • For data re-host and replace scenarios


Data Migration Activities:

  • Data Migration - analyze, design, develop, test and execute Data Migrations for various Data source and destination combinations; with replication if required
  • Data Verification testing, Cutover Planning and Cutover.
  • Replication - install, monitor, maintain, performance tune Data Replication configurations using GoldenGate, Oracle Streams and other preferred tools.


Case Studies

  • Mphasis DE team architected the solution and executed migration of 11TB Oracle databases pertaining critical business systems from AU to NZ data center for a leading Telecom Company in APAC. The migration was done seamlessly (with very minimal downtime) by deploying Oracle GoldenGate
  • Solution-ed and executed migration of 20 TB BRM application database from BRM version 6.5 to 7.4 for a telecom company in APAC. Oracle GoldenGate was deployed
  • Oracle database up gradation was done in seamless way for major airlines in the US by deploying GoldenGate
  • Migrated 1 TB of data from mainframe DB2 database to Oracle database for a major telecom company in APAC. The migration was done using native database load / unloads scripts.

 

Share on Social Sites

Data Archive and Purge

Know More
X

Data Archive and Purge

Seamless purge operations to reduce cost and increase performance

  •     Data Purge for application database having large volume of history data to regain space and performance
  •     Increase performance up to 70% and make head-room for new business / work load
  •     Regain space up to 50% and eliminate on storage investments for future growth.
  •     Data Archive to retire-decommission legacy applications to cut cost on infrastructure, licenses, maintenance and data center costs.
  •     Keep data in low cost disk storage with high compression for reference
  •     Store data in open source database for reporting and regulatory compliance purpose


Technology and Applications

  • COTS
    • PeopleSoft
    • Siebel
    • Oracle ERP
  • Native DB Scripts for home-grown applications
  • HP App IO (formerly HP DB Archive)
  • Oracle GoldenGate


Case Studies

  • Mphasis DE team architected the solution and executed a seamless purge of business data from 5 TB Siebel database which is highly business critical for one of a Telecom leader in APAC. The migration was done with zero impact to production database. At the end of purge the database was brought down to 1.5 TB with 10TB storage reclamation.
  • Mphasis DE team designed and executed data archival project for a large Telecom company in APAC. It involved archiving 1TB data from Mainframe DB2 database to Oracle Database. The task was accomplished by using native database load / unload utilities.

 

Share on Social Sites

Data Architecture Assessment

Know More
X

Data Architecture Assessment

Assessment and road map for Next-Gen Data Strategy

The objective of this assessment is to provide a Data Strategy for the enterprise and define a roadmap for a desired state by identifying the gaps and providing the recommendations and best practices and to align data management as per the industry standards.

At the end of the assessment, based on the scope, a detailed report covering the following areas is presented :

  •     Data Management Assessment Report
  •     Data Lifecycle Assessment Report
  •     RDBMS Consolidation Assessment Report

 

Infographic Alt Text

 

Data Architecture Assessment Methodology:

  • Client and Mphasis core team identified
  • Data collection ( policies, standards, architecture documents, artifacts etc )
  • Survey templates circulated and responses analyzed
  • Interview and workshops with relevant stakeholders
  • Define and Agree on future state
  • Analyze gaps, draft recommendations and best practices
  • Socialize recommendations and roadmap
  • Draft final report and present


Case Studies:

One of the leading Life insurance companies in APAC region was seeking a solution provider with specialized experience in data architecture to do a comprehensive assessment and validation of their data management and data governance. Mphasis did a complete study and analysis of their data landscape and provided recommendations on their future state of their data governance and data architecture with a detailed roadmap, which was well received and resulted in multiple projects.

Mphasis DE performed a detailed data architecture study of one of the leading retailer in APAC region for their merchandising system. A comprehensive report including a solution to synchronize data between the central merchandising system and the retail store was provided.

OUR OFFERINGS

  • Image Alt Text

    Data Architecture

    • Data Architecture- Assessment,Consulting and Support
    • Data Integration
    • Master Data Management
    • Information As A Service(ODS, Master and Reference Data delivery)
    • Design and implement regulatory compliance requirements
  • Image Alt Text

    Information Lifecycle Management

    • Data Modeling and DB Design
    • Data Quality Management : Data Profiling & Cleansing
  • Image Alt Text

    DBA Support

    • DBMS Install, Upgrade, Security Patching, Version obsolescence
    • Leveraged and Dedicated DBA Support ( 24x7 on-call production DBA support)
    • Capacity and Performance Management
    • Performance Tuning (Database and SQL)
    • Database security and audit
  • Image Alt Text

    Data Migration and Database Migration Projects

    • Data migration across RDBMS
    • Design and implement high availability and disaster recovery
    • Seamless DB migration ( Data Center Migration, Infra upgrades, consolidation , application upgraded etc )
    • Server consolidation and Virtualization
    • Design and implement Replication