Database Services - Datapipe

Database Services

Datapipe’s Database Management service encompasses all setup, management, and maintenance activities for clients’ database servers, and includes OS and database application support. Certified Database Administrators (DBAs) improve performance through optimized database design, tuning, and troubleshooting services. Additionally, this service includes proactive monitoring, reporting, and support for environments on approved systems.

Datapipe’s Database Management team can design and architect a solution based on a client’s specific needs and on a variety of infrastructure including dedicated physical hardware or a Hosted Private Cloud at any of Datapipe’s global data centers or utilizing and integrating with AWS or Azure public cloud resources.

Datapipe is an Oracle Gold Partner, a Microsoft Gold Hosting Partner, an AWS Premier Consulting Partner, a MongoDB certified partner and a DataStax Silver Certified Partner among others. Datapipe’s partnership with leading database suppliers and platforms allows it to provide users with the highest level of support with leading technologies.

Datapipe’s deep database expertise has included engagements with enterprise clients where Datapipe manages the key components in global architectures. These include solutions utilizing AWS Direct Connect and Datapipe hosted highly available Oracle RAC database clusters and SQL server clusters to provide a complete hybrid solution coupling the AWS cloud with Datapipe’s managed services and dedicated equipment. Datapipe hosts and supports enterprise databases for multi-node HA designs and is able to meet a wide variety of use cases.

MANAGED SQL DATABASES

Datapipe supports MySQL, Microsoft SQL Server, DB2 and Oracle databases running on cloud or dedicated infrastructure providing a comprehensive plan, build and run process. Running Oracle RAC environments can be a complex task for enterprises. Datapipe expert Database management team assists clients on designs with their depth of knowledge on Oracle products and database clustering and associated technologies. Whether those solutions are running on Solaris, Windows or Linux/Unix Operating systems, Datapipe experts can design and support a wide variety of solutions. The Database services section below provides a description of the service provided on these technologies.

MANAGED NOSQL DATABASES

Datapipe supports NoSQL database deployments for its clients ensuring the performance, scalability, security and availability meets enterprise level requirements. Datapipe experts can assist clients in designing, architecting the complete stack of the solution from the network to the database. Datapipe supports a broad array of platforms to design a solution to meet client specific requirements. Datapipe’s partners with Datastax to offer an enterprise grade production ready Apache Cassandra offering and with MongoDB to offer a fully supported and monitored MongoDB solution.

Enterprise grade solutions provide fully supported software with comprehensive vendor support, training, best practice guidance and escalation support for timely problem resolution along with service level agreements (SLAs) providing an enterprise the governance and environment stability they expect. Datapipe’s partnerships with leading vendors allows its clients to take advantage of this higher level of expertise and guidance in designing and supporting these leading databases.

MANAGED BIG DATA SOLUTIONS

Datapipe Big Data solutions combine global network connectivity, a robust enterprise grade infrastructure, and global data centers with big data software for a comprehensive managed solution that can be customized to meet specific client requirements.

Datapipe Database Services

Database Management consists of the following services:

  • Storage architecture
  • Software installation, patch application, and upgrades
  • Database administration and maintenance
  • Capacity planning
  • Database security management
  • Clustered (High Availability) solutions with no single points of failure
  • Database replication
  • Auditing assistance
  • Managed End-to-End (E2E) onboarding and migrations
  • Data warehouse architecture and maintenance
  • Performance tuning 
  • Data rescue service
  • Database restoration service
  • Cold backup, hot backup, and data export
  • Disaster recovery service
  • Database modification services
  • Connection management
  • Monitoring and event notification
  • Slow query detection and analysis
  • Index maintenance
  • Statistics gathering
  • Modification and configuration Services
  • Memory utilization recommendations

Storage Architecture

In order for databases to properly function, it is critical to plan and deploy databases on a proper storage underpinning. Ensuring proper disk storage implementation allows for the isolation of performance bottlenecks. DBAs are responsible for separating the OS from the database disk layer, separating the database from the backup disks and isolating I/O bottleneck areas to discrete disk diskstorage that can be tuned for the required workloads. These tasks are performed on SAN and local storage.

Software Installation & Configuration

Proper installation and configuration of essential software is critical for database functionality. DBAs install and configure the necessary software for a variety of databases.

Administration & Maintenance

To maintain optimal database performance throughout the lifetime of client solutions, Datapipe’s certified DBAs research, track, and/or apply vendor database software patches; assist with data migration from development to quality assurance, and from quality assurance to production; perform and monitor database backups; apply database changes at the client’s request; monitor and correct health issues; and employ reporting and analysis services.

Capacity Planning

DBAs apply their experience and training to help clients determine their potential storage needs. Administrators work collaboratively with clients to design and deploy database infrastructure that can be scaled up with new demands (as opposed to a rebuild), identify disk space shortages and recommend workarounds before they impact normal operations, and assist with determining when RAM or CPU upgrades will benefit overall DB workloads.

Security Management

Datapipe’s advanced security and encryption services can help protect the integrity of client databases and comply with third-party security standards.

DB Clustering (Also Called High Availability)

DBAs are proficient in designing high availability solutions using a variety of clusters.

Auditing

Datapipe provides customized vendor-supplied auditing features to assist client compliance objectives.

End-To-End Onboarding process

Migrating databases can be complex, time-consuming, and costly if not executed properly. Datapipe DBAs analyze, capture/recreate clients’ existing requirements (as a part of “go-live”), and facilitate clients’ in-house database(s) migrations to Datapipe facilities, non-Datapipe hosted database(s) including AWS, migrations to hybrid connected platforms and vendor-to-vendor migrations (e.g. Oracle to Microsoft SQL-Server).

Data Warehouse Architecture & Lifecycle Management

Due to the complexity of managing large databases, clients often need assistance with data warehouse management. Unlike small databases, a warehouse requires massive amounts of storage and data lifecycle management. Datapipe designs solutions so that the most recent data is located on fast storage, older data on mid-tier storage, and the oldest data on low-cost storage. This optimization of resources allows clients to take advantage of multiple drive speeds while allocating resources efficiently across their spectrum of needs.

Backups & Export

Hot backup, a backup performed while the database is running, is included in this service. An export is a conversion of a database to a text file for maximum portability. Backup and export tools include:

  • Oracle RMAN (Recovery Manager) to perform and monitor hot backups
  • EXPDP (Export Data Pump) to automate schema exports
  • DB2 database, tablespace and incremental level backups
  • DB2move to automate schema exports


Restoration & Recovery

Datapipe DBAs have the expertise to recover databases from crashed states or storage failures.

Data Rescue

If a user deletes important data, Datapipe can restore the database using the backup files to an earlier time on another server to recover that data. Clients require redundant database hardware to benefit from this service.

Modification & Configuration Services

Though clients are responsible for database content, Datapipe performs modification and configuration tasks in accordance with explicit client instructions.

Connectivity Management

DBAs manage connectivity between the client application and database(s) in order to ensure efficient and uninterrupted communication. Utilizing Oracle, MSSQL, DB2 and MySQL performance tools, administrators can identify database tasks that are not tuned for optimal performance. Datapipe assists clients in designing connection pooling strategies to maximize usability of their database infrastructure. This service can be provided as an initial design requirement or on an on-going basis.

Event Notification

If threshold warning levels exceed a critical parameter, an alert is sent to the monitoring system. Based on the specific alert, a ticket is created that notifies the Support Team as to when the client needs to be contacted. Datapipe collaborates with the client to resolve problems within an agreed upon timeframe.

Database Reporting

Databases are configured to generate reports that provide clients with real-time status updates for their databases and associated content.