PROFESSIONAL PROFILE
I am an IT professional with over fifteen years of experience and am currently employed by Tata Consultancy Services on the PricewaterhouseCoopers account. I lead the Infrastructure Engineering SQL DBA team, which has members both on and offshore. While my recent experience is with infrastructure and server architecture, I also have extensive experience in software and database development. I am the go to person when other DBAs have performance problems within the SQL Server database engine. I have large company experience and appreciate a small company feel.

ACCOMPLISHMENTS

• Coordinated the resolution of a major outage on a newly deployed database cluster; recovering a corrupted database without a loss of data
• Lead the investigation and resolution of an intermittent SSRS problem that plagued a project team for over six weeks
• Proposed and consulted on the use of partitioning to resolve contention issues on a vendor supplied application
• Received an Outstanding Service Award from the Director of IT at Siemens
• Identified as a top performer by the IS Director at Guardian Industries

SKILLS & TOOLS

• SQL 2000 - 2008 R2
• DB Server Architecture
• SQL Server Clustering
• Log Shipping
• SSIS & SSRS
• Encryption (SSL & TDE)
• Data Partitioning
• VLDB
• Database Design
• Stored Proc Design
• Performance Tuning
• Resource Governor
• DMV’s & DMF’s
• Change Management
• 24x7 Support
• EMC SAN

EDUCATION, CERTIFICATIONS & TRAINING

Bachelor of Science in Electrical Engineering
Master of Science in Computer Science

Microsoft Certified Professional
MCTS: SQL Server 2005 (Exam 70-431)
ITIL Foundations V2 Certified
New Horizons SQL Server 2008 Training
Hewlett-Packard PolyServe Training
MOCE Performance Workshop

EXPERIENCE

Infrastructure DBA / Architect

• Firsthand experience during the transition from an in-sourced IT model to an out-sourced model
• Identified process to capture and report on infrastructure performance data when standardized tools did not meet project needs
• Mentoring junior Infrastructure Engineering DBAs and Operational DBAs in troubleshooting issues
• Fostering team unity and camaraderie during time of transition
• Selected to lead the Infrastructure Engineering SQL DBA team
• Selected to be an infrastructure PM on new projects, working side by side with the Project Manager to ensure success
• Lead a team of IIS and Windows Administrators in investigating and resolving a deployment issue during the time of transition

Confidential, (1/2010 10/2010)

Infrastructure DBA / Architect

• Identified an application bottleneck causing poor performance; proposed and rolled out a row level partitioning resolve
• Lead troubleshooting and remediation activities for a poorly performing and undersized database server during Tax busy season
• Deployed clustered HP DL580 SQL Server 2008 SP2 instance running on Windows Server 2008 R2 for a major Tax application
• Experienced in the deployment and support of SQL Server 2008 R2 in both stand-alone and clustered configurations
• Implemented Resource Governor to prevent single processes from consuming all memory and CPU resources
• Responsible for leading the DBA role on various Tax, Assurance and Advisory line of service projects

Confidential, (1/2010 10/2010)

Infrastructure DBA / Architect

• Identified MSDTC ports in conjunction with a network resource to allow distributed transactions across domains
• Performed analysis on Profiler & PerfMon data; indentifying both hardware bottlenecks and application issues
• Documented projects prior to transitioning to the operational database administrators team for ongoing support
• Routinely work with multiple functional teams on both application and database performance issues
• Reduced EMC SAN read and write latency by over thirty percent by changing queue depth, alignment and block sizes
• Developed a new index maintenance strategy, reducing load, required disk space and duration of the scheduled job
• Participated in the interviewing process of new database administrators to support a major application deployment
• Continuously work to increase awareness of database technologies and capabilities for both technical and non-technical staff
• Deployed log shipping for numerous production instances to remote DR secondary servers

Confidential, (8/2009 1/2010)

Production / Infrastructure DBA

• Improved the up-time of Siebel and Great Plains by standardizing backup and other maintenance tasks
• Improved the performance of maintenance processes by reducing the amount of resources required
• Application administrator for Siebel and Great Plains including providing support for the finance department
• Sought new employment because of a buyout by a larger competitor, Equinix

Confidential, (5/2008 8/2009)

Production / Infrastructure DBA

• Member of a team of seven DBAs responsible for more than 180 production SQL Server instances requiring 24X7 support
• Experienced in the planning, installation, configuration and support of stand alone, two node and four node clusters
• Thorough understanding of file group backups and the partition maintenance required to support a VLDB
• Experienced in identifying and resolving both hardware and software bottlenecks utilizing native and third party tools
• Led projects to deploy DBA support applications such as SQL Sentry and Spotlight on SQL Server Enterprise
• Initiated, designed and led multiple training sessions for technical and non-technical personnel
• Routinely assist junior DBAs in creating, improving and analyzing T-SQL statements for reporting purposes

Confidential, (2/2002 5/2008)

Production & Application DBA / Developer

• Designed, developed and taught a SQL Server class on the 2005 client tools including SSMS, BIDS, DTA & Profiler
• Assisted national and international locations in improving SQL Server 2005 uptime and performance
• Successfully migrated multiple databases from SQL Server 2000 to 2005 without any unplanned downtime
• Recognized a need and developed a uniform database backup strategy available for all worldwide SQL Server installations
• Lead project to enhance a Java based corporate financial reporting system utilizing SQL Server and Essbase databases
• Provided ad hoc T-SQL reports for accounting, marketing, legal and treasury departments
• Mentored Guardian developers and DBAs worldwide in basic database administration tasks
• Developed and monitored daily ETL process to import AR and AP data to the home grown CRM database
• Identified a need, developed and deployed an SSIS package to rebuild or reorganize indexes only when needed utilizing DMVs

Confidential, (10/2000 2/2002)

Software Developer

• Participated in the development of a mature home grown Procurement system utilizing Borland Delphi
• Provided technical support and mentoring to developers who were learning object oriented programming

Confidential, (9/1997 - 10/2000)

Software Developer / Team Lead

• Managed a team of five software engineers during time of company reorganization
• Trained entry-level maintenance team members on application development tools and source code methodologies
• Proposed, acquired, and rolled out a new defect tracking system called TestTrack by Seapine Software
• Consulted with other teams to assist in solving urgent customer issues with or without code change