Your Oracle and SQL Server Database Engineers. Architecture, Implementation, & Support Expertise, Since 1995.

Managed Database Services

Oracle , and SQL Server Managed Database Services :

Since 1995, RPDATA Solutions has supported numerous mission critical Oracle environments. Our managed database service offering includes:

Pro-active support and monitoring

Using RPDATA developed custom software, we offer 24X7 secure and reliable heartbeat monitoring, space(database, filesystem) monitoring, standby database monitoring, backup monitoring, performance monitoring, auditing, log file maintenance.

On-Call 24X7

All customers under a managed database service contract benefit from having a DBA on-call 24X7 to handle any emergencies, issues, or outages.

Regular Health Checks

Health checks are critical in ensuring all databases remain secure, recoverable, and properly configured to support the demands of the application it’s hosting.

RPDATA Backup and Recovery Dashboard

Industry leading backup monitoring software that ensures your database backups are always current. This cloud based solution allows our staff to be alerted if any of your databases have not been backed on time, or backups have failed for whatever reason. We often come across missed backups where DBAs have accidentally disabled schedulers, or accounts have expired, and in these situations, failed backups don’t generate alerts, and successful backups don’t generate status emails because they don’t run at all. Our software prevents this, we manage backups from a much higher level and it’s centrally managed via our Dashboard. It’s very much like a backup and recovery heartbeat! WE DON’T MISS BACKUPS, PERIOD. Ask for a demo today!

Time-Tracking

Each client has access to our Time Tracking portal to view project statuses, detailed DBA time entries that include time spent in 15min increments, server names ,database names and description of the support activity.

Database Expertise

RPDATA Solutions hires only very senior level Oracle, and SQL Server support engineers. Our database engineers have a min of 15yrs experience and have engineered, built and supported some of the most mission critical database systems in the banking, healthcare , and government sectors across Canada. We take our responsibilities very seriously. The buck always stops with us!

Oracle Expertise

  • Oracle 7, 8i, 9i, 10g, 11g, 12c
  • Data conversions, migrations
  • Dataguard, Active Dataguard
  • RAC, RAC One-Node
  • ASM
  • Performance Tuning
  • Oracle PL/SQL custom development
  • RMAN(Recovery, automated cloning)
  • Standby Databases for Standard Edition
  • Capacity Planning
  • Architecture and Design

SQL Server Expertise

  • SQL Server 2012, 2014 and 2016 Upgrades
  • SQL Server 7, 2000, 2005, 2008, 2008R, 2012, and 2014 Support
  • Disaster and Recovery (DR) strategies testing and implementation
  • High Availability
  • Clustering
  • Performance Tuning
  • SQL Server Replication
  • SQL Server BI Stack
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Analysis Services (SSAS)
  • Capacity Planning
  • Architecture and Design