Derrick Walker

** ****** ***** · Stafford, VA ***56

Cell: 703-***-****

E-mail: adxyk4@r.postjobfree.com

SUMMARY OF QUALIFICATIONS:

Innovative, results-driven leader with more than 25 years of experience working in his field managing projects and designing application software that perform. Provide leadership and supervision in the areas of databases, application development, change/configuration management and information assurance. Demonstrate exceptional oral and written communication skills. Experienced in Enterprise development and architecture, administration, troubleshooting and the maintenance of SQL Server.

COMPUTER SKILLS

Languages: VB.NET, T-SQL, PowerShell, and VBScript

Database: MS SQL Server 6.5 – 2022 and Microsoft Azure

Skills: Microsoft Azure, Windows\SQL Clustering (FCI), AlwaysOn, Visual Studio .NET 2022, Performance Monitor, Query Execution and Analysis, SQL Server Reporting Services (SSRS), and SSIS

Operating Systems: Windows Server 2003 – Windows Server 2022

PROFESSIONAL EXPERIENCE:

Envizion Technology \ Aveshka, Inc.

April 2008 – Present

Senior SQL Server Database Administrator

Manage SQL Server farm of over 300 SQL Servers.

Implement High Availability across Log Shipping, Availability Groups / AlwaysOn, and SQL FCI / Windows Clustering.

Install, configure and maintain the server infrastructure which supports over 100 applications across 14 teams.

Proactively monitor and troubleshoot server and SQL-related bottlenecks such as CPU, memory, I/O, disk space, and other resource limitations.

Troubleshoot and resolve query performance, server performance, connectivity, and security-related issues to provide root cause analysis.

Design database structure to support large data inputs and performance strategies.

Troubleshoot Windows Server performance bottlenecks and Windows Administration.

Create Logical and Physical data models that support business needs for growth.

Migrate databases to AWS/RDS and EC2 instances.

Write and modify stored procedures, views, and various database objects as needed to support business functionality.

Manage storage allocation, file placement and growth projections.

Develop and Implement Disaster/Recovery strategies to include offsite mock disasters. Design strategies to aid in migrations to other systems on Prem as well as in the cloud to ensure production continuity.

Support ongoing database deployments and migrations from lower versions to include SQL Server 2008 to SQL 2022.

Design and build automation tools for server provisioning, administration, quality assurance, up-to-the-minute ETL, capacity planning, and data prototyping to auto predict outages and performance degradations.

Manage and track server performance metrics, resource utilization, and errors that take place in the environment for analysis.

Create Azure resource groups and databases.

Collaborate with internal stakeholders, data engineers, and capacity planning teams across the enterprise to develop specialized tools for data statistics delivery and recovery.

Participate in the full Software Development Life Cycle (SDLC), and systems design to achieve the most architecturally sound strategy possible.

Provide critical key-role feedback to the executive leadership on strategies to implement SQL Server in various multi-layered solutions supporting over 100 applications.

Develop partnerships with other teams to gain insight on best practices for integrating security programs across directorates and networks.

Visionary Integration Professionals

April 2006 – April 2008

Database Operations Lead

Managed Operations Division for 10+ TB SQL Server Databases as well as several Lotus Notes databases. The primary goal is to ensure that the system is properly functioning 24/7 365 days per year with a 99.97% uptime.

Monitored and enhanced, as needed, the database system and architecture to achieve higher levels of availability and recoverability including index and query optimization.

Managed the database infrastructure both logical and physical as well as the database programmability. As part of this role, I consult with other project development teams to ensure that best practices are being met with designs and coding structures.

Monitored system functionality and performance as it relates to system workload, application use, and performance which gives us the ability to obtain trend analysis with various groupings at multiple layers of each system.

Created and implemented stored procedures, triggers, and other SQL objects and batches as needed to support the incumbent application and its users.

Design, develop and implement automated toolsets required to support project and customer needs.

Created and deployed custom web and thick-client tools to Reporting and Web Servers.

Designed the system’s architecture regarding the workflow, scope, development tools, platforms, software/hardware, requirements data, presentation layers, and required custom components.

Developed and executed the business strategy and business plan to support the desired solution offering of the Federal Air Marshall Service.

Designed the logical and physical database infrastructure for optimized disk utilization and query performance.

Implemented best practice standards for database and SQL objects such as indexes, views, stored procedures, and disk layout

Designed and deployed custom data Extraction, Transformation, and Load procedures and code via Integration Services.

Designed interface mockups and facilitated the overall flow of the UI design process including custom graphics and user experience as well as providing a critical review of various team layouts.

