Sql Server Data

Daniel Yuan

818-***-**** ******.****.**@*****.***

Qualifications Profile

Talented, results-focused emerging professional leveraging key understanding of data gained through advanced education and applied experience to serve as Microsoft SQL Server DBA (Database Administrator), Microsoft SQL Server Developer or other positions.

Green card holder, and no sponsorship needed; willing to relocate if necessary.

Highly motivated, quick learner with over 6-year solid experience working in the IT industry specializing in Microsoft SQL Server database administration and development.

Proven ability to solve a wide variety of software and business issues.

Excellent analytical, organizational, multi-tasking, planning and problem solving skills.

Operate well independently or within a team.

Eager to increase my knowledge and expand my technical skill set.

Deal well under pressure and with rigorous deadlines.

Welcome new challenges and love creative solutions to complex problems.

Professional Summary

Over 6-year solid experience in Microsoft SQL Server administration and development (T-SQL) fields.

In-depth knowledge of T-SQL. Strong skills in SQL developing. Extensive experience in creating functions, stored procedures, indexes, views, and triggers to facilitate efficient data manipulation and data consistency.

Extensive experience in Microsoft SQL Server administration, including designing, implementing, maintaining and documenting complex database applications and data warehouse systems.

Solid first-hand experience with data modeling and database logical/physical design.

Strong experience with Microsoft SQL Server clustering, data warehousing, and data extraction/transformation/load.

Deep understanding and solid skills in Microsoft SQL Server log shipping, database mirroring, snapshot/transactional /merge replication, failover cluster, BCP, DTS and SSIS, SSAS and SSRS.

Proficient with Microsoft SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Profiler, and Performance Monitor.

Experienced with installing, configuring, analyzing, and supporting Microsoft SQL Server 2005, 2008, 2008R2 and 2012 in development, test and production environment.

Solid first-hands experience with Microsoft SQL Server upgrade, full/differential/log backup & recovery, clustered/non-clustered index, locks including live locks/dead locks.

Extensive experience with writing SQL scripts, stored procedures, triggers and functions, creating SQL Server jobs/alerts, and scheduled tasks to automate tasks.

Strong experience with Windows Server/ Microsoft SQL Database/T-SQL scripts Performance tuning and optimization.

Experience with monitoring, troubleshooting and resolving database issues in 24x7 production servers.

Strong experience with Microsoft SQL Server performance monitor and performance tuning, maintenance and SQL Server version upgrade.

Excellent knowledge with SAN Storage and Storage Capacity Planning. Experience with Amazon AWS, RDS (Microsoft SQL Server) and S3/EBS storages.

Good knowledge of system monitoring software (Zabbix/Nagios/Solarwinds). Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks.

Solid knowledge and experience of software development life cycle and project manage methodology.

Extensive knowledge of software quality assurance methodology, and hands-on experience in database/data warehouse testing.

Results-driven with ability to take initiatives and meet deadlines in a fast paced changing environment; Strong analytical and communication skills with the enthusiasm to learn new technologies.

Proven ability to approach and solve problems effectively and independently; Experience to manage multiple priorities and handle multiple tasks.

Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

Technical skills

Database:

Microsoft SQL Server 2005/2008/2008R2/2012/2014, and Access

SQL Server Tools:

SQL Server Management Studio (SSMS), SSRS, SSAS, SSIS

Toad for SQL Server, Profiler, Performance Monitor, SQLyog, and Sharepoint

Programming Languages:

Visual Basic/Visual C#/PowerShell/Perl

Development Tools:

Microsoft Visual Studio 2008/2010

Application:

Apache/IIS/Tomcat, SVN, Samba, VMWare, DNS, and Firewall

Monitor Tools:

Zabbix, Nagios, Solarwinds, Graphite, and New Relic

Professional Experience

Geico Insurance, Chevy Chase, MD 09/2013-Present

Senior Microsoft SQL Server DBA, Consultant

Manage and optimize more than 100 Microsoft SQL Servers (SQL Server 2008R2/2012) and setup and manage high availability strategy: failover cluster, replication, database mirroring and log shipping.

