I am an experienced SQL Server DBA with over 7 years of experience, who can be relied upon to perform duties with passion and professionalism while ensuring that the goals of the company are met. I pay attention to detail and have solid working experience in managing large databases, Backup/Restore, Migration, Configuring and managing HADR solutions, Performance Tuning and Data Security. I possess a methodical approach to troubleshooting and problem solving. I like to add that I work well both as an individual contributor and as a team player and have an aptitude for learning
Overview
7
7
years of professional experience
Work History
MS SQL Server Database Administrator
BrightSide Technologies
Vancouver, CANADA
11.2023 - Current
Assisted in the development of data archiving strategies to maintain long-term storage efficiency while adhering to regulatory requirements.
Reduced downtime by proactively monitoring server health, identifying potential issues, and executing preventative measures.
Provided technical support to application developers for seamless integration of databases within software solutions.
Collaborated with cross-functional teams to develop efficient data storage solutions, resulting in streamlined business processes.
Implemented database partitioning strategies, leading to improved query response times and overall system performance.
Trained junior staff members on SQL Server administration tasks, fostering continued professional development within the team.
Developed custom scripts for automating routine tasks, increasing productivity and reducing manual intervention.
Implemented regular performance monitoring and tuning strategies, proactively addressing potential bottlenecks before they impacted end users.
Designed and implemented stored procedures, triggers, and views for enhanced functionality within applications.
Managed database upgrades and migrations, ensuring minimal impact on end users and maintaining data consistency.
Ensured data integrity and security through the implementation of comprehensive backup and recovery plans.
Set up and controlled user profiles and access levels for each database segment to protect important data.
Implemented security measures to protect vital business data.
SQL Server Database Administrator
Bank Of America
CHARLOTTE , NORTH CAROLINA , UNITED STATES
04.2020 - 11.2023
Optimized database performance by implementing index tuning strategies and query optimization techniques.
Ensured data integrity and security through the implementation of comprehensive backup and recovery plans.
Assisted in the development of data archiving strategies to maintain long-term storage efficiency while adhering to regulatory requirements.
Reduced downtime by proactively monitoring server health, identifying potential issues, and executing preventative measures.
Conducted regular audits of user access rights, promoting compliance with company policies and industry best practices regarding data privacy.
Tested, Implemented different Physical and Logical Backup and Recovery methods Point-in Time, Recovery.
Configured High Availability Solution Always On Cluster, Traditional Failover Clustering, Database Mirroring and Log Shipping.
Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
Rebuilding the indexes at regular intervals for better performance.
Maintained database security using Transparent Data Encryption, Always Encrypted and Dynamic Data Masking.
MSSQL Database Administrator
PANASONIC AVIONICS CORPORATION
HOUSTON, TEXAS, UNITED STATES
06.2017 - 04.2020
Ensured database security with implementation of role-based access control and regular vulnerability assessments.
Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
Developed comprehensive documentation on database architecture, simplifying future upgrades and maintenance tasks.
Served as an internal consultant for application developers, providing guidance on query optimization techniques that improved application performance significantly.
Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability.
Optimized database performance by monitoring health and implementing tuning recommendations.
Created a robust disaster recovery plan to ensure business continuity in the event of hardware failures or natural disasters.
Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
Created and updated database designs and data models.
Evaluated emerging technologies to identify opportunities for improving database operations and reducing costs.
Education
Advanced Database Administration Training Program
HOUSTON , TEXAS
06.2016
Bachelor of Science -
UNIVERSITY OF BUEA
SOUTHWEST ,CAMEROON
08.2013
Skills
Capacity Planning
Data Warehousing
Backup and recovery
Performance Tuning
Disaster Recovery
Database Security
SQL Server Agent
Transparent Data Encryption
Database Auditing
Running backups
Database Management
Database monitoring
Data Migration
Installation, Configuration of MS SQL Server versions from 2008 to 2019 following best practices