Objective
To migrate the entire database systems to Microsoft Azure Environment as an IAAS and PAAS.
Client and Project Details
Sungard is a global Managed Services, Cloud, Data Centre Services, Networks and Security, Applications and Software, Business Continuity and IT Consulting Services. Provide Database Migration and Support Services.
The main projects which intellidb has worked is to migrate the database estates from on-premise to cloud environment
Requirements
- Sungardas requires intellidb to take care the entire migration support of database systems. Microsoft Azure is the primary cloud platform.
Solutions
- Migrated all of the legacy system of SQL Server to SQL Server 2006.
- Involved in performance tuning of SQL Server like the server configuration change and SQL Server objects tuning including the rewriting of stored procedures, views, Ad hoc T-SQL queries etc.
- Implemented ETL process, SSRS, SSAS Reports
- DTS to SSIS migration assistance provided to Microsoft Vendor
- Complete engagement for the Microsoft SQL Server Azure migration.
Results
- Delivered the projects based on the client requirements on time.
- Automate the alerts where the issue causes critical to the business
- Customer Service efficiently managed their clients without down time
- Cost savings achieved 50% compared to the on-premise.
Customer Benefits
We automated almost all the manual work and that has enabled to achieve a 70% reduction in staffing overhead.
We developed automation for the high availability environment to stay in the preferred node.
Performance of the system
As a result of the migration to the newer version, the legacy system issues, particularly slowness of database execution is completely eliminated.
About Us
IntelliDB – established in the year 2012 based in the heart of London – is a pioneer and leading provider of database managed services (cloud & on-premises) including Database Migration, Administration, Proactive Monitoring, Design and Development Solutions etc.
We provide services to many sectors such as Health Care, Government Organisations, Oil and Gas Industries, Broadcasting, Audit, Tax and Advisory, Automation IT Management Services, Marketing, Telecommunications and Financial Services.
Reach Us
E : info@intellidb.co.uk
T : +44(0)2036379142
Address:
20-22 Wenlock Road
London
N1 7GU
United Kingdom