Summary
Overview
Work History
Education
Skills
Area Of Expertise
Professional Memberships
Timeline
Generic

Aminu Alao

Atlanta,GA

Summary

Experienced professional with over 10years in MS-SQL DBA and Windows Server, and 3+ years in MS Azure Cloud Architecture, administration, and migrations across diverse industries. Managed 2,500+ MS SQL instances, 4,000 databases, and a VLD of 21TB within hybrid environments. Holds certifications including Microsoft Certified IT Professional Database Administrator (SQLDBA 2012) and Microsoft Certified Technology Specialist – MS SQL 2012. Proficient in data migration, performance tuning, backup and recovery, security management, upgrades, SSIS, SSRS, and SQL Server patches. Demonstrates strong leadership, collaboration, and problem-solving skills, with a commitment to continuous learning. Adaptable team player with excellent communication and negotiation abilities, capable of meeting project deadlines and budgetary requirements in fast-paced environments.

Overview

11
11
years of professional experience

Work History

MS-SQL DBA

U.S. Bancorp, (Contract – Savient Systems)
Minneapolis, MN
05.2021 - Current
  • Designing High Availability Strategy and Disaster recovery using AlwaysOn
  • Modernize existing applications with Azure SQL Managed Instance
  • Migrating existing SQL Server instances to Azure SQL or provision a new Azure SQL database
  • Backup and restore Azure SQL databases
  • Monitor and optimize the performance of cloud database to meet the strategic goal of the business
  • Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers
  • Promoting query tuning through schema refinement
  • Provide development and design assistance to development and other application support teams
  • Provide technical leadership to development team through project leadership and technical documentation and outage management
  • Promote data standards, system procedures and security policies, and best practices, e.g
  • Dev/UAT/Prod environments and QA & release control
  • Facilitate the readiness and availability of all database repositories
  • Establishes and builds strong working relations and partnerships with Business Units and senior management
  • Provides database assistance and problem support to application developers, business analysts and business users
  • Maintained periodic database growth rate and performance statistics to support a proactive database management culture
  • Using Query store and scripts to find the most expensive queries for CPU, I/O, Memory and obtain full history of query executions
  • In addition, quickly find performance regression and fixing it by forcing the previous query plan whose performances are much better than a newly generated plan Conducted SQL Server production database analysis on a regular basis
  • Help developers improve the performance of query by tweaking it or modifying indexes in TSQL
  • Removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes
  • Rebuilding the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance
  • Provide 24/7 SQL Server Database Support and on call rotation
  • Worked with network, storage, server, and application technologies
  • Provides support in capacity planning, forecasting and evaluation reports
  • Also analyzed execution plans and generate suggestions for improvement
  • Managed Security using SQL Logins, Roles and Security Modes for various users including permission
  • And auditing, penetration and vulnerability tests, and restricting SQL access
  • Ability to develop/employ tools that proactively identify database performance issues and bottlenecks.

MS-SQL DBA

Galen College of Nursing
Louisville, KY
02.2016 - 03.2021
  • Ensured all code changes made in production environment are compliant before they get deployed through CR
  • Installed, designed, implemented, upgraded, and optimized database performance required to operate software solutions
  • Managed and monitoring SLAs for uptime and performance of SQL Server databases
  • Provided ad-hoc support service to users of all computer systems, troubleshoot and resolved database problem
  • Ensured that detailed physical design of database and data structures comply with data policies, standards, principles, and met established level of service agreements/goals for our system
  • Proactively monitored database systems to ensure secure services with minimum downtime
  • Participated in process of ensuring that identified Business Continuity measures are implemented, documented and regularly tested to enable continue operations of systems identified as requiring such protection in accordance with corporate Disaster Recovery program
  • Setup and managed distributed availability groups across regions Utilized “Partially contained database” feature of SQL server 2012 to ease migration and database refreshes for clients
  • Established escalation policies for database team
  • Used Jenkins, GIT, Chocolatey in managing deployments
  • Experience using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA)
  • Rebuild, Monitored indexes at regular intervals for better performance
  • Provided 24/7 on call support as needed
  • Implemented DBA maintenance plan for MS SQL-Server (DBCC, updating index statistics, monitoring database)
  • Monitored multiple servers for resource utilization (disk space, memory, CPU, etc)
  • Standardized processes installations, migrations, upgrades, backups, restores, index maintenance, etc
  • Set up and administered SQL Server Database Security environments using Profiles, database Privileges and Roles
  • Revised and improved current DR and HA strategies, thereby reducing downtime during failure
  • Performed frequent health checks for all backups and productions (mission-critical) databases
  • Created and analyzed daily reports for mission-critical databases
  • Involved in System database migrations and maintenance
  • Monitor disk space, transaction log growth, CPU E.T.C
  • Design, develop and implement database tables, views, triggers, indexes, and stored procedures to ensure data integrity for custom applications
  • Maintained all environments (prod, uat, test, training and dev)
  • Set up and managed replication, mirroring and log shipping
  • Supported applications by troubleshooting, diagnosing, and resolving database issues
  • Established escalation policies for database team
  • Managed Backup, Restore and managed Scheduled jobs
  • Installed, configured, monitored and maintained databases in the production, development, and quality assurance environments.

