Projects

Oracle

Database planning, design and implementation

Installation, setup and configuration

Identifying performance bottlenecks in the database

Converting and loading data into Oracle from legacy applications

Migration from Oracle 9i,10G to 11G on Windows, Unix and Linux platforms

Designing data models

SQL and PL/SQL programming and tuning

Training users in SQL and database administration

RMAN configuration

Oracle Internet Directory (OID) setup and configuration

Unix shell scripting for backup and ETL processes

GIS

Custom GIS data sets. Download 1:20k Grid shape file for Canada. Numbering based on the BCGS mapping system. For this project each 1:250k NTS grid was divided into 100 squares.

Database Reporting

Development of Crystal Reports for Oracle