Production Support List

Oracle Production Support List

Managing ASM instance

Creating/Droping ASM Diskgroup if required to add/drop Storage in the Database

Monitoring and Managing ASM Diskgroup via “ASMCMD” or OEM Grid Control

Resizing Datafile/Tablespace if reaches threshold setting

Rebuild Tables, Indexes

 Production Support List

Apps Production Support List

Database Services( Instance and Background Process)
Listener Services
Forms & Web Services
Concurrent Manager and Report Services

Oracle DBA Consulting

SG has a skilled pool of highly experienced Oracle database administrators. Most of our DBAs are Certified Oracle Professionals and have average Ten years of database administration experience and are experts in planning and designing of Oracle database systems, basic database administration and proactive maintenance, backup and recovery, performance tuning, upgradation of databases, migration of other database to Oracle, cross platform migration of database, setting up and administration of standby database, replication, Oracle streams and Datagaurd, migration from parallel server to RAC, RAC setup and administration, iAS installation and administration etc.

SSG DBAs have proficiency in Oracle 7,8,8i, 9i 10g and 11g, Oracle Real Application Cluster (RAC) 9i, 10g and 11g, Oracle Internet Application Server (iAS) 9i and 10g.

DBAs at SSG have experience on most of the operating systems like Sun, Linux, HP-UX, AIX and Windows, which enables us to take up any kind of database jobs.

Database Support Service:

SSG offers different Oracle database support services to meet your exact requirements. SSG provides 24 X 7 support to your database or part-time service to assist your in-house staff. SSG offers customized support services to suit your requirements. Our standard support service includes the following database support activities

  • Initial and complete study of system
  • Continuous monitoring of database using advanced monitoring and alert tools
  • Routine health checks of database and proactive maintenance.
  • Emergency support for production outages
  • Guaranteed response to production outages (based on SLA)
  • Out of hours maintenance
  • Create and schedule the housekeeping jobs.
  • Regular database backups and validation of backups.
  • User and security management
  • Database growth planning and management.
  • Performance monitoring and periodic tuning.
  • Regular report on the activities performed and database health

    The database support service is categorized based on the mode of support offered

    Remote DBA Support: Remote DBA support service is becoming popular because of its low cost, enabling the customer to choose from among the experts across the globe for the best service. The service has proved to be reliable and guaranteed. The secured and reliable VPN connections are used to access your database, the security is further enhanced by SSH and password token technology. 

    On-site DBA Support: Our DBA will be stationed at your site to cater to your short-term project requirements. Such support is also provided as a stand-in service during holiday/sickness of your staff. You can utilize this service for few weeks to several months

    SSG offers different Oracle database support services to meet your exact requirements. SSG provides 24 X 7 support to your database or part-time service to assist your in-house staff. SSG offers customized support services to suit your requirements. Our standard support service includes the following database support activities

  • Database Upgrade & Migration Service:

    SSG has an expert team in database upgrades and migrations. We perform all kind of upgrades/migrations, which are supported by Oracle. We advise you to choose the best migration path and help you in planning. We take care from preparation to migration and backup of new database. SSG offers following type of services. However these can be customized to meet your specific requirements.

  • Upgradation to latest Oracle supported version
  • Cross platform migration
  • Application of patches (to fix bugs and security vulnerability)

    Please note that all the above can be performed either from offshore or onsite. 

  • High Availability Services with RAC:

    SSG offers RAC (Real Application Cluster) services for Oracle 9i, 10g and 11g database. Oracle RAC is very complex technology. Designing, installing, configuring and running RAC systems requires a skilled and experienced DBA with a sound knowledge of operating system and load balancing technologies. The deployment of Oracle RAC involves the following:

  • Determine the Oracle RAC architecture
  • Determine the Hardware sizing
  • Verify the hardware, OS and storage configuration and patch level
  • Configure the Operating System parameters as required by RAC.
  • Configure file systems, raw partitions and/or OCFS/ASM as necessary
  • Install Oracle Cluster Ready Services (CRS)
  • Configure CRS and Virtual IP (VIP)
  • Installation of Transparent Application Failover (TAF)
  • SRVCTL Configuration
  • Testing for load balancing
  • Testing the TAF for server, instance, VIP and Interconnect failover
  • Deliver complete document on RAC setup performed and basic administration
  • Post install support
  • Remote support and health check of RAC environments

    SSG has a team of experienced and dedicated consultants for Oracle RAC services and offers:

    Setting up of new Oracle RAC systems
    Migration of the existing database to RAC system
    Administration and support for Oracle RAC systems (remote and onsite)

  • Disaster Recovery & Business Continuity Solutions:

    Recovering the application and crucial business data is most challenging job in case of disasters or natural calamities. This obviously requires reliable disaster recovery planning. As always most of the companies plan for this, but lack in implementing the same. SSG assist those customers who want to run business with no worries of data protection. SSG offers disaster recovery & Business continuity services ranging from archiving the data to setting up the Oracle data guard, based on the criticality of data.

  • Understand the customer need for disaster recovery.
  • Recommend the best disaster recovery plan based on the criticality of data.
  • Implement the disaster recovery plan.
  • Validate the implemented disaster recovery plan.
  • Complete documentation of the disaster recovery setup.
  • Maintain and support standby systems.
  • Disaster recovery exercise.

  •  Offshore-Onsite Support
    Oracle Core - DBA support
    Remote DBA support
    Application DEA support
    Application Development     Support - Custom

     

    <<Previous Page Top^