Sql Server Oracle
Resume:
Hui Cheng
**********@*****.***
**** ******* **, ***** ****, TX 77479
Phone 713-***-****
SUMMARY
• More than 8 years of extensive experience in database administration services (MS SQL & ORACLE & Sybase), systems programming (DOS script & UNIX Shell) and analysis. Technical documents of database systems set up, configuration procedures and processes and standards.
• Working knowledge of a variety of relational DBMS products, with 8 years’ experience programming for relational databases, including SQL server, Oracle and Sybase.
• Over 10 years of progressive experience in business information systems as a skilled system analyst. Focus on data model maintenance, software design and programming
• Excellent problem solving and communication skills. Good written composition and language skills
• Ability to learn very quickly and apply new skills to existing problems
• Commitment to quality from requirements through design, construction, testing, and installation
• Customer service oriented
• Recognized by peers and staff as a reliable and motivated team player
TECHNICAL SKILLS
• Databases - SQL Server 2008R2/2008/2005/2000, Oracle 11g/10g/9i/8i, Sybase 12.5/11.5, MySQL, FoxBASE, Access
• DB Management - Oracle OEM, BMC Patrol, SQL Server management Studio, Sybase Central
• Data & Process modeling - Erwin 4.0, XCase 6.0
• Systems – Tivoli Backup, VERITAS Net Backup, Weblogic server, HA, Replication, Auditing(MS SQL & Sybase)
• Operating Systems - AIX 6.1/5.3, UNIX/Red Hat LINUX, Windows 2008/2003/2000 Server, Windows 2008/2003/2000 Enterprise Edition, DOS, Windows IIS, TCP/IP, Citrix Servers/Clients, Windows XP/2000/98/95, Citrix Server, WindowsNT4.0 server/Workstation, Novell Netware
• Languages - T-SQL, PL/SQL, DDL, DML, UNIX Shell Script, Windows 32-bit API, C++/C, Visual Basic 6.0, HTML, VB Scripts, MS-Access, Power Builder 5, FORTRAN
• Software Tool – SQL Profiler, Windows Performance counters, PSSDIAG, STATSPACK reports and AWR reports, TOPAS, Open Text Exceed, PUTTY, RUMBA, Erwin, ArcGIS 9, DB Artisan, SQL Navigator, SQL*PLUS, TOAD, Lotus Notes, MS Project, PowerPoint, BCM Remedy
MS SQL SERVER/ORACLE DBA FUNCTIONS
• Install, configure, upgrade, hot fixes/ service patch software: server, tools, applications
• Monitor, tune, size, backup, recover, analyze, defrag, migrate
• Design and implement DB security, auditing, replication, data management
• T-SQL and PL/SQL: scripts, triggers, procedures, packages, automation projects
• High availability, 24/7 on call support
• SQL clusters, log shipping, mirroring, replication, standby database
• Oracle standby server, archive log & no-archive log
• Design/model DB structures to support a variety of software applications
• Support developers in tuning DB and apps for optimal performance
• Monitor database growth and provide DB capacity planning for apps expansion
• Design and implement backup methods and disaster recovery strategies
• Migrate database between software versions, platforms, database products
• Implement the scripts for daily tracking on SQL & Oracle server backup & space status
PROFESSIONAL EXPERIENCE
Sysco Corporation Houston, Texas
DBA III (MSSQL SERVER & ORACLE & SYBASE) Jan 09 – Present
• MSSQL Environment (150 + Servers):
Windows server 2008/2003 Windows Server 2008/2003 Enterprise Edition SQL Server 2008R2/2008/2005/2000 SQL 2008/2000 Enterprise Edition
SQL Production/Development DBA functions:
SQL Server 2005 Transaction Replication configure and maintain, SQL 2008 clustering pier to pier set up/maintain, SQL 2008 mirroring & log shipping configure / failover test, SQL 2008 reporting server configure, 32-bit DB2 driver installation/configure on 64-bit Windows server 2008, SQL2000/2005 replication maintain, SQL Backup configure/monitor and database restore, database performance investigation via event viewer & SQL profiler & windows performance counter and PSSDIAG, Linked server set up, knowledge of OLTP & Reporting Database & OLAP, scripts for daily tracking of SQL server backup & space, DB security
• Oracle Environment (100 + instances):
AIX 5.3/6.1 Oracle 11g/10g/9i/8i, Oracle Enterprise Manager 10g, Weblogical server, Oracle Forms applications, Tivoli Backup, VERITAS Net Backup
Oracle Production/Development DBA functions:
Oracle 11g upgrade from 8i/9i/10g, Oracle patch, DB server hosting move, Oracle 8.1.7 & 11.2.0.1 standby server configure and maintain, oracle table partitioning, technical document of backup set up ( Data Pump export/import, cold/standby/standby archive/hot backup) and DB recovery procedure, database refresh and clone, tuning, health check, space management, application support, DB security, Oracle Client/Driver installation/configure, Cronjob setup, ORA- errors investigation through trace files and alert log, database performance review via STATSPACK report and AWR report, scripts for daily tracking of Oracle server backup & space
• Sybase Environment (2 servers):
AIX 6.1 Sybase 12.5
Sybase Production DBA functions:
Sybase/UNIX SOX auditing, Database backup and Security setup
Sr. DBA (MSSQL SERVER & SYBASE) Apr. 06 – Jan. 09
• MS SQL Server Environment (120 + servers):
Windows server 2000/2003 Windows Server 2003 EE SQL Server 2000/2005
SQL Production/Development DBA functions:
SQL Server Replications (Snapshot, transaction and dynamic merge) configure and maintain, the technical document of SQL 2000/2005 clustering & SQL 2005 standby & SQL 2005 mirroring &SQL 2005 log shipping & SQL reporting server set up and configuration, SQL 2005 upgrade from SQL 2000, SQL 2000/2005 SOX Auditing, SQL Server (120+ servers) hosting move, SQL Client/ iseries IBM DB2 driver installation/configure, DTS, BCP, DB backup setup (full and transaction log backup) & monitor and DB Recovery procedure, DOS batch job setup, database performance investigation
• Sybase Environment (1 server):
Windows server 2003 Sybase Adaptive Server Anywhere 8.0/9.0 Sybase Central
Sybase Production DBA functions:
Sybase installation and database setup, Backup/Database maintain job setup, Test environment data synchronization, Windows job scheduler, Database migration from Sybase to MS SQL 2005
Weatherford International Houston, Texas
Sr. Database Developer/Data Architect (MS SQL/.Net) July 05 – Apr. 06
• MS SQL Server Environment:
Windows Server 2003 SQL server 2005 – 1 instance
SQL Developer functions:
Data modeling, Technical spec document, Well Service Management system, Data Integration project
Williams Gas Pipeline Houston, Texas
System Analyst Staff/Development DBA (ORACLE) Jan 03 – June 05
• Oracle Server Environment:
UNIX 5.3 Oracle 8i/9i – 3 instances, Erwin, ArcGIS 9, DB Artisan, SQL Navigator, TOAD, Lotus Notes, PL/SQL
Oracle Development DBA functions:
Data modeling with Erwin, Logical model converts to Physical model, Project analysis, security maintenance, ArcGIS data conversion, database objects deployment
Sr. Systems Analyst/Database Developer (SYBASE & PowerBuilder) Sep 00 – Dec 02
• Sybase Server Environment:
Citrix Server/Client UNIX 5.3 Sybase 12 – 2 instances
Database Developer function:
Data conversion, both front-end & back-end development
University of Houston Houston, Texas
Research Assistant/ C&C++ Programmer August 99 – August 00
• Environment:
UNIX C/C++ FORTRAN
Programmer function:
Physical phenomenon demonstration system, parallel application that dramatically improved the cluster reading, writing and saving
Hubei Province Power Supply Bureau Hubei, China
Team Lead/Database Developer (SYBASE & PowerBuilder) July 97 – January 99
• Environment:
Windows NT Sybase 11.5 & PowerBuilder 5.0 FOXBASE
Team Lead/Database Developer function:
Complex Financials Package development, data conversion, team work assign
EDUCATION
University of Houston Houston, Texas
Master of Science in Computer Science
University of North China Electrical Power Hebei, China
Bachelor of Science in Computer Science and Engineering
Contact this candidate