PROFESSIONAL SUMMARY

• 17 years professional experience encompassing Database Administration primarily MS SQL Server , Team Management, Systems Analysis, Project Management and Strategic Planning
• Database Administration in fast-paced, distributed architectures supporting thousands of users, 24x7 on-call environments
• Database design and implementation.
• Development of complex stored procedures TSQL to create unique solutions
• SSRS reporting and SSIS development
• Performance Tuning expertise
• Database infrastructure implementation projects such as RDBMS installs/upgrades, hardware upgrades, real-time replication and disaster recovery

PROFESSIONAL

MCSE Data Platform Confidential

CERTIFICATIONS

MCSA Microsoft SQL Server Confidential

MCTS Microsoft SQL Server Confidential

PROFESSIONAL

Senior SQL Server Consultant

EXPERIENCE

Confidential

• Provided SQL Server consulting services and assisted clients with SQL Server performance problems.
• Identified and tuned poor performing SQL code to increase performance and reduce/eliminate deadlocks and blocking.
• Addressed SQL Server configuration errors
• Identified poor storage IO latency
• Created custom SQL scripts
• Completed proof-of-concept projects such as SQL Server to Oracle conversions.
• Implemented database maintenance processes
• Provided detailed expert analysis of existing performance problems in a concise deliverable report.
• Analysis focused on areas such as disk IO latency, SQL Server database IO latency, SQL Server waits, deadlocks, and blocking.
• Specific technical recommendations to address a client's performance issue s .
• Created and maintained an automated SQL Server performance data capture process.
• SQL Server 2014 research in the areas of Cardinality Estimator and In-Memory databases.
• Wrote technical blogs for corporate website see Publications section below .

Database Architect/SSIS Developer

Confidential

• Migrated all of the Intermodal Ops Department's SQL Server 2000 databases and DTS packages to a new SQL Server 2008R2 environment.
• SSIS development included components such as External Data Sources, Exports to Access Databases and Excel files, Importing CSV files, FTP Tasks, Dynamic Statements, Foreach Loop Containers, Conditional Expressions, Child Package execution, File System Tasks, Stored Procedure Calls, Data Conversion and Data Cleansing.
• Data migrations were completed with custom SSIS packages utilizing a combination of SQL Script, Data Flow and File System tasks.
• Created database design changes as needed to support new SSIS functionality.
• Assisted the Norfolk Southern Manager with project management and change control duties for each database/package migration.
• Coordinated database and dependent system migrations to the new environment with end-users and the IT department.

Senior Database Administrator Confidential

• Remote SQL Server administration and consulting for all of Ntirety's SQL Server clients. A wide variety of services are provided: Basic DBA, Replication support, Database Mirroring support, MS Cluster support, Performance Tuning, Production support, etc.
• Project management: Developed SOWs and work with clients on projects from design through implementation.
• Example: Developed a solution to synchronize database data between local and remote systems. The solution included SSIS packages and FTP automation.
• Designed and developed custom solutions via stored procedure programming
• Examples: Dynamic Database Backups, Selective Re-Indexing, Selective Update Statistics
• Mentored junior team members

Database Administrator Principle I Confidential

• Database Administration and Production Support including on-call support of the entire SQL Server environment
• Over 100 SQL Server instances across Production, Q/A and Development environments
• Supported development teams with their SQL Server projects and implementations
• Performance Tuning
• Managed database migration and implementation projects which consisted of the following:
• Coordinating with business owners and IT resources
• Planning and configuring system resources
• Developing implementation plans
• Project communication and status updates
• Designed and developed custom SQL Server monitors, alerts and processes Stored Procedure programming
• Examples: Database Mirroring Alerts, Automatic Server Reboot, System Capacity statistics, Disk Freespace Alerts, Automating Non-Production database refreshes
• Mentored junior team members

Senior Database Engineer Confidential

