SUMMARY:

• 6+ years’ working experience in SQL Server database administration and SQL Scripts
• Extensive experience including designing, implementing, maintaining, and documenting complex database applications and Data Warehouse
• Experience with installing, analyzing, and supporting SQL Server 2005, 2008, 2008R2, 2012 and 2014
• Strong experience with Data modeling and Database Logical /physical Design
• Strong experience with server clustering, data warehousing, data extraction/transformation/load (ETL)
• Strong experience with High Availability(HA) and Disaster Recovery(DR): AlwaysON, Log shipping, Database Mirroring, snapshot/transactional/Merge replication
• Experience with BCP, DTS and SSIS and SSRS.
• Develop and implement policies, procedures and standards for preserving the integrity and security of data, reports and access.
• Proficient with SQL Management Studio, SQL Profiler, Performance Monitor
• Strong experience with writing and tuning 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
• Strong experience with upgrading SQL SERVER 2008R2 to SQL Server 2014
• Strong experience with clustered/non - clustered index, locks including livelocks/deadlocks
• Experience with monitoring, troubleshooting and resolving database issues in 24 7 production Server.
• Experience with establishing and maintaining development, testing and production environments
• Familiar with linked servers
• Good Knowledge of the scripting language C#
• Experience with deploying AWS cloud instances of SQL Server
• Expertise with MySQL configuration, load balancing, failover and caching technologies
• Good Knowledge of system monitoring software (Sql monitor /Solarwinds)
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks.
• Excellent communication skills. Proactive, independent, self-managing and teamwork spirits.
• Experienced on 7X24 On-call Service
• Good OS skills in Windows

TECHNICAL SKILLS:

Databases: MS SQL Server 2000/ 2005/2008/2008 R2/2012/2014

Tools: SSRS/SSIS, Profiler, Performance Monitor; Visual Studio/ SharePoint; MS Office

Windows System: XP/Vista/Win 7/2003/2008/2008 R2, Exchange 2007

PROFESSIONAL EXPERIENCE:

Confidential, Watsonville, CA

Senior DBA

Responsibilities:

• Managed and optimized 50 + MSSQL Servers (SQL Server 2005/2008/2008 R2/2012/2014)
• Installed and configured windows 2012R2, and installed and configured SQL Server 2012/2014
• Wrote T-SQL scripts including stored procedures, functions and triggers
• Set up and managed SQL Server High availability(HA) and Disaster Recovery (DR) solutions: Log Shipping and AlwaysOn
• Migrate SQL Server 2008 to SQL Server 2014
• Set up database backup plans including full/differential/log backup
• Detected and troubleshot Hardware bottleneck using Performance Monitor
• Monitored and Optimized slow queries
• Periodically optimized index and updated statistics to improve performance
• 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
• Built and managed data warehouse, used SSIS for data processing and SSRS for reports
• Worked on periodical DB maintenances
• Documented Database structures
• Used SQLMonitor to monitor windows system and SQL Server databases
• Worked on 7X24 on-call

Confidential, San Francisco, CA

Senior DBA

Responsibilities:

• Managed and Optimized 50 + MSSQL Servers (SQL Server 2005/2008/2008 R2)
• Set up and managed high availability(HA) strategy: alwayson and log shipping
• Configured SQL Server maintenance plans to automatically back up SQL Server Databases
• Collaborated with infrastructure team for database backup strategy
• Used SQL Server Profiler to trace long running queries for optimizing databases
• Troubleshot SQL Server related CPU/Memory, I/O using Performance Monitor
• Collaborated with system teams and development teams for codes release including MSSQL database changes
• Set up and configure Sql monitor to monitor SQL Server system and Windows Application systems
• Documented All MSSQL Database structures and functionalities
• • Worked on 7X24 on-call

Confidential, Union City

Server DBA

Responsibilities:

• Installed OS (windows server 2003/2008) and databases (SQL Server 2005/2008R2) for different Applications
• Managed and Optimized 30 + MSSQL Servers
• Set up and managed SQL Server transactional replication/merge replication and Log Shipping
• Worked on Backup and Restore databases, database tuning and optimization
• Detected and troubleshot SQL Server related CPU/Memory, I/O using Performance Monitor
• Wrote SQL codes including stored procedures, functions, triggers
• Designed database for registration/account system, billing system and user tracking system
• Managed data warehouse, used SSIS for ETL tools, SSRS for reports
• Worked on database maintenance (including DB changes, DB patch, DB index tuning)
• Monitored windows system using Zabbix software
• Documented DB structures and functionalities