| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLE PHONE NUMBER AVAILABLELinkedIn GA, USDatabase AdministratorDynamic 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 ExpertiseData Warehouse ManagementSQL Query OptimizationAzure ImplementationServer MonitoringData ModelingDisaster Recovery PlanningETL DevelopmentAuditingSecurity ManagementTeam Building & LeadershipCross-Functional CollaborationVirtual Server MigrationsTechnical SkillsSQL 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 NetezzaCareer ExperienceNational Vision Inc. Atlanta, GA Sept 2016 Dec 2023Senior Database Administrator/ArchitectSpearheaded 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 2016Database Administrator/BI/DeveloperDeployed 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 2015Engineered 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 2015Database Administrator/BI/DeveloperManaged 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 ExperienceStaff Sergeant, United States Air Force Retired 21 yearsAffiliationsMember of PASSMember of PASS Atlanta BI |