Oversee the daily disaster recovery processes, batch jobs and replications are being maintained properly and consistently.

Idea Integration

October 2005 – April 2006

Team Lead / Database Administrator

Designed database infrastructure, logical and physical including file placement, sizing, and number as well as hard disk arrays.

Create stored procedures, triggers, views, functions, and various other SQL objects and batches to support system design, functionality, and development team.

Interface with client PM to discuss data requirements.

Setup, configure and support SQL Server Reporting Services and SQL Server Integration Services for use with custom reports and ETL processes for data migration and validation.

Created and deployed custom web-based reports to Reporting and Web Servers.

Design and implement daily disaster recovery processes and batch jobs which include database performance and/or tuning problems such as query design, index, and hard disk fragmentation as well as data replication.

Produce upgrade strategy for SQL Server 2005 platform including object redesigns such as Query, Procedure, Integration Services / DTS packages, and Reporting Services.

Designed and oversee system implementations to port databases and applications to various client labs and other hosted environments. This was automated via custom ActiveX components.

Oversee daily Log Shipping jobs on servers.

Provided technical support and documentation to Senior Management for best practices, and hardware/software requirements as well to the client team.

Provided project oversight and new directions of target industry to clients and other external providers and partners.

Accenture Technology Solutions

December 2003 – October 2005

Team Lead - Database Administrator

Design, implement, and maintain system architectures for development, staging, test, and production environments.

Manage the design of data models and physical database implementations for various support projects.

Verify and resolve project, data, and development constraints in conjunction with development timeline issues.

Manage daily disaster recovery processes and batch jobs which include database performance and/or tuning problems.

Ensure all issues concerning security, upgrades, and patches or hotfixes to SQL Server, Web-App Server, and Enterprise Server are performed when needed.

Design, develop and maintain business processes and associated objects, procedures, triggers, and code.

Supervise daily processing of automation and maintenance tasks of Windows 2000/2003 Servers and XP Workstation, IIS 6, and multiple installations of SQL Server.

Provide both coaching and guidance to junior team members and internal staff to ensure company success, as well as to make certain that employee morale and career aspirations are being met.

Our Kids Inc.

September 2002 – December 2003

Database Administrator

Design and develop system architecture, security, and integrity.

Implement data models and database designs, data access and entity maintenance plans and jobs.

Resolve database performance, indexing issues and capacity matters.

Implement backup, recovery, and database maintenance procedures.

Design disaster recovery, space management and system capacity plans

Oversee daily progress including installation, tools, import/export, automations, maintenance, tuning, reporting and security issues.

Install and administer Windows 2000 Server/Workstation, IIS Server 5, and SQL Server database environments.

KRA, National Institute of Health

May 1999 – March 2003

Database Administrator/SQL Programmer

Defined database performance issues

Support MS SQL 6.5, 7, and 2000 database migration into production and development environments.

Administer MS SQL 6.5, 7, and 2000 databases, such as defining new databases, ensuring system-level security, monitoring and managing database activities, as well as supporting database sizing and indexing.

Install and maintain Windows NT/2000, MS SQL, and other system software upgrades, patches, and hot fixes.

Monitor progress and completion of nightly batch jobs.

Create stored procedures, triggers, views, and rules as needed.

Respond to and correct problems on Windows NT/2000 servers and MS SQL databases on an ongoing basis.

Coordinate completion of vendor hardware/software maintenance activities.

Support developers in an application DBA capacity as well ASP Web Developer.

Develop Custom Software Administration Tool utilizing VB Scripting, ADO, and HTML technologies.

Analytic Services, Inc.

February 1998 - May 1999

Database Administrator /Systems Administrator

Provided SCATS Administration and was a technical liaison for current database system supported by SQL Server 6.5.

Defined backup and recovery planning and execution.

Responsible for client/server support on an NT Domain of 2300 users.

Administered domain backups, printer rebuilds, PC rebuilds and installs and client configuration and upgrades as well as database dumps and loads, query tuning, and user management.

Maintained overall user security and data integrity and managed the operating system and applications.

Installed and performed maintenance of computers and network devices managing network services and file system.

Military Service:

US Coast Guard

September 1991 - February 1998

Access Developer

Functioned as the Microsoft Access programmer and designer for the Freedom of Information Act system.

Design, develop and support the maintenance of the database.

Provided management of software support and evaluated training needs for user the community as well as product testing for Network and PCs.

Education:

Northern Virginia Community College

Information Systems Management – Northern Virginia Community College

Reference upon request

Contact this candidate