Data Services

Database Support

Database Support Services is an easy, secure and cost-effective solution to manage your database systems. This service will augment your existing database administration staff and provide you access to knowledgeable experienced Database Analysts (DBAs). Avocette offers a variety of packages to suit your specific needs. Database Support can include flat or tiered pricing. You can also choose between 24×7 coverage or business hours only.

Database Services

Avocette has skilled analysts that are able to build data architecture blueprints required to guide integration, quality and successful data delivery. We employ data modeling best practices and techniques to help integrate any complex business data requirements into a data model. Our team of analysts, supported by experienced DBAs, will conduct data mapping exercises as required when migrating from a legacy database to a new version, in order to ensure a successful database deployment.

 

When upgrading a database management system (DBMS) to a new version, we will plan and prepare all steps ranging from developing an upgrade strategy, designing test plans and deployment schemes. We will ensure data integrity and ensure that the upgraded database is optimized and performs to meet expectations, including loading production data and rolling out the production database.

 

We provide proactive monitoring and continuous database performance analysis and assessments. We also are available to address emergency performance issues quickly and effectively. Our complete database health check services help safeguard infrastructure against costly database outages.

Database Development

Avocette has developed over 50 applications in recent years, and brings expertise in a wide range of database development using both SQL Server and Oracle. We currently provide database support and development for the Ministry of Children and Family Development, Service BC, the Ministry of Community, Sport and Cultural Development, Ministry of Justice, WorkSafeBC, and more.

Data Storage and Archiving

A database system functions best when the storage it operates upon is appropriate and well managed. We’ll ensure this is the case. We provide enterprise-level data protection. We back up your data, either continuously throughout the day or at pre-set intervals, and provide the proper offsite storage solutions.

Data Warehouse

Avocette’s Data Warehouse experience includes designing, building and support of data warehouse ETL processes for the Ministry of Children and Family Development.  Avocette understands the critical nature of the data warehouse, getting the right data, at the right time to the program areas and executives for strategic decisions.  We have experienced resources in business analysis, warehouse technical architecture, data mart design and Oracle development.