Senior Oracle Applications Database Engineer

RUI (RAY) WANG

Senior Database Administrator

Calgary, Alberta, Canada 403-***-**** ******@*****.***

PROFESSIONAL SUMMARY

A Senior Database Administrator with more than 20 years of production experience across Oracle, Microsoft SQL Server, and Azure, combining deep reliability and performance engineering with modern automation. Owns enterprise database estates end to end: architecture, high availability, disaster recovery, performance tuning, migration, and the tooling that keeps all of it observable.

Migrated Oracle database from Oracle RAC to Azure Cloude, migrated hundreds of SQL Server instances from on premises to Azure SQL Database and Azure SQL Virtual Machines, converted Oracle workloads to SQL Server, and designed the corporate SQL Server strategy at NOVA Chemicals. Operates Oracle RAC/ASM, Always-On Availability Groups, Failover Clustering, Data Guard, and RMAN in production.

Builds the tooling rather than waiting for it. Designs and ships Python, PowerShell, and T-SQL monitoring and automation — including a Python Oracle monitoring platform on a PostgreSQL repository that replaces key Oracle Enterprise Manager functions, automated blocking and connection-leak detection, and a contribution to the open-source DBA Dash project. Works spec-first using GitHub Spec Kit methodology, with LLM coding agents (Claude Code, Codex) as an implementation accelerator under engineering review — retaining ownership of design, failure-mode analysis, and production safety.

CORE COMPETENCIES

Microsoft SQL Server (21+ yrs): SQL Server 2000–2022 • Performance Tuning & Query Optimization • Query Store & Regression Analysis • Always-On Availability Groups • Failover Clustering • Backup & Recovery • SQL Server Agent • Capacity Planning • Migration & Upgrades • Licensing & Audit • Azure SQL Database & Azure SQL MI

Oracle (20+ yrs): Oracle 8i–19c • RAC • ASM • Oracle Database Appliance • RMAN • Data Guard • Oracle Enterprise Manager • AutoUpgrade • SQL Tuning • Oracle APEX • Oracle ORDS • Oracle HTTP Server• Oracle WebLogic • Linux & Windows

Cloud & Modernization (5+ yrs): Azure SQL Database • Azure SQL Virtual Machine • On-premises to Azure migration • Oracle-to-SQL Server conversion • Cloud assessment (Azure, AWS, GCP) • Hybrid database architecture

Other Platforms: PostgreSQL •MongoDB •Sybase ASE / IQ • VMware • Hyper-V • Windows Server • Linux • UNIX • Enterprise Storage

Programming & Automation: Python • PowerShell • T-SQL • PL/SQL • Bash & Batch scripting • REST/API integration • SQL Server Agent job engineering • Monitoring & alerting pipelines

Development Toolchain: Visual Studio Code • Git • GitHub • GitHub CLI • GitHub Spec Kit (spec-driven development) • Claude Code • OpenAI Codex • Claude Opus • ChatGPT • Markdown technical documentation

Engineering Practice: Spec-driven development • Code review of AI-generated output • Non-production validation before deployment • Runbook and operational documentation • Root-cause analysis • Incident response & on-call

PROFESSIONAL EXPERIENCE

Senior System Analyst — Database Technology NOVA Chemicals, Calgary, AB

September 2012 – September 2026

Senior technical owner of the enterprise SQL Server and Oracle estate supporting SAP, Primavera, SharePoint, BizTalk, Data Warehouse, and plant-critical applications across Canadian and U.S. sites.

Cloud Migration & Database Modernization

•Migrated hundreds of SQL Server instances from on-premises environments to Azure SQL Database and Azure SQL Virtual Machines, establishing a repeatable assessment, cutover, and validation process.

•Converted Oracle databases to Microsoft SQL Server and landed the resulting workloads in Azure, reducing Oracle licensing exposure and consolidating the supported platform footprint.

•Designed and implemented the corporate Microsoft SQL Server strategy, defining supported versions, HA/DR standards, and the decommissioning path for legacy estates.

•Evaluated Azure, AWS, and Google Cloud against enterprise database and infrastructure requirements to inform platform direction.

Database Automation & Monitoring Engineering

