Dosql

Dosql Service Inc. is a database consulting firm focusing on IBM DB2, Oracle, Sybase ASE, Microsoft SQL Server, and MySQL. We have specialties and experiences in data architecture, database design, development and operation.

Incorporated in the province of Ontario, Canada in 2007, Dosql Service Inc has been providing database services at the client site or remotely over the internet. Our services can be customized to fit your business needs and budget constraints.

Services we provide

Data Architecture and Modeling
Collect business requirements and understand application architecture
Create conceptual, logical and physical data models with Sybase PowerDesigner, ERWin or Visio
Create and maintain data dictionary

Database Design and Development
Involve at different stages of the software development life cycle (SDLC)
Develop database objects to support application and implement business logic
Create database unit tests to verify database code against requirement

Database Project Build and Deploy
Build database project with Visual Studio Team System – Database Edition
Source control with Team Foundation Server (TFS), Subversion
Continuous integration, build and deploy with FinalBuilder, TFS Build, CruiseControl.Net

Data Warehouse and Business Intelligence
Create relational data model for Operational Data Store(ODS) and dimensional data model for Data Warehouse
Design ETL processes to load data to ODS and Data Warehouse
Create OLAP Cubes to support Business Intelligence (BI) analysis
Create management reports to support critical business decisions

Database Operation
Select software vendor and licensing options
Install and upgrade database management system (DBMS) software
Create and monitor routine database maintain plans and tune database performance
Manage security and monitor audit logs to ensure compliance and detect intrusion
Establish disaster recovery plan and verify periodically to ensure data is safe
 
Capacity Statement
DBMS and Certificate:

• DB2 UDB: IBM Certified Solutions Expert
• Oracle: Oracle Certified Professional (OCP)
• Sybase ASE
• Microsoft SQL Server: Microsoft Certified System Engineer (MCSE)
• MySQL

Operating System:

• Microsoft Windows
• IBM AIX
• Sun Solaris
• HPUX
• Linux

Our Previous and Current Clients

• Government of Alberta
• CIBC
• TD Canada Trust
• Insurance Bureau of Canada
• IBM
• Bell Canada
• MacCosham Logistics
• Dima Glass Inc.

Contact us

Dream hosted by: