Project goals:
- Upgrade Oracle database from 11.2.0.4 to 12.2.0.1
- Migrate the database to the new high-end server
- De-fragment and consolidate data within the database to reclaim space and improve performance
- Implement In-Memory database option
- Implement Multitenant database architecture

Accomplishments:
- The upgrade and migration has been performed, meeting 1 month project deadline
- Meeting such a tight deadline became possible because of merging the upgrade and migration activities under one Oracle DataPump export/import process
- Complex post-migration ETL performance issues have been resolved, by optimizing target configuration DB parameters
- Multitenant and In-Memory options have been implemented
Technologies:
- Oracle Database
- Oracle Database Multitenant option
- Oracle Database In-Memory option
- Oracle Enterprise Linux
Workload:
Project team:
- Senior Oracle Database Architect
- Senior Oracle DBA
Client’s feedback:
«UCGP Consult is one of the best Oracle teams I’ve met, and I’ve worked with many. Their knowledge levels are incredible, feels like they can answer any question and solve any problem. They solved our slowdown issue and we can recommend them to anyone who is dealing with complex projects and big data.”
Project goals:
- Migrate the whole client’s enterprise ERP system to new virtual servers
- Optimize system performance on the target platform

Accomplishments:
- The main challenge turned out to be low network bandwidth between the source and target sites
- The issue was addressed by using a custom copy approach, that allowed to compress data before sending it over the network and uncompressing on the target system – all in one data pipeline
- System performance has been optimized, allowing the solution to use 30% CPU less resource after the migration, and using all virtualization benefits
- E-Business Suite clone process has been scripted to minimize downtime to less than 6 hours for two interconnected EBS systems
Technologies:
- Oracle Database
- Oracle E-Business Suite
- Oracle E-Business Suite Advanced Supply Chain Planning
- Oracle Discoverer
- Red Hat Enterprise Linux
Workload:
Project team:
- Senior Oracle Database Architect
- Senior Oracle DBA
- Senior Linux Administrator
Client’s feedback:
«All communications with UCGP Consult were pleasant, the project was finished on time despite outdated software and all the difficulties it inevitably brings. Highly skilled professionals, always ready to help, very likely will hire again. Thank you for your work!»
Project goals:
- Conduct an Oracle license audit of over 300 database systems
- Identify and report on possible Oracle license breaches in the system
- Identify suboptimal license usage
- Develop and implement a plan to remediate licensing issues

Accomplishments:
- A thorough audit of license usage and breaches conducted
- 12 major license issues were identified, including both one-time and regular cases of unintentional licensed feature usage
- 8 cases identified, where the usage of licensed features does not provide any business value
- A plan has been developed, to remediate the issues and optimize the systems, minimizing the system impact
Technologies:
- Oracle Database
- Oracle Licensing
- Oracle Database Multitenant option
- Oracle Database Tuning and Diagnostic packs
- Oracle Database Advanced Security option
- Oracle Database Advanced Compression option
- Oracle Database Real Application Clusters
- Oracle Database OLAP
- Oracle Database Advanced Analytics option
- Oracle PL/SQL
Workload:
Project team:
- Senior Oracle Database Architect
- Oracle Licensing Expert
Client’s feedback:
«The project has been completed perfectly. UCGP Consult employs very skilled Senior DBAs with a proactive approach and professional attitude. Will hire again!»
Project goals:
- Perform a health check of the university learning management system
- Identify and report on any sort of technical issues and misconfigurations
- Develop and implement a plan to remediate the issues

Accomplishments:
- System health check has been performed for all technology layers: OS, DB, Middleware, Application
- 37 major issues has been discovered, 6 of them identified as “Critical”
- A plan has been developed, to remediate the issues, minimizing the system impact
- The plan has been successfully executed, increasing the system scalability by 40%, improving security and minimizing risk of unplanned downtime
Technologies:
- Oracle Database
- Weblogic server
- Oracle Apex
- Oracle Rest Data Services
- Oracle Forms and Reports
- Oracle Fusion Middleware
- Oracle Discoverer
- Red Hat Enterprise Linux
- Microsoft Windows Server
- Apache Tomcat
- Ellucian Quercus
Workload:
Project team:
- Senior Oracle DBA
- Senior Oracle Middleware Administrator
Client’s feedback:
«UCGP Consult has greatly increased our system stability and robustness. Now we are confident that our environment is free from issues and is configured according to the best practices. Thank you, Ilya and UCGP Consult!»
Project goals:
- Design Oracle Cloud architecture to host a database solution, comprising 5 enterprise databases
- Cost-optimize the solution
- Develop and plan the migration approach

Accomplishments:
- Business requirements analysis has been conducted to scope the project and define clear KPI for the new cloud system
- Cost-optimized, scalable Oracle Cloud solution has been designed, ready for deploy and migration
- The solution implementation approach and plan has been developed, to minimize the downtime and expedite the migration to meet the 3-months project deadline
Technologies:
- Oracle Database
- Oracle Cloud
- Oracle Database as a Service
- Oracle Real Application Clusters
- Oracle Infrastructure as a Service
- Oracle Exadata as a Service
Workload:
Project team:
- Senior Business Analyst
- Oracle Cloud & Database Architect
Client’s feedback:
«Alexander is an extremely skilled architect. He has designed the whole database solution for us and, together with his team, has led the project to a successful implementation. Thank you, Alex, thank you UCGP Consult, will definitely hire you again! It has been a pleasure working with Alex and his team.»