•Designed and built a Python-based Oracle monitoring platform replacing key Oracle Enterprise Manager functions — tablespace utilization, resource utilization, RMAN backup status, invalid objects, and locking. Selected PostgreSQL as the central repository to avoid additional Oracle licensing for monitoring data, and scoped the build to the OEM capabilities actually in use.

•Engineered SQL Server Agent automation to detect and terminate idle leaking connections, defining the idle-session criteria conservatively so that legitimate long-running workloads are never affected — reducing resource consumption and improving instance stability.

•Built continuous blocking and locking monitoring in T-SQL and SQL Server Agent with automated DBA email alerting, converting a recurring manual diagnosis into a detection-before-impact control.

•Contributed a disk-performance monitoring capability to DBA Dash, the open-source SQL Server monitoring platform, via GitHub.

•Developed a Python real-time disk performance meter for storage architecture decisions, measuring achievable throughput under database-style I/O patterns rather than relying on vendor specifications.

•Authored an operational runbook and PowerShell automation for Oracle HTTP Server certificate renewal, removing a recurring manual, error-prone procedure.

•Applied spec-driven development (GitHub Spec Kit) across these projects — defining requirements, edge cases, and acceptance criteria before implementation, using LLM coding agents to accelerate delivery while retaining design ownership, code review, and non-production validation before any production deployment.

Oracle Administration & Performance

•Administered Oracle 8i through 19c on Linux and Windows, including 11gR2 and 12c RAC/ASM on Oracle Database Appliance V1, X3-2, X4-2, and X5-2 platforms.

•Upgraded and migrated Oracle databases from 12c on Linux to 19c on Windows Server using the Oracle AutoUpgrade methodology.

•Performed Oracle SQL tuning and performance optimization across 10g, 11gR2, and 12c RAC/ASM environments; administered Oracle Enterprise Manager 11g/12c and Oracle Internet Directory 10.1/11.1.

•Managed Oracle licensing position and compliance reporting.

SQL Server Administration & Performance

•Administered SQL Server 2000 through 2019 across Hyper-V and VMware, investigating and resolving complex performance and concurrency issues.

•Designed and implemented SQL Server 2012–2019 Failover Cluster and SQL Server 2016 Always On Availability Group environments on Windows Hyper-V.

•Decommissioned legacy SQL Server 2000/2005/2008/2008 R2 estates and upgraded platforms to supported 2012–2019 versions.

•Delivered database platform upgrades for SharePoint, BizTalk, Lync, and Hexagon SmartPlant suite including SmartPlant Foundation, Smart Reference Data, Smart 3D, SPI, and SPID onto clustered and Always On SQL Server environments; supported Primavera P6 upgrades from v7.0 through v20.0 and its SAP 7.3 integration.

•Managed SQL Server licensing and audit response.

Senior Consultant Longview Systems, Calgary, AB

November 2011 – September 2012

•Delivered senior Oracle and SQL Server consulting, administration, and production support across energy, financial, manufacturing, and transportation clients.

•Supported Oracle on IBM AIX, Linux, and Windows — including Data Guard environments — and clustered SQL Server implementations.

•Client environments included NAL Energy, Bonavista Energy, Olympia Trust, Intrawest, Nature's Path Foods, and Denver International Airport.

Senior Consultant / Team Leader TELUS, Calgary, AB

November 2001 – November 2011

•Provided senior database consulting, performance tuning, and technical leadership for government and health-region customers; mentored and led DBA staff.

•Tuned Oracle 7–11gR2 RAC/ASM, SQL Server 7.0–2008, and Sybase 11.5–12.5 environments supporting PeopleSoft, Tuxedo, and WebLogic applications.

•Designed indexes, stored procedures, triggers, and physical structures; partitioned Oracle tables and indexes across tablespaces to reduce I/O contention.

•Optimized SQL Server data, log, and tempdb file layouts across physical storage; diagnosed transaction behaviour with SQL Profiler, SQL Analyzer, and PSSDiag.

•Configured and optimized Oracle RMAN backup environments, including memory and multi-channel tape I/O tuning, and automated archived-log backups via scripting.

IT Consultant & Advisor Buchanan Associates, Toronto, ON

January 2001 – September 2001

•Designed and implemented the corporate database backup and recovery strategy; automated full and transaction-log dumps via scripting.

•Resolved blocking and lock-contention issues through lock promotion tuning and table locking strategy; provided Level 3 support and trained junior DBAs.

