Martin Ritchie Email & Phone Number

Kitchener, On, Ca

Kitchener, Ontario, Canada

Supported over 600 cloud database servers containing 200,000 individual databases.Databases ranged from single gigabyte to over to 100 terabytes TB and over 20,000 transactions per secondImplemented Cloud Spanner very high availability solution.Optimized queries for 1000x improvement to performanceWrote integration test framework to cut down on development time and errorsMentored junior team membersProvided guidance to development teams on database design, and problem resolutionResponsible for returning systems back to operation during outages.

Kitchener

Technical and architectural design of PostgreSQL backend for product management website.Wrote PostgreSQL functions to read and write data to database.Designed secure multi-tenant solution.Ensured that database performance exceeded requirements.Wrote Node.js modules to access database.Wrote exhaustive test routines.

Toronto, Canada Area

Short term contract to improve database performance behind CBC News App.Achieved over 10,000% improvement in performance (target was 500% improvement).Instructed staff both formally and informally on steps to improve performance in future.

Kitchener

Created and implemented data model for electronic medical record system.Wrote functions to support back end processing and front end requirements within a PostgreSQL database.

Kitchener, Canada Area

Support developer for .net/Salesforce hybrid consumer facing web application.Created Support processes.Improved application up-time from 98% to 99.5%.Was primary support person for all incidentsPerformed Disaster Recovery testing.

Wrote design documents for the implementation of a .net reinsurance project.Created powershell scripts to control file transfer.Coordinated off-shore development.

Cambridge, Ontario

Ported SQL Server Integration Services package to new database schema.

Princeton, Ontario

Documented logical data model for existing data warehouse.Designed conceptual data model for the organization.Created logical data model for a salesforce implementation.Generated reports using COGNOS.Created custom ad-hoc and published reports from DB2 data warehouse.

Waterloo, Ontario

Designed and Developed ETL routines to process 1 Billion records per day.Designed and Developed High Performance Data Warehouse containing over 1 Trillion Records.Developed standard 3NF schemas as well as dimensional database schemas.Supported and optimized OLAP Front End.Managed Vendor Relationships.Supported and continuously improved legacy reporting systems.Updated web pages to use AJAX.Scaled and optimized reports to generate in excess of 300,000 reports per day while undergoing exponential data growth.Generated advanced ad-hoc reports as needed, often under ASAP time constraints.

Cambridge, Ontario

Introduced Project Management methodologies to team.Modified existing database structure for Manufacturing Execution System database.Refactored all existing Stored Procedures.75% space reduction.10x speed improvement.Developed new advanced configuration Windows application.