Patrick Mua

Plano, TX, *****.

Ph: 314-***-****

Email: ac7zkr@r.postjobfree.com

Professional Summary

- SQL SERVER DBA: NTHRIVE. Plano, TX.

**/****- *******

Four years’ experience in SQL Server Database Administration with focus on Migration, Installation (Builds), Patching, System Analysis, Testing, Development and Support with MS SQL Server in Production and Development Environments.

Experience in Installation, Configuration, Database design & Development, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services, and Database Security

Experience working with MS SQL Server 2016/2014/2012/2008 versions. Hands on experience in SQL Server data transfer techniques and SSIS package design, constructing, and deployment.

Expert in creation of tables, views, triggers, stored procedures and functions using SQL (Structured Query Language) and T-SQL (Transact-SQL).

Expertise in database Backup, Recovery and Disaster Recovery procedures. Developed and documented disaster recovery plans and backup and recovery strategies for production environment.

Performance tuning, trouble ‘shooting and monitoring using Performance Dashboard reports, Database Tuning Advisor, SQL Profiler.

Experience in providing 24 x 7 production support.

Excellent communication skills, organizing skills, highly punctual and an excellent listener.

Education:

Bachelor’s in sciences

University of Missouri- St Louis. December 2014

Training and Certifications:

SQL Server TSQL and Database Administration Training.

Technical Skills:

Operating systems

Mac OS X, Windows OS

Languages

SQL

Relational Databases

SQL SERVER T-SQL, ORACLE(Basic),

Other Tools

Microsoft Office, SSIS(Basic), Spotlight on SQL SERVER

Additional Professional Experience:

-SQL DBA: INNOVAZIX GP. LLC. Dallas, TX.

02/2015- 05/ 2017

Responsibilities:

Administering and maintaining large SQL Server 2016, 2014, 2012 databases with more than 100 million records in individual tables and multi-Terabyte servers

Developed SQL scripts to Insert, Update and Delete data in SQL database tables.

Creating and re-evaluating indexes for better performance.

Backups and Restore for SQL Server.

Creating databases and logins with permissions in SQL Server as per the developer’s request.

Created backup schedule for test and development servers.

Assigning user logins and privileges at database and instance level

Involved in restore operations to refresh the data from production to test servers.

Contact this candidate