|
|
 |
|
 |
| |
Some Case Studies for
DBA & Production Support
|
 |
|
|
|
|
Services  Offerings DBA / 24x7 production support |
|
Successful operation of large and critical business applications requires 24x7 monitoring of databases and operations support. India is ideally suitable for US/Canada nighttime DBA and operations work. KMG has operations offices located across multiple locations in India. This not only provides ideal setup for DBA and operations jobs but also provides required redundancy, essential for failover mechanisms required for such mission critical jobs.
Database Administration (DBA)
KMG has a team of Database Administrators (DBAs) working round the clock for Canadian customers and US. KMG DBAs have following skills:
 |
Oracle, SQLServer, DB2, Sybase. |
|
Monitoring, backup, recovery, space management, DB patches, DB job running |
|
Monitoring of mainframe jobs on CA-7 |
|
Cold Backup, Logical backups, Hot Backups etc |
|
UNIX shell scripting knowledge essential especially for databases on Solaris, HP-UX, AIX, |
|
Linux |
|
Windows administration, batch jobs |
|
Database mirroring |
Production Support
KMG has teams managing operations of large enterprise applications. This work typically involves:
|
Running of batches on UNIX, AS/400 and Mainframe environment |
|
Sanity Checks of application environment before US/Canada day starts |
|
Monitoring of batch jobs running on UNIX, AS/400 and mainframes |
|
Corrective measures and escalation in cases of job failures, ABENDS |
Resources
KMG has a team of DBAs spread over KMG's New Delhi, Bangalore and Kolkata offices. Oracle DBAs are OCP certified while SQL DBAs are Microsoft certified DBAs.
Production Support staff comprises of certified AS/400, UNIX and Mainframe operators.
| |
|
|