Our Services
KMS Datasystems Inc.
KMS Datasystems provides reliable ORACLE and Microsoft SQL Server Database Consulting and related services to mid-sized and large corporations and all levels of government. We also provide remote DBA support across Canada via high-speed Internet.
KMS offers ORACLE and Microsoft Certified Professionals (OCP, MCP), has a proven track record of over 25 years of ORACLE and SQL Server experience.
Not only do we offer the highest quality of service to our clients, but as independent database consultants, we offer exceptional value.
Database Administration and Consulting Services
- Managed Services: Emergency DBA Services and 24/7 monitoring. Certified DBA experts on-call.
- Cloud Database Secure Hosting, Managed Services and Administration.
- Comprehensive performance validations, configuration and security audits. We can provide an independent certification of your database, application, and networking environment to ensure compliance with industry standards and best practices.
- Full-time DBA Vacation/Absence Relief: We offer peace of mind during employee absences.
- Database Strategic Planning, Project Management, Data Modeling, and Database Design.
- Database Backup and Recovery Strategies, Disaster Planning, and Recovery Scenario Verifications.
- Business Continuity Planning and Database Disaster Recovery Planning.
- Database Integration: Interfaces between ORACLE and SQL Server databases, and other systems.
- Database Security: Planning, Auditing, and Security Audits.
Comprehensive Consulting Services for IBM Cognos and TM1 Planning Analytics
For over 25 years in Business Intelligence and Data Warehousing & Planning, KMS Datasystems has analyzed, designed, built, managed, and delivered projects throughout the Americas and Europe. We have a proven track record of creating successful solutions for complex business issues backed by positive customer feedback.
Our expertise and services include:
- IBM Cognos Analytics Services
- IBM TM1 Planning Analytics Services
- Installation, Setup, Content Store, Upgrades, Patching, Performance Tuning, Data Modeling, Development, Deployment, Project Management, Knowledge Transfer and Training.
- On-premises and Cloud hosted (Azure, Oracle Cloud, etc.)
- Data Warehouse Design and Implementation
- ETL and Data Life Cycle Management
Our company offers several consultants in these service areas with many years' experience including tenure working at Cognos and IBM.
ORACLE Services
- ORACLE 19c, 12c, and 11g Database Administration, Installation, and Configuration.
- ORACLE Real Application Clusters (RAC) and DataGuard installation and configuration on all platforms.
- ORACLE 13c, 12c Enterprise Manager Cloud Control Installation, Upgrades, Configurations.
- ORACLE 12c, 11g WebLogic and Fusion Middleware Installation and Configuration.
- ORACLE Backup Strategies, Disaster Planning, and Recovery Scenario Testing, High-Availability.
- ORACLE Integration: Interfaces between ORACLE, SQL Server, and other systems.
- ORACLE Database Upgrades, Patches and Data Conversion.
- ORACLE Fast-Track courses and Instruction in the ORACLE database, tools and technologies.
- ORACLE Platforms supported include Microsoft Windows Server, AIX, HP-UX, UNIX, Linux and Solaris.
Microsoft SQL Server Services
- SQL Server 2019-2005 Database Administration, Planning, Installation, and Configuration, Performance Tuning and Clustering.
- SQL Server Backup Strategies, Disaster Planning, and Recovery Scenario Testing.
- SQL Server Integration: Interfaces between SQL Server, ORACLE and other systems.
- SQL Server Database Upgrades, Migrations, Patches, and Data Conversion.