Skip to content
SPEC INDIA

SPEC INDIA

Request a Quote
Menu
  • Services
      • Custom Software Development
      • Enterprise Mobility
      • Technology Consulting
      • Business Intelligence & Analytics
      • On-Demand Team
      • Product Engineering
      • Legacy App Migration
      • Software Testing & QA
      • SLA Driven 24/7 Support
  • Technology
      • .NET core
      • ASP.NET
      • Java
      • Power BI
      • Tableau
      • Pentaho
      • DevOps
      • IoT
      • Beacons
      • Fullstack
      • MEAN Stack
      • React
      • AngularJS
      • NodeJS
      • VueJS
      • Kotlin
      • Swift
      • React Native
      • Flutter
      • Python
      • ML
      • Big Data
      • Salesforce
      • R
      • AI
      • Azure
      • AWS
    • Our Innovation

      Hire highly-skilled on-demand teams to build sustainable, secure, and strategic digital solutions.

      Let's Connect
  • Industries
      • Retail & FMCG
      • Healthcare
      • Supply Chain & Logistics
      • Education
      • Manufacturing
      • Advertising
      • Travel & Hospitality
      • Media & Entertainment
      • Energy & Utilities
      • BFSI
  • Business Solutions
      • Custom Mobile ERP
      • Mobile Sales Force Automation (SFA)
      • Enterprise CRM
      • Warehouse Management System
      • Enterprise Service & Maintenance Solution
      • Vehicle Tracking System
      • Help Desk Management System
      • Laundy Management System
      • Spot Billing System
  • Our Work
    • Case Study
      Live BI Visualization
      Portfolio
  • Company
      • Overview
      • Quality Policy
      • GDPR
      • Testimonials
      • Life @ SPEC
      • CSR
      • Events & News
      • Engagement Models
      • Project Execution Models
      • Contact Us
      • Career
      • Blog
CLOSE

SQL DBA Services For Largest Container Terminal Operators

SPEC INDIA/Case Study/SQL DBA Services For Largest Container Terminal Operators

About the Customer

Industry: Shipping & Logistics

The client is one of the largest container terminal operators in the world. It operates over 70 ports and terminal facilities in 40 counties across five continents.

With the global presence in 55+ countries, they have access to the main shipping lines and immediate access to a rich hinterland and key markets in northwest India. It is a multi-cargo port and terminal operators handling containers, bulk, liquids including petroleum products, chemicals, edible oil, bitumen, LPG cargo, and RoRo cargo. In 2017, it handled the 100,000th Auto Unit which is considered as a key milestone in just 20 months.

Key Challenges

One of the primary functions of the client is import-export of goods through the vessels & train. They have 24*7 business critical application running on almost 1TB SQL database and nearly 10 other SQL databases & applications running on SQL server platform. Applications running on these SQL server databases are accessed worldwide.

  • One of the major problems the client was facing is poor SQL server performance
  • The application was running slow due to fragmentation of indexes in the database
  • Also, there were no automated Full & Transaction log backups due to which log file was getting full at times leading to the unnecessary outage
  • They also could not afford downtime and they were in search of a solution to optimize the performance of the database/application and carry out the necessary on-going maintenance
  • The need of 24 x 7, proactive maintenance & DBA monitoring of SQL databases

Our Solution

Post engagement of SQL DBA services with the client, our team carried out routine Database Administration with a focus on uptime & compliance.

  • Performed extensive fragmentation check on the databases & tracked the fragmented indexes
  • Rebuilt the fragmented indexes & optimized the performance of the application
  • Initiated the process of performing a weekly SQL health check of all the SQL databases to find any loopholes/issues
  • To avoid the downtime scenario, our team started the process of Online Rebuilding fragmented indexes biweekly, based on the need of the situation
  • Configured Maintenance Plan for automatic scheduling of database backups to have a point-in-time recovery of the databases whenever required
  • Considering the criticality of 24*7 operational database, our team suggested Log Shipping of SQL database & configured it on client’s DR site for higher availability
  • To avoid any application outage, our team was capable of making secondary DB server as primary one in case of downtime
  • Performance Monitoring and Tuning using inbuilt tools
  • Isolated performance problems and identified bottlenecks along with troubleshooting of day to day SQL Server issues
  • Automated & scheduled SQL Server Agent Jobs for DBA tasks
  • Ensured platform uptime & response times within proposed SLA

Tools & Technologies

Business Benefits

SPEC India’s successful engagement of DBA services benefited clients in the following ways:

  • Active DBA monitoring of 12 Production DB Servers consisting of 12 SQL databases
  • 24*7 smooth operations of vessels & shipping
  • Performance of their business-critical application has been increased immensely
  • Automation of the scheduled backups has overcome the problem of point-in-time recovery of the databases
  • A configuration of Log Shipping at DR site has addressed the need for Disaster recovery
  • No more worries related to downtime of the business critical application
  • Weekly & monthly reporting of the databases has provided statistics on the status of client databases including figures like the growth of data over that period
  • Bottlenecks & showstoppers are stopped in advance prior to their occurrence



SQL DBA Services For Largest Container Terminal Operators


    Please prove you are human by selecting the Flag.

    Contact Now

      Please prove you are human by selecting the Heart.

      Safe & Confidential

      INDIA

      “SPEC House”, Parth Complex, Near Swastik Cross Roads, Navarangpura, Ahmedabad 380009, INDIA.

      +91-79-26404031, 32, 33, 34

      [email protected]

      USA

      “SPEC Partner", 350 Grove Street, Bridgewater, NJ 08807, United States.

      +1 908-450-9862

      [email protected]

      Services

      • Custom Software Development
      • Enterprise Mobility
      • Business Intelligence And Analytics
      • Web Application Development
      • Mobile App Development
      • UI / UX Design
      • Technology Consulting
      • Cloud Deployment
      • DevOps

      Quick Links

      • Blog
      • Career
      • News
      • Life @ SPEC
      • Case Study
      • Newsletter
      • Contact Us
      • Sitemap
      • Privacy Policy
      • Terms of Use
      • Tech in 200 Words

      © 2021 SPEC INDIA. All Rights Reserved.

      DMCA.com Protection Status

      Request a Quote

        .doc, .docx, .pdf, .xls, .xlsx, .jpg and .png files with 5MB size allowed.

        Please prove you are human by selecting the Car.

        Safe & Confidential
        We use cookies to enhance your user experience. By continuing to browse, you hereby agree to the use of cookies.
        To know more; visit our Privacy Policy & Cookies PolicyAccept and Close
        Privacy & Cookies Policy

        Privacy Overview

        This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
        Necessary
        Always Enabled

        Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

        Non-necessary

        Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

        Scroll Up