Optimize data processing in the database, tune the system performance
Develop DB backup solution
Accomplishments:
The database size has been reduced by 60% by reclaiming unusable space
The data processing approach has been changed, implementing External Tables, to avoid unnecessary DB operations. This allowed to speed up data ingestion processes by 40%
A logical backup solution has been developed to suit the company’s target KPIs
Design a zero-downtime availability solution for an Oracle Exadata-based system
Accomplishments:
The existing backup solution has been reconfigured, decreasing backups footprint by 50%, while maintaining the required redundancy KPIs
A flexible business continuity solution has been developed, including several standardized service levels (Platinum, Gold, Silver) for different business applications
Sub-second RPO and sub-minute RTO has been achieved for Platinum service level, even for the most devastating failure scenarios
Migrate of 50+ TB Highly-Available OLTP database from Europe to Russia
Migrate the DB from IBM Power AIX-based servers to Oracle Exadata X7
Setup a high-availability solution, based on geo-replication between Russian and European datacenters
Ensure the migration downtime window to be less than 4 hours
Migrate Weblogic-based enterprise application
Accomplishments:
Highly-available, scalable architecture has been developed, comprising Oracle RAC, geo-distributed DataGuard system, Cascade Active DataGuard for offloading reporting workload
A custom two-phase migration approach has been developed to ensure downtime windows of less than 4 hours
The migration solution based on XTTS for Phase One and on Data Guard switch-over for phase 2
The migration procedure has been scripted to minimize the downtime and manual work
The load testing plan has been developed, using Oracle Database Replay
The solution has been implemented within 4 months, meeting the deadline requirements
Migrate 200+ enterprise databases from a variety of platforms (AIX, HP-UX, Linux), consolidating them on Oracle Exadata X7
Upgrade legacy DB versions in the process of migration, from versions 9i, 10g, 11g to 12c
Set up Disaster Recovery solution
Conduct performance optimization as per Exadata best practices
Accomplishments:
We have developed a flexible migration plan to be able to adjust the migration approach for each DB’s specific requirements
Migration approaches list included Oracle DataGuard switchover, Oracle Data Pump migration and Oracle RMAN duplicate
The migration process have been scripted to minimize downtime and optimize work
All database have been migrated to Exadata servers
Disaster recovery solution has been designed and set up, comprising Oracle RAC, Oracle Data Guard with standby databases on a dedicated Exadata system, and Oracle RMAN backups
Technologies:
Oracle Database 9i, 10g, 11g, 12c
Oracle Exadata X7
Oracle Grid Infrastructure
Oracle Real Application Clusters
Oracle DataGuard
Oracle RMAN
Oracle Data Pump
HP-UX
AIX
RedHat Enterprise Linux
Workload:
15.000 hours
Migration team:
3 x Senior Oracle Exadata Administrator
Senior Oracle Database Architect
Project Manager
Support team — 24×7 coverage:
Rotation shift member: 8 x Senior Oracle DBA
Rotation team leader: 4 x Senior Oracle Exadata Administrator