Azure SQL Administrator | MS SQL Database Administrator with 10+ years of expertise in database security, performance tuning, and high availability solutions. Professional database specialist with in-depth expertise in SQL Server management, optimization, and troubleshooting. Skilled in security implementation, and data integrity maintenance, ensuring reliable and efficient database environments. Strong focus on team collaboration and result-oriented strategies, adaptable to evolving project needs. Known for analytical problem-solving and effective communication to support organizational goals.
Overview
12
12
years of professional experience
1
1
Certification
Work History
LEAD SQL SERVER DATABASE ADMINISTRATOR
Illinois Mutual Insurance
05.2023 - 09.2024
Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
Documented analysis results and provided performance improvement feedback.
Developed custom database objects, stored procedures and delivered application support.
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.
Analyzed business reports for prompt communication, follow-up and ongoing support.
Supported projects enabling delivery efficiencies and technical resolution.
Followed standard practices for migrating changes to test and production environments.
Created optimal technical solutions to user needs with in-depth system analysis.
Implemented system enhancements to design and develop solutions to address problem reports.
Assisted in capacity planning by analyzing growth trends and forecasting future storage needs, facilitating timely infrastructure investments.
Participated in troubleshooting efforts for complex database-related issues as part of collaborative problem-solving approach among colleagues improving performance by up to 30%.
Designed and implemented stored procedures, triggers, and views for enhanced functionality within applications.
Trained junior staff members on SQL Server administration tasks, fostering continued professional development within team.
Produced high-standard database solutions to meet stability, reliability and performance metrics.
Facilitated change management processes by conducting thorough reviews of proposed alterations prior to implementation into production environments.
Managed database upgrades and migrations, ensuring minimal impact on end users and maintaining data consistency.
Optimized database performance by implementing index tuning strategies and query optimization techniques with up to 60% improvement.
Oversaw disaster recovery planning initiatives to ensure minimal disruption in event of unexpected system outages or failures.
Collaborated with cross-functional teams to develop efficient data storage solutions, resulting in streamlined business processes.
Developed scripts and processes for data integration and maintenance.
Implemented BI solution framework for business intelligence projects.
Installed and configured middleware in Linux and Windows environments.
MS SQL SERVER DATABASE ADMINISTRATOR
Bankers Trust
12.2022 - 06.2023
Ensured SQL Server HA and disaster recovery (Always On Availability Groups, Log Shipping, Mirroring), boosting business continuity and data protection
Deployed SSIS and Power BI, cutting operational overhead and enhancing reporting capabilities
Supported multi-site SQL environments including production environments, maintaining 24/7 availability
Developed automated scripts for database maintenance, reducing manual intervention and improving efficiency
Executed strategic upgrades to SQL Server infrastructure, significantly increasing system reliability and reducing downtime incidents
Fostered partnerships with IT and business units, aligning database solutions with organizational goals and enhancing cross-departmental communication
Mentored junior DBAs, providing guidance on best practices and fostering a culture of continuous improvement within the team
Enhanced data security protocols, mitigating risk and ensuring compliance with industry standards
Coordinated with cybersecurity teams to safeguard database integrity, minimizing potential breaches
Led cross-functional projects to integrate new technologies, driving forward system modernization initiatives
Delivered Always On Availability Groups and Database Mirroring for high availability
Designed and executed SQL Server Data Partitioning and Data Compression strategies for performance and storage efficiency
Engaged in Data Warehousing, Backup/Restore Planning, and implementing Predictive Analytics for business insights
Led cross-functional teams to optimize database performance, enhancing response times and ensuring seamless data accessibility
Streamlined backup processes, achieving 99.9% uptime and minimizing downtime, ensuring uninterrupted business operations
Collaborated with IT teams to integrate new technologies, fostering a culture of continuous improvement and technical excellence
Enhanced security protocols for SQL databases, reducing risk of breaches and ensuring compliance with industry standards
Facilitated cross-departmental workshops, promoting knowledge sharing and fostering a unified approach to database management.
MS SQL SERVER DATABASE ADMINISTRATOR
UnityPoint Health
05.2020 - 11.2022
Analyzed business reports for prompt communication, follow-up and ongoing support.
Followed standard practices for migrating changes to test and production environments.
Created optimal technical solutions to user needs with in-depth system analysis.
Incorporated extensive familiarity with systems for data management, backup and recovery accountability with a 99.9% RPO achieved.
Reduced downtime by 80% by proactively monitoring server health, identifying potential issues, and executing preventative measures.
Ensured data integrity and security through the implementation of comprehensive backup and recovery plans.
Optimized database performance by implementing index tuning strategies and query optimization techniques leading to 75% performance gain.
Facilitated change management processes by conducting thorough reviews of proposed alterations prior to implementation into production environments.
Produced high-standard database solutions to meet stability, reliability and performance metrics.
Reviewed SQL code for optimization opportunities, leading to more efficient processing times across various applications.
LEAD SQL SERVER DATABASE ADMINISTRATOR/HEALTH SUPERVISOR
AEDES/IRESCO CONSORTIUM, Ministry of Public Health
02.2013 - 11.2019
Coordinated with vendors to address hardware or software concerns promptly while minimizing disruptions to daily operations.
Designed and implemented stored procedures, triggers, and views for enhanced functionality within applications.
Assisted in capacity planning by analyzing growth trends and forecasting future storage needs, facilitating timely infrastructure investments.
Reviewed SQL code for optimization opportunities, leading to more efficient processing times across various applications with 50% performance gains.
Provided technical support to application developers for seamless integration of databases within software solutions.
Produced high-standard database solutions to meet stability, reliability and performance metrics.
Implemented database partitioning strategies, leading to improved query response times and overall system performance.
Created and implemented database designs and data models.
Implemented security measures to protect vital business data.
Wrote and maintained technical and functional specifications to document database intentions and requirements reducing administrative overhead by 30%.
Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
Set up and controlled user access levels across databases to protect important data reducing data breaches by 99%.
Built databases and table structures for web applications.
Conducted tests to identify issues and make necessary modifications.
Modified databases to meet needs and goals determined during planning process.
Oversaw disaster recovery planning initiatives to ensure minimal disruption in the event of unexpected system outages or failures.
Conducted regular audits of user access rights, promoting compliance with company policies and industry best practices regarding data privacy.
Assisted in the development of data archiving strategies to maintain long-term storage efficiency while adhering to regulatory requirements.
Education
Associates - MS Azure Administration
KiawitechIT LLC
Houston, Texas, USA
01.2018
Masters - Public Health
Universidad Central De Nicaragua (UCN)
Managua, Nicaragua
09.2017
Associates - MS SQL Database Administration
KiawitechIT LLC
Houston, Texas, USA
02.2016
Bachelor's Degree - Computer Science
University of Buea
Buea, Cameroon
12.2015
Skills
SQL Server Administration
SSAS
SSRS
SQL Queries
RDMS
Performance Tuning
Indexing
Database Migration
Data Modeling
Azure SQL Database
AWS RDS for SQL Server
PostgreSQL
MySQL
Oracle Database
Java
Python
C
Service Broker
Data Mining
ETL
Query Rewriting
Parameter Sniffing
Data Lakes
Power BI
Salesforce Administration
CRM Database Management
Sales Data Analysis
HubSpot CRM
Dynamics 365
Azure DevOps
Network administration
GitHub
Terraform
Ansible
Docker
VMware
SQL Agent
Log Shipping
Mirroring
Always On Availability Groups
DMV (Dynamic Management Views)
SQL Server Encryption
SQL Server Filestream
Team Leadership
SQL Server Heaps and B-Trees
SQL Server Profiler
Agile Methodologies
ITIL
IT Management
IT project management
IT Strategy
IT Service Management
SQL Server Query Store
Extended Events
Database Sharding
SQL Server Database Snapshots
Active directory
System administration
Cognitive Services
SaaS
PaaS
IaaS
Analytical Skills
Normalization
System Architecture
Change Management
Schema Design
Metrics Communication
HTML
DB2 LUW
Data Warehousing
Database Security
SQL Server Integration Services
Data Compression
SQL Server Reporting Services
SQL Server Analysis Services
Replication Management
Capacity Planning
Transparent Data Encryption
SQL Server Agent
SQL Profiler
Policy-Based Management
Resource Governor
Database Partitioning
Query Optimization
Index Maintenance
Change Data Capture
Database Mail
Backup and recovery
Database Auditing
Disaster Recovery
Full-Text Search
Dynamic Management Views
Microsoft Visual C#NET
Database Development
Relational databases
Database Administration
Linux Operating System
Database Management
Database Design
Systems administration
NoSQL Databases
Microsoft NET framework
Database monitoring
Agile Methodology
ETL development
Data Security
Code debugging
Relational Database Management
Customer Needs Assessment
Information modeling
Database locking
SAP PowerBuilder
Running backups
Process Automation
End-User Training
Implementing security measures
Interdepartmental communication
Netsuite ERP
Storage virtualization
Root Cause Analysis
Data audits
Continuous Process Improvement
System Testing
Document Management
Compiling Data
Presentations
Data Migration
Patch management
Transaction Management
Data Acquisitions
Data Governance
Information Protection
New Product Testing
Teamwork and Collaboration
Problem-Solving
Time Management
Attention to Detail
Problem-solving abilities
Multitasking
Multitasking Abilities
Reliability
Excellent Communication
Critical Thinking
Organizational Skills
Team Collaboration
Active Listening
Effective Communication
Adaptability and Flexibility
Decision-Making
Relationship Building
Team building
Task Prioritization
Self Motivation
Interpersonal Skills
Analytical Thinking
Goal Setting
Python Programming
Professionalism
Interpersonal Communication
Object-Oriented Programming
Strategic Planning
Certification
Microsoft Azure Administrator (AZ-104) - Certified
Microsoft Technology Associate (MTA) - Certified
Azure Database Administrator Associate (DP-300) - In progress
Azure Solutions Architect (AZ-305) - In progress
Projects
Implemented a High Availability and Disaster Recovery solution, utilizing SQL Server failover Clustering, and automated Log Shipping to ensure continuous database availability.
Developed a comprehensive Data Warehousing and ETL solution integrating multiple data sources, optimizing financial reporting, and creating interactive dashboards and apps using Power BI and Azure Machine Learning.
Led a SQL server Migration project from SQL 2014 and SQL 2016 to SQL 2019 involving over 700 hundred databases including large and complex vendor databases.
Timeline
LEAD SQL SERVER DATABASE ADMINISTRATOR
Illinois Mutual Insurance
05.2023 - 09.2024
MS SQL SERVER DATABASE ADMINISTRATOR
Bankers Trust
12.2022 - 06.2023
MS SQL SERVER DATABASE ADMINISTRATOR
UnityPoint Health
05.2020 - 11.2022
LEAD SQL SERVER DATABASE ADMINISTRATOR/HEALTH SUPERVISOR
AEDES/IRESCO CONSORTIUM, Ministry of Public Health
02.2013 - 11.2019
Microsoft Azure Administrator (AZ-104) - Certified
Microsoft Technology Associate (MTA) - Certified
Azure Database Administrator Associate (DP-300) - In progress
Azure Solutions Architect (AZ-305) - In progress
Associates - MS Azure Administration
KiawitechIT LLC
Masters - Public Health
Universidad Central De Nicaragua (UCN)
Associates - MS SQL Database Administration
KiawitechIT LLC
Bachelor's Degree - Computer Science
University of Buea
Similar Profiles
Tanyhell StallworthTanyhell Stallworth
Independent Agent at Illinois MutualIndependent Agent at Illinois Mutual
Lead Sales Representative at Liberty Mutual Insurance/Comparion Insurance AgencyLead Sales Representative at Liberty Mutual Insurance/Comparion Insurance Agency