Specialized IT Services focused on Data Management | Speak with Us  877-634-9222

Database Practices
Delivering 24x7 Expertise
For a deeper look into the technical depth on any of Datavail’s practices select the database that interests you below.

Microsoft SQL Server

Complete, technically deep, operationally sound SQL Server support.
Datavail provides deep technical support and development on all components of SQL Server
Database Support
Development Services
  • Replication (Transactional, Merge & Peer to Peer)
  • SQL Server in a Windows Cluster
  • Reporting Services Support
  • Analysis Services Maintenance: Maintain cubes or dimensions
  • SQL Server Integration Service (SSIS)
  • Database Mirroring
  • Query Tuning including T-SQL
  • SQL Server Always On
  • Index strategies
  • Backup Tuning
  • Table Partitioning
  • Security: Analysis & Mitigation of superfluous users
  • Service Pack and CUP Installation
  • Best Practices: Health Checks & Tuning of Parameters
  • Service Broker: Ensure optimal settings
Migrate Database Platforms
  • Move databases
  • Oracle & MySQL to SQL Server
  • ETL to SQL Server Integration Services (SSIS)
  • Reporting Tools to SQL Server
  • Reporting Services
SSIS – SQL Server Integration Services
  • Upgrade from DTS to SSIS
  • Code rewrites
  • New package creation
  • ETL for Datawarehouse loads
  • Tune existing packages
SSAS – SQL Server Analysis Services
  • Upgrade old cubes to the latest version of SQL.
  • Create cubes to satisfy specific business needs
  • Analyze large amounts of data to find trends.
  • Evaluation of existing Cubes/DataWarehouse
  • Enhance functionality of cubes by consolidating and using MDX to execute functions
  • New reports from SSAS/MDX
SSRS – SQL Server Reporting Services
  • Convert from other reporting tools to SSRS
  • Create new reports
  • Integration into SSAS
  • Improve current reports
Data Partitioning
  • Create new partitions
  • Architect data management strategy
  • Maintain current partitions
  • Data archival
Performance Tuning
  • Index tuning and creation
  • T-SQL improvements
  • Review & optimize stored procedures
  • Create new code
OS Scripting
  • Batch & PowerShell
  • Biztalk to SSIS Migration
  • Convert Biztalk code in SSIS

Oracle

Complete, technically deep, operationally sound Oracle support.
Disaster Recovery
  • Within one data center
  • Across multiple data centers
High Availability
  • RAC
  • Dataguard

Replication of Data

Backup Strategies to accommodate
  • RTO and RPO objectives
  • Watch Webinar Watch The Webinar
  • Using OEM and Custom Templates for Alert Optimization
Performance Tuning
  • Instance Tuning to ensure database is setup & running properly
  • Query Tuning ensuring sql statements are running with optimal execution plans
Health Checks
  • Review Oracle data dictionary on 39 items for compliance against best practices, performance markers, etc.
Ensure environments are installed consistently
  • Oracle Home (follows OFA), version, patches, filesystems or disk groups
Data Management
  • Purging data
  • Partitioning data
  • Data Retention

Data Modeling

Defining Database Standards
  • Oracle software install
  • Database creation
  • Picking the right character set
Database upgrades
  • Strategy & Planning
  • Execution
  • Alternatives to minimize downtime

Oracle EBS

Complete, technically deep, operationally sound Oracle EBS support.
Datavail provides deep technical support on all components of EBS including:
  • Release 12.x
  • SOA Suite
  • Demantra
  • OBIEE
  • RAC
  • Grid Control
  • Database Cloning
  • DISCOVERER Admin
  • Oracle SR Management
  • Multi Org Support
  • Form Personalization
  • ‘Ad’ Utilities
  • Patch Application
  • Data Archival & Purging
  • Code Release and Migration
  • Monitor Concurrent Manager
  • Performance Tuning
  • Month/Period End Support
  • Upgrade from 9i/10g to 11gR2
  • Platform migration to Linux (from LONG to SHORT Endian format) using data pump and transportable tables
  • OID/Single Sign-On 10g setup and integration with Oracle Apps 11i/R12
  • Applications upgrade from 11i to R12
  • OAM/AccessGate integration with R12
  • Setting up SSL and load balancer in front of OAM
  • Registering Oracle databases with OID
  • Setting up OID external authentication plug-in with Microsoft AD as well as Kerberos
  • Upgrading Oracle forms and Oracle Application server to latest patch sets in EBS environment
  • Oracle EBS security setup for SOX compliance/auditing
  • Reviewing and applying quarterly CPU patches to Oracle EBS environments
  • Oracle Database and Oracle Applications R12 clones/patching and migrations
  • Install Oracle Grid control setup and monitoring template setup to suppress noise and false alarms
  • Oracle DR standby database setup using DataGuard and DG broker
  • Oracle Apps Tier DR setups
  • Setting up RMAN backups and testing recovery
  • Database character set conversion
  • Oracle RAC setup using ASM
  • Oracle 24×7 monitoring setup
  • Code migrations following company standard RFC and other change processes.
  • General troubleshooting/Directly working with user/tracing/working with Oracle support/SR
  • Oracle Applications DMZ/Internet setup for external access
  • Oracle Application Express APEX installs and upgrade. Install and upgrade APEX listener from 1.x to 2.x

MySQL

Complete, technically deep, operationally sound MySQL support.
MySQL Replication Topologies
  • M-S, M-M, Chained Replication,
  • Limited Circular Replication
  • Implement, monitor & maintain replication
