Scott LeBlanc

Canadian consultancy firm delivering professional Oracle database administration services with emphasis on security, scalability, efficiency and reliability. Deliver ongoing managed services that emphasize proactive optimization, readiness, and trusted client advisory for sustainable business outcomes. Expertise in the intricacies of RMAN, Data Guard, performance tuning and Oracle Advanced Security on-premises environments directly translates into the ability to architect and optimize same capabilities in Oracle Cloud Infrastructure.

Strengthened data security and compliance by implementing Transparent Data Encryption (TDE) and managing SSL/TLS certificates for encrypted communications. Ensured operational effectiveness in cybersecurity and recoverability by applying corporate security policies. - Enhanced audit readiness and operational oversight by designing and deploying Oracle Unified Auditing frameworks. - Exceeded retention, data loss, and downtime requirements by creating automated RMAN backup and recovery scripts. - Secured DoD-owned Oracle data by implementing STIG-based database configurations in compliance with DISA standards. - Reduced downtime and data loss from hours to minutes by designing Oracle Data Guard solutions with offsite standby databases. - Increased operational efficiency by leveraging Oracle Enterprise Manager to prioritize metrics, triage events, and communicate issues. - Tripled managed database count at zero incremental cost by utilizing Oracle Multi-Tenant, while reducing per-database licensing expenses. - Identified $20M in license risk and ensured compliance through in-house audits / education during Oracle license negotiations. - Improved application processing time from hours to minutes by resolving performance issues via indexing, query optimization, and database tuning using OEM, ASH, AWR, ADDM, trace files, and TKPROF.

Ensured all departmental database backups consistently met RTO and DLO requirements defined in business impact assessments. Supported team capabilities by mentoring and coaching Junior DBAs. Advised executive leadership on database modernization, emerging technologies, and long-term data management strategies. - Reduced database recovery test time from one hour to zero by automating recovery processes. - Minimized documentation costs and effort by leveraging RMAN Recovery Advisor for recovery procedures. - Eliminated manual backup checks (previously 10 minutes per database) by developing PL/SQL-based automated integrity evaluations. - Improved application support and performance by liaising with application DBAs and providing expert guidance to application teams.

Disaster Recovery • Designed, implemented, and maintained database backup processes, meeting downtime, recovery time, and data loss objectives and maintaining business continuity. • Completed recovery to disaster recovery site successfully, maintaining business continuity during Calgary Flood (2013) and 4-day city wide power outage in Calgary (2014). Backup and Recovery • Modernized backup process, reduced disk overhead for backups by 50%, while increasing options for recovery by validating and implementing RMAN, Oracle’s backup and recovery tool. • Minimized recovery procedure documentation cost and effort by leveraging RMAN to automate monitoring of backup success and automate backup integrity tests. • Developed backup checks using PL/SQL that automated evaluation of backup integrity, reducing manual backup checks from 10 minutes per database to 0. Availability Through Automated Monitoring • Improved reporting capability, leveraging historical capacity data for trend analysis and server capacity planning by installing, configuring, and maintaining UpTime monitoring tool. • Designed and built automated database integrity checks, backup checks, and schema integrity checks, reducing triage time for database troubleshooting from hours to minutes. • Identified potential database and application failure points which reduced support ticket count and turnaround time by automating root cause identification during troubleshooting phase of problem solving. Automation and Scripting • Designed, developed, and implemented automated processes, improving capability, capacity, and consistency of completing day-to-day operational tasks. Application System Performance Management • Sourced, evaluated, and implemented Lab 128 application, automating performance data collection on Oracle Standard Edition databases. • Leveraged Oracle Enterprise Manager (OEM), Automatic Workload Repository (AWR), and database trace files, improving performance management and troubleshooting.

Catering Sales Manager • Consistently met or exceeded sales targets. • Qualified and interpreted customer requirements. • Worked closely with hotel departments and staff to ensure customer expectations were exceeded.