System Engineer
Resume:
Fuan Zhao
Green Brook, NJ *****
908-***-****(C), 908-***-****(w)
RESUME OF: FUAN ZHAO
SUMMARY
. 13 years professional experience in database design, administration,
performance tuning & High availability
. Extensive background in Sybase replication and across DRMS data
moving configuration
. Strong Background in database migration from Sybase to MS SQL, Sybase
to Oracle,Sybase ASE to Sybase IQ
. Strong experience in production support, issue finding and problem
resolving
SKILLS
RDBMS: ASE 15.x, Sybase IQ 12.6, 12.7, 15.x, Sybase Replication 12.6, 15.x, MS SQL 2005, ORACLE 10g release 1 and 2,
Operating System: Sun Solaris 2.6-2.10, Windows
Query Languages: SQL, ISQL, TSQL, PL/SQL, AIX
Database Management Tools: DBARTISAN, SQL Netbackup, Iwatch
Languages: Korn Shell
Schedule tools: Autosys and crons
Other: OpenSwitch 12.6 and 15,
EXPERIENCE
Citigroup, Warren NJ August
2006 to present
Sybase DBA
. Production support on Sybase IQ, version 12.x and migrating to 15.
. Production support on Security Trading systems running on Sybase 12.5.4
and 15.x
. Performance tuning on Sybase IQ, ASE, Replication servers
. Production support on t applications like Program trading, Account
services, Reference data, Sales
. Worked with app team to tune processes load data to IQ
. Worked on migration of Sybase to MS SQL
. Replicate data from Sybase to MS SQL through Direct Connect
. Troubleshooting the problems of the Databases and replication. Scheduling
the Jobs through CRON, maintaining Production Data Structure and
Providing the Production support 24x7
Major projects
. Setup/upgrade Sybase IQ and ASE from 12.0 to 15.x and rep server
12.x to 15.x
. Upgrade Sybase IQ and OpenSwitch
. Migration Sybase IQ from Sun Solaris to AIX
. Customize the monitoring on Sybase IQ
. Create programs to upgrade ASE and replication servers
. Configure and tune Warm standby replication system on VERITAS
clusters
. Configure and setup large ASE 12.5 systems. Create monitor, manage
tools to maintain the system
. Tune replication system to handle trading systems with large volume
. Worked on ASE and rep server rebuild and migrations
. Worked on Disaster recovery plan, implementation and monitoring
. Disaster recovery design and implementation
. Data migration for Sybase to MS Sql 2005
Jefferies & Co, NJ May 99
to August 2006
Senior Sybase DBA
. Created scripts for monitoring the CPU usages and Physical I/O and
redirecting to a file
. Created scripts and stored procedures to rebuild indexes.
. Created and maintained scripts for BCP out system tables for the recovery
of master database and user databases.
. Created latency checking system, including tables, procs and shell
scripts for replication system and cross domain replication systems
. Created scripts to reverse engineer replication server objects and
configurations for recovery and replication migration.
. Created scripts for replication server installation and configuration,
new connections.
. Installed and configured warm standby Replication server 12.x using
resource files.
. Worked with developers & QA testing group to put the new releases on the
Production server.
. Troubleshooting the problems of the Databases and replication. Scheduling
the Jobs through CRON, maintaining Production Data Structure and
Providing the Production support 24x7
Major projects
. Setup Sybase ASE 12.x and rep server 12.x on Varitas clusters.
. Configure and tune Multiple way replication system with multiple
primaries and multiple branches
. Configure and setup cross domain replication systems with function
string.
. Configure and setup large ASE 12.5 systems. Create monitor, manage
tools to maintain the system
. Tune replication system to handle large volume
. Lead and worked on ASE and rep server rebuild and migrations
. Lead and worked on Disaster recovery plan, implementation and
monitoring
. Disaster recovery design and implementation
. Data migration for legend system to PeopleSoft on Sybase
Oracle projects
. Set up and install oracle 10g on a clustered Sun Solaris system with
three nodes.
. Design layout of the databases with a SANDS storage system
. Setup monitoring with OEM and crons, using HP Openview trap and shell
scripts
. Configure logical standby
. Tuning the databases for performance improvement on both server and
client application sides
. Create shell scripts to monitor data guard
. Migrate Sybase database to Oracle
. Create scripts in Windows environment to install (silent mode) Oracle
Client
. Setup DR plan and systems to make sure the recovery meets company
requirements
Instinet, New York, NY Oct. 96 to
May 1999
Production Database DBA, Sybase DBA
. Installed, configured & upgraded Adaptive Server from 11.5 to 11.9.2 and
setup of replication server 11.5 .
. Troubleshooting the problems of the Databases and replication. Scheduling
the Jobs, maintaining Production Data Structure.
. Configured Adaptive Server to achieve best performance.
. Install and configured DB2 replication system
. Worked on Helpdesk system with Web front-end
. Worked on HR system with replication to other departments. Security setup
. Installed & configured Sybase Open Client for managing the databases &
replication.
. Provided 24x7 on call Production Support
RUTCOR, Rutgers University, NJ
Jan. 93 to Oct 1996
Research Assistant
. Worked on research on Envelope Theorem
. Worked on Non resource allocation theory
. Worked on projects with Web front end and database(Sybase) back end
. Worked on optimality conditions for dynamic programming with
incomplete information
EDUCATION
RUTCOR, Rutgers University, NJ
Institute of Operations Research, Qufu Normal University, China
Department of Mathematics, Qufu Normal University, China
Training classes from Sybase and Oracle
Contact this candidate