SENIOR SQL DBA/ARCHITECT

Whole Foods Market
Austin, TX
02.2013 - 01.2016
  • Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery
  • Designed, developed, tested, documented, and implement scripts to automate data importing, exporting, reporting, and analysis to ensure data confidentiality, availability and integrity
  • Designed and implemented TSQL queries for reporting and complex solution development
  • Performed scheduled maintenance and support release deployment activities after hours
  • Implement DBA maintenance plan for MS SQL-Server (DBCC, updating index statistics, monitoring database)
  • Administered sql server versions ranging from sql server 2008 through sql server 2019 in windows environment
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision
  • Designed high level database security systems to manage and protect access to PI data with different authentication systems
  • Provided 24x7 supports for critical production systems
  • Implement SQL migrations from on-perm servers to AWS RDS instances
  • Support applications by troubleshooting, diagnosing, and resolving database issues
  • Create and manage the automation of database tasks and administrative functions
  • Produced high-standard database solutions to meet stability, reliability and performance metrics
  • Responsible for importing and exporting data to and from SQL Server using Import/Export Wizard, BCP, BULK INSERT, OPENROWSET and SSIS
  • Monitored multiple servers for resource utilization (disk space, memory, CPU, etc.)
  • Standardized processes for installations, migrations, upgrades, backups, restores, index maintenance, etc
  • Configures and upgrades database software
  • Build and maintain strong working relationships with other DBAs and application teams
  • Developed custom database objects, stored procedures and delivered application support
  • Developed and maintained solutions using SSIS, specifically ETL operations
  • Enforce and document the database policies.

Education

B.Sc. - Business Administration

Ambros Ali University
01.2005

Diplomat - Business Management

University of Jos
01.2001

Skills

  • Data Migration (on-prem/Cloud)
  • AlwaysON High Availability
  • HA/DR Strategy
  • SQL Server Builds
  • Complex StoredProcs
  • Azure SQL/Cloud
  • Database Performance Tuning
  • T-SQL/StoredProcs
  • SSRS, SSIS & SSAS (ETL)
  • Failover Clustering
  • SQL Server Patches
  • ADF (CI/CD Pipelines)
  • Backup and Restores Mgt
  • Database Security Mgt
  • Database Monitoring
  • Code reviews/Deployments
  • DevOps/Agility
  • Automations
  • PowerShell
  • AWS & Azure Cloud
  • Migration (DMA, BacPac, DacPac, az-copy)

Area Of Expertise

  • Manage the production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity on SQL Server 2008 R2, 2012 and SQL Server 2014.
  • Use SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
  • Tables partitioning, file and file-group management, Knowledge of High Availability of database servers using Database mirroring, replications, and Log Shipping.
  • Design and implement 2005, 2008 R2, 2012, 2014, MS 2016, 2017 and 2019 databases for mission-critical business.
  • Strong experience in Database Administration in SQL Server.
  • Experience in Monitoring and optimizing the performance of cloud databases.
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
  • Configuring and setting up windows Server Failover Clustering environment.
  • Strong experience in Installations, Migrations and Decom of SQL Servers on Linux, Cloud and On premise.
  • Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication in Azure Cloud and on-premises.
  • Experience in ticketing tools like BMC Remedy, Service Now, JIRA and HP Service Management.
  • Experienced in SQL Server Native tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs).
  • SQL Development - ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints).
  • Develop and modify stored procedures, queries, triggers, views, indexes, and functions to handle business rules, history data and audit analysis.
  • Use Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tools of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
  • Configure and support SSIS and SSRS for 2005, SQL Server 2008 R2, SQL Server 2012, 2014and SQL Server 2016.
  • Experienced in working with end users to define, implement, and maintain their reporting requirements.
  • Experienced in the design, coding, testing and implementation of high volume transactional (OLTP) SQL databases instances.
  • Generate the weekly, monthly, and quarterly report by using SQL Standard Report.
  • Proven ability to work with software engineering teams and understand complex development systems, environments and patterns.
  • Experience presenting to high level executives (VP’s, C Suite).
  • Experienced with monitoring and troubleshooting in 24x7 operations.

Professional Memberships

  • Project Management Institute (Madrid, Spain)
  • Project Management Institute (Atlanta Chapter)
  • Nigerian Institute of Management

Timeline

MS-SQL DBA

U.S. Bancorp, (Contract – Savient Systems)
05.2021 - Current

MS-SQL DBA

Galen College of Nursing
02.2016 - 03.2021

SENIOR SQL DBA/ARCHITECT

Whole Foods Market
02.2013 - 01.2016

B.Sc. - Business Administration

Ambros Ali University

Diplomat - Business Management

University of Jos

Similar Profiles

CREATE PROFILE
Aminu Alao