MySQL Server in a Heterogeneous Environment
  • Configure, monitor & maintain MySQL in LAMP, WAMP & Unix
  • Implementing distributions of MySQL using
  • Oracle MySQL, Percona MySQL, Maria DB etc.
  • Manage MySQL servers in Physical, Virtual & Cloud Environment

MySQL Workbench Utilities and Percona Toolkit

MySQL Monitoring & Trending
  • Use Enterprise Solutions like MEM, Monyog
  • Opensouce Technologies like Nagios, Xymon, custom scripts, etc.
  • Cacti, Ganglia, etc. for Trending
Database HA and Scalability Solutions
  • Analysis & recommendation
  • Implement mirroring using DRBD/Heartbeat
  • MySQL NDB Cluster solutions
  • Multi Master Mananger
  • NoSQL solutions like MongoDB
  • In memory object cache solution: Memcached
  • Other Opensource Technology solutions
Database Tuning
  • Optimal database design strategies
  • Tune code when requested
  • Recommend changes to SQL when opportunities exist
  • Using performance schema
Index Strategies
  • Maintain existing indexes
  • Create new indexes where necessary
  • Recommend best indexing strategies
  • Sphinx Full text indexing
Backup Tuning
  • Optimal database design strategies
  • Tune code when requested
  • Recommend changes to SQL when opportunities exist
  • Using performance schema
Table Partitioning
  • Manage existing table partitions
  • Recommend & create partitioning strategies
  • Enable automatic partition rotating & management
Security Analysis
  • Perform and analysis of current security policy
  • Work with customer to mitigate any superfluous users
  • Perform database auditing
  • Integrate MySQL using PAM
  • MySQL Replication over SSL
Package Upgrades
  • Discover the version changes & bug fixes
  • needed for the current installed version
  • Upgrade to patched and major version releases
Best Practices
  • Run Health Checks to discover deficiencies in best practices
  • Tuning MySQL based on trending and analysis
  • Reviewing MySQL configuration & status variables
  • Adjust settings and parameters to meet standards
  • Following the standard best practices for Installation and configuration

DB2

Complete, technically deep, operationally sound DB2 support.
Supporting DB2 z/OS & LUW:

Maintaining & optimizing on the mainframe or on a distributed platform

  • Maintaining & optimizing on the mainframe or on a distributed platform
  • DB2 software
  • DB2 applications
  • DB2 databases
  • Performance Tuning
  • Monitoring and calibrating both static and dynamic SQL
  • Managing and tuning DB2 specific software
  • Addressing data migration and rebinding issues resulting from scheduled enhancements and version upgrades
  • Supporting legacy DB2 applications as well as new development efforts
  • Managing the DB2 utilities
  • Maintaining data sharing and high availability features of DB2

MongoDB

Complete, technically deep, operationally sound MongoDB support.
Administering Replication
  • Setting up and Configuring Replication
  • Add/Change Replication Set Members
  • Manually Re-synching of Replication Sets
  • Restoring
  • Building/Removing Indexes on Replication Sets
Sharding
  • Capacity Planning
  • Adding/Removing Shards
  • Configure Sharding Keys
  • Review Data Distribution
  • Adding/Removing Configuration Servers
Monitoring
  • Replication Slave Lag
  • Sharding Data Distribution
  • Network Usage (connections and data migration between shards or replica sets)
  • Data Balance (Shard)
  • Chunk Sizes (Shard)
  • Memory Usage
  • Page Faults
  • IO
  • CPU

Application Administration

Profiling system

Security Management (Typically done at the OS level)

Configuring Authentication Methods (ie Kerberos)

Code/Framework review

Index management

Moving Data into RAM

Compacting Data

Moving Collections and Data

Backups

RAID Management

SharePoint

Complete, technically deep, operationally sound SharePoint support.
Installation & Configuration
  • Standalone Installation
  • Farm Installation
  • Configuration of Features (Search, BDC, BCS, etc.)
Development & Customization
  • No Code Solutions
  • Branding
  • Custom Solutions
Monitoring
  • Datavail Delta for
  • SharePoint databases
  • Health Checks & Health Analyzer
Performance & Maintenance
  • Test and Implement
  • Patching & Bug Fixes
  • Releases & Upgrades
  • Capacity Planning
Security & Governance
  • User Management
  • Server Security
  • Branding & Template
  • Standardization
  • Content Lifecycle
Reporting
  • Health & Usage Reports
  • BI Reports
High Availability & Disaster Recovery
  • Architecture with Redundancy
  • SQL AlwaysOn
  • Disaster Recovery Strategies
User Support
  • User Adoption Training
  • Knowledge Base
  • Office Apps and Metadata Solutions
One Global Service Management team

Your Service Delivery Manager focuses on the critical, non-technical aspects of delivery.At Datavail your SDM coordinates:

  • Regular reporting of activities
  • Quarterly business reviews
  • Other governance & communication tasks

Your US SDM is assisted by our off-shore SDM team to create a global approach to service management & quality assurance.

Datavail Educates Down And Escalates Up

Datavail has created a learning organization:

  • Higher tiers teach the lower tiers (educate)
  • Lower tiers reach into higher tiers to help solve problems (escalate)

By implementing this learning approach:

  • DBAs in the lower tiers become more knowledgeable over time
  • DBAs have upward mobility & a clear career path
  • We retain talent & build deeper knowledge about your environment
TIER Lead DBA US

Your Lead DBA is a US-based Tier 3 level DBA with 10+ years experience

  • Technical expert on your environment
  • Integrated into your team
  • Provides oversight, consulting, direction
  • Escalation point from other Datavail DBAs
TIER
Lead DBA US
TIER
Senior Level Capability In Time Zone

