add photo
Damilare
damilolajonsen@gmail.com
240-413-4583
Columbia, MD 21045
SQL SERVER DATABASE ADMINISTRATOR
10 years experience W2
0
Recommendations
Average rating
216
Profile views
Summary

Multi-dimensional and career-driven professional credited with over six (6) years of solid experience resolving complex inquiries, capable of holding positions of great responsibility. Digest several new thoughts after having attacked and overcome the latest performance or space issue and started considering aspects of a seemingly simple query that isn't performing as anticipated. A dynamic and passionate individual with a proven track record of finding ways to store, organize, and manage data with expertise in liaising with programmers, applications/operational staff, IT project managers, and other technical staff. Ensure success as a database administrator by providing key data recommendations and best practice solutions to project teams. Committed to utilizing resources to drive significant decisions and assimilate new concepts, ensuring integrity and accountability through transparency and actionable insights. Viewed as a path of resistance to a development team and must walk the fine line of ensuring security & availability while at the same time not hampering delivery. AND ACHIEVEMENTS

  • Excellent knowledge of databases and query languages, and intimately familiar with the steps required to perform the work.
  • Spearheaded over 500 databases and VLDB across multiple data centers and migrated SQL data from on-premises to Azure SQL database, Azure VM and AWS. Performed Physical and Logical Data Modeling for databases of varied sizes, including VLDBs.
  • Set up and sustained high availability and disaster recovery solutions and large-scale database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014, 2016, 2017, 2019.
  • Aided the SQL server prime customers with configuration, administration, implementation, and troubleshooting for business workflow with the Log shipping mechanism and installed and maintained SSIS, SSRS, and Power BI.
  • Configured DR solution with transaction replication from distribution server with multiple updatable subscriptions.
  • Developed and maintained SQL objects like Tables, Views, Stored procedures, constraints, and user-defined functions.
  • Achieved Database consistency checks with DBCC, Defrag, and Index tuning monitored error logs and implemented Log Shipping from Primary to Standby servers. Conducted scheduled backups and restored operations with LiteSpeed 4.5.
  • Implemented Log Shipping from Primary to standby servers and used tools like SQL Profiler and Red Gate for monitoring the environment. Involved in creating and developing SSIS packages in SQL Server 2008
  • 17
  • Crafted shell scripts and SQL scripts for database administration to support DBA function and assisted developers with complex query tuning and schema finessing.

Experience
Education
Cybersecurity
Prince George's Community College
BANKING AND FINANCE
Oduduwa University Osun State
Skills
Database Backups
2022
6
DBA
2022
6
SQL
2022
6
SQL Server
2022
6
Data Replication
2022
5
Performance Tuning
2022
2
Data Access
2017
1
Data Dictionary
2017
1
Data Integrity
2022
1
Database Upgrades
2022
1
Machine Learning
2022
1
Microsoft Excel
2017
1
PL/SQL
2017
1
Stored Procedure
2017
1
Windows
2017
1
Data Center
0
1
Data Modeling
0
1
Disaster Recovery
0
1
MS Azure
0
1
MS Power BI
0
1
Shell Scripts
0
1
SSIS
0
1
SSRS
0
1