Badges
Certifications
Work Experience
Oracle DBA
Canadian Food Inspection Agency• June 2019 - Present
Migration Team to move from Oracle 10g to Oracle 12 and SQL Server 2008 to SQL Server 2016
IT Security Analyst
Employment and Social Development Canada• April 2019 - May 2019
Thoroughly conduct a security audit of production MS SQL Server databases to assess potential vulnerabilities and ensure effective protection against identified threats. Used document reviews, interviews and scripts to document compliance to CIS and ITSG-33 standards. Successfully delivered the SQL Server Audit 3 weeks ahead of schedule by leveraging strong IT analysis and project management skills.
Systems Analyst
Brookfield Renewable• November 2014 - February 2019
Oversaw the delivery of Tier 3 Support for multiple mission critical databases including: performance optimization, tuning large databases (Terabyte size), debugging and tracing ETL processes and web services, OEM Grid. Efficiently configured dashboards, reports, custom metrics, and jobs on OEM Grid. Successfully configured the new IFS Financial Application Linux platform in Azure to resolve system crashes and to enhance performance. Efficiently monitored and facilitated Data Guard on three Production databases to minimize threats and to ensure effective data protection. Established best practices for Active Directory regarding database access for Oracle and SQL Server, and initiated patching of all SQL Server databases for enhanced security. Key Projects: Upgrade Cognos Controller to SQL Server 2012 in Azure (Aug 2018 – Dec 2018) Successfully executed Azure and SQL Server configuration to streamline batch processing. Effectively applied PowerShell build scripts to deploy servers and databases. Efficiently completed the migration of Cognos Controller three times between different platforms and locations with minimal downtime and meeting all project objectives. Corporate Software Delivery, Systems Analyst and Vendor Management (Jul 2018 – Feb 2019) Efficiently monitored and advised vendors for IFS, Oracle, Linux and SQL Server in Azure, including online meetings, case submission and follow-up. Swiftly backed-up and refreshed the IFS databases on Oracle Linux in Azure and monitored using Oracle Cloud Control 13c. Delivered configuration, patching and optimization of the new Commvault backup solution in Azure. IFS upgrade and child projects (Nov 2016 – Jun 2018) Successfully identified and solved major issues with Oracle standbys across multiple locations. Wrote and deployed Rman scripts for backup, rebuild and restore. Effectively contributed to the testing, backup, rollout, and rollback to production of an EPayment Project. Coded and deployed the cleanup of over 2.8 billion obsolete records minimal downtime. Cyber Security Project (Sep 2017 – Sep 2018) Enhanced internal security for databases and applications with the project manager, application manager and senior technical DBA, QA and business analysts Strategically documented and established best practices for 20 production application/databases comprising COTS and custom solutions. SQL Server DBA - Migrate Cognos Controller (Jun 2015 – Aug 2015, Sep 2016 – Dec 2016) Effectively built new database to Brookfield specifications and transitioned the key database to SQL Server 2012 and the new Cognos version. Strategically partnered with a cross-functional and cross-continent team to efficiently solve user issues.
Oracle Applications DBA
Aboriginal Affairs• February 2014 - November 2014
Successfully executed testing, deployment, and maintenance of multiple Oracle databases to ensure alignment with department standards. Wrote documentation on project initiation, functional specifications, and business requirements. Confidently applied Windows scripting tools to archive logs and trace files, as well as OEM grid to create and schedule jobs. Efficiently standardized the deployment process to ensure a unified application/ database development, system testing, QAT, and UAT. Consistently applied Oracle Designer to assess and update existing models to meet client requests and standards. Expertly wrote and developed technical specifications for data manipulation of source and receiver data for the Corporate Information Repository
DBA and Database Developer
Canadian Human Rights Commission• March 2002 - February 2014
Delivered the development, testing, maintenance and upgrade of a custom case management database built with C# .Net, Oracle 9i and Oracle 11g. Thoroughly analyzed functional specifications, designed, and documented business logic, and added custom code including function-based indexes to extend data integrity. Expertly transitioned data from the legacy Oracle 8i system to the new 9i database (Over 100 tables), and from Oracle 9i to 11g with minimal downtime. Established comprehensive security practices by granting specific access rights and writing an interface to Active Directory. Successfully developed Recovery Manager (RMAN) scripts to supplement use of Oracle imp and exp as backup. Swiftly completed Extract, Transform and Load (ETL) import and export using SQL Loader and custom packages for web scraping and csv files. Efficiently identified ways to minimize costs related to Oracle Licenses leading to significant cost savings. Skillfully wrote a wiki document highlighting change management, code standards and implementation, troubleshooting and application architecture.
Education
Algonquin College
Technology Developer Program, B.Tech• July 2001 - February 2002