Datavail has created a global Tier 3 team

  • Staffed in a 1-DBA-to-1 ratio between our US Lead DBAs & our India Tier 3 DBAs
  • Ensures a close-knit relationship between senior level resources
  • Our offshore Tier 3 DBAs match their US counterparts in technical skills
  • Enables tightness of communication & clear understanding of processes
off shore delivery operation
TIER
  • Senior Level Capability In Time Zone

Our offshore Tier 3 team delivers in-room, in time zone senior skills

  • Provides stability & quality
  • Matches the technical skill level of our US-based Lead DBAs
  • Enables 24×7 Tier 3 coverage from the most senior level DBAs
TIER
  • Operational database administration
  • Fully staffed 24x7

Tier 2, or Operational DBA, is the core of all DBA work.

  • Full 24×7 3-shift model
  • Executes on incidents & service requests
  • 5+ year experienced DBAs with a powerful economic benefit
TIER
  • Service Desk: Staffed with DBAs

The Tier 1 layer, or service desk layer.

  • Staffed with DBAs
  • Delivers ticket triage and execution of basic DBA tasks
No Offshore?
TIER US
  • Lead DBA
TIER US
  • Operational database administration
TIER OFFSHORE
  • For monitoring & escalation only
  • The leader in remote database administration services:
    More than 800 employees & growing
  • Covering all major databases
  • 24x7x365

Over 700,000

DBA hours delivered annually

Over 125,000

Databases Monitored

  • Portals, Collaboration & Customer Self-Service
  • Content Management & Governance
  • Tracking & Incident Management
  • Unified Communications
    Microsoft Dynamics CRM
    SharePoint
    Office 365
  • Business Intelligence, analytics & EPM services and tools
  • Full application lifecycle support - plan, design, build, deploy
  • Data warehousing & data visualization
  • EPM & BI Cloud solutions
  • Planning, budgeting, forecasting, financial close & reporting
10 Ways to use Datavail
Datavail serves the needs of more than 300 clients. Our solutions can be customized to solve any client database challenge or problem.
Here are 10 of the most common ways our clients use Datavail.

Augment Your Team

Fill in gaps and lighten DBA loads
problem
  • Your DBAs are strong but need monthly operational support
solution
  • Use remote DBA services from Datavail to add capacity
  • We improve the quality of life of your DBAs & enable them to add more value
  • Business results improve & costs are contained

Production Support

Improve business results, decrease attrition, gain 24x7 coverage
problem
  • Projects are piling up
  • Your application teams need more DBA time
  • Your DBAs are consumed with Tier 2 production work
solution
  • Use remote database administration from Datavail to handle production support
  • Your DBAs deliver more value
  • DBA retention & morale improves

2nd & 3rd Shift

Improve DBA productivity & stop late night calls
problem
  • Your DBA team isn’t large enough to be structuredacross a 24×7 shift schedule
  • Escalations cause late night calls, leading to turnover
solution
  • Use remote database administration from Datavail to cover the late shifts and relieve your DBAs
  • Higher DBA productivity, work quality and job satisfaction

Fractional Resources

Contain costs while gaining 24x7 coverage
problem
  • You need more DBAs for coverage or to expand capabilities
  • You can’t make a new hire & 1 person won’t solve your problem
solution
  • 20 hours per week of remote DBA services, spread across a 24×7 shift schedule
  • Costs contained by avoiding a full time hire
  • 24×7 coverage & stress relief in your DBAs

Complete Solution

Avoid increasing staff for a complex environment
problem
  • Cost pressures are mounting
  • High attrition in your DBA team
  • You can’t find the talent you need
  • A new environment requires support you don’t have
solution
  • Implementation of multi-tiered 24×7 coverage
  • Avoid having to staff up for a complex environment
  • Manage costs and receive more value your DBAs

24 x 7

Contain costs while gaining 24x7 coverage
problem
  • Workload doesn’t justify building it in-house
  • You need it but at an affordable cost
solution
  • Leverage Datavail’s 24×7 onshore/offshore delivery model
  • Use Datavail for production support
  • Let your DBAs focus on higher value work
  • Cut costs, improve quality, and gain flexibility

Projects

Improve your environment and meet your business deadlines
problem
  • Daily requirements consume your DBAs & they can’t get to important projects
  • You need a health check, performance improvement, support for an application roll-out
solution
  • Project services from Datavail
  • Environment improves & deadlines are met

Dedicated Resources

Get a DBA focused on you or build your dedicated offshore team
problem
  • You need an additional DBA for a short or long term need
solution
  • Dedicated resources, onshore or offshore, for the duration of time you require
  • Flexible contract terms & faster ramp-up
  • You get a dedicated DBA who can escalate into Datavail to help solve complex problems

Tier 3 & Above

Gain access to the highest level of technical talent when you need it
problem
  • You need more senior level skill sets
  • The skills needed are too broad to be covered by a single DBA
solution
  • Engineering & architecture talent you need, when you need it
  • Datavail serves as an escalation path for your team
  • Reduce cost by avoiding multiple hires for broad requirements

2nd & 3rd Shift

Cover a small environment without a full-time hire
problem
  • A small environment needs support outside your time availability or skill sets
solution
  • Monitoring of your environment
  • P1 support with a response time SLA
  • Get the help you need, when you need it, and avoid cost
  • Ensure stability on a small environment
Spotlight on BI/DW, Analytics & EPM

When Business Intelligence & EPM software, tools, or platforms are not properly configured, the reporting and review delays can cause insights to be missed.

That’s why Datavail’s Business Intelligence (BI), Data Warehousing (DW), Analytics, and Enterprise Performance Management (EPM) experts provide full application lifecycle support, including planning, designing, building, deploying, and supporting all stages of the business intelligence lifecycle.

