Assistant Network

XU PIDONG

Dandong Liaoning, China +86-132********

*****************@*****.***

I am an IT professional with 10 years of experience in system and network support. I have a strong understanding of network architecture and system administration as well as information technology in general. I have proven adept at handling user complaints, troubleshooting and diagnosing problems, and explaining network issues in both technical and laymen’s terms. Oracle Database Administrator with a Top Secret Clearance and 6 years of experience designing, installing, upgrading, and maintaining 11gR1/R2 databases in large-scale UNIX/Linux environments. Professional skills include Backup and Recovery methodologies (RMAN), Performance Tuning, Security and User Management.

EXPERIENCE

3/2007 – 10/2012

SYSTEM & NETWORK ADMINISTRATOR, AGRICULTURAL BANK

Agricultural Bank is one of china's famous banks.

I have designed efficiency network and have managed many servers of company.

Managing system administration, networking and hardware management & maintenance in the organization.

Assisted in creating upgrade protocols for all users and network hardware.

Assisted in creating troubleshooting logs for operating system and application software users.

Helped to develop several network administration policies that made support more efficient for users.

Assisted in developing several support policies that are still in use today. Increased team productivity and automated repetitive tasks by using batch files, PowerShell, VBScript.

Resolved a history of problematic network failure by troubleshooting LAN/WAN connections.

Responsible for tracking all support tickets and making sure each issue was resolved.

Assisted in planning several large system software and hardware upgrades.

Responsible for monitoring HP virtual classes including 24 hour support for late night emergencies.

LAN/WAN/WLAN/VPN/Network Security, Cabling, and Racking.

Responsible for installation, troubleshooting of Mobile Computing Devices.

Managed company VOIP phone system and extension listings.

Managed Chat-based service desk help with the client. 10/2012 – 6/2018

ORACLE DATABASE & SYSTEM & NETWORK ADMINISTRATOR, AGRICULTURAL BANK

Assisted in planning and implementing Disaster Recovery and High Availability strategies.

2

Perform ongoing database maintenance, patching and upgrading for oracle 11gR1/11gR2 databases.

Utilize Oracle diagnostics tools like Explain Plan, SQL Trace, TKPROF, and the AWR to analyse timing & execution plan for tuning. Also use TOP and VMSTATS to understand the impact on memory & CPU processes.

Design and implement standard and advanced security enhancement and monitoring policies using Fine Grain Access Control (FGAC) and Fine Grain Auditing (FGA).

Provide guidance and recommendations for efficient use of database resources using various Resource Management techniques.

Plan and implement backup and recovery strategies using RMAN.

Utilize Oracle support to troubleshoot and solve critical database issues.

Work with clients, information architect, system admin, and developers to define information flow helping to transform business requirements into environment specific databases.

Provide database maintenance using SQL Developer and OEM. EDUCATION

SEPTEMBER 2005

BACHELOR OF TECHNOLOGY IN COMPUTER SCIENCE AND ENGINEERING COMPUTER SCIENCE AND TECHNOLOGY, TSINGHUA UNIVERSITY

Operating System Design

Software Assurance and Product lines

Data-Modeling And Implementation Techniques

Software Engineering of Web-Design and Development

Network Management

Network Security

Computational Science

SKILLS

• Operating Systems: Linux (Debian, Ubuntu, RedHat, CentOS), Windows Server and Mac OS

• Programming: PowerShell, Bash, Python, C/C++, PHP, Java, JavaScript, Node, HTML/CSS

• Virtualization: VMware ESXi, Virtualbox

• Containers: Docker

• Networks: NAT, VPN, Firewalls, Load balancers, IP Routing(BGP, OSPF, RIP), VLAN, OpenVPN, VPS

• Network Services: DHCP, DNS, NFS, FTP, SAMBA, SNMP, SSH

• Databases: MySQL, ORACLE, MongoDB

• Web Servers: Apache, NGINX

• Security: SSL Certificates, Spam and Antivirus protection

• Oracle Enterprise Manager (OEM)

• Database Configuration Assistant (DBCA)

• Database Upgrade Assistant (DBUA) / MetaLink

3

• UNIX/Linux Shell Scripting & PL/SQL

• SQL*Plus / SQL Developer

• SQL Loader / Data Pump

• AWR / ADDM Report Analysis

• Database Replication

ACTIVITIES

• Oracle Database & System & Network Administratator, Agricultural Bank, March 2007 - June 2018

• Freelancer, June 2018 – present

LANGUAGES

• Chinese

Native

• English

Full professional proficiency

Contact this candidate