Sql Server C#

Craig Williams

*******@*****.*** • 303-***-**** • https://www.linkedin.com/in/craig-williams-3190977

With over 20 years professional experience in designing, developing, supporting, analyzing, troubleshooting and managing databases and database applications for a variety of industries including finance, technology and marketing; I have proven experience in delivering high-available solutions to complex business needs.

A goal-oriented, self-motivator willing to balance risks with rewards to maximize growth potential who thrives on new challenges as an opportunity to expand my skills and build team cohesion.

Technical Experience

• Windows Server: Versions: 4.0 - 2019 • FTP, SFTP, PGP, HTTP, HTTPS

• SQL Server: Versions: 2008 - 2022 • PowerShell, JSON, C#, VB.NET

• SQL Server Reporting Services (SSRS) • IIS: Versions: 6.0 - 10 (SSL, TLS Crypto, HYPER-V)

• SQL Server Integration Services (SSIS) • Jenkins, Octopus, Artifactory (CI/CD), GitHub, TFS

• Database Performance Tuning • Windows Team Foundation Server

• T-SQL, SQL ETL, DTS • ITSM-ServiceNow, CyberArk, Splunk

Employment History

Truist Bank (Contract) Denver, CO

Principal SQL Server DBA 10/2021- Present

• Primary support for all PROD & Non-PROD SQL Servers hosting over 400+ instances with multiple

SQL Server versions from 2012 to 2020, 2022

• Responsible for reducing SQL Server licensing from 64 cores with Enterprise Edition to 32 cores

currently, and 24 cores in the following few months, resulting in reduced licensing costs of

over $250k

• Prepare on SQL Server on-premises servers for AWS cloud services migration

• Implement AWS stack setup and support– S3, Glue, EC2 & RDS

• Transform current legacy ETL processes to modern SSIS versions for scalable data pipelines

• Execute database replication and load-balancing procedures, achieving high

availability and disaster recovery objectives, and ensuring 99.98% uptime

• Responsible for the roll-out a robust backup and recovery strategy using Rubrik that reduced

data loss risk by 90%

• Troubleshoot performance issues configuring Extended Events, SQL Profiler and Execution Plans

• Revamped the indexing strategy for the company's main SQL databases, reducing read/write performance

• Perform SQL Server backup and restore tasks and troubleshooting

• Setup and configure SSL certificate processes for secure SQL Server connections

• Support and administer all aspects of SSRS in all environments from scale out to configuring security

• Responsible for database change control review prior to promoting to PROD

• Develop, maintain, and automate SQL backup and recovery plans

• Configure Always-on, Mirroring, Log Shipping, Replication & Clustering

• Configure TDE on PROD SQL Servers, certs, private keys and deploy to non-PROD environments for restores

• Provide database design recommendations, development, implementation, and methodologies for

Data warehouses & OLTP business systems

• Migrate, scale-out & support SSRS in PROD and non-PROD environments

• Build & re-engineer SSIS packages from On-premises to coexist in AWS infrastructure

• Design ETL (SSIS) processes for extracting, cleaning, transforming, & loading data into target tables

• Extensively use SSIS transformations such as Script component, Pivot/Unpivot, Multicast, Derived column,

Data conversion, Row count & Send Mail task etc.

• Perform SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS

packages using checkpoints & scripting with VB.NET in SSIS

• Develop SSIS ETL processes from internal & external data resources to existing DataMarts

• Responsible for the overall strategic direction of the data engineering technology stack

• Routinely perform Performance Tuning and Optimization (PTO) of SQL Server databases, using

native monitoring and troubleshooting tools

• Support enterprise networking such as DNS, TCP/IP, FTP, DMZ, Active Directory, SSL/TLS

• Perform monthly and semi-annual access validations on SOX and non-SOX

business applications

Allstate Jacksonville, FL

SQL Server DBA 07/2004 - 10/2021

• Configure & support Always-On high-availability protection with numerous SQL Server 2012 to 2019 nodes

• Responsible for migrating all PROD and Non-Prod SQL Servers 2012 to SQL Server 2019

• Perform backup & recovery as needed for all production & non-PROD environments