Data Warehousing & Data Visualization

Spotlight on Data Warehousing & Visualization

DATA WAREHOUSING
Good insights come from good data warehousing. We help you:
Determine goals, objectives, and processes
Design a dimensional model
Develop operational data stores
Perform regular tuning and backups
DATA VISUALIZATION
To get on top of those mounting data visualization requests, let us help you:
Choose an application that fits your needs
Install and configure the application
Convert data to visualization
Provide standards for self-service analytics

Report & Dashboard Customization

Spotlight on Customization

REPORTS
Leverage Datavail reporting expertise so that you can:
Free up time for important projects
Reduce technology frustrations
Streamline processes
Reduce inquiry time
Deliver self-service reporting
DASHBOARDS
Building effective dashboards can be tricky. We can give you:
Vital information in real time
Drill-down capability
Sleek design for easy interpretation
Innovative data visualizations
360-degree management KPI view points

ETL & OLAP

Spotlight on ETL & OLAP

ETL DESIGN, DEVELOPMENT, OPTIMIZATION
Datavail can help you make your data more accessible. We will:
Design and build custom ETL solutions
Extract data from multiple source formats
Develop data warehouse structures from scratch
Provide “real-time” analytics
ONLINE ANALYTICAL PROCESSING (OLAP)
A Datavail implementation of an OLAP initiative for analytics gives you:
A solution delivering consistent data analysis
Access to Datavail’s patented Tech-enabled IP
Tools offering answers from various perspectives
Enhanced trend analysis
Innovative data mining capabilities

BI/DW & Analytics Consulting

Spotlight on BI/DW & Analytics

VALUE FROM YOUR DATA
With Datavail’s help you can:
Obtain the best data warehousing solution
Design effective data visualization
Analyze a cloud or on-premise dashboard
Provide a feedback loop for end users
EASY SOLUTION SHARING
Datavail solutions let you:
Share decision-making information
Configure your out-of-the-box data warehouse
Work with data retrieval in OBIA
Create self-service analyses

EPM Cloud Solutions

Spotlight on EPM Cloud Solutions

SOLUTIONS
Enterprise Planning Cloud
Planning & Budgeting Cloud
Enterprise Performance Reporting Cloud
Account Reconciliation Cloud
Financial Consolidation & Close Cloud
Profitability & Cost Management Cloud
Tax Reporting Cloud
Essbase Cloud
Cloud Accelerate Implementations and Migrations
Cloud Assessments and Roadmaps
Cloud Managed Services

Planning, Budgeting & Forecasting

Spotlight on Planning, Budgeting & Forecasting

SOLUTIONS
With Oracle PBCS you can:
Move from spreadsheets to systems
Optimize your forecast processes
Build custom budget models
Eliminate capital outlay
KEY BENEFITS
By using Datavail, you can achieve:
PBCS implementation on-time and on-budget
Standard application delivery
Optional customer features
Hyperion administration managed services

Financial Consolidation & Close

Spotlight on Financial Consolidation & Close

SOLUTIONS
With our Oracle FCCS expertise, you can achieve:
A configurable consolidation and close framework
Robust analytics, dashboards, reports, and analysis
Unparalleled insight
An all-encompassing FCCS solution
KEY BENEFITS
By using Datavail, you can achieve:
FCCS implementation on-time and on-budget
An out-of-box application with custom options
Hyperion administration managed services

EPM for Midsize

Spotlight on EPM for Midsize

MIDSIZE COMPANY SOLUTIONS
Enjoy the EPM benefits large organizations get when:
Growing company size
Expanding internationally
Establishing an IPO
EPM BENEFITS
Datavail takes midsize organizations to the next level with BI and EPM solutions, giving you:
Deep and accurate rolling forecasts
CEO visibility into the business
Automated reporting
Use the buttons to learn about Datavail.
We'll manage your data and applications,
you manage your business.
Find out why Datavail offers BI/Analytics services.
Don’t give your databases to a company that doesn’t really care about your data.
Microsoft SQL Server
Oracle
Oracle EBS
MySQL
DB2
MongoDB
SharePoint
Database Practices Delivering 24x7 Expertise
Datavail provides comprehensive & technically advanced remote database administration services in each of our core database practices. Each practice delivers solutions that leverage our multi-tiered, ITIL delivery model with onshore and offshore capabilities.
Universal Database Management Tasks
For a deeper look into the technical depth on any of Datavail's practices select the database that interests you to the left.
Microsoft SQL Server
Oracle
Oracle EBS
MySQL
DB2
MongoDB
SharePoint
Complete, technically deep, operationally sound SQL Server support.
Datavail provides deep technical support
and development on all components of SQL Server
  • Replication (Transactional, Merge & Peer to Peer)
  • SQL Server in a Windows Cluster
  • Reporting Services Support
  • Analysis Services Maintenance: Maintain cubes or dimensions
  • SQL Server Integration Service (SSIS)
  • Database Mirroring
  • Query Tuning including T-SQL
  • SQL Server Always On
  • Index strategies
  • Backup Tuning
  • Table Partitioning
  • Security: Analysis & Mitigation of superfluous users
  • Service Pack and CUP Installation
  • Best Practices: Health Checks & Tuning of Parameters
  • Service Broker: Ensure optimal settings
  • Migrate Database Platforms
    • Move databases
    • Oracle & MySQL to SQL Server
    • ETL to SQL Server Integration Services (SSIS)
    • Reporting Tools to SQL Server
    • Reporting Services
  • SSIS - SQL Server Integration Services
    • Upgrade from DTS to SSIS
    • Code rewrites
    • New package creation
    • ETL for Datawarehouse loads
    • Tune existing packages
  • SSAS - SQL Server Analysis Services
    • Upgrade old cubes
      to the latest version of SQL.
    • Create cubes to satisfy
      specific business needs
    • Analyze large amounts of data to find trends.
    • Evaluation of existing Cubes/DataWarehouse
    • Enhance functionality of cubes by consolidating and using MDX to execute functions
    • New reports from SSAS/MDX
  • SSRS - SQL Server Reporting Services
    • Convert from other reporting tools to SSRS
    • Create new reports
    • Integration into SSAS
    • Improve current reports
  • Data Partitioning
    • Create new partitions
    • Architect data management strategy
    • Maintain current partitions
    • Data archival
  • Performance Tuning
    • Index tuning and creation
    • T-SQL improvements
    • Review & optimize stored procedures
    • Create new code
  • OS Scripting
    • Batch & PowerShell
    • Biztalk to SSIS Migration
    • Convert Biztalk code in SSIS
