One of the leading manufacturer of pharmaceutical products and having its subsidiaries in Europe, Asia, Africa, Australia, USA and Canada
Domain
Health Care
Geography
GLOBAL
Customer / Product
DB 18c, 12c , 11g R2
Technology
Oracle Enterprise Manager 11g/12c
Oracle Internet Directory 10g
Oracle Application Server 10g
SQLServer replication and clustering
Release Engineering / code migration
Bladelogic
Oracle APEX
Shell Scripts
Alerts
OEM
Datagaurd
Version
DB 18c, 12c , 11g R2
OVERVIEW
SCOPE / FEATURES
- Support of Over 250 databases in Oracle and SQL Server
- Support of Oracle Application server including Oracle OID
- Database sizes varying from 2TB to few 100GB’s
ACHIEVEMENTS / TAKEAWAYS
- Implemented Transperent data encryption.
- Set up high availability using Disaster Recovery site.
- All oracle databases were migrated to Linux
- Upgraded DB version to 12C
- Improved performance Monitoring using Support metrics
BENEFITS
- Improved Security
- Improved Transparency, Availability
- Standardization
- 20% Effort reduction using Support methodology