• Developed numerous automated processes via SSIS and other scripting

• Took charge in Installation, Upgrade, Configuration and Migration of MS SQL Server in clustered and

non-clustered production environments

• Regularly ensure the integrity of full, incremental & differential backups in all environments on daily basis

• Monitor & ensure SQL jobs complete, troubleshoot, & address failures in a timely manner

• Extensive knowledge of execution plans, statistics, & reading plan diagram

• Have advanced knowledge of T-SQL and/or ANSI SQL, ETL and Data Warehousing

• Create source to target mappings and ETL design for integration of new/modified data streams into the

data warehouse/DataMarts

• Responsible for setting up & implementing CI/CD for code promotions via Jenkins, Octopus & Artifactory

• Perform SQL production SDLC changes both developers & DBA develop while remaining SOX compliant

• Implement Transparent Data Encryption (TDE) for sensitive data protection

• Solid understanding in SQL high availability technologies, including clustering, replication, mirroring

• Create, maintain & optimizing database objects such as indexes, triggers, views, stored procedures & catalogs

• Designed & support various SQL Server versioning using CLUSTER Active/Passive including database schema

• Designed, optimization, SQL Development, failover, XML, meta-data

• Troubleshoot & correct firewall issues relating to SQL Server communications from MPN to DMZ

• Performed SQL Server 2005 migration to SQL Server 2008 & SQL Server 2008 to SQL Server 2012

• Review SQL code by developers & BI teams to ensure they’re adhering to DBA best practices & procedures

• Participate in periodic HA / DR exercises & other activities during off-hours

• Convert business requirements to system design

Florida Blue Jacksonville, FL

SQL Server DBA/Systems Engineer 11/2001 - 07/2004

• Responsible for SQL Server datacenter migration & automated dataflow to new financial partners

• Provided SQL Server 2000 administration & backup recovery over 40 database clusters across

multiple datacenters

• Performed & validated integrity of all system backups for disaster recovery testing

• Performed server monitoring & maintenance for high visibility database applications

• Responsible for testing & implementing code in DTS & SQL

• Responsible for understanding the architectural & detailed design aspects of client & vendor application

• Assisted in Design of R&D environments for product testing prior to rolling-out to production environment

• Assisted needs, troubleshooting &/or escalating problems to management

• Performed extra/off hours support as the service needs dictate

• Technical group lead for application implementations & support, for all client server hardware/software

• Maintain & upgrade databases to provide stable & optimal database environment

• Organize & maintain version, script & data control for mission critical databases

• Responsible for providing RAID & replication strategies for disaster recovery & failsafe solutions

• Responsible for system configuration, maintenance, backups, & maintaining server health for 25 SQL servers

• Second line of support for 5 other SQL servers with various databases & applications

• Thoroughly test patches, service packs, & 3rd party tools such as Seagate BackUp Exec

• Responsible for security & administration of IIS WLBS clustered web servers

• Implemented SSL on IIS server for customer insurance enrollment website, containing credit card data

Automatic Data Processing (ADP) Jacksonville, FL

SQL Server DBA 07/1999 -11/2001

• Traveled nationwide implementing & supporting Oracle 7.3.4, Oracle8i, SQL Server 6.5, 7.0, & 2000

for time and attendance database backend

• Responsible for rigorous database upgrade testing, before rolling out to client production environments

• Instrumental in working as a team with other DBA’s, developing stored procedures & other

related database structures for product enhancement

• Performed Oracle & SQL Server database implementations in multi-Citrix Metaframe 1.8 Server

Farms via LAN/WAN local/global domain

• Upgrades include version SQL Server 6.5 to 7.0, & 7.0 to 2000

• Responsible for implementation & support with IIS 4.0, 5.0 clustered web servers hosting

enhanced time & attendance applications

• Database consultant for application rewrites & product upgrades

Education/Certifications:

Sullivan College

Major: Computer Science

Florida State College of Jacksonville

Major: Computer Science

Microsoft Certified Systems Engineer (MCP) ID # 1255118

Citrix Certified Administrator (CCA)

Contact this candidate