Experience

LA Care Provider

• Hospitals and Health Care
• 1 - 100 Employee

• Sr SQL Sserver DBA

  • Mar 2015 - Present

  • Manage over 200 SQL Server (including develop, test, UAT & Product environment (over 80 productions) (including SQL Server 2012/2014/2016/2017/2019), Server type (including standalone/SQL server Cluster/SQL Server alwayson, SQL Server Replication (transaction), SQL Server Log Shipping, SQL Server Reporting Service, Power BI Server and Integration Service etc.). • Install and configure, develop, test, UAT & Product environment (by installing SQL Server, configuring standard and Failover Cluster, AlwaysOn, Replication (transaction), Reporting Service, Integration Service, Analysis services). • Migrate (from Low version SQL server 2012/2016/2017 to SQL server 2012/2016/2017/2019), upgrading SQL Server Service Package • Use SolarWinds and Red Gate to Monitor SQL SERVER’s performance (CPU, Memory, Disk Space, etc.), create Alert, and provide support for 7-day, 24-hour database administration support for production databases. • Manage database backup and restore (using SQL Server maintenance Plan to backup, for Disaster Recovery (DR) plans), all production databases are TDE encryption. • Release and deploy SSAS, SSIS package & SQL Server Reporting Service, Power BI Server report to test, uat, production Server creating and maintaining schedule job. (Release job) • Tune SQL queries by rewriting query statements (using temp table indexes and hints to affect query execution plan etc.). Fully understands different table access methods and table join methods. Expansive knowledge of Database Engine Tuning. • Creating and configuring Microsoft Azure Cloud experience in Azure SQL Database, SQL managed instance, Azure SQL Server VM, Migrating local Database to Azure Cloud, Setting up backup & Restore policy, granting permission for users etc. • Setup Azure Site to Site VPN and Point to Site VPN to migrate Database between on Prem server to Azure SQL Server. Show less



Agile1

• Senior SQL Server DBA/Developer

  • Sep 2012 - Present

  Agile 1’s main business is integrated services and technology that drive value and mitigate risk, Total workforce solution Responsibilities : (About 3000 employee) Responsibilities: • SQL Server DBA: install SQL Server (2000/2005/2008 (R1, R2)/2012), Installing and configuring standard and Failover Cluster SQL Server ( Windows 2008/SQL Server 2008, Windows 2012/SQL Server 2012 active/passive). Install and configure SQL Server 2012 Alwayson (create Availability Group, Configure Availability Mode), Select Failover Mode)Product Server ( SQL Server 2008 R1/R2 Enterprise Database Engine, SQL Server 2012 Reporting Service) . Client site (SQL Server 2008 Developer or SQL Server 2012 Enterprise ) • Using Ignite to Monitor SQL SERVER’s performance. Using Database Engine Tuning Advisor & Resource Governor etc. manage database Performance Tuning, provide support in a 24x7 environment. • Adding tables, views, indexes, scheduled jobs, triggers, logins, etc. based on system specifications. Using RED Gate SQL Compare & SQL source control to make database simultaneously (Manage 26 production Databases) • Managing database backup and restore schedule (Using SQL Server maintenance Plan to backup, Check Database integrity and Rebuild index etc.) for Disaster Recovery (DR) plans • Planning and implementing Microsoft SQL server upgrades (including Version up (like SQL Server 2000 to 2008) and service package ) • Using SSIS & SQL Batch job to Implement data loading from client side and maintenance plan for operational automation • Writing technical documentation, Introducing SQL new Feature to IT staff on the database systems and tasks. • Troubleshooting and resolving database issues . Show less



5

• SQL Server DBA

  • Sep 2012 - Present

  Creating SSIS project and Using SQL Batch job to Implement customer’s data ( Excel, Csv, txt file etc) loading for operational automation Helping application/SQL developer to create complex stored Procedure to meet customer’s requirement Analyzing slowly running reports and identified the most time-consuming SQL statements by actual execution plan & database engine tuning advisor. These SQL statements were examined and tuned first. Expertise in using Merge statements to replace time-consuming cursor for loops to improve performance significantly Using Database Engine Tuning Advisor & Resource Governor etc., Adding and configuring tables, views, indexes, scheduled jobs, triggers, logins, etc. based on system specifications. Writing technical documentation, Introducing SQL new Feature to IT staff on the database systems and tasks. Troubleshooting and resolving database issue. Show less



