Our team of Certified Oracle Database Professionals have been providing Database Administration and support since 2001. We manage support to Development, Staging and Production databases.

Areas of Expertise

• High Availability Solutions
• Scalability Solutions
• Setup Backup Strategies & Integrity Testing
• Database and Application Performance Tuning
• Capacity Planning

In addition to the above we have been involved in hundreds of installations, upgrades and migrations over the years.

Setup and Maintenance of High Availability Solution

We have recommended and implemented High Availability solutions based on the Oracle Edition, Hardware availability and requirement for disaster recovery. We have setup Standby servers and Databases to ensure zero data loss in the event of any failure. Changes can be transmitted from the Primary database to Standby database in a synchronous manner – enabling zero data loss, or in an asynchronous manner – minimizing any potential performance impact on the production system. This technology also provides an automated framework to switch over to the standby system in the event of a disaster or a hardware/data corruption on the production site, or even during planned maintenance.

Scalabiity Solutions – Real Application Clusters (RAC) setup , upgrades and migrations

To ensure that the Database servers are able to cope with increase in number of visitors and have no impact on performance, we have recommended and set up Scalability Solutions using RAC. We migrated the databases to new servers and converted them to RAC with two nodes in cluster. This has reduced the scheduled and unscheduled downtimes and there is better resource utilization.

We are handling RAC maintenance tasks which include checking of CRS Status, maintaining cluster settings, node configuration and maintaining votedisks , OCR devices & files.

Backup Strategies and Integrity Testing

Backup and recovery is one of the most important aspects of database administration. If a database crashes and there was no way to recover it, the devastating results to a business could include lost data, lost revenue and customer dissatisfaction. Whether companies operate a single database or multiple databases storing hundreds of terabytes of data, they share one common factor – the need to back up important data and protect themselves from disaster by developing a backup strategies and recovery plans. Whenever a databases is setup, we prepare optimal Backup strategies that is shared with the IT Support team for implementation. Backup Integrity testing is done on a regular basis in coordination with the Support team.

Database and Application Performance Tuning

The DBA team work in sync with the Application Development team to help them with tuning of queries. They also proactively studying the AWR reports to identify expensive queries that cause an impact on the server resources like I/O and CPU. These queries are then shared with the Development teams so they can be optimized.

Regular Database maintenance tasks are done on a regular basis to ensure that databases perform at optimal levels. Some of these involve regular rebuilding of indexes, table de-fragmentation etc. We use customized and standard monitoring tools to constantly monitor the databases for any performance issues. Constantly proactively monitor site responses and coordinate with the IT Operations Team to identify potential causes of failure. The DBA team also provides information to the development team on unusable indexes, disabled triggers , broken jobs etc.

To ensure no issues during peak hours , automated Comprehensive Daily Database Health Checks are done . Issues are addressed before start of business hours.

Capacity Planning

We handle Capacity Planning for Databases by studying the existing growth of objects in the databases and gathering information on the anticipated growth rate. Based on the disk free space availability the DBA team sends the server hardware requirement details (like storage) in advance to the IT Support team so they can plan accordingly.

Our Team of Certified Database Professionals have been successfully providing support to Development, UAT and Production databases by utilizing advance monitoring techniques in cloud infrastructure at super affordable cost.

Wisdom leaf provides best-in-class Database Support of Microsoft SQL Server databases on the cloud infrastructure that includes AWS and Rackspace.

We have wide experience in supporting different versions of SQL Server, starting from SQL Server 7 to 2014 versions, We recommend compatible and relevant infrastructure/hardware as per client requirement.

Migration assistance are given to different environment and versions.

Areas of Expertise

• Performance Tuning
• Capacity Planning
• Database and Server resource Management.
• High Availability Solutions
• Backup Strategies
• Disaster Recovery

Performance Tuning

Regular maintenance tasks are done to ensure that databases perform at optimal levels.

Some of the tasks include:-

• Optimizing and creating relevant indexes on a regular basis,
• Tables de-fragmentation,
• Query optimization and execution
• Checking queries and statistics using Profiler, DTA.
• Monitoring Server and Database resources.- we use Customized and Standard Monitoring tools to constantly monitor the databases for any performance issues.
• We constantly monitor site responses and coordinate with the IT Operations Team to identify potential causes of failure.
• Monitoring Server and Database resource utilization levels.
• Monitor SQL and Event logs.

Capacity Planning

Capacity planning is done by monitoring daily, weekly, monthly database and drive growth forecast. These forecasts are done by manual monitoring and checking daily Database File and Drive space reports.

High Availability Solutions

The different High Availability Solutions offered with different versions of SQL Server are:-

• “Always On” Failover Cluster Instances
• “Always On” Availability Groups
• Database mirroring
• Log shipping
• Replication.

Backup Strategies

• We have expertise in managing backups and prepare optimal backup strategies to enable our clients to recover up to the point of failure.
• Backup Integrity testing is done on a regular basis.
• We use 3rd party tools to encrypt the backups and move to the cloud.

Disaster Recovery

We have experience of recovering the Database and Server environment from scratch in the event of any disaster. Weekly and Monthly DR tests are performed on SQL Server to ensure reliability of the backups, check RTO(Recovery Time objective) . Regular integrity checks are done to make sure that the backup sets are valid.

We have been providing 24/7 application support since 2007. We have a dedicated Team of Database Professionals who can handle tight SLA schedules.

We have built a customized alerting tool that has been configured to send alerts from Applications to reach Cell phones.

We also have a custom built tool to archive information about alerts and their resolution. This information is useful for issue resolution if the same issue occurs again.

Along with Database Support, we offer 1st Level 24/7 application support to clients.

The different task includes:-

• Support Development Teams with new releases .
• Support Development Team for any DML activity as all updates to the databases are done by the Support team.
• Applications are monitored using monitoring tools with tight response time as defined in the SLA.