866-279-5692 Toll-free 613-212-5050
Business Challenges
The client was having trouble finding personnel to support the mainframe environment. They decided to move away from IBM mainframe environment into SQL Server and web based.net portals and applications.
Outcome
Koza technology architects and developers worked with internal development team to implement the SQL Server environment, to design the databases and to migrate data from DB2 to SQL Server. The .net developers got continues help and mentoring for optimized transaction SQL coding.
The client successfully implemented the transaction system on time as was planned together with third parties such as Goldman Sachs. Converting from IBM mainframe to Microsoft saved millions of dollars licensing and support costs. Further, the client was able to hire personnel to support the environment.
Business Challenges
Too much licensing cost for the SQL database environment.
Outcome
After reviewing the SQL Server Environment with around 100 SQL servers, a new enterprise level environment was designed.
- All of the servers for devteststgdemo environments were downgraded to developer edition.
- A new hosting cluster was designed for the specific needs of production SQL servers.
- Many changes were implemented in production environment to minimize the licensing cost.
The client saved $300k/year in SQL server licensing, by paying a consulting and implementation fee of around $30-50k.
Business Challenges
The client had too high licensing cost for the SQL database environment.
Outcome
After a two-week review the SQL Server Environment, many improvements to minimize the licensing was recommended.
The client saved $450k/quarter in SQL server licensing, total around $1 million annually.
Business Challenges
Server and database outages triggered a high available database management to support the web and internal operations 24 / 7.
Outcome
Koza was the managed database supplier of CBoC for 11 years. During the first year, we improved the database availability from 2-3 outages/week to no outage. We decreased the license budgeting costs and mentored the internal developers for best practices and standards.
Business Challenges
Slow running transactions causing business impact on the 2 most important business critical policy admin systems of a P&C Insurance company.
Outcome
During a 5-week assignment, Koza`s SQL Server expert identified many issues with the transactional applications and reported them in detail to C-level management. The client started a yearlong project to modernize and enhance the system. Koza database expert helped development team to improve the performance of the system, by upgrading the SQL servers, and by implementing a SQL change management including mentoring, code reviews and a technical approval process by Koza architect.
Business Challenges
The client had slow running transactions and ETL procedures causing business impact.
Outcome
During a month project, SQL server performance engineering practices were implemented. The databases were stabilized. Further analysis resulted in application improvements and ETL architectural changes to improve the system.