Sql Server Service

Henry W. Naylor IV Telephone: 302-***-****

New Castle, DE E-mail: *******@*****.***

Link to References Link to LinkedIn Profile

M I C R O S O F T C E R T I F I C A T I O N S

MCITP DBA on Microsoft®

SQL ServerTM 2008

MCITP DBA on Microsoft®

SQL ServerTM 2005

MCDBA on Microsoft®

SQL ServerTM 2000

MCTS on Microsoft®

SQL ServerTM 2008

MCTS on Microsoft®

SQL ServerTM 2005

MCP on Microsoft®

Windows ServerTM 2003

C O R E C O M P E T E N C I E S

Database Administration

On/ Off Shore Management

Service Oriented Architecture

Database Server Optimization Team Leadership N-Tier Architecture

HADR Designing Complex Systems Object Oriented Design

Database Design/ Development Waterfall/SCRUM Response Design

Multi-Terabyte Database Project Management Clean Code

Query Optimization Requirement Gathering Web Development

Data Warehousing Test Coordination Web Design

Data Migration Source Control Management Web Services

Reporting SDLC DevOps

T E C H N O L O G I E S

C#

JQuery

T-SQL / SQL

Replication

.Net 4.5 AngularJS SSMS/ SSIS Service Broker

MVC5 JSON/ XML/ XSLT SSRS/ SSAS Extended Events

WCF HTML5/ CSS3 Clustering DMVs

Entity Framework 5 Bootstrap AlwaysOn/ Mirroring CLR Functions

Razor TFS/ Git Log Shipping SQL Server Profiler E X E C U T I V E S U M M A R Y

A dedicated senior solution architect, application development and dba manager with a progressive history of driving global database development and data warehouse projects, managing complex IT initiatives, maintaining Microsoft SQL Servers and developing ASP.NET web application in the financial services, real estate, health compliance and information sectors. Expertise with taking organizations from subpar IT situations to streamlined, fully automated IT environments performing at full capacity. Proven individual contributor as a dba and web developer as well as a gifted teacher, coach and mentor. Lifelong learner.

H e n r y W N a y l o r I V P a g e II

P R O F E S S I O N A L E X P E R I E N C E

RAIT FINANCIAL TRUST

SYSTEMS ARCHITECT, MANAGING DIRECTOR OF DEVELOPMENT 12/2013 – 02/2017 Manage the 3-person development department. Meet with business stakeholders to gather requirements, establish test plans and assign resources. Direct the testing, release and defect mitigation process.

Architected and designed SQL Server database and .NET applications

Lead developer for responsive web based loan origination system

Lead database and application development using SQL Server and ASP.NET MVC

Developed SSIS packages for data loads and data migrations

Created SSRS reporting portal and reports for the Accounting department. TECHNOLOGIES

SQL SERVER 2012/14, SSMS, SSIS, SSRS, Profiler, AlwaysOn, T-SQL, CLR Functions, Service Broker, XML, Visual Studio 2012-15, TFS 2012, C#, WCF, MVC, Entity Framework, JSON, JQuery, Razor, HTML 5, CSS 3, Bootstrap, SCRUM, Visio, Microsoft Project

CITIGROUP, PREPAID CARDS

VICE PRESIDENT, GLOBAL DATA SERVICES TEAM LEAD 04/2011 – 12/2013 Oversaw a global team of database developers and interacted with bank departments throughout the world. Led a global anti-money laundering initiative for prepaid cards.

Implemented a global database file reorganization project for a twenty-one terabyte database footprint.

Designed a global database file I/O and database object file to monitor, trend and report growth. DATA SERVICES TEAM LEAD: OPEN SYSTEMS TECHNOLOGY, DATABASE CONSULTANT Developed the source control / release process and implemented a code review process while supervising seven on and offshore developers. Served as a technical lead on the Google Wallet BIN sponsorship project.

Assigned as the database lead for the Simple Money Transmission Service project for the United Kingdom government, Department of Work and Pensions; handled the database design, sizing estimates, SSIS packages, SSRS reports and invoicing process design and implementation.

