Senior SQL Server DBA

Frank Li

San Diego, CA USA

email: *********@*******.***

Summary:

Senior MS SQL Server DBA, Data Engineer with extensive knowledge/experience in managing SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

16+ Year of solid database engineering experience in Database Design, SQL Server database technology. 2022/2019/2017/2016/2014/2012/2008 in Production, Development, Test and Cloud based Environment.

13+ Years’ experience in Performance tuning queries, index, stored procedures using tools like Windows System Monitor, Activity Monitor, DMV's, SQL Query Analyzer, execution plan, Query store and performed Query Optimization as well as SQL Profiler/Extended Events.

Hands-on experience with Installation/Troubleshooting, Managing and Auto Configuration of MS SQL Server 2022/2019/2017/2016/2014/2012/2008 on Windows 2016/2012/2008.

10+ years’ experience in planning, designing, implementing, Upgrading and Migrating from SQL Server to SQL Server and to Cloud.

Maintain databases with sizes ranging from Large to Very Large Databases (terabytes) on high traffic SQL Server.

Experience in high availability AG- always On, Disaster Recovery, DB mirroring, Log shipping and replication.

Extensive experience in design, development of Stored Procedures, Views, Triggers and Complex Queries on SQL Server2022/2019/2017/2016/2014/2012/2008.

Hands-on experience with SSIS (SQL Server Integrated Services), SSRS (SQL Server Reporting Services).

Work on Azure, Data Factory, Synapse. AWS/RDS/EC2/S3. PostgreSQL/MySQL and expert in ticketing systems, handling, and resolving tickets.

Automated Database code release, SQL service account and sa password auto rotation, DB file and DB refresh management automation as well as Consistency Checks, index statistic, fragmentation checks and Index Reorganization/Rebuilding Operations/automations.

Deployment management in different environments, DOCs, and collaborations between different teams.

Experience

General Atomics, San Diego, CA Sep 2024 – Jun/2026

DBA

T-SQL, PowerShell, MS SQL AG, Replication, Troubleshooting, Performance tuning, Backup and recovery, code deployment, DPA, Azure/AWS. Upgrade and Patch management. SQL server/DB migration to AWS (EC2, RDS, S3) and Azure.

Support Dev/QA and Prod Environment 24x7. MYSQL, PostgreSQL.

NuVasive Inc. San Diego, CA May 2019 – Sep 2024

Sr. DBA

Planned, designed, and migrated Databases/SSRS from SQL2008/2012/2014 to 2016/2017/2019.

Installed SQL servers, Setup/configure Cluster, AG, DR/Log-shipping/mirror.

Designed auto refresh DB, designed to auto setup Log-shipping, auto expand files size of DB.

Designed and created auto deployment of code/SQL Agent Jobs, auto rotation/change/update password of SQL accounts with T-SQL and PowerShell. Big data management, PostgreSQL, and Linux.

Monitor/Maintain SQL Servers, troubleshooting SQL servers, DB backup and restore with Commvault/Cohesity, create script to backup and restore DB. Utilize Sentry one monitor tool, Zabbix.

Work with Dev, PM and manage code release into production, write SOP/DOCs.

Production, Dev/QA SQL servers support 24x7. Own several projects. Azure. GCP and Security patches.

HuaPin Technology Sep 2016 – Apr 2019

Sr. DBA

Built up teams, managed people, planned and designed projects.

Worked with team, planned, and designed database with SQL2016/2017. MySQL. Mentor and train others.

Installed SQL server 2008 R2/2012/2016/2017 and Migrated SQL Server to SQL server 2016/2017 by using Backup Restore, Detach-Attach and log shipping, and custom scripts on a test environment to be the future production environment.

Experience in Tuning Databases, queries, stored procedures, index by using Performance monitor, DMV and Query analyzer and profiler.

Worked on Always on, DB mirroring, backup and restore in different environment.

Create queries, Stored procedures, and views. Performance tuning and optimization.

Troubleshooting and providing 24/7 production support/operations. Worked on Cloud/Operations.

Microsoft, (Office365-Sharepoint Online Operations) Sep 2011 – Sep 2016

Sr. Service Engineer

Establishing, coaching, and operating SPO Beijing Ops team to deploy, maintain and support Telemetry/IMC/WOW/SPOAM/Show Point, SPO Capacity, Imaging PM, SPO farm deployment across 33 data centers (DC) worldwide.

Team management and managed 8 Engineers.

Extensively worked in high volume OLTP environments that included Production, Per-Production and eDog, databases in SQL Server. Managed SQL Servers in production. Installed, Configured, and managed SQL server across 30 DCs WW. Involved in development activities including hardware installation and configuration, and participation in database design, architecture, and SQL scripting.

Planned, configured and Setup Database Mirroring and Log shipping.