Complete, technically deep, operationally sound Oracle support.
  • Performance Tuning
    • Instance Tuning to ensure database is setup & running properly
    • Query Tuning ensuring sql statements are running with optimal execution plans
  • Health Checks
    • Review Oracle data dictionary on 39 items for compliance against best practices,
      performance markers, etc.
  • Ensure environments are installed consistently
    • Oracle Home (follows OFA), version, patches, filesystems or disk groups
  • Data Management
    • Purging data
    • Partitioning data
    • Data Retention
  • Data Modeling
  • Defining Database Standards
    • Oracle software install
    • Database creation
    • Picking the right character set
  • Database upgrades
    • Strategy & Planning
    • Execution
    • Alternatives to minimize downtime
Complete, technically deep, operationally sound Oracle EBS support.
Datavail provides deep technical support on all components of EBS including:
  • Database Cloning
  • DISCOVERER Admin
  • Oracle SR Management
  • Multi Org Support
  • Form Personalization
  • 'Ad' Utilities
  • Patch Application
  • Data Archival & Purging
  • Code Release and Migration
  • Monitor Concurrent Manager
  • Performance Tuning
  • Month/Period End Support
Datavail provides deep technical support on all components of EBS including:
  • Upgrade from 9i/10g to 11gR2
  • Platform migration to Linux (from LONG to SHORT Endian format) using data pump and transportable tables
  • OID/Single Sign-On 10g setup and integration with Oracle Apps 11i/R12
  • Applications upgrade from 11i to R12
  • OAM/AccessGate integration with R12
  • Setting up SSL and load balancer in front of OAM
  • Registering Oracle databases with OID
  • Setting up OID external authentication plug-in with Microsoft AD as well as Kerberos
  • Upgrading Oracle forms and Oracle Application server to latest patch sets in EBS environment
  • Oracle EBS security setup for SOX compliance/auditing
  • Reviewing and applying quarterly CPU patches to Oracle EBS environments
  • Oracle Database and Oracle Applications R12 clones/patching and migrations
Datavail provides deep technical support on all components of EBS including:
  • Install Oracle Grid control setup and monitoring template setup to suppress noise and false alarms
  • Oracle DR standby database setup using DataGuard and DG broker
  • Oracle Apps Tier DR setups
  • Setting up RMAN backups and testing recovery
  • Database character set conversion
  • Oracle RAC setup using ASM
  • Oracle 24×7 monitoring setup
  • Code migrations following company standard RFC and other change processes.
  • General troubleshooting/Directly working with user/tracing/working with Oracle support/SR
  • Oracle Applications DMZ/Internet setup for external access
  • Oracle Application Express APEX installs and upgrade. Install and upgrade APEX listener from 1.x to 2.x
Complete, technically deep, operationally sound MySQL support.
  • MySQL Replication Topologies
    • M-S, M-M, Chained Replication, Limited Circular Replication
    • Implement, monitor & maintain replication
  • MySQL Server in a Heterogeneous Environment
    • Configure, monitor & maintain MySQL in LAMP, WAMP & Unix
    • Implementing distributions of MySQL using Oracle MySQL, Percona MySQL, Maria DB etc.
    • Manage MySQL servers in Physical, Virtual & Cloud Environment
  • MySQL Workbench Utilities and Percona Toolkit
  • MySQL Monitoring & Trending
    • Use Enterprise Solutions like MEM, Monyog
    • Opensouce Technologies like Nagios, Xymon, custom scripts, etc.
    • Cacti, Ganglia, etc. for Trending
  • Database HA and Scalability Solutions
    • Analysis & recommendation
    • Implement mirroring using DRBD/Heartbeat
    • MySQL NDB Cluster solutions
    • Multi Master Mananger
    • NoSQL solutions like MongoDB
    • In memory object cache solution: Memcached
    • Other Opensource Technology solutions
  • Database Tuning
    • Optimal database design strategies
    • Tune code when requested
    • Recommend changes to SQL when opportunities exist
    • Using performance schema
  • Index Strategies
    • Maintain existing indexes
    • Create new indexes where necessary
    • Recommend best indexing strategies
    • Sphinx Full text indexing
  • Backup Tuning
    • Optimal database design strategies
    • Tune code when requested
    • Recommend changes to SQL when opportunities exist
    • Using performance schema
  • Table Partitioning
    • Manage existing table partitions
    • Recommend & create partitioning strategies
    • Enable automatic partition rotating & management
  • Security Analysis
    • Perform and analysis of current security policy
    • Work with customer to mitigate any superfluous users
    • Perform database auditing
    • Integrate MySQL using PAM
    • MySQL Replication over SSL
  • Package Upgrades
    • Discover the version changes & bug fixes needed for the current installed version
    • Upgrade to patched and major version releases
  • Best Practices
    • Run Health Checks to discover deficiencies in best practices
    • Tuning MySQL based on trending and analysis
    • Reviewing MySQL configuration & status variables
    • Adjust settings and parameters to meet standards
    • Following the standard best practices for Installation and configuration