Supported the full lifecycle of requirements, design and development of the Prepaid Data Warehouse project using: SSAS, SSIS, SSRS and Change Data Capture.

Developed the Flucare card billing process using SSIS and SSRS.

Assisting the DBA team in creating SQL Server 2008 database clusters, setting up database mirroring, log shipping and snapshots.

Configured and maintained Service Broker

Performance-tuning SQL and improving server and disk configurations, tempdb optimization and tuning a two- terabyte database for sub-second response by implementing logically established filegroups, filtered indexes and partition tables.

TECHNOLOGIES

SQL SERVER 2012, TFS, SVN, SSMS, SSIS, SSRS, SSAS, Profiler, Database Mirroring, T-SQL, Service Broker, Clustering, Change Data Capture, Table Partitioning, Visio, Microsoft Project H e n r y W N a y l o r I V P a g e III

AUDIT & COMPLIANCE SERVICES, INC. A XEROX COMPANY

INFORMATION TECHNOLOGY MANAGER / DATABASE ARCHITECT 4/2008 – 4/2011 Managed one SQL server database administrators, two SQL server database developers, two .NET developers, one SSRS report developer and one help desk person. Designed, developed and supported staff development of the AuditTrack 2.0 platform.

50% decrease in database footprint achieved by creating logical and physical designs of SQL Server 2005 databases.

Six million daily insert, update and delete transactions processed by designing and developing a dynamic data load process using SSIS, Service Broker and TSQL stored procedures operating for more than 60 different customers.

Implemented a reporting platform using SSIS and SSRS.

Customized and implemented a BugTacker.NET ticketing system.

Established strong and resourceful development and UAT environments and a software promotion process.

Defined backup and data retention policies.

Originated a quality assurance and data correction process to insure the accuracy of customer claims data.

Resolved application and database bottlenecks, tuning Windows servers for optimal performance as SQL server database servers.

30% increase in productivity and accuracy of internal review staff and new hire reduction attained by designing intranet applications that housed core applications including AuditReview 2.0. TECHNOLOGIES

SQL SERVER 2005/2008, TFS, Visual Studio, C#, ASP.Net, SSMS, SSIS, SSRS, Profiler, T-SQL, Service Broker CORPORATION SERVICE COMPANY

SENIOR / LEAD DATABASE ADMINISTRATOR 07/2006 – 04/2008 COMMERCE BANK

SENIOR DATABASE ADMINISTRATOR 11/2005 – 07/2006

AJILON CONSULTING

PRODUCTION DATABASE ADMINISTRATOR 05/2005 – 11/2005 VOLT DELTA RESOURCES/DATASERV

PRODUCTION DATABASE ADMINISTRATOR 05/2001 – 05/2005 SENIOR SOFTWARE ENGINEER

BIDTRAC.COM

LEAD SYSTEMS DEVELOPER 07/2000 – 05/2001

EPOTEC.COM

WEB DEVELOPER 01/2000 – 06/2000

GRACE TEMPLE CHRISTIAN ACADEMY

COMPUTER TEACHER 01/1998 – 01/2000

H e n r y W N a y l o r I V P a g e IV

V O L U N T E E R A C T I V I T I E S

SEEDS OF GREATNESS BIBLE CHURCH

o 40 – 49 Age Group Director (2017 – Present)

o Parking Lot Ministry (2010 – 2012)

o Children’s Ministry (2008 – 2010)

TEENSHARP

o Delaware Parents Group Coordinator (2016 – Present)

SANFORD SCHOOL

o Parents Ambassador (2016 – Present)

KINGSWOOD COMMUNITY CENTER

o Middle School C# Instructor (2016 – Present)

Delaware Rush Soccer Club

o U15 Boys Fundraising Coordinator (2013-2014)

Kirkwood Soccer Club

o Board of Directors (2011 – 2013)

o Academy Team Manager (2008 – 2012)

o Instructional Team Coach (2004 – 2008, 2012)

Delaware Hawks AAU Basketball Club

o Team Coach (2006 – 2008)

Victory Christian Fellowship

o Children’s Ministry (2000 – 2008)

Contact this candidate