Reviewed specifications. Performed data driven, analysis and found solutions to design database, tables, and categories of alerts, KPI, dashboard to meet business spec. Improved deployment process to 65% from 30%.

Designed and implemented auto KPI and dashboard online service. Managed Telemetry, IMC, SPOAM and IaaS/PaaS key projects.

Created SSIS packages to Extract and Load data from diverse sources. Designed SSRS and created queries, view, and stored procedures, built DW and SSIS data pipeline with SQL server and SQL Azure.

Performance tuning, and optimization of procedures and queries. Security patches monthly. Troubleshooting and Provide 24/7/365 production support. Docs and train team members. Collaborations between Ops, Dev, Test, PM and other cross-functional teams in US and China.

Collaboration and communication among various teams. Training, supporting 21V team and Gallatin deployment and management. Working with Redmond and China Dev/PM/Test/Ops teams successfully delivered several key projects.

Microsoft, EHS (Email archive online service). Aug 2008 – Sep 2011

SQL DBA

Conducted analysis and found solutions to design and develop distinct kinds of monitoring tools such as full text index and Cloud partition jobs.

Found solutions and created procedures for the management of the cloud database system and SQL server. Designed and developed automatic switching system for data migration from SQL servers to SQL Cloud.

Create and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.

Managed and support SQL Cloud, customer provisioning and created Cloud partition. Managed 350 SQL servers and databases (all over TB) in production. Database migration to SQL Cloud from SQL server. Database mirroring, Log shipping, replication, backup and restore. Performance tuning. Created DB partition and ETL to fix customer data issues.

Administered the MS SQL Server by creating user logins with appropriate roles, dropping and the logins, monitoring the user accounts, the creation of groups, granting the privileges to users and groups.

Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.

Monthly security patches provided 24/7 production support (on call).

Pay Scale Inc. Seattle May 2005 – Jul 2008

Sr. SQL DBA

Designed and created a log shipping system. Created query, stored procedures. Performance tuning such as index, query, and store procedure. Code review and deployment in production and test environments.

Setup and maintain transactional replication, log shipping, backup, restore in production and development environment, and DB migrations. Troubleshooting and provided 24/7 production support.

Microsoft Jan 2001 – May 2005

SQL DBA

Performance tuning and troubleshooting, expert in backup and restore, extremely familiar with log shipping, replication, monitoring servers and systems analysis.

Created scripts, queries, stored procedures, views, and triggers; Designed systems that automatically push out certificates to several thousands of servers in the data center.

Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Data transfers between various servers using BCP and DTS. Maintaining and providing technical support of world-class application systems (SQL server, IIS, and CH). Performing installations, setup, configure and troubleshooting for SQL Server.

Supporting Internet and Intranet web sites, databases, and applications. Conducting systems analysis, and monitoring applications and systems.

Setup, configure, maintaining and troubleshooting problems in applications such as ESL (end user subscription licensing), WPA (windows product activation), VLK (volume licensing key), and TSLM (Terminal Server License Manager) systems.

Writing guide of installation and troubleshooting. Working with vendors to solve systems issues.

Kit Solutions Inc Pittsburgh, PA Sep 1996 – May 2001

Software Engineer

Managing several projects. Reviewing spec and customer requirement, designing and developing/coding, testing, deploying databases and applications (PA training Database management system and PBPS).

Designing and setup a centralized application system (web based, PBPS, PA) and providing service to over 30 states in the U.S. as a core member involving all products development and company setup.

SQL Server, Client/Server system configuration and architecture design. Installations, setup, configure, troubleshooting of SQL Server, including DTS, backup and restore. Managing security, and databases. Performance tuning, stored procedures, queries, views. Capacity planning (SQL server).

Designing, setup, configure, troubleshooting and maintaining Ethernet and NT Enterprise network systems. Setup and configure TCP/IP and Gateway. Having found solutions for a variety of connectivity issues (systems).

Installing, setup, configuring and maintaining servers, including Windows NT, PDC, BDC, Active Directory, WINS, DHCP, DNS Server. RAS Server, Windows 2000 & NT Terminal Server, Windows2000 Advanced Server, IIS Server, Exchange Server, Printer Server, File Server, Citrix Server (Metaframe1.8), Sun (8.0) Workstation, and Certificate Server.

User account administration, system security and configuration of the system’s environment.

Education / Certifications:

Bachelor’s degree in electrical engineering, Northeast Electric Power University.

Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Systems Engineer (MCSE), and Microsoft Certified Professional (MCP). U.S citizen.

Bellevue College (SQL 2000 Programming, SQL Admin, SQL Database Design and Implementation, Database Design, W2K Network Infrastructure, OLAP, VB.NET).

Microsoft Certified - Azure Data Engineer Associate

Microsoft Certified - Azure Database Administrator Associate

Contact this candidate