CLIENT: One Of the School Districts In California
CUSTOMER’S GOAL: Customer wanted to reduce the cost associated with support, maintenance and monitoring of their Oracle Database & Application Servers and at the same time maintain high availability of the systems for their users.
SCOPE OF THE PROJECT: Remote DBA monitoring agreement encompassed twelve (12) month commitment for remote administration of client’s Oracle Production Database with associated Application Servers and Web Servers.
Remote Administration Support includes following services:
- Monitoring & Supporting Database and Application Servers as per the SLA
- Initial configuration review and problem identification
- Installation of monitoring tool to proactively identify any issues with the database
- Installation of required patches
- Periodic performance analysis & identification of tuning activities
- 24/7-Oracle emergency support
- Reporting and resolving all serious Oracle alert log messages
- Quick response emergency support for production database outages
- Scheduling backups
- Restoring the database using the files provided by the Data Center networking team
- Twenty hours of custom DBA work on Oracle staging environment or client’s SQL server environment
- Support of the operating system environment
- Support of the Networking and Configuration tasks
- Upgrade/Migrate to new versions of database and application servers
- Data conversion and Data loading
- Performance Tuning
- Release Management
- Oracle on-demand DBA activities such as exports, dumps, additional backups, troubleshooting and installations
- Code development for backend activities using Oracle PL/SQL, PERL and other languages
- Oracle database schema modifications
- Database reorganizations and row re-sequencing for performance
- Migration of database objects
- User and security management
- Oracle data migrations and refreshing test databases
- New database setup and configuration
- Setup and installation of backup and recovery software
- Oracle disc architecture and disk load balancing
- Oracle SQL tuning
- Oracle design reviews
- Installation of the Multi-threaded servers
- Installation of Oracle Real Application Clusters RAC
- Creation of Oracle standby database and fail over databases
- Installing advanced replication
- Implementing change control procedures
- Implementing KEEP & RECYCLE pools
- Implementing multiple block sizes
- Building self-tuning database mechanisms
- Implementing automatic segment space management
- Implementing new database features
SOLUTION / VALUE ADDITION:
4iSoft looked for ways to automate the administrative tasks to reduce the cost and mistakes of manual intervention. We automated the job monitoring system and application release process for client’s production environment
4iSoft had highly proactive approach to database monitoring and support. We deployed proven monitoring tools to notify our DBAs of any bottlenecks in the database. With this approach, our DBAs could resolve the issues before affecting the business users.
DELIVER QUALITY ON TIME:
4iSoft uniquely combines requirement definition, visualization and management into a single 3-Dimentional” solution. This gives managers, analysts and developers the right level of detail about how this long term project should be designed and developed and maintained. By cutting ambiguity, the direction of development & support team is clear and the risk of poor outcomes is slashed. 4iSoft exceeded customer’s expectations by delivering all high volume complex reports on time and within budget. We have an excellent reference from this leading Third Party Administrator (TPA).
For a more detailed version or additional Case Studies please contact us directly.??