• Database Administration of the SQL Server environment. The environment consisted of SQL Servers located in multiple datacenters supporting internal GMTI applications, over 100 Gannett Newspapers and Publications, TV stations and USA Today. MS Clustering was utilized for SQL Servers supporting highly available applications
• 24x7x365 on-call support
• Production support
• SQL Server Replication Transactional, Merge, and Snapshot of small to VLDBs.
• Database maintenance
• Performance Tuning
• Replication: Implementation, monitoring, trouble-shooting
• Log Shipping cross-site
• Database migrations
• SQL Server installation
• Implement FTS
• Assisted with MS Premier Technical Support Cases
• Vendor management - Managed the relationship with an outsourced DBA service provider
• Planned and Implemented SQL Server migrations includes: Project Plan, Test Plan, Schedule, etc.
• Designed and Developed stored procedures to solve various issues
• Created DTS/SSIS packages for migrating data between SQL Servers and from various sources

Database Administrator Principle I Confidential

• Database Administration including on-call support of the Knowledge Management SQL Server environment
• Participated in data architecture planning meetings
• Mentored junior level DBAs as needed

Database Engineer Confidential

• Data Architect, DBA, and Database Developer for the DoD funded A2IPB Automated Assistance with Intelligence Preparation of the Battlespace project
• Research Development for the A2IPB RDBMS migration from Sybase 12.5.x to Oracle 9.x platform
• Designed Developed the A2IPB v3.2.x database upgrade utility
• Stored Procedures: TSQL, dynamic execution, cursors, temporary objects and error handling
• Upgrade Features: Schema changes, existing data maintained while ensuring data integrity
• Designed Developed the A2IPB v3.2.x database installation and uninstall programs
• C-Shell script controls installation process using Java UI windows
• Calls to ISQL batch scripts

Strategic Systems Analyst

Confidential

• Executed project management duties and responsibilities across all projects, teams and organizations
• Interacted with internal customers to develop requirements and ensure project satisfaction
• Produced detailed system/process flow diagrams identifying SIs, manual and automated processes
• Assisted with creating business plans for executive and funding review
• Created conceptual systems architectures for proposed solutions on multiple projects
• Produced and issued a comprehensive Request for Proposal RFP to 26 vendors

Database Manager, Confidential

• Hands-on, empowering management style, remained technically involved
• Managed over 50 SQL Servers, multiple locations, 3000 users, 24x7x365 HA arch, >99 uptime stats
• Created, hired and supervised the database team
• Administered a multi-million dollar capital and expense budget
• Organized, managed and implemented numerous database projects
• Established and reported database metrics to upper management on a consistent basis

Database Administrator DBA , Confidential

• 24x7 on-call support dedicated pager/cell phone
• Primary responsibilities included: resolving database corruption problems supporting the Application Development team reviewing code releases installing and configuring servers/SQL Servers resolving LAN connectivity issues and Help Desk tickets
• Developed complex stored procedures consisting of: input/output parameters, temporary tables, system tables interaction, RPCs, global/local variables, cursors, control flow statements, function calls, error handling, nested procedures, etc.
• Researched and developed an active-passive SQL Server Microsoft Cluster Server environment
• Created a prototype online ordering system application utilizing ASP for the DB interface

Associate Consultant

Confidential

• Completed the Sybase System 11 training and certification program
• Provided on-site Sybase support for clients such as USF G and Fannie Mae

Performance Tuning Corporation Confidential

• Supported PTC clients by providing remote database consulting services such as:
• Reporting Services 2008R2 Sharepoint configuration.
• Performance Tuning.
• Analysis and recommendations on SQL Server environments experiencing performance issues.
• General Database Administration
• Database Migrations.

Panasonic Confidential

• Create custom data extracts and reporting for the Avaya database environment. Solutions included custom stored procedure, scheduled jobs, and Reporting Services reports.
• Performance and Tuning
• Provide database infrastructure analysis and recommendations.

Advanced SW Technologies Confidential

• Provided remote support via VPN for a SQL Server 2005 migration. I installed and configured 3 new SQL Server instances, migrated existing databases, created custom database maintenance processes and configured database mirroring.
• Wrote custom stored procedures for Database Backup, DBCC, Re-index and Update Statistics maintenance jobs.
• Configured Database Mirroring to provide a High Availability solution.
• Provided turnover and documentation of the solution.

GMTI Confidential

• Provide after-hours DBA support remotely via VPN.
• SQL Server Replication Transactional, Merge, and Snapshot implementation, monitoring and support.
• Database maintenance
• Performance and Tuning
• Database migrations
• SQL Server installations
• Assisted with MS Premier Technical Support Cases