Complete, technically deep, operationally sound DB2 support.
Supporting DB2 z/OS & LUW:
  • Maintaining & optimizing on the mainframe or on a distributed platform
    • DB2 software
    • DB2 applications
    • DB2 databases
  • Performance Tuning
  • Monitoring and calibrating
    both static and dynamic SQL
  • Managing and tuning DB2 specific software
  • Addressing data migration and rebinding issues resulting from scheduled enhancements and version upgrades
  • Supporting legacy DB2 applications as well as new development efforts
  • Managing the DB2 utilities
  • Maintaining data sharing and
    high availability features of DB2
Complete, technically deep, operationally sound MongoDB support.
  • Administering Replication
    • Setting up and Configuring Replication
    • Add/Change Replication Set Members
    • Manually Re-synching of Replication Sets
    • Restoring
    • Building/Removing Indexes on Replication Sets
  • Sharding
    • Capacity Planning
    • Adding/Removing Shards
    • Configure Sharding Keys
    • Review Data Distribution
    • Adding/Removing Configuration Servers
  • Monitoring
    • Replication Slave Lag
    • Sharding Data Distribution
    • Network Usage (connections and data migration between shards or replica sets)
    • Data Balance (Shard)
    • Chunk Sizes (Shard)
    • Memory Usage
    • Page Faults
    • IO
    • CPU
Complete, technically deep, operationally sound SharePoint support.
  • Installation & Configuration
    • Standalone Installation
    • Farm Installation
    • Configuration of Features
      (Search, BDC, BCS, etc.)
  • Development & Customization
    • No Code Solutions
    • Branding
    • Custom Solutions
  • Monitoring
    • Datavail Delta for
      SharePoint databases
    • Health Checks & Health Analyzer
  • Performance & Maintenance
    • Test and Implement
      Patching & Bug Fixes
    • Releases & Upgrades
    • Capacity Planning
  • Security & Governance
    • User Management
    • Server Security
    • Branding & Template
      Standardization
    • Content Lifecycle
  • Reporting
    • Health & Usage Reports
    • BI Reports
  • High Availability & Disaster Recovery
    • Architecture with Redundancy
    • SQL AlwaysOn
    • Disaster Recovery Strategies
  • User Support
    • User Adoption Training
    • Knowledge Base
    • Office Apps and Metadata Solutions

 

Our Delivery Model - Unique and Powerful
TIER 3 • Lead DBA US

Your Lead DBA is a US-based Tier 3 level DBA with 10+ years experience

  • Technical expert on your environment
  • Integrated into your team
  • Provides oversight, consulting, direction
  • Escalation point from other Datavail DBAs
TIER 3 • Offshore delivery operation

Our offshore Tier 3 team delivers in-room, in time zone senior skills

  • Provides stability & quality
  • Matches the technical skill level of our US-based Lead DBAs
  • Enables 24×7 Tier 3 coverage from the most senior level DBAs
TIER 2 • Offshore delivery operation

Tier 2, or Operational DBA, is the core of all DBA work.

  • Full 24×7 3-shift model
  • Executes on incidents & service requests
  • 5+ year experienced DBAs with a powerful economic benefit
TIER 1 • Offshore delivery operation

The Tier 1 layer, or service desk layer.

  • Staffed with DBAs
  • Delivers ticket triage and execution of basic DBA tasks
Offshore delivery operation

Datavail's off shore delivery operation is the most sophisticated delivery model in the industry

  • Combines talented DBAs with efficient operational processes
  • Operations leaders, shift managers & quality control personnel review tickets
  • Multi-tiered delivery
  • Technical & nontechnical training
  • Service management
  • Many more areas of investment work together to create a reliable, high-quality database delivery operation
A Learning Organization Educates Down
And Escalates Up

Datavail has created a learning organization:

  • Higher tiers teach the lower tiers (educate)
  • Lower tiers reach into higher tiers to help solve problems (escalate)

By implementing this learning approach:

  • DBAs in the lower tiers become more knowledgeable over time
  • DBAs have upward mobility & a clear career path
  • We retain talent & build deeper knowledge about your environment
One Global Service Management Team
Your Service Delivery Manager focuses on the critical, non-technical aspects of delivery.
At Datavail your SDM coordinates:

  • Regular reporting of activities
  • Quarterly business reviews
  • Other governance and communication tasks

Your US SDM is assisted by our offshore SDM team to create a global approach to service management & quality assurance.

One Global Tier 3 Team

Datavail has created a global Tier 3 team

  • Staffed in a 1-DBA-to-1 ratio between our US Lead DBAs & our India Tier 3 DBAs
  • Ensures a close-knit relationship between senior level resources
  • Our offshore Tier 3 DBAs match their US counterparts in technical skills
  • Enables tightness of communication & clear understanding of processes
A US Only Delivery Model

Leverage off shore for monitoring & escalation only:
No fingers on the keyboard
Datavail is... The Largest Remote DBA Services Company In North America
  • The leader in remote database administration services:
    More than 800 employees & growing
  • Covering all major databases
  • 24x7x365
Over 700,000
DBA hours delivered
annually
More Than 200,000
Databases Monitored
A One-stop Shop for Application Development, Integration & Support
  • Portals, Collaboration & Customer Self-Service
  • Content Management & Governance
  • Tracking & Incident Management
  • Unified Communications
    • Microsoft Dynamics CRM
    • SharePoint
    • Office 365