medversant

• SQL SERVER DBA

  • Mar 2006 - Sep 2012

  • Install and configure Server (2000/2005/2008 (R1, R2)/2012), secure, optimize, and maintain Microsoft SQL Server instances including SSAS, SSIS and SSRS components • Installing and configuring Failover Cluster SQL Server ( windows 2008/SQL Server 2008(R1/R2), active/passive) ( including install and configure windows cluster on Vmware environment, use iscsi to connect san system, Configure two nics for heartbeat/Failover Cluster, Failover Cluster Manager etc.) • Install and configure Database Mirroring (Principal Role, Mirror Role, Witness Server ), configuring High Availability/High Performance/ High Safety Operating Mode. • Install and configure Database Replication (include snapshot, Transactional etc) & log shipping for Database backup. • Experience with High Availability (HA), Fail-Over and Disaster Recovery (DR) options for MSSQL Server across multiple data centers. create backup/restore plan, (Disaster Recovery ). familiar with all backup Type (Full, Differential, Transaction log etc.) • Configure linked server, Database Mail, reporting service, SSIS, SSAS (including SSIS, SSRS, SSAS configuration and deploy). • Create Maintenance Plan (create task for database like rebuild index, Check DB Integrity etc ) • Monitor production databases and environments related to DEV, QA and Staging to identify capacity and performance issues • Provide support in a 24x7 environment (include System, IIS Web, SQL Servers). • Experience with DMV to monitor and tune server & database to provide a high availability service Show less



Medversant Co., Ltd

• Senior SQL Server DBA/Developer

  • Mar 2006 - Sep 2012

  Install and configure Server (2000/2005/2008 (R1, R2)/2012), secure, optimize, and maintain Microsoft SQL Server instances including SSAS, SSIS and SSRS components Installing and configuring Failover Cluster SQL Server ( windows 2008/SQL Server 2008(R1/R2), active/passive) ( including install and configure windows cluster on Vmware environment, use iscsi to connect san system, Configure two nics for heartbeat/Failover Cluster, Failover Cluster Manager etc.) Install and configure Database Mirroring (Principal Role, Mirror Role, Witness Server ), configuring High Availability/High Performance/ High Safety Operating Mode. Install and configure Database Replication (include snapshot, Transactional etc) & log shipping for Database backup. Experience with High Availability (HA), Fail-Over and Disaster Recovery (DR) options for MSSQL Server across multiple data centers. create backup/restore plan, (Disaster Recovery ). familiar with all backup Type (Full, Differential, Transaction log etc.) Configure linked server, Database Mail, reporting service, SSIS, SSAS (including SSIS, SSRS, SSAS configuration and deploy). Create Maintenance Plan (create task for database like rebuild index, Check DB Integrity etc ) Monitor production databases and environments related to DEV, QA and Staging to identify capacity and performance issues Provide support in a 24x7 environment (include System, IIS Web, SQL Servers). Experience with DMV to monitor and tune server & database to provide a high availability service. Designed, developed and tested a new T-SQL Program to replace existing stored procedures which improved performance by ten times. Using SQL Server Business Intelligence Development Tools( SSIS ), create Data Source, Data Source View, SSIS Packages to export and import customer data file (Excel, Flat File etc). Create job running (daily, weekly or monthly). If job fail, send notice to me. Show less



IDS (Insurance Data Service) Co

• Net Web Developer & SQL Server Developer

  • Jan 2005 - Mar 2006

  Designed and developed business objects to implement complex business rules and business entity objects to communicate data among layers in C# and VB.net. Designed and developed data access layer to communicate to SQL server using ADO.NET and Microsoft Data Access Application Block Helped to design and develop SQL Server database for the project. Developed stored procedures in SQL Server 2000/2005 to meet customer’s requirement, Assisted junior developers. Used various web forms and user controls throughout the project. Set up source safe (VSS) for the application. Deployed application in the development and QA environment. Created web and Windows controls for project. Show less



CIeNET - China. (Pitney Bowes – China) Beijing China

• Net Web Developer & SQL Server Developer

  • Jul 2002 - Nov 2004

  Worked with Pitney Bowes Project team. Client is White & Case (Law Office). Pitney Bowes provided printing services and mail services for White & Case. Project included planning and analysis with our client to determine the main functions which included inputting, outputting and managing documents for each layer. Ultimately the solution managed the salary system and salary statements by E-mail using UML/Rational Rose for Design, Web Forms and Web Services to manage documents. Designed and developed business objects to implement complex business rules and business entity objects to communicate data among layers in C# and VB.net. Developed stored procedures & T-SQL in SQL Server 2000 Show less



