Paul Ma

Cell: 856-***-**** Email: adt4h4@r.postjobfree.com Cherry Hill, NJ 08003

QUALIFICATION HIGHLIGHTS

• Over Ten years of IT experience in SQL Database Administration and Data Architecture, System Analysis, Design, Development & Support of MS SQL Servers 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 in Production, QA, Reporting Services, Development environments & Replication and Cluster Server Environments.

• Extensive knowledge of proper design of database to meet scalability, security, performance and reliability requirement

• Extensive knowledge of Relational Database Management System (RDBMS)

• Extensive knowledge of Datawarehouse Design by using WherescapeRED and Snowflake

• Strong experience with Data modeling and Database Logical /physical Design Using Erwin, Microsoft Visio, Visual Paradigm and other commonly used tools.

• Strong experience with maintaining SQL server High availability options including clustering, Always on, SQL Server Log shipping, Database Mirroring, Snapshot/Transactional/Merge replication

• Strong experience with BCP, SSIS, SSRS and SSAS

• Strong experience with Tableau

• Experience in Developing and implementing policies, procedures and standards for preserving the integrity and security of data, reports and access.

• Proficient with SQL Management Studio, SQL Profiler, Performance Monitor.

• Experience with installing, analyzing, and supporting SQL Server 2008R2, 2012, 2014, 2016, 2017 and 2019.

• Strong experience with writing SQL scripts, stored procedures, triggers and functions

• Strong experience with Full/Differential/Log Backup & Recovery

• Solid experience with creating SQL Server Jobs/alerts, and creating scheduled tasks

• Strong experience with server/database/scripts Performance tuning and optimization by using different monitor software including Redgate monitor tool, Idera Diagnostic Manager and Spotlight database management and performance monitoring tools

• Strong experience with clustered/non-clustered index, locks including live locks/deadlocks

• Experience with monitoring, troubleshooting and resolving database issues

• Experience with configuring and managing Linked Server, data transfer between SQL server

• Experience with establishing and maintaining development, testing and production environments

• Experience with migration instance between different servers

• Experience with Microsoft Azure (Azure Data Factory, Azure SQL database, Azure Synapse)

• Experience with Disaster and Recovery (DR) strategies testing and implementation

• Strong experience with Redgate software for Database management, SQL compare and multi-server script administration, SQL backup pro and performance monitoring

• Knowledge of Linux OS (CentOS, Ubuntu)

• Good Knowledge of MySQL (5.7 and 8.0), PostgreSQL and MongoDB

• Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks.

• Excellent communication skills. Proactive, independent, self-managing and teamwork spirits.

• Strong experience with VMware vSphere

• Experienced on 7X24 On-call Service

TECHNICAL SKILLS

Operating Systems: Windows 2003/2008/2008R2/2012/2012R2 Server, Windows XP/VISTA/WIN7/WIN10/CentOS/Ubuntu

Databases: MS SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019, MS Access, MYSQL, PostgreSQL, MongoDB, Azure SQL

Database, Azure SQL data lake, Azure Synapse

Languages: T-SQL, Window PowerShell, C#, HTML, Python SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2008/2013/2017/2019, Gitlab, Github, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSRS, Microsoft Clustering Services (MSCS), Erwin, Visual Paradigm Redgate toolset, Idera Diagnostic Manager, Spotlight database management and performance monitoring tools, LiteSpeed SQL backup and Restore tool, SQLSentry, Apex SQL tools. Application: FTP, DNS, VPN, Sample Master XP, iLab, Tableau 8.0, VMware workstation 9, Hyper-V, Domain Controller, Linked server, Maximizer, Macola, VMware vSphere, Snowflake,

WhereScapeRed

PROFESSIONAL EXPERIENCE

Colonial Electric Supply

King of Prussia, PA 19406

Sr. Database Administrator

July, 2020 - Present

Responsibilities:

• Perform installation, configuration of SQL 2008R2, 2016, 2017 and 2019 Enterprise, Standard and developer version on Windows 2008R2, 2012R2 and 2016 servers on Enterprise systems of Dell servers in enterprise Data Centers.

• Manage and Optimize all MSSQL Servers in the company.

• Build and maintain database and data pipeline of the company by identifying and installation solutions of data system and data architecture

• Responsible for management of data structure at the design phase of database management

• Set up Data warehouse for reporting.

• Implement and manage company data management and security practices and policies.

• Provide guidance and support to Application Developers

• Assist with schema design, code review, SQL query tuning

• Supporting Log shipping and database replication

• Have upgraded SQL server 2014 and SQL server 2017 to SQL 2019 on all develop and production servers

• Develop, deploy, and support SSIS packages, SSRS reports (migrating SSRS reports between servers) and SSAS cubes

• Estimate disk storage requirements for databases software, database files and databases administration needs.

• Design logical and physical database, data structures using Microsoft Visio and Erwin

• Monitor performance and troubleshoot problems to ensure database uptime. Troubleshoot and resolve database integrity issues, blocking and deadlocking issues, connectivity issues, and security issues

