Sql Server Data

SCOTT YU

*** ********* ***** **, **********, GA

OFFICE:678-***-**** EMAIL:************@*****.***

Profile:

7+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.

in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Expertise in T-SQL writing stored procedures, triggers and functions.

Administering SQL Server High Availability and Disaster Recovery strategies.

Expert in data transformation services and Bulk Loads with SSIS.

Implemented the new SQL Server 2012 mechanisms like data compression, online indexing.

Worked on logical and physical data base modeling with ERWIN tools.

Experience in finding out long running queries.

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Experience in Disaster Recovery Planning and Security Management operations.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Worked on configuring SQL Server with minimum privileged access.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.

Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.

Having Experience on Data center servers and handling 1.4 TB databases.

Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS) and Clustering.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Strong experience in mentoring team members and writing documentation.

24 X 7 Production Database on Call Support

KEY SKILL

Oracle DBA 12c, 11g, 10g, 9i, 8i, RMAN, TSM, RAC, DATAGUARD, GRID/Cloud CONTROL, GOLDEN GATE, STREAMS, RAC, Veridata, DataDomain, Virtualbox

SQL Server 2008, 2012, 2014, SSIS, SSRS

DB2/UDB DBA 7.1, 8.2, 9 HA

PROFESSION EXPERIENCE

04/2012 – current

Worldpay

SENIOR DBA

5 year in SQL server administration. Create New SQL server database, Backup/Restore SQL database, Install security patch, troubleshoot turning queries, monitor replications and restore database jobs.

Setup encryption on server and databases.

Setup encryption on server and databases.

Create Monthly Billing Databases by extracting information from production transactions databases Into Data Warehouse and perform Business Logic with Vendor information to generate billing statement using SSIS jobs.

Replicate Vendor Informations daily to different department for Business Intelligent process to running variety report.

Develop, Maintain ana Deploy SRSS reports on SQL reports server to provide different department for Business Intelligent purpose.

Archiving Monthly operational data warehouse for auditing purposes.

Maintain monthly databases online up to 24 month and create union views on all transations.

Archiving older databases and restore databases as request from legal department requests.

Work with BI team developing Data Warehouse application to analysis trend and summary of Business activity.

Work with different department for developing SASS reports for analysis purpose

Leading Project with other department for building new databases and reports, mentor junior DBA.

04/2010 – 04/2012

Precyse

SENIOR DBA

Setup/Configure multi tera bytes Database, perform performance monitoring and manintence.

Deploy New store procedures and work with Development for application deployment and migrations.

Contact this candidate