Summary
Overview
Work History
Education
Skills
Websites
Certification
References
Core Skills
Timeline
Generic

Aston Smallwood

Duluth,USA

Summary

Resourceful professional in database management adept at maintaining high productivity and efficiency in task completion. Skilled in SQL optimization, database security protocols, and disaster recovery planning. Excel in problem-solving, teamwork, and adaptability, ensuring seamless database operations and support.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Senior Database Administrator

Mai Charity Foundation
Atlanta, GA
02.2020 - Current
  • Administer multi-platform database environments including SQL Server and MySQL across both Windows and Linux systems.
  • Implemented Azure SQL Database solutions, including automated deployments using Azure Data Factory and ARM templates.
  • Monitored system performance, identified potential bottlenecks, implemented solutions to improve efficiency.
  • Optimized existing queries to ensure maximum performance and scalability of the databases.
  • Maintained multiple versions of the same database while ensuring data consistency across them.
  • Designed and implemented disaster recovery plans in case of system failure or data corruption.
  • Developed scripts using T-SQL language to automate routine administrative tasks.
  • Implemented change management processes to ensure smooth transition between different stages of development life cycle.
  • Provided technical support for database users, troubleshooting issues as they arise.

Database Administrator

Home Care of Atlanta Inc.
Douglasville, GA
01.2016 - 01.2022
  • Managed SQL Server and MySQL databases hosted across hybrid environments (on-prem and Azure VMs).
  • Migrated legacy databases to Azure SQL Managed Instance, improving performance and reducing infrastructure cost.
  • Configured user accounts, privileges, roles, profiles. in the database server.
  • Installed, configured, and maintained Oracle 11g and 12c databases on Linux servers.
  • Resolved customer queries related to database issues promptly and accurately.
  • Tested application code changes before deploying them into production environment.

SQL Server DBA

Andrew Holliday Law Group
Atlanta, GA
02.2014 - 02.2016
  • Deployed and maintained SQL Server instances supporting critical legal data.
  • Led the database upgrade from SQL Server 2012 to 2016, including compatibility testing and user acceptance.
  • Configured user accounts, privileges, roles, profiles. in the database server.
  • Resolved customer queries related to database issues promptly and accurately.
  • Tested application code changes before deploying them into production environment.
  • Analyzed system logs regularly to identify any potential problems or suspicious activities.
  • Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
  • Ensured that all the stored procedures are optimized for better performance of the system.
  • Monitored performance of queries and tuned them as needed using Explain Plan tool.

Education

M.S. - Homeland Security & Emergency Management

Purdue Global University
Indianapolis, IN
05.2022

Certificate - Database Administration

Bade Tech
Nashville, TN
01.2012

B.S. - Computer Science & Business Management

African Methodist Episcopal University
Monrovia, Liberia
05.2010

Skills

  • SQL Server administration
  • MySQL administration
  • Azure SQL management
  • Disaster recovery
  • Database optimization
  • PowerShell automation
  • ETL processes
  • Performance tuning
  • Data security
  • Schema design
  • Technical documentation
  • Effective communication
  • Problem solving
  • Performance monitoring tools
  • Implementing security measures
  • Team leadership
  • Data migration techniques
  • Cross-platform database support

Certification

  • Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration
  • Microsoft Certified: Azure Fundamentals
  • CompTIA Linux+ (in progress or optional mention if applicable)

References

Available upon request.

Core Skills

SQL Server, MySQL, Azure SQL Database, PostgreSQL, Windows Server, Linux (Ubuntu, CentOS, RedHat), Microsoft Azure (VMs, Azure SQL, Data Factory), AWS RDS, Always On AG, Clustering, Replication, Log Shipping, Query optimization, Indexing, Execution Plans, PowerShell, Bash, T-SQL, Python, SSIS, SSRS, Power BI, Role-based access, TDE, GDPR, HIPAA, Ansible, Bitbucket, Jenkins, Git

Timeline

Senior Database Administrator

Mai Charity Foundation
02.2020 - Current

Database Administrator

Home Care of Atlanta Inc.
01.2016 - 01.2022

SQL Server DBA

Andrew Holliday Law Group
02.2014 - 02.2016

M.S. - Homeland Security & Emergency Management

Purdue Global University

Certificate - Database Administration

Bade Tech

B.S. - Computer Science & Business Management

African Methodist Episcopal University
Aston Smallwood