Success Stories
DBA support for a Leading Asset Management Firm improved from 8*6 to 16*6
Business Need
Providing DBA support for project Portfolio accounting management. DBA support is envisaged to resolve all the production related critical/ routine issue and provide high end resolution to clients, end user and Production support Team, for all applications jobs i.e. run against CPP (Consolidate Portfolio Position), CRD (Charles River Database) and PAM Accounting management applications of Production & QA environments.
- Understanding Project Support/ application
- Identifying hierarchy for escalation
- Reduce Escalation Time (between Japan & US)
- Skilled Resources (to understand Sybase, SQL & Oracle) for supporting the applications
- Software Installation of Oracle and patching databases system
- Creating databases on client request at New York servers
- Writing shell scripts, scheduling jobs
- Taking care of overnight databases backups, RMAN, Exports and Imports for Production ,QA & DEV environment
- In case of failure of any backup re-run the backup and escalate the issue regarding failure, to the Job owner
- Provide DBA help to production support team, in case of any job has issue related to job running long, hanging or performance
- Help Prod support in order to resolve the issue of databases and to meet their SLAs
- Writing, creating and managing all Documentation related to task performed daily, DBA Check list, DBA run Book and AIG-GIG Project applications information related to all process (CPP, CRD, PAM, ITI and GPS)
- Continuous support with DBArtisian & TOAD
- Schedule & write Unix shell scripts for database Jobs
- HCL have undertaken documenting each and every problem/ transactions
- Unbreakable production loads and less overnight process escalation with regards of databases and support developers across the globe
- Resolved critical issue during the initial phase of installation of oracle 10G for SAP project
- Helped Developers to re-design the code with performance tuning inputs to speed up their the Jobs by about 90%
- Escalation calls, intervention by onsite team reduced by 80%
- 12 months DBA support with out any Major Escalation or Issue.
- DBA Support from 8*6 is currently 16*6. To be extended to 24*7.
- The DBA support team has increased from 1 to 3 resources
- The DBA Support enable client to improve productivity and functionality in -
- Help Production Support to meet regular SLA with regards of each process
- Improved process loads and long term available support
- Support various applications over the night of EST thereby reducing escalations
- Stream lined process and database structures
- Lower cost operated Support
- Project Status Reports are generated for regular updation, not existing earlier
- Faster Time to market for enhancement and/or additions
