Summary
Overview
Work History
Education
Skills
Certification
Work Preference
Timeline
Generic
Open To Work

Tade Dimbisso

Silver Spring,MD

Summary

A Microsoft certified SQL Server (DBA) with 7 years IT experience in supporting database solutions in SQL Server Environments (production and non-production) with different versions.

Possess strong communication and problem-solving skills, developed through a variety of projects, offers proven ability in teamwork and proactive system support.

Experience in installing, configuring, administration and maintenance of mission-critical client databases in SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 versions.

Experience in upgrading SQL Server (in place and side by side) based on application compatibility and fixing orphan users.

Experience in creating and granting logins at server level, and creating users and granting permissions, and assigning roles to users at database level as per business requirement.

Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using ticketing tools.

Implementing and troubleshooting HA and DR of database servers using replication, log shipping, database mirroring, Failover Clustering and AlwaysOn Availability Group.

Configuring and scheduling SQL Server agent jobs, alerts, operators, maintenance plans, database mail configuration and Transparent Data Encryption /TDE/. Experience in monitoring, performance tuning, and analyzing database performance issues.

Designing and implementing the backups in configuring and maintaining full backup, transactional log backup, differential backup, and disaster recovery strategies as per RPO and RTO values.

Creating maintenance plans of index rebuild, index reorganize based on level of fragmentation.

Experience on Database Migrations and Upgrading by using database migration approaches within the on-prems and from on-prem to Azure environment

Strong experience on identifying and troubleshooting database health, integrity checks and fixing them.

Hands on experience on applying patches, cumulative updates, and hot fixes

Experience in MSSQL Server Reporting Service (SSRS) with report authoring, management, delivery, and security, and create jobs which alerts to run SSAS, SSRS packages periodically.

Experience in Configuring the SQL Server in AWS Relational Database Management system and in EC2 Created the automated processes for the activities such as database backup processes and SSAS, SSRS packages run sequentially using SQL Server Agent job

Overview

6
6
years of professional experience
1
1
Certification

Work History

Sr. SQL DBA Administrator

Walmart
11.2023 - Current
  • Experienced in installing, configuring, administering, and securing production and non-production servers (clustered and non-clustered).
  • Experienced in upgrading SQL server 2012 to SQL Server 2016, 2017 and 2019.
  • Experienced in implementing SQL Clusters across multiple availability zones and configured SQL Server Always-On Availability Group in Azure.
  • Experienced in setting up database transactional replication for reporting servers, using backup and restore methods.
  • Expert in database refresh in production environment as per the business requirements and automated quarterly/monthly.
  • Managed and involved in SQL performance-tuning, identifying locking, and blocking issues using native and third-party tools to enhance and boost performance of SQL databases.
  • Implemented and managed SQL Server maintenance plan and created schedules for all environments.
  • Created database maintenance jobs to perform full & transaction log backups and scheduled them with the SQL Server agent job scheduler.
  • Monitor database growth activities & troubleshoot transaction log issues.
  • Managed SQL Server logins, database users & roles.
  • Created and configured mirroring for disaster recovery.
  • Providing weekly status updates of all projects to project manager.
  • Debug stored procedures and DDL or DML triggers, functions as per of client requirements.
  • Extensively worked on troubleshooting and fine-tuning of databases for optimal performance.
  • Worked with performance tuning/query tuning, execution plans, trace flags and SQL profiler
  • Monitored and implemented cumulative updates, patches, service packs as per of the environments.
  • Extensive experience on in-place and side-by-side database migrations by using database migration on-prem and Azure environment
  • Supporting SQL Server Integration Services (SSIS) to validate data warehouse in data extraction, transformation, and loading (ETL) packages.
  • Experience in migrating SQL Server from lower to higher versions with Always-On Availability Group.
  • Good understanding in database design, development, production, and data warehousing concepts (OLTP & OLAP).
  • Created new tables, stored procedures, triggers, and refactored and fine-tuned the queries by using T-SQL.
  • Performing database backups, restores, refresh, clean-up, statistics update
  • Installed and configured MS SQL Servers in physical and virtual environments.
  • Analyze the execution plans and recommend a better execution plan for implementation.
  • Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
  • Experience in a robust software used to register, organize, prioritize, and resolve supporting tickets.
  • Environment: Windows 2008-2012R2, SQL Server 2008-2019, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate, Visio 2010, Ticketing tool.

