| Futurism provides remote DBA services for our clients as part of our suite of Managed services. Currently we have Remote DBA services for IBM DB2, Oracle, MS SQL & Sybase databases. We offer 24x7 premium services to augment your team of database administrators – to ensure round-the-clock support.
Our services include:
- Database status monitoring
- Collect performance and resource metrics
- Automated performance decisions of collected metrics
- Notification of system alerts due to performance, Availability and Resources
- Scan system log files
- Verify Backups
- Professional DBA support
- 24x7 DBA monitoring and 99.9% uptime of data
- Daily and Weekly report generation
- Onsite Installation and Technical DB support
- Our focused offering in DB2 DBA services include:
Database Design:
- Schema design and Schema design changes
- Conceptual data design (ER - Diagrams)
- Logical design and Physical design
- Normalization of Tables
Tuning:
- Designing Locking and Concurrency strategy
- Snapshot Monitoring and Event Monitoring Techniques
- Tuning Database Parameters
- Performance Monitoring through db2pm
- SQL Monitoring through db2explain utility
- Explaining different logs like db2diag. log, db2 alerts, db2 traces, db2 dump files and db2 trap files for better performance
Installation and Configuration:
- Installation of db2 on different platforms like Linux, Aix, Sun Solaris, and OS/390.
- Resolving the Installation issues for better performance.
Capacity Planning
Backups and Recovery:
- Crash Recovery, Version Recovery, Roll forward recovery with Unix built-in scripts.
- Problem analysis and resolution activities in all aspects of the recovery of the database.
- Proven recovery strategies for better recovery of the databases.
- Automated scripts for all backups and recoveries.
- Trend analysis Report:
- Through automated scripts, we will maintain a close watch on all aspects of database functionalities like Buffer pool Monitoring, Table space monitoring, on different configuration parameters, hit ratios...etc
- Automated Scripts for all Trend analysis factors with different colors to show the priority or criticality of the system parameters.
- Automated Reports will be generated and sent to concerned people through emails.
We are glad to say that we service Enterprise customers for our remote DBA services. We can provide consistently top quality and reliable DBA services based on our expertise in providing database services and the expertise we have developed in providing services from our Data Centers. |