• Troubleshoot SQL Server related CPU, Memory, I/O, disk space and other resource contention Performance tuning and query optimization, using Performance Monitor, SQL Profiler, SQLSentry and other related monitoring and troubleshooting tools

• Monitor and tune databases to meet the performance and availability requirements of on-line systems and multiple applications

• Modify database structures including tables, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements

• Mentor and oversee junior members of staff, work with the development teams to provide high-quality business solutions as well as play an active role in projects from inception to delivery EMSL Analytical, Inc,

Cinnaminson, NJ 08077

Jan, 2015 – July, 2020

SQL Server DBA/Developer

Responsibilities:

• Performing installation and configuration of SQL 2008R2, 2012, and 2014 Enterprise, Standard and developer version on Windows 2008R2 and 2012R2 servers on Enterprise systems of clustered and standalone Dell (PowerEdge R710) servers in enterprise Data Centers.

• Performing installation, configuration and administration of MYSQL 8.0 in Windows server

• Developing, optimizing the company conceptual and logical data system and data architechture

• Examining and identifying database structural necessities by evaluating client operations, applications and programing

• Managing and Optimizing 50 + MSSQL Servers.

• Setting up Data warehouse for reporting with WherescapeRED.

• Setting up and administrating SQL 2014 AlwaysOn Availability Group

• Have upgraded SQL server 2008R2 to SQL server 2014 on all develop and production servers

• Managing SQL Server Merge replication in EMSL Analytical company (more than 20 subscribers), monitoring the merge replication day-by-day and resolved update and delete conflicts

• Estimating disk storage requirements for databases software, database files and databases administration needs.

• Creating logical and physical database design, data structures using Microsoft Visio and ER one

• Have Migrated 30+ SQL server 2008 R2 instances from old servers to new servers (move all databases, all login, all jobs, all linked servers, all alerts between two different instance)

• Designing and constructing data workflow for real-time data transformation between different databases by using SSIS packages

• Developing and creating the new database objects including tables, views, indexes, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers

• Writing stored procedures, functions, triggers and etc using T-SQL

• Loading stored procedures and functions implemented by developer teams into production databases

• Creating jobs and alerts, analyze activity logs and error logs .

• Monitoring and tuning databases to meet the performance and availability requirements of on-line systems and multiple applications

• Modifying database structures including tables, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements

• Maintaining day-to-day production servers

• Performing troubleshooting performance problem and fine-tuning of databases by using SQL profiler, performance monitor, DBCC command,DMV and Redgate monitor tool

• Using Index tuning wizard to redesign and created the indexes for better performance.

• Fine tuning Stored Procedures using Execution Plan in T-SQL for better performance.

• Implementing trigger and stored procedures and enforced business rules via checks and constraints.

• Working with various business groups while developing their applications (Sample Master XP, iLab, Maximizer CRM and Macola), assisted in database design, installing SQL Server clients, phasing from development to QA and to Production environment.

• Reviewing DB Scripts from the development team before release and deploying them into the Production

University of Pennsylvania,

Philadelphia PA 19104

July 2011 – Jan 2015

SQL Server DBA/Data Analyst

Responsibilities:

• Performed installation of SQL Enterprise 2008R2 version on Windows 2008R2 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers.

• Monitored database size and disk space in Production, Staging & Development environments

• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration, Security and architectural planning issues as well as testing and training.

• Wrote stored procedures, functions, triggers using T-SQL

• Detected and troubleshot Server related CPU/memory, I/O using Performance Monitor

• Configured Merge Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.

• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.

• Configured Database mail, linked servers in SQL server 2008R2.

• Created and scheduled Maintenance plans (database and log backups and cleanups), Business Intelligence packages. Created tables and performed data imports and restores for successful migration.

• Periodically checked Index fragmentation and optimized index

• Executed Change management scripts on weekly basis.

• Set up SQL Agent jobs, SSIS packages, and scheduled tasks to automate works

• Provided day-to-day monitoring, troubleshooting, and performance tuning of all databases

• Documented DB structures and functionalities

• Created monitoring scripts to alert for production issues

• Analyzed human health related data by using Excel, Python and SQL EDUCATION

BS Sichuan University 1996

CERTIFICATE

MCSA: Microsoft Azure Administrator Associate

MCSA: Microsoft Azure Database Administrator Associate MCSE: Microsoft Azure Solutions Architect Expert

MCTS: Microsoft Certified Professional: SQL Server 2008 MCITP: Microsoft Certified IT Professional: Database Administrator 2008 MCSA: Microsoft Certified Solutions Associate: SQL Server 2012/2014/2016 MCSE: Microsoft Certified Solutions Expert: Data Platform 2012/2014/2016 MCSE: Microsoft Certified Solutions Expert: Data Management and Analytics 2012/2014/2016 HIPPA (Health Insurance Portability Accountability Act) Awareness Certificate HIPPA (Health Insurance Portability Accountability Act) Security Certificate

Contact this candidate