Objective

• Senior SYBASE/SQL Server/Oracle DBA seeking a position to employ his database management, design and architect skills to realize strategic business objectives

SUMMARY

• 18+ years of work experience in database design, development, maintenance and software development
• Proven database management, design and architecture skills on Media and retail application projects
• Highly skilled in Sybase ASE 11.x to Sybase ASE 12.5,Sybase ASE15.0 and SAP ASE 16.0, Sybase Replication12.6, MS SQL server 2000/2005/2008/2012/2014 , Oracle 10G/11i/12c, HP Unix, Solaris Unix, Digital Aix, SCO Unix, Linux, Windows 2003/2008/2012 severs
• Sybase Replication Professional and Sybase ASE professional training Courses bringing over 10+ years of Sybase experience
• Combination of Sybase/Oracle/MS SQL Server experiences with complementary front - end development experience(C/C++/C#, Power Builder, Java)
• Full rich network and system noledge and got Cisco Certified Network Professional(CCNP)
• Team Player, quick learner, energetic, enthusiastic, Follow teh change order rule, work with change order and incident monitor on ITIL.

TECHNICAL SKILLS

Databases: Sybase 11.x to Sybase ASE 12.5, Sybase ASE 15.0, Sybase Replication 12.6, Sybase IQ, Sybase anywhere, SAP ASE 16.0, Oracle 10G/11i/12c, MS SQL Server 2000/2005/2008/2012/2014 Languages: C/C++, C#, Power Builder, Java, HTML, XML, UNIX script, Perl

Operating Systems: HP UNIX, SUN Solaris, Digital Aix, SCO UNIX, Linux, Windows NT

Utilities: Sybase’s Utilities(BCP, ISQL, Defncopy), SAP SCC, SAP Cockpit, Spotlight, Power Designer, Open Server application(Replication Server, CIS, RPC), Transact-SQL, SQL Server Managerment Studio, SQL Server BIDS, SQL Server Profiler, Veritas, Oracle RMAN, PL/SQL, Exp/Imp, SQL*plus, SQL Backtrack2.0 SSH configuration.

PROFESSIONAL EXPERIENCE

Sr. Sybase/SQL Server/Oracle DBA

Confidential

Environment: S4M project (Terabyte databases, multi tiers and 500 users), Sybase ASE 12.5.3/15.0 Sybase Replication 12.6, SQL Server 2000/2005/2008/2012/2014 , HP-Unix, N-tie (Citrix.Net, Jboss, Tomcat), Oracle application database 11i/R12

Responsibilities:

• Sybase software installation and Sybase ASE data server creation, configuration, loading, dumping, monitoring, problem resolution
• Sybase Replication Server creation configuration, monitoring, problem resolution
• S4M application database creation, upgrading, reloading
• S4M application replication installation, removal, upgrading
• Working with and developing new Unix shell scripts.
• Integrating and communicating with teh Winnipeg DBA team, teh Toronto application support team, and teh S4M support team
• Supporting teh project during off-prime hours as well as weekends
• Other tasks assigned by Winnipeg DBA staff and/or Toronto project staff
• SQL Server 2000/2005/2008 installations, patches, upgrade, replication setup, maintenances, DTS/SSIS packages design, write SQL scripts to handle data.
• Finished off-duty work at home to promote patches into production and answered 24/ on-call

Configuration Software Engineer

Confidential

Environment: Windows Server, MKS, Jakarta Ant, XML

Responsibilities:

• Maintained and designed build/release Scripts to compile source codes to .exe .dll .class files, make installation Images, build/release process monitor, version control and burn CDs
• Wrote windows command scripts, call Ant with designed XML to finish build/release tasks. These scripts call MKS commands, compilation commands, Installshield commands to create sandbox, resynchronize sandbox, compile teh source codes, pack teh programs, get products for different codes that include Java codes, C codes, PowerBuilder codes.
• Full of experience of software source codes management with MKS

Sybase/Oracle DBA

Confidential

Environment: SUN Solaris, Digital Aix, SCO Unix, Linux, Windows NT, Veritas

Responsibilities:

• Performed logical and physical data modeling supporting powerful retail POS Management Systems. Installed maintained and tuned Sybase ASE, Replication Server and MS SQL Server
• Migrated Sybase11.x to Sybase 12.5 on different OS platform comprehensively. Used Defncopy, BCP, SQL tools and Wrote Scripts to migrated Sybase 11.92 on Digital AIX to Sybase 12.5 on Sun Solaris, also migrated Sybase 11.03 on SCO Unix to Sybase 12.5 on Linux
• Provided technical support for transaction processing, data access, production implementation, performance tuning, problem resolution, and database recovery. Provide high-performance database for programmer, optimize stored procedures, triggers. Teh largest data volume is 80G including valid data size is more than 40G wrote teh shell scripts to exchange data among different servers automatically. Also applied teh Sybase updated technology like CIS, RPC, external file access, Sybase replication to provide teh powerful interconnection database platform
• Designed some database tools to halp troubleshooting in SQL and halp teh programmer track teh problems easily
• Specialized in optimizing DBS applications to conform to resource constraints
• Mastered teh noledge of Java inside Sybase, can mentor programmer to apply teh Java technology inside Sybase. wrote teh server side processing logics with Java to take place of stored procedures for getting complex logical results
• Supported, administered, tuned, and maintained database for accounting system on Oracle. Installed Oracle software and upgrades, configured teh instance, created teh databases and implemented backup polices and restore with RMAN. Applied security polices to keep teh database safe. Designed PL/SQL to halp administer database. Solved teh on-line problems

Confidential

Environment: petroleum products management and sales system, Windows, SQL server

Responsibilities:

• SQL Server database setup, tuning, backup policies, and administration.
• Analyze data, build data model, and implement data in database.
• Document and maintain complete metadata.
• Participate in implement and development of data conversion processes.
• Wrote many procedures, triggers and functions with Transact-SQL to halp finish some administration tasks and logical functions