Sr Developer/DBA

Dennis Wardosky

Phone: 616-***-****

E-mail: **********@*****.***

Summary

• 30 years of IT experience including roles as a Developer and SQL Server Database Administrator

• 7 years experience in Microsoft® SQL Server 2008 R2/2005/2000 supporting mission critical environments as a Production DBA

• 7 years experience in setup and managing Microsoft® SQL Server Replication, Clustering, Log Shipping and Database Mirroring to provide high availability of the database

DBA Skills

Excellent experience in

• Installing and Configuring SQL Server 2008R2/2005/2000 to provide the optimum performance in mission critical OLTP Environment

• Administrating large SQL server installation with VLB

• Maintaining High Availability in 24/7/365 environment using MS Windows/SQL Server Clustering and Database Mirroring

• Skilled with SQL Server 2008/2005 Management Studio, SQL Server Profiler, Windows Performance Monitor, and T-SQL

• Monitoring and troubleshooting using Windows Event Logs, SQL Server error logs, SQL Server Profiler trace data

• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, DB Mirroring issues, connectivity issues, and security issues etc.

• Extensive experience upgrading SQL Server and migrating databases between SQL Server 2000, 2005, 2008 & 2008R2

• Supporting the business by insuring a highly available and efficient SQL Server environment.

• Providing a high level of support to application developers and clients

Technical Skills

RDBMS: MS SQL Server 2000\2005\2208\2008R2

OS: WINDOWS NT 2000\2003\2008\2008R2

Hardware : Compaq Proliant 8000/8500, HP-9000 Series E-35

Education

Associates in Computer Science,

Certification

Microsoft Certified IT Professional (MCITP): SQL Server 2008 Database Administrator

Pending completion of SQL Server boot camp in Orlando 10\30\2011

Professional Experience

Amway Corp, Ada Mi August 1986 – Till date

A direct selling company that produces high-quality consumer products available in over 80 countries

Sr. Database Administrator

• Implemented high availability of databases using Database Mirroring and provided near zero downtime

• Planed, Designed and built database servers from scratch for the new Development, QA and Production environments

• migrated database servers across different domains in Windows 2008R2 and provided database availability for the business applications with near zero downtime

• Built and maintained SQL Server Transactional and Snapshot Replication

• Designed and implemented Role based security for Windows groups to various database environments

• Support developers to resolve performance issues with help of SQL Server Profiler traces and provided various performance reports to the team

• Implemented periodic jobs to do database consistency checks (DBCC) to ensure the physical consistency of the database objects

• Monitored databases to identify the performance issues using SQL Server Management Studio (SSMS), Windows performance monitor, SQL Server profiler and DMVs

• Built and managed Clustering in SQL Server to provide high availability of mission critical production servers

• Provided database size and trend analysis report to the management for capacity planning

• Planned and implemented SQL Server Service Packs and patches to numerous environments

• Supported 4000+ databases which are hosted on 175+ servers on 24/7/365 basis

• Built and managed Clustering in SQL Server to provide high availability of production servers

• Built and managed DB Mirroring to provide DB level high availability for various mission critical databases

• Designed and implemented Role based security to all database instances using custom made scripts

• Implemented Database auditing to fine tune the database security and access

• Monitored the database to identify the performance issues using SSMS, Windows performance monitor and T-SQL scripts

• Planned and implemented SQL Server Service Packs and patches on multiple clustered servers without impacting the availability of the databases

• Implemented databases on SAN for RAID 5 and RAID10 disk subsystems for better scalability, performance, storage and retrieval of high volume of the data

• Created and maintained documentation of all DB servers to provide on-time reports to management

• Migrated Databases and DTS Packages from SQL Server 2000 to 2005

• Set up SSIS Packages in order to scheduled and executed by SQL Server agent

• Optimized Indexes for better performance using SQL Query Plans at Query Analyzer and Index Tuning wizards

• Created Backup and Recovery strtagty utilizing Transaction Log, Differential and Full Database Backups to insure PIT recovery

• Improved the performance by query optimization and fine-tuned Stored Procedures and Triggers

• SQL Server Performance Data Collector, Windows Performance data collector, database tuning advisor

• Handling 175+ SQL Server instances and 4000+ databases from 50 MB to multi terabytes as a Sr. Production Support DBA

• SQL Server Performance Data Collector, Windows Performance data collector, database tuning advisor

Contact this candidate