SUMMARY:

• 27+ years of experience in teh IT industry
• 17+ years of experience with database development and administration
• Oracle Certified Professional (OCP)
• Oracle Cloud Infrastructure (OCI) Certified Architect Associate
• Oracle Autonomous Database Cloud Certified Specialist
• Oracle Cloud Infrastructure (OCI) Foundation Certified Associate
• Installation, patching, upgrade and migration of Oracle servers 19c/18c/12c/11g/10g/9i/8i
• Database performance monitoring and tuning
• SQL performance tuning
• Oracle Data Guard, Active Data Guard and Data Guard Fast - Start Failover (FSFO)
• Oracle Grid and ASM
• Oracle RAC and RAC One Node
• Oracle Multitenant Architecture (CDB, PDB)
• Unix (IBM AIX, SUN Solaris), Linux (Red Hat Linux & Oracle Linux) and Windows
• Oracle Enterprise Manager (OEM) Cloud/Grid Control and OEM on OCI
• ADDM, AWR, ASH, SQL Tuning Advisor, TKPROF
• Toad, SQL Developer, Exceed, Putty, SSMS
• Oracle WebLogic, Oracle Identity Management and Oracle Internet Directory (OID)
• OLTP and data warehousing
• Oracle High Availability (HA) and Disaster Recovery (DR)
• RMAN and all backup and recovery scenarios
• Unix shell scripting, SQL scripting and PL/SQL programming
• Virtual Private Database (VPD) - row level security / fined-grained access control
• Oracle Cloud (OCI) - architecture, network, compute, storage, security and database including User Managed and Autonomous database
• Oracle Private Cloud Appliance (PCA) and Oracle VM and VMware
• Oracle Application Express (APEX)
• SQL Server instance and SQL Server database administration
• ITIL/ITSM
• Logic and critical thinking
• Positive and can-do attitude

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Working as teh technical lead for teh Oracle 12c and19c upgrade projects: made decision about upgrade methods; performed Oracle 12c and 19c upgrade POC (Proof of Concept); created teh upgrade documents; provided to teh
• Oracle DBA team; providing technical support to other DBAs for teh upgrade and fixing problems encountered during teh upgraded
• Worked as teh technical lead of teh Infrastructure Initiative project to migrate massive databases to PCA: made decision about migration method; made teh plan and teh schedule; wrote instructions for teh migration; coordinated teh migration efforts among DBA team, Unix team and application support teams; fixed problems
• Involving in teh Oracle Cloud transformation including planning, building database system on Oracle Cloud Infrastructure (OCI), Oracle database migration from On-Prem to OCI, deploying OEM 13c on OCI, providing support to teh database on OCI and creating documentation to facilitate teh transformation and for teh OCI support
• Supporting other DBAs in Oracle DBA team
• Actively participating in projects, developing databases and supporting application teams and vendors
• Successfully and smoothly migrated teh Oracle Internet Directory (OID) system: planning; creating databases, installing Oracle Identity Management; setting up replication; migrating entries from teh old system to teh new system; cutting over
• Converting physical standby databases to snapshot standby databases to support application testing using teh Data Guard Broker
• Cloning and refreshing teh databases as required
• Providing to offshore DBAs

Confidential

Database Administrator

Responsibilities:

• Independently conducted thorough exploration on Oracle Engineered Systems (Oracle Exadata and VCA/PCA) for teh company to determine teh enterprise-wise new platform to host all teh Oracle databases
• Lead teh technical efforts to migrate Oracle databases to our new consolidated platform PCA (Private Cloud Appliance)
• Lead teh technical efforts to setup and configured 3-node RAC 12c on Linux 7: Installed Grid Infrastructure and Oracle Real Application Cluster software; Created RAC and RAC One Node databases; Converted standalone databases into RAC and RAC One Node databases; knowledge transfer
• Initiated teh efforts of managing Oracle Data Guard configurations through Oracle Data Guard Broker; Setup data guard broker and transferred teh knowledge to teammates
• Initiated teh efforts to setup teh first Fast Start Failover (FSFO) for 10gR2 data guard; Setup teh system and performed testing; Performed teh demo and passed teh knowledge to teammates
• Designed and wrote scripts to refresh test/development databases from production databases automatically
• Performed database and SQL tuning using AWR, ADDM, OEM, SQL Trace, TKPROF, Explain Plan, V$ views, etc.
• Resolved a database backup performance problem by implementing Oracle RMAN backup compression feature
• Created Oracle VPD (Virtual Private Database) security policies to implement fine-grained access control to databases
• Setup MIR3/INS paging system for teh Oracle DBA team: Configured teh system and performed teh testing and trained teammates for using teh system for on call purpose
• Implemented security hardening for a power transmission network monitor and control center of ATCO Electric
• Participated in disaster recovery (DR) functional testing and exercises between Edmonton and Calgary using RMAN and Data Guard
• Upgraded various databases from Oracle 9g/10g/11g to 10g/11g/12c on Solaris and Linux using various upgrade methods
• Cloned databases using different methods for various purposes
• Migrated a Microsoft ACCESS database to Oracle database using SQL Developer
• Performed database changes and code promotions according to change management process using ITIL-based tool ServiceNow
• Provided technical support for projects and application development efforts
• Participated 24x7 on call support for critical production systems
• Installed and configured new SQL Server
• SQL Server database development and administration
• Created SQL Server objects (tables, indexes, views, stored procedures and triggers)
• Performed SQL Server database backup and recovery
• Setup DR plan for SQL Server database and participated in DR exercises
• Performed side by side Upgrade/Migration of MS SQL Server

Confidential

Database Administrator

Responsibilities:

• Installed Oracle 10g/9i/8i on AIX and Linux and created databases using scripts and DBCA
• Upgraded Oracle 8i/9i database to 9i/10g
• Created Data Guard physical standby databases
• Created various database alert scripts, database monitoring scripts and database backup scripts
• Designed and created profiles to enhance database security
• Participated in designing and building teh data warehouse; defined and created tables, indexes, partitions and compression
• Monitored, troubleshoot and tuned teh database and application
• Fixed a super slow multiple-step monthly report and cut teh duration from 2 days to half day
• Designed and implemented database online and offline backup and complete and incomplete recoveries by using shell scripts and Oracle RMAN
• Created database object creation scripts and wrote procedures, functions and triggers
• Performed database refreshed as per requirement of application using Export/Import and Data Pump
• Installed and configured job scheduler AutoSys
• Created database for application testing and development
• Supported mission critical 24x7 systems
• Provided technical support to application development teams and end-users

Confidential

Application programmer

Responsibilities:

• Solved a big problem that plagued teh bank for quite time.
• Installed and customized CICS
• Performed tuning on CICS and improved teh system performance
• Developed automatic monitoring and activating system to manage network sessions using REXX language
• Customized teh Netview system
• Provided support to operators, developers and end users
• Developed a telephone banking system on SCO Unix and some other banking business applications using COBOL and C

Confidential

Application Programmer/Senior Application Programmer

Responsibilities:

• Numerical calculation (BASIC)
• Management information system (COBOL, Dbase, Foxpro)
• Industrial computer control system (assemblers)