Resume

Sign in

DBA, System Analyst, Security Analyst

Location:
Ottawa, ON, Canada
Posted:
May 23, 2020

Contact this candidate

Resume:

Kevin LaRoche

Ottawa, ON, Canada

613-***-****• addd7h@r.postjobfree.com

https://www.linkedin.com/in/kevinlaroche/

Systems Analyst & Oracle DBA

Multifaceted technical career with 18-year track record of success

Technically sophisticated Systems Analyst & Oracle DBA with solid experience executing tier 3 support and project delivery to facilitate deployment, configuration and migration of core Infrastructure services in the cloud or multi-site global enterprise environment. Driven Systems Analyst with proven track record of success deploying, configuring, and maintaining production, development and testing databases based on Oracle, SQL Server, Linux and Windows operating Systems. Experienced IT professional in troubleshooting and isolating issues and failures in a hybrid virtual / physical server environment. Possess the ability to engage with program leadership, external business partners and customers to facilitate communications and project decisions acceptance.

Deployment, Configuration & Migration of Core Infrastructure/ Database Maintenance & Cyber Security

Security Risk Assessment & Problem Solving/ Troubleshooting & Issue Resolution

TECHNICAL PROFICIENCIES

Platforms:

Oracle 10, 11, 12, SQL Server 2005, 2008, 2012, 2014, 2016 Windows Server 2003, 2008, 2012, 2016, Linux

Tools:

Azure, Cognos Controller, Cognos Business Intelligence, HP Application Lifecycle Management, IFS, multiple .Net in house applications hosted at vendors and in the cloud, Citrix, Commvault, Netapp, OEM Grid, Cloud Control, PowerShell, Service Now, SSRS Reporting, Team Foundation Server, Team Viewer, Visual Studio, VMware

PROFESSIONAL EXPERIENCE

Analyst, Oracle Database Services (January 2020 – March 2020) Shared Services Canada

Technical Scope: Oracle 12, 19, OEM Cloud Control 13C, RHEL Linux, Commvault

All activities to support Oracle as a service for clients using Multi-Tenant architecture including creating Gold Images, patching, implementing security and auditing and capacity planning.

Senior Data Conversion Specialist (September 2019 – December 2019) Department of National Defense

Technical Scope: MS SQL Server, PowerShell, Mongo DB

Import, clean and validate data from databases and SharePoint sites to a Mongo DB database using a REST API.

Inform and get approval from data owners about the results of the conversion.

Overcame budget and security constraints by creating a PowerShell module to handle discovery, export and import to Mongo DB.

Reporting and data warehouse creation as required.

Oracle DBA, Migration Team (June 2019 – September 2019) Canadian Food Inspection Agency, CA

Technical Scope: Oracle 10, 11, 12 SQL Server 2008, 2016, Windows Server 2008, 2012, 2016, Linux

Saved hundreds of hours of work by writing PowerShell Scripts to install Oracle clients in development

Wrote shell scripts to rotate listener logs on Windows and Linux

Backed up, restored and migrated Oracle 10g databases to Oracle 11 and 12

IT Security Analyst (April 2019 – May 2019) Employment and Social Development, CA

Technical Scope: MS SQL Server

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 & Technical Lead (November 2014 – February 2019) Brookfield Renewable Energy, CA

Technical Scope: Oracle 10, 11, 12, SQL Server 2005, 2008, 2012, 2014, 2016 Windows Server 2003, 2008, 2012, 2016 Linux, Azure, Cognos Controller, Cognos Business Intelligence, HP Application Lifecycle Management, IFS, multiple .Net in house applications hosted at vendors and in the cloud, Citrix, Commvault, Netapp, OEM Grid, Cloud Control, PowerShell, Service Now, SSRS Reporting, Team Foundation Server, Team Viewer, Visual Studio, VMware

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 (Feb 2014 – Nov 2014) Aboriginal Affairs, CA

Technical Scope: Oracle 10, 11, Oracle Designer, Oracle Enterprise Manager, BMC Remedy

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 (Mar 2002 – Feb 2014) Human Rights Commission, CA

Technical Scope: Oracle 8, 9, 11, Oracle Forms, .Net

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 AND TRAINING

Technology Developer Program, Algonquin College, Honors (2002)

Amazon Certified Cloud Practitioner (March 2020)

Microsoft Certified Azure Fundamentals (March 2020)

Security Clearance: Secret File 95-09-7993 expires May 1, 2028 and Top Secret expires November 20, 2024



Contact this candidate