Database Administrator Sql Server

David M. Keyes

********@*******.*** • 770-***-****

LinkedIn • GA, US

Database Administrator

Dynamic and results-driven Database Administrator with extensive experience in spearheading transformative database initiatives.

Seasoned in orchestrating comprehensive rebuilds and implementing cutting-edge technologies to optimize system performance. Proficient in pioneering innovative solutions and collaborating with cross-functional teams to drive operational excellence. Skilled in managing database availability, security, and performance across diverse environments. Experienced in deploying SQL Server and establishing replication mechanisms for seamless data synchronization. Adept at crafting robust ETL processes and developing intricate stored procedures to streamline operations and enhance efficiency.

Areas of Expertise

Data Warehouse Management

SQL Query Optimization

Azure Implementation

Server Monitoring

Data Modeling

Disaster Recovery Planning

ETL Development

Auditing

Security Management

Team Building & Leadership

Cross-Functional Collaboration

Virtual Server Migrations

Technical Skills

SQL Server TSQL Idera Diagnostic Manager Red Gate Monitor Data Compare Schema Compare SVN Microsoft Office Suite General Microsoft Network Administration/Security Microsoft Active Directory Microsoft PowerShell IBM Netezza

Career Experience

National Vision Inc. Atlanta, GA Sept 2016 – Dec 2023

Senior Database Administrator/Architect

Spearheaded comprehensive rebuilds for production and development environments, ensuring dedicated disaster recovery solutions, while pioneering Azure database implementation. Orchestrated Always Available Group (AAG) deployment across clustered servers, collaborating with programmers to establish Listeners, and partnered with IBM to establish and maintain Netezza environments for data warehousing. Collaborated with Consulting DBAs to maintain databases, optimize stored procedures, and engineer Active Directory permissions for seamless database access. Acted as primary liaison for auditors, addressing SQL inquiries, providing verifications, and leveraging Microsoft PowerShell for auditing information extraction. Led Soler Wind integration for comprehensive server monitoring and managed Idera Diagnostic Manager for vigilant server monitoring across dual data centers. Collaborated with server administrators for seamless virtual server migrations, navigating space constraints.

Transformed database environments by designing and implementing cutting-edge technologies, optimizing performance and enhancing system capabilities.

Fidelity bank Atlanta, GA August 2015 – September 2016

Database Administrator/BI/Developer

Deployed SQL Server Enterprise 2008 R2 across seven production environments, meticulously managing security and permissions, while facilitating hardware installation and testing in a VMware virtual environment and EqualLogic SAN to ensure peak performance. Conceptualized and executed the data warehouse model, utilizing SSIS for efficient ETL processes, and established Merge Replication across a dispersed seven-server topology to ensure seamless data synchronization. Implemented a Central Management Server to streamline operations across all nodes, enhancing efficiency, and installed and configured the Red Gate tool belt for robust performance monitoring on all production servers. Developed numerous SSRS reports, providing actionable insights to stakeholders, and crafted comprehensive test scripts to ensure software reliability and functionality. Oversaw database availability and performance for all servers, proactively addressing issues.

Achieved efficient customer query resolution and enhanced rebate and promotion tracking through proficient utilization of SQL, T-SQL, Access 2000, and AS-400 language.

Working General Contractor, Feb 2015 – Aug 2015

Engineered database stored procedures to efficiently calculate data within SQL, optimizing report generation processes. Spearheaded the implementation of a robust backup and recovery system for the company, including log shipping to maintain a warm standby, ensuring data integrity and business continuity.

Developed an SSIS package to seamlessly import and generate reports from a FoxPro database into SQL, establishing and managing large tables for enhanced data analysis.

Generation Mortgage Atlanta, GA Aug 2012-Jan 2015

Database Administrator/BI/Developer

Managed database availability, performance, and security, optimizing operations and orchestrating company-wide server redesigns. Implemented Merge Replication across multiple servers at Generation Mortgage, ensuring mirrored replication for data consistency. Developed over 600 stored procedures to monitor usage and streamline application development processes. Devised triggers and procedures to capture historical changes to user accounts, enhancing data tracking and integrity. Crafted test scripts to meticulously scrub data for application developers, ensuring accuracy within development environments, while ensuring continuous database availability and performance optimization.

Headed the development of multiple SSIS packages, facilitating efficient data gathering for accounting and metadata application across Development and Production servers.

Led the modeling of the data warehouse and executed ETL processes with SSIS, significantly enhancing data profiling, staging, and processing for the data warehouse (DW) and cube.

Additional Experience

Staff Sergeant, United States Air Force Retired 21 years

Affiliations

Member of PASS

Member of PASS Atlanta BI

Contact this candidate