Victor Adekola
Dallas,TX
Summary
High-performing SQL SERVER DBA with Seven (7) years of progressive experience. A proactive professional with extensive experience administering and provisioning SQL Servers 2008, 2012, 2014, 2016, 2017 and 2019 in Production, Test and Stage Environments. Critical thinker, analyst, problem solver and agile team player with excellent communication and troubleshooting skills who can successfully manage multiple priorities while performing well under pressure. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
8
8
years of professional experience
Work History
SQL Server Database Administrator
PlusEight Designs LLC
04.2019 - Current
- Implemented SQL Login Roles, and Authentication Modes as a part of security policies for various categories of users.
- Worked with the front-end developers to deploy reports.
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
- Used third-party tools such as SQL Profiler to analyze performance issues, Database Tuning Advisor for baseline synthesis, performance monitor for resource evaluation , and gathered information about the SQL environment using Database Management Views (DMV).
- Provisioned Databases and configured appropriate HA/DR strategy based on the RTO/RPO of the Business Division.
- Implemented Always-on Availability Group as a High Availability solution on SQL Server 2016.
- Developed scripts and processes for data integration and maintenance.
- Created and updated database designs and data models.
- Created and deployed Tables, Indexes, Constraints, Views, Stored Procedures, Functions and Triggers.
- Managed and troubleshoot SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019, Azure SQL
- Migrated and Upgraded SQL server from Legacy to 2016, 2017, & 2019 and Azure.
- Supported Reporting Servers (SSRS), Integration Services (SSIS), and Analysis Services (SSAS).
- Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
- Monitored regular backup and maintenance tasks for over 150 databases.
- 24 X 7 Production Database On-Call Support.
- Designed and implemented complex TSQL queries using Stored procedures, Functions and Views.
- Documented analysis results and provided performance improvement feedback.
SQL Server Database Administrator
Lydia Painting LLC
02.2017 - 03.2019
- Defined database security and enabled data distribution to appropriate users.
- Applied new patches and versions as required with minimal downtime.
- Migrated data between database environments (development, test, production).
- Configured, maintained, and troubleshoot Log shipping, Mirroring, Always On Availability Groups, Replication, SQL Server Failover Cluster on same and multiple subnets.
- Installed and configured SQL Server 2008 and 2012 on Windows server 2008.
- Exported and imported data from text files and Excel to SQL Server using Bulk Insert and BCP utility.
- Worked with development team to optimize schema and performance.
- Responsible for installing SQL Server and upgrading existing SQL Server and ensuring the success of the upgrade.
- Performed Database Refresh tasks from production to Development servers.
- Documented analysis results and provided performance improvement feedback.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment.
- Used Import/Export Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel, and many other data sources supports ODBC, OLE DB Data Sources.
- Managed multi-terabyte production of both STANDBY and CLUSTERED systems using ACTIVE-PASSIVE Clustering.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Supported Reporting Servers (SSRS), Integration Services (SSIS), and Analysis Services (SSAS).
- Planned and executed disaster recovery (DR) exercises on DR servers.
System Administrator
Solar Bank Africa Ltd
01.2016 - 11.2016
- Worked with users to determine areas of technology in need of improved usability.
- Providing on-call technical support for network and communication problems.
- Installed important security and functionality patches to maintain optimal protections against intrusion and system reliability.
- Provisioned new software and hardware for use, following established security policies.
- Completing special projects and presentations as assigned by the IT director, technology services manager, and senior network administrator.
- Researching and choosing hardware and software products to be deployed and supported by client services.
- Managed onboarding and offboarding of employees.
- Assigning field calls and balancing workload for deployment of new equipment and replacement of PCs.
- Installing, configuring and administering network technologies including firewall, routers and switches.
- Achieved customer’s satisfaction rating of 95% within Six months, exceeding corporate target.
Education
Certificate of Completion - SQL Server Database Administration
Teky Computer Education
Lagos, Nigeria12.2015
National Diploma - Computer Science
Federal College of Agriculture
Akure, Ondo State, Nigeria05.2015
Skills
- SQL Server 2019, 2016, 2014,2012, 2008 R2
- Windows Server 2019, 2016, 2012 R2, 2008
- Linux, VMware
- Data Migration
- SQL Server Migrations- SQL Server to SQL Server SQL Server to Azure VM-MI
- PaaS, IaaS, SaaS
- ServiceNow, SolarWinds, SQL Sentry
- Performance Tuning
- SQL Server Upgrade and Patching
- Installation and Configuration of SQL Server
- ETL Tools: SSIS (SQL Server Integration Services)
- High Availability (HA), Disaster Recovery (DR)
- Transparent Database Encryption (TDE)
- Dynamic Data Masking (DDM)
- Power BI
- Tableau
- Brent Ozar Toolkit
- AWS
- PostgreSQL/Oracle
- Backup and Restore Procedures
- Active Directory
- AlwaysOn
- Database Refresh
- Bulk Copy Program (BCP)
- Microsoft Office
- Communication Skill
- Strategic Planning
- GitHub
- Data Conversion
- SQL Automation
- Database Security
- SQL Server Reporting Service
- Oracle 11g/12c Installation
References:
Available on Request
Timeline
SQL Server Database Administrator
PlusEight Designs LLC
04.2019 - Current
SQL Server Database Administrator
Lydia Painting LLC
02.2017 - 03.2019
System Administrator
Solar Bank Africa Ltd
01.2016 - 11.2016
Certificate of Completion - SQL Server Database Administration
Teky Computer Education
National Diploma - Computer Science
Federal College of Agriculture
Similar Profiles
Devyn FullerDevyn Fuller
Welding Assistant at Welding Designs LLCWelding Assistant at Welding Designs LLC
Tavaryl WallsTavaryl Walls
Customer Retention Specialist at Mag Mile Designs LLCCustomer Retention Specialist at Mag Mile Designs LLC
LaNetra Belser, MPALaNetra Belser, MPA
Owner/Creative Director at B3 Events & Designs, LLCOwner/Creative Director at B3 Events & Designs, LLC
Charmagne N. GelseyCharmagne N. Gelsey
Payroll Conversion Consultant at EmpowerPayroll Conversion Consultant at Empower
Hope RodriguezHope Rodriguez
Claims Adjuster at GEICOClaims Adjuster at GEICO