SQL Server Database Administrator

Wells Fargo
03.2021 - 10.2023
  • Installed and configured various SQL Server editions and versions in standalone, and clustered nodes
  • Installed, and Configured SQL Server Failover Cluster for SQL Server 2012, 2016 and 2017
  • Upgraded SQL Server 2005, 2008 and 2008 R2 database into SQL Server 2017 and applied service packs, hotfixes, and cumulative updates
  • Created and maintained server level logins, database level users and roles, and managed security of the databases.
  • Implemented disaster recovery plan by performing routine backups and restore, and taking full, differential, and transactional log backups and setting automated jobs.
  • Migrated data using Import/Export, bulk, backup-restore, SSIS, Detach/Attach
  • Supported and maintained SQL Server Integration Services (SSIS).
  • Rebuild /reorganize indexes to reduce fragmentation and enhance SQL server performances.
  • Created triggers, views, and stored procedures, and implemented database maintenance plans, scheduled automated SQL Server jobs, create alerts, operators, notifications, and configured database mail.
  • Hands-on experience in monitoring and performance tuning using tuning advisor, SQL Server profiler, activity monitor, Windows performance monitor, DBCC, DMVs, stored procedures.
  • Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.
  • Configured and managed database HA: replication, database mirroring, log shipping, failover clustering and Always On Availability Group.
  • Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports
  • Worked in a team with integrated developers, CAB (Change Approval Board) and disaster recovery planning team.
  • Experience in contacting Microsoft and other vendors for product and technical support.
  • Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due.
  • Experienced in a robust software used to register, organize, prioritize, and resolve support tickets to fix the issues
  • Experience in supporting a database AWS-RDS production and development environment.
  • Experience in Agile projects with a solid foundation in Software Development Lifecycle (SDLC).
  • Environment: Windows 2003-2012R2, SQL Server 2008-2014, IDERA SQL diagnostic Manager, Red-gate SQL, Visio 2010, SSDT, AWS-RDS
  • Maintained complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision.
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
  • Designed and implemented TSQL queries for reporting and complex solution development.
  • Designed and implemented stored procedures, triggers, and views for enhanced functionality within applications.
  • Assisted in the development of data archiving strategies to maintain long-term storage efficiency while adhering to regulatory requirements.
  • Implemented regular performance monitoring and tuning strategies, proactively addressing potential bottlenecks before they impacted end users.
  • Implemented database partitioning strategies, leading to improved query response times and overall system performance.
  • Ensured data integrity and security through the implementation of comprehensive backup and recovery plans.
  • Participated in troubleshooting efforts for complex database-related issues as part of a collaborative problem-solving approach among colleagues.
  • Reduced downtime by proactively monitoring server health, identifying potential issues, and executing preventative measures.
  • Managed database upgrades and migrations, ensuring minimal impact on end users and maintaining data consistency.
  • Set up and controlled user profiles and access levels for each database segment to protect important data.
  • Created and updated database designs and data models.
  • Set up and controlled user access levels across databases to protect important data.

SQL DBA

