Jiying Song
Salt Lake City UT 84118
Phone: 801-***-****
Email: **********@*****.***
Objective
Oracle DBA position that uses my knowledge and talent in database management and development
Skills and Abilities
Database Management
● Knowledge of Oracle DBMS and their tools to administer in an Oracle DBMS environments
● knowledge with Oracle Core technologies RAC, GRID, ASM, RMAN, EM Grid Control, Data Guard, and Active/Passive Cluster Oracle technologies
● Knowledge with RAC installation and setup, RAC characteristics and RAC maintenance
● Knowledge with database backup, restore and recovery methods using RMAN, Data Pump and other industry standard tools
● Knowledgeable in Oracle11g Database Control
● Knowledge and understanding of database performance tuning tuning SQL, memory usage and data access, tuning data manipulation and physical storage, using the automated workload repository
● Knowledge of database security policies, procedures and auditing including database authentication methods, authorization methods
● General knowledge with logical and physical database design
Database Development
● Develop procedures and functions using database languages (PL/SQL), Data Manipulation Language (DML), and Standard Query Language (SQL) supported by Oracle related platforms
Enterprise Working Skills
● Quicker learner for new knowledge and technologies
● Good time planner for projects
● Excellent experience to manage system and analyze data
Communication Skills and Other
● Established and improved communication skills to maintain good relationships with co-workers
● Good skills to communicate with co-worker to solve problems
● Very good to work in a team
Tools used
• SQL Developer, SQL* Plus, EM
Certificates
Oracle 11g DBA OCA October 7th, 2010
Oracle 11g DBA OCP April 12th, 2011
Education and Training
Oracle DBA Training 04/2010-12/2010
● Oracle Database 11g Administration II
● Oracle Database 11g Administration I
● Oracle Database 11g SQL/PLSQL
● Oracle Database 11g: Data Warehouse Fundamentals
B.S in Biology & Minor in Chemistry 08/2002-08/2005
University of Utah, Salt Lake City, U.S.A
Employment
University of Utah, Salt Lake City, U.S.A 11/2005-04/2010
Laboratory Technician, Data Manager in Neurobiology and Anatomy Lab
● Design and maintain small database for orders in Mac system.
● Conduct mice genotype experiments, PCR experiments and gel electrophoresis
● Raise Xenopus laevis embryos
● DNA isolation from E. Coli cells
● Support lab with purchasing lab supplies, keeping inventory, balancing accounts, filing, making solutions, etc.
● Make slides by cryostat sections and paraffin sections
University of Utah, Salt Lake City, U.S.A 11/2004-08/2005
Laboratory Technician in Biology Department Lab
● Prepare for sequencing PCR products, analyze result and create report on the Georgie Project wiki
● Design and prepare solutions for laboratory procedures
● Design primers for PCR by using the Primer3 program
● Conduct PCR experiments and electrophoresis to sequence fox DNA
University of Utah, Salt Lake City, U.S.A 05/2003-08/2003
Research Assistant, Biology Department Lab, Individual Research
● Collect, manage, and analyze data by using access and excel.
● Design and prepare stock solutions for experiments
● Assisted the lab manger in culturing, transferring and freezing nematodes samples