Built & supported company recruiting modules with RDBMS MSSQL, VS Studio, C# .NET, TFS & TeamCity.· Designed database schema, stored procedures, triggers, jobs, & scripts.· Architect database deployment automation, versioning & change controls.· Created & maintained various ETL, CLR functions, SSIS processes & data syncs.· Maintained console applications for email blast and client rules of engagement using C# .NET, integrated API services for job postings & job alerts.· Maintained database consistency & integrity via replications, backups, index tuning and monitoring using Profiler, DMV queries, DBCC commands or monitoring tool Ignite from SolarWind.· Migrated stand alone application and reporting databases to Microsoft Azure SQL.· Worked closely with product managers to develop various SSRS reports and data pulls.· Provided database technical support to development team as well as formulating policies and procedures in compliance with database standards.. Participated in SCRUM agile development.

Supported company email cloud archiving and their related applications. Became lead of 4 database administrators and engineers, responsible for 100+TB databases at multiple data centers.. Setup Failed-Over SQL Server Clustering at 6 data centers.. Upgraded 50+ databases from 2000/2005 to 2008.. Developed admin and automated tools.. Developed 100+ reports with SSRS.. Setup database disaster recovery with Log Shipping. Performance tuning, data archiving, schema design, bug fixes, legacy code cleanups, code standards.

. Update and enhance web contents with in-house built tool Phoenix Co-brand. . Develop HTML Email Campaign templates for Marketing Departments.. Develop CSV/Excel parser tool for Marketing

. Participated in designing and developing Company Account Management System. Maintained & supported company corporate websites: PADI.com, PadiMembers.com, ProjectAware.org, EmergencyFirstResponse.com

. Developed Clan Tournament System for a FPS game.. Work with SQL DB team to maintain multiple game databases.. Enhance existing PHP sites for Online Shopping Carts.. Enhance existing company affiliate websites.

. Developed Student Online Applications & Credit Card Payments.. Developed Student Online Services: Class Registration / Class Schedule / Unofficial Transcript / Financial Statement / Intern Credits.. Provided help-desk supports for students, school staffs, and professors; answering phone calls and emails. Repaired and upgraded computer software and hardware on-site and off-site.

. Developed CPC (cost per click) web pages, banner ads, XML, and JavaScript RSS feeds for high traffic websites.. Migrated XML RSS feeds from classic ASP to ASP.NET.. Enhanced XML page response with multi-threading and object oriented coding.. Developed management and report panels for searches/clicks/keywords statistics.. Developed e-commerce websites.. Developed task scheduling system.. Maintain various SQL Server databases by writing Stored Procedures, Views, Triggers, and Jobs.

. Modified existing database, created front-end applications using VBA and Access forms with queries and reports. . Developed online order systems and management panels for our clients (Blue, PacifiCare, TraveLogia, Water Magazine, and Calmoseptine).. Designed intermediate Flash websites.. Maintained office computers by installing updates, softwares and upgrading hardwares.