Your analytics and EPM resource for
  • Business Intelligence, analytics & EPM services and tools
  • Full application lifecycle support - plan, design, build, deploy
  • Data warehousing & data visualization
  • EPM & BI Cloud solutions
  • Planning, budgeting, forecasting, financial close & reporting
Augment Your Team
Production Support
2nd & 3rd Shift
Fractional Resources
Complete Solution
24 x 7
Projects
Dedicated Resources
Tier 3 & Above
Insurance Policy
10 Ways to Use Datavail
Datavail serves the needs of more than 300 clients. Our solutions can be customized to solve any client database challenge or problem.
Here are 10 of the most common ways our clients use Datavail.

white paper Read Our White Paper:
Top Trends in Database Management

Fill in gaps and lighten DBA loads
Improve business results, decrease attrition, gain 24x7 coverage
Improve DBA productivity & stop late night calls
Contain costs while gaining 24x7 coverage
Avoid increasing staff for a complex environment
Contain costs while gaining 24x7 coverage
Improve your environment and meet your business deadlines
Get a DBA focused on you or build your dedicated offshore team
Gain access to the highest level of technical talent when you need it
Cover a small environment without a full-time hire
Problem
  • Your DBAs are strong but need monthly operational support
Solution
  • Use remote DBA services from Datavail to add capacity
  • We improve the quality of life of your DBAs &
    enable them to add more value
  • Business results improve & costs are contained
Problem
  • Projects are piling up
  • Your application teams need more DBA time
  • Your DBAs are consumed with Tier 2 production work
Solution
  • Use remote database administration from Datavail to handle production support
  • Your DBAs deliver more value
  • DBA retention & morale improves
Problem
  • Your DBA team isn't large enough to be structured
    across a 24×7 shift schedule
  • Escalations cause late night calls, leading to turnover
Solution
  • Use remote database administration from Datavail to cover the late shifts and relieve your DBAs
  • Higher DBA productivity, work quality and job satisfaction
Problem
  • You need more DBAs for coverage or
    to expand capabilities
  • You can't make a new hire &
    1 person won't solve your problem
Solution
  • 20 hours per week of remote DBA services,
    spread across a 24×7 shift schedule
  • Costs contained by avoiding a full time hire
  • 24×7 coverage & stress relief in your DBAs
Problem
  • Cost pressures are mounting
  • High attrition in your DBA team
  • You can't find the talent you need
  • A new environment requires support you don't have
Solution
  • Implementation of multi-tiered 24×7 coverage
  • Avoid having to staff up for a complex environment
  • Manage costs and receive more value
Problem
  • Workload doesn't justify building it in-house
  • You need it but at an affordable cost
Solution
  • Leverage Datavail's 24×7 onshore/offshore delivery model
  • Use Datavail for production support
  • Let your DBAs focus on higher value work
  • Cut costs, improve quality, and gain flexibility
Problem
  • Daily requirements consume your DBAs &
    they can't get to important projects
  • You need a health check, performance improvement,
    support for an application roll-out
Solution
  • Project services from Datavail
  • Environment improves & deadlines are met
Problem
  • You need an additional DBA for a short or long term need
Solution
  • Dedicated resources, onshore or offshore,
    for the duration of time you require
  • Flexible contract terms & faster ramp-up
  • You get a dedicated DBA who can escalate into Datavail
    to help solve complex problems
Problem
  • You need more senior level skill sets
  • The skills needed are too broad to be covered by a single DBA
Solution
  • Engineering & architecture talent you need,
    when you need it
  • Datavail serves as an escalation path for your team
  • Reduce cost by avoiding multiple hires for broad requirements
Problem
  • A small environment needs support outside
    your time availability or skill sets
Solution
  • Monitoring of your environment
  • P1 support with a response time SLA
  • Get the help you need, when you need it, and avoid cost
  • Ensure stability on a small environment
Data Warehousing & Data Visualization
Report & Dashboard Customization
ETL & OLAP
BI/DW & Analytics Consulting
EPM Cloud Solutions
Planning, Budgeting & Forecasting
Financial Consolidation & Close
EPM for Midsize
Spotlight on BI/DW, Analytics & EPM

When Business Intelligence & EPM software, tools, or platforms are not properly configured, the reporting and review delays can cause insights to be missed.

That’s why Datavail’s Business Intelligence (BI), Data Warehousing (DW), Analytics, and Enterprise Performance Management (EPM) experts provide full application lifecycle support, including planning, designing, building, deploying, and supporting all stages of the business intelligence lifecycle.

Data Warehousing

Good insights come from good data warehousing. We help you:

Determine goals, objectives, and processes
Design a dimensional model
Develop operational data stores
Perform regular tuning and backups
Data Visualization

To get on top of those mounting data visualization requests, let us help you:

Choose an application that fits your needs
Install and configure the application
Convert data to visualization
Provide standards for self-service analytics
Reports

Leverage Datavail reporting expertise so that you can:

Free up time for important projects
Reduce technology frustrations
Streamline processes
Reduce inquiry time
Deliver self-service reporting
Dashboards

Building effective dashboards can be tricky. We can give you:

Vital information in real time
Drill-down capability
Sleek design for easy interpretation
Innovative data visualizations
360-degree management KPI view points
ETL Design, Development, Optimization

Datavail can help you make your data more accessible. We will:

Design and build custom ETL solutions
Extract data from multiple source formats
Develop data warehouse structures from scratch
Provide “real-time” analytics
Online Analytical Processing (OLAP)

