IslandTech Computer Group provides Oracle database development, data warehousing and reporting consulting. Serving clients since 1997.
We are based in British Columbia on Vancouver Island. We provide systems support, build and maintain data warehouses, ETL and reporting, and modernize and automate application deployment pipelines.
Services
- Data warehouse design, ETL and data modelling
- Oracle SQL and PL/SQL development
- Oracle Reports development
- Release automation for databases, reports and applications (Jenkins, GitHub Actions)
- Continual system modernization
- REST and JWT data integration
- Linux system administration and support
- Requirements and systems analysis, technical documentation and user training
Selected work
Client details are confidential, so these examples are anonymized.
For a provincial government financial data warehouse, we replaced a multi-person manual release process with an automated pipeline using Jenkins and GitHub Actions. One person can now release reports, applications and database changes across delivery, test and production databases in a single step. This removed the multi-week scheduling lead time and cut emergency-fix turnaround from multiple days to a single afternoon.
We moved a PeopleSoft data feed from a direct Oracle database extract to REST access with JWT authentication against a cloud-hosted source on Oracle Cloud Infrastructure. We developed the PL/SQL components that handled the REST layer and isolated the change from other components.
Technology
- Databases
- Oracle 19c, 12c, 11g; SQL; PL/SQL; SQL*Loader; Oracle Partitioning; Virtual Private Database; Oracle Advanced Security; Oracle Financials R12; PeopleSoft schema; AirTable
- Reporting and middleware
- Oracle Reports 12c; Oracle Fusion Middleware / OAS 12c
- Delivery
- Git; Jenkins; GitHub Actions; Ansible; CI/CD; Docker; Vagrant; VirtualBox
- Integration and scripting
- REST; JWT; JavaScript; Node; Discord; bash/ksh; Linux
Contact
Available for contract engagements.