Configure Microsoft SQL Server maintenance plans to automatically back up SQL Server databases, optimize index and update statistics.

Write PowerShell Scripts and setup Windows Task Scheduler to automatically back up MS SQL Server databases in Windows X64 Systems.

Collaborate with the infrastructure team for database backup strategy: onsite backup, offsite backup and offline backup.

Use SQL Server Profiler to trace long running queries for optimizing databases.

Restore MS SQL Backups to check backup integrity and practice disaster recovery.

Troubleshoot SQL Server related CPU/Memory, I/O using Performance Monitor.

Troubleshoot MS SQL Server issues and optimize MS SQL Server performance through slow query log and execution plan.

Write Microsoft SQL T-SQL codes including stored procedures, functions, triggers and ad hoc queries.

Manage Microsoft SQL data warehouse, and write SSIS for ETL tools, SSAS for data analysis, and SSRS for reports.

Collaborate with system teams and development teams for code release including MS SQL database changes and patches.

Set up and configure Zabbix monitor system and Solarwinds to monitor MS SQL Server system, Windows Application systems.

Upgrade SQL Server 2005 to SQL Server 2008R2, SQL Server 2008R2 to SQL Server 2012.

Create and manage full-text servers, linked servers to support production needs.

Document all Microsoft SQL Server database structures and functionalities.

Work with auditors and provide database related documents.

Work on 24x7 on-call rotation.

Hewlett-Packard Enterprise(HP), Pontiac, MI 05/2011–08/2013

Senior Microsoft SQL Server DBA, Consultant

Worked closely with systems administrators and development teams to install, upgrade, migrate and troubleshoot Prod and non-prod SQL server instances across both physical and virtual machine (VMware) environments.

Administered over 60 SQL servers. Migrated several Prod database servers with minimal downtime.

Supported reporting applications, and other sub systems dependent on Microsoft SQL server.

Monitored production databases for performance, availability and data integrity.

Configured and maintained database replication, log shipping and database mirroring.

Scripted several database maintenance tasks reducing manual processes and related overheads.

Performed data recovery from corrupt databases or simple backups or transaction logs.

Set up SQL/database mail to produce database health reports and other alerts.

Managed production deployments of schema changes and data conversions.

Created SSIS packages for data transfers, Import/Export and Migrations.

Recreated indexes, optimized queries, memory management to improve performance.

Database space management, log files and data integrity.

Created and managed full-text server, linked servers to support production needs.

Administered Microsoft SQL server security and kept up-to-date through frequent audits of SQL logins.

Tested and installed latest Microsoft SQL server/Windows server service packs on all SQL servers.

Integrated SQL Server with windows active directory security for database/table level permissions.

Created strong passwords for SA account, sometimes disabled it, and removed sample databases.

Ran Microsoft baseline security analyzer periodically to check for SQL server security issues.

Worked on database maintenance (including database changes, database patch, database index tuning).

Monitored Windows/SQL Server systems using Nagios.

Mascon Inc., Woburn, MA 06/2009–04/2011

Microsoft SQL Server T-SQL Developer

Worked closely with business partners, assembled and converted business requirements into complex T-SQL scripts and stored procedures.

Created database objects like tables, views, indexes and constraints. Managed and maintained scripts, stored procedures, functions, triggers, views and indexes.

Identified and analyzed expensive T-SQL stored procedures by using the SQL profiler, SQL analyzer, index tuning wizard and running home-cooked SQL scripts, and created the necessary indexes and SQL hints to improve query performance.

Created ETL packages with SSIS tools to extract data from various source of record, transformed and cleansed the data, and loaded the data into data warehouse.

Designed and deployed various different professional reports with SSRS tools, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports. Set up advanced functions, dashboard, drill-trough/drill-down, KPI/Indicators in reports.

Designed Cube, and imported sales data into SQL database from various data sources such as Oracle and flat text files.

Wrote, maintained and updated technical documentations.

Educational Background

Master of Science, Northern Arizona University – Flagstaff, AZ

Contact this candidate