A Datavail implementation of an OLAP initiative for analytics gives you:

A solution delivering consistent data analysis
Access to Datavail’s patented Tech-enabled IP
Tools offering answers from various perspectives
Enhanced trend analysis
Innovative data mining capabilities
Value from Your Data

With Datavail’s help you can:

Obtain the best data warehousing solution
Design effective data visualization
Analyze a cloud or on-premise dashboard
Provide a feedback loop for end users
Easy solution sharing

Datavail solutions let you:

Share decision-making information
Configure your out-of-the-box data warehouse
Work with data retrieval in OBIA
Create self-service analyses
Solutions

Offerings:

Cloud Accelerate Implementations and Migrations
Cloud Assessments and Roadmaps
Cloud Managed Services
Solutions

With Oracle PBCS you can:

Move from spreadsheets to systems
Optimize your forecast processes
Build custom budget models
Eliminate capital outlay
Key Benefits

By using Datavail, you can achieve:

PBCS implementation on-time and on-budget
Standard application delivery
Optional customer features
Hyperion administration managed services
Solutions

With our Oracle FCCS expertise, you can achieve:

A configurable consolidation and close framework
Robust analytics, dashboards, reports, and analysis
Unparalleled insight
An all-encompassing FCCS solution
Key Benefits

By using Datavail, you can achieve:

FCCS implementation on-time and on-budget
An out-of-box application with custom options
Hyperion administration managed services
Midsize company solutions

Enjoy the EPM benefits large organizations get when:

Growing company size
Expanding internationally
Establishing an IPO
EPM Benefits

Datavail takes midsize organizations to the next level with BI and EPM solutions, giving you:

Deep and accurate rolling forecasts
CEO visibility into the business
Automated reporting

Datavail Named to 2017 Inc. 5000 List of the Fastest Growing Private Companies

TECHNOLOGIES WE SPECIALIZE IN

Datavail provides specialized IT, professional and managed services via our global delivery model. Our more than 850 architects, developers, analysts, data scientists and DBAs possess, on average, 15 years of technology experience. From application development and modernization to remote DBA services to advanced enterprise data management and business intelligence, our team can help you make informed business decisions through data.

Datavail has the technology expertise and implementation experience to help you get the most out of your Microsoft investment. For over 20 years, we have been helping businesses become more agile, lower costs, prepare for mobile and IoT, and ensure their applications meet the needs of your customers and employees.

Microsoft Services >>

With an average of 15 years of experience, our Oracle database administrators can guide you through strategic initiatives and routine management. This breadth of experience has enabled us to provide successful management for smaller operations to larger environments up to 50TB.

Oracle Services >>

Datavail’s AWS Cloud implementation team is ready to help your business move to the next level of performance in the cloud. Our award winning services will help you migrate to the AWS cloud quickly and efficiently.

AWS Services >>

Unlike many providers who often substitute PHP developers for MySQL admins, Datavail seeks only seasoned MySQL database administration experts with a strong, focused background in database administration. Our team’s MySQL DBAs have supported a wide range of customers throughout their careers, allowing them to share and apply their unique experience and knowledge across our entire client base.

MySQL Services >>

In the Big Data space, MongoDB has emerged as a clear NoSQL database leader. Want to know what Big Data can do for your organization? Datavail can help your team evaluate, plan, and implement your Big Data solution with MongoDB.

MongoDB Services >>

Datavail provides DB2 services for z/OS and LUW to support your mainframe or distributed platform. Our experts will assess, plan, implement and manage your DB2 environment, including software, applications and databases, keeping them at peak performance, streamlining your administrative tasks and fine tuning your recovery protocols.

DB2 Services >>

Our Informatica experts and patented Tech-enabled IP toolbox gives our clients the data management solution they need. Our experts can provide 24×7 operational support to keep your Informatica installation up and running so you don’t have to.

Informatica Services >>

Datavail’s PostgreSQL database support helps your organization increase performance and stability. Within our core practice, a U.S.-based Primary PostgreSQL DBA is appointed to each client to guarantee that our services are most powerfully implemented.

Postgres Services >>
The Blog
Replacing UNION with CASE
FEATURES
Software Company White Paper
How and Why You Should Think Like a Software Company

This White Paper will share the elements of a Modern application strategy, why it’s essential to your business, and teach you how to think of the bigger technology picture, in essence, how to think like a software company.

Download Now
SQL 2008 Upgrade Webinar
Planning an Effective Upgrade from SQL Server 2008

In this webinar, Jeff Duncan will discuss the steps that you need to ensure that you have the smoothest migration to the SQL Server 2016 and beyond.

Watch Now
Datavail Delta White Paper
Monitoring Databases with Datavail Delta

Datavail has created a powerful monitoring tool that focuses on what's important for our customers, letting them spend their time on other initiatives while we work to ensure that your databases enjoy maximum performance and uptime.

Download Now
WHY CHOOSE DATAVAIL

Datavail is focused on data management and business intelligence; application development, modernization and support; and database support for Oracle, Oracle Applications, Microsoft Applications, SQL Server, DB2, MySQL, MongoDB and SharePoint. From managed services and consulting, to projects, and 24x7 operational support, Datavail has you and your data covered. Datavail’s clients include Fortune 100 to mid-sized companies and startups that rely on robust support services that build their revenue-generating data infrastructure.

WHAT CLIENTS SAY ABOUT DATAVAIL
Datavail Provided Quality Database Support for Our Team

Datavail helped our organization save costs and improve the quality of our database administration. They have helped me back up our DBA team without having to hire new people.

Source: Medium Enterprise Industrial Manufacturing Company