Allstate Ins Group
04.2019 - 02.2021
  • Installed and configured SQL server 2008/2008R2, 2012/2012R2, 2014 and 2016.
  • Installing, maintaining the SQL database, and creating storage database structures with security features, and setting up database user accounts.
  • Created and updated databases, tables, stored procedures, triggers, functions, and views.
  • Configured, administered, and troubleshot multiple databases in production and staging environments in clustered and standalone environments.
  • Prepared documentation for disaster recovery plan and implemented database mirroring and log shipping.
  • Involved in installing SQL server failover clustering on multiple nodes.
  • Planned backup strategies, scheduled backups, and performed restore operations.
  • Managed security of SQL server databases by creating logins, creating database users, roles, and assigning proper permissions, creating server and database audits.
  • Worked on creating, reorganizing, and rebuilding indexes.
  • Worked on database space management, alert management, and performance monitoring, and planned the location of files and managed the size and number of files.
  • Performed tasks of query optimization, troubleshooting client/server connectivity issues, and performance tuning.
  • Monitored and troubleshoot database and server performance at system-wide scale and effectively identify network, databases, memory, CPU, disk space, and I/O related bottlenecks.
  • Supported transfer of data between several servers using SSIS
  • Generated extensive reports using SSRS.
  • Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due.
  • Environment: Windows 2008-2012R2, SQL Server 2008-2008R2, SQL Server 2012 SSMS, SQL Server 2012, Profiler, Extended Events, JIRA
  • Streamlined backup and recovery processes, enhancing overall system stability and availability.
  • Ensured database security with implementation of role-based access control and regular vulnerability assessments.
  • Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
  • Set up and controlled user profiles and access levels for each database segment to protect important data.
  • Enhanced reporting capabilities by designing efficient ETL processes that improved data accuracy and completeness.
  • Modified databases to meet needs and goals determined during planning process.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
  • Set up and controlled user access levels across databases to protect important data.
  • Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability.
  • Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
  • Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
  • Created a robust disaster recovery plan to ensure business continuity in the event of hardware failures or natural disasters.
  • Optimized database performance by monitoring health and implementing tuning recommendations.
  • Evaluated emerging technologies to identify opportunities for improving database operations and reducing costs.
  • Collaborated with cross-functional teams to develop custom applications that supported business objectives and met user needs.
  • Implemented comprehensive data retention policies that met regulatory requirements while minimizing storage costs.
  • Developed scripts and processes for data integration and maintenance.
  • Developed comprehensive documentation on database architecture, simplifying future upgrades and maintenance tasks.
  • Streamlined database deployments, automating processes to accelerate development cycles and reduce errors.
  • Optimized database operational efficiency by implementing automated backup and recovery procedures.
  • Cultivated detailed documentation library, capturing database schemas, configurations, and procedures for future reference.
  • Reduced operational costs by identifying and decommissioning underutilized database resources.
  • Ensured high availability and disaster recovery capabilities, establishing and testing robust backup and failover strategies.
  • Enhanced data security with development and enforcement of comprehensive database access policies.
  • Achieved remarkable system performance improvements, fine-tuning database configurations and indexes.
  • Empowered end-users with creation of user-friendly reports and dashboards, enhancing decision-making processes.
  • Elevated user satisfaction, promptly addressing database-related issues and providing expert guidance.
  • Advanced database security posture, leading successful initiative to encrypt sensitive data at rest and in transit.
  • Streamlined data retrieval and processing, designing and optimizing complex SQL queries for business intelligence.
  • Facilitated knowledge sharing, conducting training sessions for junior DBAs and developers on best practices.
  • Enhanced data consistency across platforms, orchestrating effective data synchronization and integration projects.
  • Improved team productivity, coordinating database administration tasks and fostering collaborative work environment.
  • Installed and configured middleware in Linux and Windows environments.

Education

Master of Science - Information Technology

AAU
AA
12.2009

Skills

  • Windows 2008-2012R2, SQL Server 2008-2019, T-SQL, AWS-RDS, IDERA SQL diagnostic Manager, SQL safe 60, Red-gate, SSDT, Azure, SSIS, SSRS, SSMS, RAID, LiteSpeed, AZURE VM, Azure managed instance, Salesforce, Visio
undefined

Certification

Certificate in MCDBA

Work Preference

Work Type

Full TimeContract WorkPart Time

Location Preference

HybridRemote

Timeline

Sr. SQL DBA Administrator

Walmart
11.2023 - Current

SQL Server Database Administrator

Wells Fargo
03.2021 - 10.2023

SQL DBA

Allstate Ins Group
04.2019 - 02.2021

Master of Science - Information Technology

AAU

Similar Profiles

CREATE PROFILE
Tade Dimbisso