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 knowledge and got Cisco Certified Network Professional(CCNP)
• Team Player, quick learner, energetic, enthusiastic, Follow the 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 the Winnipeg DBA team, the Toronto application support team, and the S4M support team
• Supporting the 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
• Refreshed the 5 test Sybase instances with staging production to help implement testing purpose for more times everyday or every week
• Developed many routine Unix/SQL scripts used to improve the process and shorten the test instances refresh time. Like, used scripts to load and dump database with parallel mode and save much time for routine
• Performance tune, recently I used DBCC, showplan to analyze two queries with table scans after update statistics, finally I identified the issues from a skewing data on a column in a table with too much duplications. I fixed the issue with changing the range and cell densities for the column. (sp modifystats)
• Designed to install replication and add databases to replication with resource files in auto mode
• Finished off-duty work at home to promote patches into production and answered on-call
• Used Spotlight, Monitor tables and system tools to do performance monitor and tuning
• Solved the problems anytime emerged, such as space monitoring, auditing, replication monitoring.
• Designed scripts used at CRON to finish basic DB tasks, like error checking
• Helped adjust some configurations to get the best performance.
• Ran SQL Backtrack, BCP to shrink databases
• Ran script2db built on Perl to install Ad-sales patches.
• Designed and created the SSIS packages ‘Populate data from S4M s4rights to BTT’ and ‘Populate data from S4M schedule to BTT’. These two packages are used to transfer data from XML files(which are from S4M), manipulate and convert them to the format BTT can accept, insert and update the tables in BTT. Development tools and items used: Visual studio2005/2008, SSIS package, Transact-SQL, C# code, SQL agent.
• As a warm stand-by solution, I setup database mirror and log shipping models and implement these to our SQL Server production system.
• Setup replication and replicated broadcasting schedule data from BTT to VERTIGO snipe scheduler. Tools and Items used: SQL Server replication, error monitoring, Email notification.
• TV Schedule Cue Sheet project, this function is implemented on BTT interface and used to show the users with cue sheet details. Wrote a procedure to apply the cue sheet rules from TV schedule info and generate cuesheets. Development tools and items used: Transact-SQL, SQL server stored procedure, Linked Server.
• Vacation Tracker project, The application is used to book, manage the vacation info for personal and reports and management for HR. Designed and wrote functions, stored procedures, and are responsible for the schemas design, data consistence with trigger and constraints and keep the query good performance with appropriate indexes. Development tools and Items used: SQL schema, Transact-SQL, SQL stored procedure, function, Trigger.
• Engineering Tracker, this is a project used to manage and ticket the equipments in broadcasting engineering department. Manipulated and converted the data and generate report for the users. Development tools and Items used: SQL schema, Transact-SQL, SQL stored procedure
• Digital media project, Title change tracking project and all ongoing project. Support digital media development team on all their SQL Server instances, help design database schemas and monitor all the servers performance, designed stored procedures.
• Refreshing all the SQL server staging instances, development instances from production servers. Development tools and Items used: SQL Management Studio, SSIS packages, SQL server tool TABLEDIFF with windows scripts, the third-party tool REDGATE
• Installed and maintained a lot of SQL server instances, one instance on cluster, and some for third-party applications.
• Created reports, based on the application data in BTT generated a lot of reports. Development tools and Items used: Transact-SQL, stored procedure
• Backup check script, wrote an automatic script to check the backup status for all the SQL instances. Development tools and Items used: SQL Agent, Transact-SQL, SQL server system tables.
• Performance monitoring, are responsible for all the SQL server performance monitoring. Development tools and Items used: SQL data collection, performance monitor, SQL profiler, database tuning advisor, activity monitor, and SQL system stored procedures/commands, data normalization and index review, database and table partition strategy.
• Designed and implemented backup/restore strategy, Maintenance packages and jobs created for all SQL instances.
• Installed and maintained an Oracle Application R12 system. Applied backup/restore policies with archive mode for database node.
• Wrote a bunch of OM reports with PL/SQL on Oracle application 11i.

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 the source codes, pack the 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. The largest data volume is 80G including valid data size is more than 40G wrote the shell scripts to exchange data among different servers automatically. Also applied the Sybase updated technology like CIS, RPC, external file access, Sybase replication to provide the powerful interconnection database platform
• Designed some database tools to help troubleshooting in SQL and help the programmer track the problems easily
• Specialized in optimizing DBS applications to conform to resource constraints
• Mastered the knowledge of Java inside Sybase, can mentor programmer to apply the Java technology inside Sybase. wrote the 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 the instance, created the databases and implemented backup polices and restore with RMAN. Applied security polices to keep the database safe. Designed PL/SQL to help administer database. Solved the on-line problems

SQL Server database Developer

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 help finish some administration tasks and logical functions