SELECTED ENGINEERING PROJECTS

•Oracle Monitoring Platform — Python, PostgreSQL, Oracle, GitHub, Spec Kit. Centralized monitoring for tablespace, resource utilization, RMAN backup status, invalid objects, and locking; designed as a licensing-free replacement for the Oracle Enterprise Manager functions in active use.

•SQL Server Connection-Leak Automation — T-SQL, SQL Server Agent. Detects and safely terminates idle leaking sessions; conservative qualification criteria protect legitimate long-running work.

•SQL Server Lock & Blocking Monitor — T-SQL, SQL Server Agent, Database Mail. Continuous detection with automated DBA alerting on problematic blocking chains.

•DBA Dash Contribution — GitHub, DBA Dash. Added disk-performance monitoring to an open-source SQL Server monitoring platform.

•Disk Performance Meter — Python. Real-time measurement of achievable disk throughput under database I/O patterns, used to validate storage design decisions.

•Oracle HTTP Server Certificate Renewal Automation — PowerShell. Runbook plus automation replacing a recurring manual certificate procedure.

OTHER SKILLS/ABILITIES

•Experience PostgreSQL v16, V17 and v19, MongoDB v7, v8

•Working knowledge of PostgreSQL or Enterprise DB database environments

•Experience managing SAP and Primavera P6 connections, SQL jobs, stored procedures, and reporting jobs

•SQL Clustering on Windows Failover Cluster

•Scripting SQL Monitoring, alerting, and diagnosis

•Linux and UNIX shell scripts

•Other duties as assigned

AI, LLM & Intelligent Database Automation

•Generative AI / LLM: Claude Opus, ChatGPT

•AI-assisted database administration and performance engineering

•AI-assisted SQL analysis, optimization, troubleshooting, and code generation

•AI-assisted Python, PowerShell, T-SQL, and SQL Agent development

•AI-driven database monitoring and operational automation

•AI-assisted root-cause analysis and technical research

•AI-assisted software design, development, debugging, testing, and documentation

•Spec-driven development and AI coding-agent workflows

•GitHub Spec Kit methodologies

•AI-assisted enhancement of DBA Dash (GitHub)

•AI-assisted Query Store and database performance analysis

•Query performance monitoring and regression detection

•Intelligent DBA workflow automation

•AI-assisted runbook and operational procedure generation

Microsoft SQL Server

•21+ years

•SQL Server 2000–2019

•Database Administration

•Performance Tuning & Troubleshooting

•Query Optimization

•Query Store

•Query Regression Analysis

•SQL Server Agent

•High Availability / Disaster Recovery

•Always On Availability Groups

•Failover Clustering

•Backup & Recovery

•Database Migration & Upgrades

•Capacity Planning

•Performance Monitoring

•Windows Hyper-V

•VMware

Oracle

•20+ years

•Oracle 8/8i/9i/10g/11g/12c/19c

•Oracle Database Administration

•Oracle RAC

•Oracle ASM

•Oracle Database Appliance

•RMAN

•Oracle Enterprise Manager

•Oracle AutoUpgrade

•Performance Tuning

•Backup & Recovery

•Database Upgrades & Migration

•Oracle Internet Directory

•Oracle APEX and ORDS

•Oracle HTTP Server

•Linux and Windows Oracle environments

Microsoft Azure

•5+ years

•Azure SQL Database

•Azure SQL Virtual Machine

•Azure Database Administration

•On-premises to Azure database migration

•SQL Server modernization

•Oracle-to-SQL Server migration

•Azure database architecture and administration

•Azure cloud assessment and strategy

Programming & Automation

•Python

•PowerShell

•T-SQL

•SQL scripting

•Batch scripting

•SQL Server Agent

•Database monitoring automation

•Performance monitoring automation

•Backup/recovery automation

•AI-assisted software development

CERTIFICATIONS

• Microsoft Certified: Azure Database Administrator Associate

• Oracle Certified Professional (OCP)

• Microsoft Certified Database Administrator (MCDBA)

• Microsoft Certified Systems Engineer (MCSE)

• Microsoft Certified Professional (MCP)

EDUCATION

Master's Degree — Nanjing University of Aeronautics and Astronautics

Bachelor's Degree — Nanjing University of Aeronautics and Astronautics

Contact this candidate