Jun Liu
San Leandro
Summary
An Oracle DBA who has over 7 years experience, is a technical professional responsible for installing,Configuring,monitoring and maintaining Oracle database systems.Key responsibilities include daily database management, performance tuning, backup and recovery, security control, and trouble shooting.Extensive experiences including Oracle database design, modeling,administration, implementation, PL/SQL, RMAN, RAC, ASM, DataGuard, GoldenGate, OEM, Exadata, Weblogic, OCI. SQL Server/Azure, PeopleSoft PeopleTools installation, configuration, upgrade, migration, trouble-shooting, and performance tuning. Have impeccable communication and interpersonal skills and an exceptional team player.
Overview
3
3
years of professional experience
Work History
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.
Education
Bachelor Degree -
Kunming University of Science and Technology
Kunming, China01.2010
Skills
- Oracle Database/RAC 9i/10g/11g/12c/18c/19c/23c, SQL Server(2012/2014/2016/2019/2023), MySQL, PG, NoSQL
- Peoplesoft, Ellucian Banner, Apex, etc
- SQL and PL/SQL, TSQL, Perl, Korn/Bash Shell
- Linux, Solaris, IBM AIX, HP-UX, Exadata, OCI, Windows, Azure, AWS
Personal Information
Marital Status: Authorized to work in US
Timeline
Oracle Database Administrator
Medtronic
02.2017 - 09.2019
Bachelor Degree -
Kunming University of Science and Technology
Similar Profiles
Mohamed HassanMohamed Hassan
Senior Software Engineer at MedtronicSenior Software Engineer at Medtronic
Yuki NoskerYuki Nosker
Senior Global Product Manager at MedtronicSenior Global Product Manager at Medtronic
Carlos BamacaCarlos Bamaca
Product Assembler at MedtronicProduct Assembler at Medtronic
Anna Marie ErvinAnna Marie Ervin
Sales Solutions Coordinator - Diabetes at MedtronicSales Solutions Coordinator - Diabetes at Medtronic
Fatima VerdugoFatima Verdugo
Svc Center Support at AAA Cooper TransportationSvc Center Support at AAA Cooper Transportation