PostLinx Co Ltd

• Senior Software Developer & Fox Pro Developer

  • Jan 1999 - Jun 2002

  Worked for Direct Mail system to assist Royal Bank, Bell Canada and GM to complete billing system. The OS was Windows and development responsibilities included Visual Basic (DAO, RDO, ADO, and FTP), Access, FoxPro, Photoshop, PRS (Print Software)). Helped Oracle DBA (PL/SQL) to manage and maintain Oracle Database for Salvation Army. Provide reports for Salvation Army. Provide information and Tax statement to donators. Worked for Direct Mail system to assist Royal Bank, Bell Canada and GM to complete billing system. The OS was Windows and development responsibilities included Visual Basic (DAO, RDO, ADO, and FTP), Access, FoxPro, Photoshop, PRS (Print Software)). Helped Oracle DBA (PL/SQL) to manage and maintain Oracle Database for Salvation Army. Provide reports for Salvation Army. Provide information and Tax statement to donators.



Almedio Co., Ltd

• Senior Software Developer

  • Oct 1997 - Nov 1998

  Supervised a team (5 people) to work for one project of National Electronic. Authored web DV Transfer Compressor program using MPG2 (Java program), Socket, Server Socket (TCP/ IP) and JDBC. The operating system was Red Hat Linux. Supervised a team (5 people) to work for one project of National Electronic. Authored web DV Transfer Compressor program using MPG2 (Java program), Socket, Server Socket (TCP/ IP) and JDBC. The operating system was Red Hat Linux.



5

• Senior Software Developer

  • Jul 1994 - Sep 1997

  Developed under multi-environments including Windows 3.1, Win9X/NT using in Visual C++ (MFC) and Visual Basic(COM/DCOM, Active X DLL, Active X Control), Designed, developed and upgraded a series of software for testing quality of CD, CD_ROM, VCD, DVD Driver using MPG1, MPG2 technical. Our customer is Sony and Toshiba Electronics Inc. Products include Test CD_ROM 701, 703, Test Video CD (TVD_581) and Test DVD(TDD_820). Developed under multi-environments including Windows 3.1, Win9X/NT using in Visual C++ (MFC) and Visual Basic(COM/DCOM, Active X DLL, Active X Control), Designed, developed and upgraded a series of software for testing quality of CD, CD_ROM, VCD, DVD Driver using MPG1, MPG2 technical. Our customer is Sony and Toshiba Electronics Inc. Products include Test CD_ROM 701, 703, Test Video CD (TVD_581) and Test DVD(TDD_820).



TokoTestac Co Ltd

• Software Developer

  • Sep 1993 - Jun 1994

  Participated in the development of a much-publicized financial system for TyoBuKeSetsu Co Ltd in Tokyo as a Project Leader designing and supervising a team of five programmers. Created user interface using Visual Basic to collect and update Database via Access. Communicated frequently with clients to define their requirements, instructed clients with proper operation of the system and checked the Specs for possible anomalies. Updated program Specs, and corrected inconsistencies in the functionality. Show less



5

• Software Developer

  • Nov 1990 - Aug 1993

  Developed software in N88_Basic, C and MASM to test the characteristics of the automobile materials for DaiWaDeKi Co Ltd in Yokohama. Test data input through I/O and A/D Board. Generated reports in forms of screen curves as well as printer output to demonstrate the extent of Strength/Strains and Exhaustion of the materials. Developed software in N88_Basic, C and MASM to test the characteristics of the automobile materials for DaiWaDeKi Co Ltd in Yokohama. Test data input through I/O and A/D Board. Generated reports in forms of screen curves as well as printer output to demonstrate the extent of Strength/Strains and Exhaustion of the materials.



Beijing No. 5 Semiconductor Company

• Software Developer

  • Sep 1989 - Oct 1990

  Designed circuits for the Program Control Telephone using the CAD under MS_DOS Initiated and established the company’s first personnel Database using dBase III under MS_DOS Designed circuits for the Program Control Telephone using the CAD under MS_DOS Initiated and established the company’s first personnel Database using dBase III under MS_DOS