Sql Server Project Manager
Resume:
ARAMIDE AKINMOLA
Laurel MD, *****
******@*****.***
Work Authorization: U.S Citizen
AREAS OF EXPERTISE
8+ years’ experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server-2008/2008R2, 2012, 2014, 2016
Experience using Tableau to provide dashboards for reporting. Also Tableau for analyzing data and providing visual Dashboards
Experience in Disaster Recovery Planning, Execution and Testing at remote site
Experience in using SQL Server Tools like Import/Export Wizard, SQL Profiler and SQL Query Analyzer.
Configured and implemented High availability (Always-On) SQL Server solutions, including Replication Models (Snapshot/Transactional/merge)
Significant experience with SQL Server Management Studio, Microsoft Access/VBA
Cyber Security modelling and installations, firewalls, proxy servers and DMZ
Experience in E.T.L TOOLS (SSIS/SSRS)
Education
MCSA: Microsoft – 03/2016(Analytics & Business Intelligence)
PMP: PMI-12/2010
ITIL, v3: Axelos-10/2014
MBA: University of Port-Harcourt-09/2002
SECURITY+: CompTIA – 12/2011
OTHER SKILLS: Microsoft suite- Excel, PowerPoint, Project, Visio
Tableau
PROFESSIONAL EXPERIENCE
LIDL: 04/2015 - 08/2017
DBA/Lead
Microsoft SQL Server DBA with 8+ years of experience in design, Development and
Administration using MS SQL Server 2008, 2012, 2014, 2016 database on windows server
Extensively used SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/troubleshooting
Designed and implemented SSIS package to migrate data from multiple data sources
Develop, troubleshoot & optimize complex queries, stored procedures, and database scripts
Develop complex reports using SQL Server Reporting Services(SSRS) and visual dashboards using Tableau
Tuning and Optimization, troubleshoots and resolves database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, index management and statistics
Used SQL Indexes for improving query performance, lower storage and maintenance cost.
Experience in optimization tools such as SQL Profiler, cyber security configurations, windows
Performance Monitor, using virus scans and Datacenter controls
Creating SQL Server Logins, Groups, Users and assigning Roles and Authentication Modes as a part of Security Policies for various categories of user support
Team lead in maintenance configuring, architecture and managing SQL Server 2008/2012 and upgrading Service Packs for multiple instances.
Configured Application Databases and designed, modelled database for point of sale application
Analyzing Locks, Dead Locks using both Spotlight and DMVs and DMFs, and handling the isolation Level and Concurrency Effects
Project manager in installing Always On solution for high availability
Migrated data from heterogeneous data sources and Legacy system (DB2, Access, Excel) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints
Participated in creating Jobs for various packages that run at specific schedule every day using SQL Server agent, Proxies and other user accounts between domains.
Performed and coordinates installations, upgrades, and patches to Microsoft SQL RDBMS products and tools.
Participated in Disaster prevention and Recovery Strategies and supported High availability components,
E.g. Snapshot Replication, Clustering (Active/Passive) and Database Mirroring
Interact with SME's and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
Rite Aid: 06/2008 -04/2015
Database Administrator -MS SQL
Experience in Log Shipping from Primary to Standby servers and SQL maintenance plans.
Experience in systems configuration (Windows OS) to adhere to best practices for Microsoft SQL RDBMS platforms.
Experience involved in using tools like SQL profiler for Monitoring and Tuning MS SQL Server.
Experience in Normalization, Database design, Performance Analysis and Production Support
T-SQL queries and maintained SQL infrastructure using SQL Sentry, Quest SQL Performance Analyzer,
IDERA
Refresh the Production databases to DEV and QA environments for new releases.
Secured the database environment using various security measures e.g. encryption, user lists
Created Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications.
Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL
Server agent and monitoring and troubleshooting jobs, event notifications using Database Mail.
Extraction, Transformation and Loading (ETL Tools) data using DTS/SSIS Import/Export utility
Automate DBA activities to help ensure the high availability of the server
References: Available on request
Contact this candidate