Resume

Sign in

Oracle/MS SQL database administrator, AIX/Linux/Solaris/Windows

Location:
London, Ontario, Canada
Posted:
October 06, 2016

Contact this candidate

SUMMARY OF QUALIFICATIONS

•Strong technical skills with a commitment to professional development; more than 8 years of experience in Oracle and MS SQL database management, troubleshooting and performance optimizing, backup and recovery, database security, database replication and high availability, SQL and PL/SQL programming.

•Experience also includes AIX/Linux/Solaris/Windows management and Websphere management, Shell and Perl script development. Proficient database SQL query performance optimizing and tuning.

•Analytical and flexible problem-solver able to quickly identify and troubleshoot technical challenges and maintain complex hardware and software systems providing customers with the most suitable solutions.

•Excellent communicator and team member skilled in collaborating to achieve common objectives and able to explain complex technical concepts to nontechnical users.

•Highly organized with excellent attention to detail demonstrated in all technical work as well as in document- ing and documents management ensuring ease of information retrieval.

•Motivated, self-directed and adept at quickly learning new technologies and completing multilayered projects within tight deadlines.

•Certificates include: IBM AIX6.1 Administrator, OCP, Oracle Exadata 11g Certified Implementation Specialist

TECHNICAL SKILLS

Operating Systems

AIX, Linux, Solaris, Windows

Databases and Machines

Oracle Database 10g R2, Oracle Database 11g R2 & R4, Oracle Exadata, Microsoft SQL 2012/2014

Middleware and Tools

IBM: Tivoli products, Websphere; Informatica PowerCentre; Microsoft SSIS;

Oracle: ASM, RAC, RMAN, DataGuard, Golden Gate, Oracle EM

Development Tools

PL/SQL Developer, Java, Javascript

Languages

SQL, T-SQL, PL/SQL, Shell, Perl, Java

PROFESSIONAL EXPERIENCE

Senior Database Administrator

Digital China Ltd. Jinan, China 2013.04-2014.10

•Installation, upgrade, patching and configuring of Oracle Database (10g R2, 11g R2, 11g R4) on RAC environment. Planning and designing for Oracle Environments. Develop and implement backup and recovery solutions, database security features. Solve database issues encountered in software development.

•Monitor the database environment, physical storage and structures, control system resources usage and perform capacity planning. Perform troubleshooting and diagnostics activities; collect and analyze database performance information; identify and implement solutions for performance problems

•Solve issues by developing automating task with Shell, Perl, PL/SQL and Java. Develop complex queries, stored procedures, and pack- ages to support report requests, migrating data by automating task with SQL script.

•Managed AIX and MS SQL including performance optimization, deploying applications. Take 24x7 on-call rotation and troubleshooting problem tickets and response to customer requests and change controls.

PROFESSIONAL EXPERIENCE CONTINUED

Database / System Administrator

Shandong Green Continent Service, Ltd. Jinan, China 2012.04-2013.04

•Managed Oracle database and Oracle Exadata as Oracle Database Administrator.

•Effectively managed Linux / Solaris maintenance, configuration, and troubleshooting, deploying NTP, DNS server on Linux/Solaris, design and planing filesystem and storage, monitor the system environment.

•Take 24x7 on-call rotation and troubleshooting problem tickets and response to customer requests and change controls.

Database / System Administrator

Shandong Hicoscom Info Tech. Ltd Jinan, China 2010.03-2012.04

•Managed Oracle and MS SQL database, Linux system in cluster environment as Database / System Administrator.

•Take 24x7 on-call rotation and troubleshooting problem tickets and response to customer requests and change controls.

System Administrator

Shandong Computer Centre Jinan, China 2006.06-2010.03

•Completed various projects as a System Administrator in charge of application software implementing and

integrating, data migrating.

•Managed Oracle database and AIX / Linux in cluster environment.

VOLUNTEER EXPERIENCE

Library and Computer lab Coordinator

Stoney Creek Public School London, Ontario 2015.10-2016.09

•Organizing book, data entry, computer and IT facility maintenance, software install and reconfiguration.

•Giving advise on computer interest teaching, providing solution on teaching equipment using and schemes.

IT Support

Single Women In Motherhood London, Ontario 2015.12-2016.09

•Maintaining, supporting and troubleshooting network, Computer and laptop hardware and software.

•Creating maintenance plan, process and checklist, looking into IT environment at regular intervals and managing technical documents.

EDUCATION AND TRAINING

Master of Engineering Degree

Shandong University Jinan, China 2011

•Evaluated by World Education Service (WES) as equivalent to a Master of Engineering degree at a Canadian University

Bachelor of Computer Science Degree

Shandong Jianzhu University Jinan, China 2006

Microsoft Certified Solutions Associate SQL Server 2012/2014 Administrator Training

Online London, Canada 2016

•With 6 months hours learning and practising. Passed exam of Querying Microsoft SQL Server 2012/2014 and Administering Microsoft SQL Server 2012/2014 Databases.



Contact this candidate