Aston Smallwood
Duluth,GA
Summary
High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements. Equipped with strong problem-solving abilities, willingness to learn, and excellent communication skills. A result-oriented achiever with proven to exceed targets and drive success in fast-paced environments
Overview
10
10
years of professional experience
1
1
Certification
Work History
SQL Server Database Administrator
Mai Charity Foundation
01.2019 - Current
- Provision Databases, configure and install Always On High Availability Group with up to five replicas
- Producing high-standard database solutions to meet stability, reliability, and performance metrics
- Work with the migration of databases from one Windows Server and SQL Server instance to another
- Assist developers with complex query tuning and schema refinement
- Resolving SQL Server problems in conformance with SLAs.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Documented analysis results and provided performance improvement feedback.
- Developed custom database objects, stored procedures and delivered application support.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Supported projects enabling delivery efficiencies and technical resolution.
- Followed standard practices for migrating changes to test and production environments.
- Assisted in the development of data archiving strategies to maintain long-term storage efficiency while adhering to regulatory requirements.
- Ensured data integrity and security through the implementation of comprehensive backup and recovery plans.
- Optimized database performance by implementing index tuning strategies and query optimization techniques.
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
Database Administrator
Home Care of Atlanta Inc.
01.2016 - 01.2022
- Supported and troubleshot very large databases (VLDB) ranging from 500 GB to 17 TB
- Migrated SQL Server databases from 2008 R2 to 2012/2014, 2016 to 2017, and 2019
- Implemented Always-On HA and worked with concepts such as Delayed Durability, Data Compression.
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
- Built databases and table structures for web applications.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Enhanced reporting capabilities by designing efficient ETL processes that improved data accuracy and completeness.
- Modified databases to meet needs and goals determined during planning process.
- Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Set up and controlled user access levels across databases to protect important data.
- Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability.
- Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
- Increased efficiency in software development processes through effective collaboration with developers to design databases that support application requirements.
SQL Server Database Administrator
Andrew Holliday Law Group
01.2015 - 08.2018
- Worked in installing, configuring, managing, monitoring, and troubleshooting SQL Server 2005, 2008/R2, 2012, 2014 and 2016
- Engaged in RDBMS database design, development, performance tuning, optimization, backup, and recovery.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Supported projects enabling delivery efficiencies and technical resolution.
- Followed standard practices for migrating changes to test and production environments.
- Assisted in development of data archiving strategies to maintain long-term storage efficiency while adhering to regulatory requirements.
- Ensured data integrity and security through the implementation of comprehensive backup and recovery plans.
- Implemented database partitioning strategies, leading to improved query response times and overall system performance.
- Reviewed SQL code for optimization opportunities, leading to more efficient processing times across various applications.
- Developed custom scripts for automating routine tasks, increasing productivity, and reducing manual intervention.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
Education
MS in Homeland Security and Emergency Management -
Purdue Global University
Indianapolis, USA05.2022
Certificate - Database Management
TekyPro Online DBA Institute
Tennessee Ridge, TN04.2013
Bachelor of Science - Computer Science And Business Management
African Methodist Episcopal University
Monrovia, Liberia05.2010
Skills
- Extensive experience in configuring, implementing, and maintaining MS SQL Server HADR Solutions involving Always On, Mirroring, Replication Models [Transactional/Snapshot] and Log Shipping
- Experience in Backup and restore, Performance Tuning, Optimization, and Maintenance Job Scheduling
- Experience in supporting Very Large Databases (VLDBs) and Data Warehouse setups
- Involved in support and Management of Thousands of Databases and SQL Servers
- Support of MS SQL Server versions 2005/2008/2008R2/2012/2014/2016/2017 and 2019 in Production, Test, Development, Cluster, and Cloud Environments (Azure SQL Databases, Azure Virtual Machines, and Azure SQL Managed Instance)
- Implementation of SQL Security, Logins, Roles, and Permissions
- Experienced in Upgrade (Patches) and Migration of MS SQL Server from 2005/2008/2008R2/2012 to 2014/2016/2017/2019
- Good knowledge of Azure Cloud Technology and Migration of databases from on-premises to Azure Cloud and Migration Tools such as DMA & DMS
- Experience in working with SSIS, SSRS, Tableau, and PowerBi for Integration, Reporting, and Data Visualization
- Experience in setting up Encryption [Transparent Data Encryption TDE], Masking, and Always Encryption
- Azure SQL Data Warehouse, Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Microsoft Fabric, Cosmos DB, Event Hub, MariaDB, MySQL, Couchbase, MongoDB
- Excellent Analytical, Communication, and Interpersonal Skills
- Excellent Team Player and Motivator
- Experienced in setting up Maintenance Plans, Creating Jobs, and Automating Processes
- Knowledgeable in TSQL and PowerShell Scripting
- Experienced in creating Technical Documentation and process archiving and change
- Database Security, Capacity Planning, Data Modeling, Code debugging
- Data Security, ETL development, Customer Needs Assessment
- Root Cause Analysis, Implementing security measures, End-User Training
- Information Protection, Data Governance, New Product Testing
- Organizational Skills, Active Listening, Effective Communication
- Adaptability and Flexibility, Decision-Making, Relationship Building
- Task Prioritization, Self Motivation, Analytical Thinking, Goal Setting
- Attention to Detail, Multitasking Abilities, Reliability
- Organizational Skills, Active Listening, Adaptability and Flexibility
- Task Prioritization, Self Motivation, Goal Setting, Continuous Improvement
- Data Governance, New Product Testing, Teamwork and Collaboration
- Attention to Detail, Problem-solving abilities, Multitasking Abilities
Certification
- Microsoft Certified Solutions Associate (MSCA): SQL 2016 Database Administration
- Microsoft Certified: Azure Fundamentals
References
References available upon request
Timeline
SQL Server Database Administrator
Mai Charity Foundation
01.2019 - Current
Database Administrator
Home Care of Atlanta Inc.
01.2016 - 01.2022
SQL Server Database Administrator
Andrew Holliday Law Group
01.2015 - 08.2018
MS in Homeland Security and Emergency Management -
Purdue Global University
Certificate - Database Management
TekyPro Online DBA Institute
Bachelor of Science - Computer Science And Business Management
African Methodist Episcopal University
Similar Profiles
Aliaa MetaweeAliaa Metawee
Swasia Charity Foundation- Volunteer at Swasia Charity FoundationSwasia Charity Foundation- Volunteer at Swasia Charity Foundation
Taohidul IslamTaohidul Islam
Cleaner at Charity FoundationCleaner at Charity Foundation
Mardiya BawaMardiya Bawa
Founder at DIYA CHARITY FOUNDATIONFounder at DIYA CHARITY FOUNDATION