Jun Liu

Oracle Database Administrator

Medtronic

Minneapolis

02.2017 - 09.2019

Provided Support of Oracle and SQL Server databases (Oracle 11G, 12C,19C/SQL 2014,2016,2017) in production, testing and development environments hosted on Solaris, Linux, Windows servers.
Installed databases from Oracle 11g to Oracle 12c/18c/19c Container & Pluggable Database.
Cross platform upgrade migration between different endian servers from 11g to 12c.
Upgrade and migration of SQL Server database from 2014 to 2016/2017, from On Premise to Azure.
RMAN level 0, 1, and 2 backups, Full backup and Incremental backup and database recovery.
Daily Backup of SQL Server databases use SSMS include full backup and incremental backup as a job.
Refreshed schema/database using Data Pump Export/Import or RMAN Duplicate.
Refresh of SQL Server databases from PROD to DEV/QA/TST using SSMS.
Set up OEM and configure Monitor database performance via Oracle Enterprise Manager (OEM).
Performance Tuning via generate AWR/ASH/ADDM, use Execution Plan, to diagnose and fix SQL and PL/SQL related issues to improve database performance and recommend Applications code rewrites.
Maintenance WebLogic Server 12c and 11g include HTTP(OHS) Server for Banner, APEX, EFORM, EPAY and +100 PL/SQL Developer applications. Manage admin server and managed server in cluster.
Configure Oracle Wallet Manager for HTTPS certificates and Oracle 12c, 11g ACL features for SMTP, HTTP, etc.
Write PL/SQL and UNIX shell scripts to automate database functions.
Database Capacity Management and Resource Planning.
ServiceNow to create and manage Service Requests, Incidents, Change Requests, and Projects.
Actively participate in Change Advisory Board (CAB) providing key input.
Provide on-call support in adherence to specific business and customer Service Level Agreements.

Similar Profiles