5+ years of experience in Database Administration for large databases in SQL Server 2005, SQL Server 2008,2008 R2,2012,2014 2016, 2017, 2019 and 2022
Systematic and organized SQL DBA trained in database systems management using a variety of technology platforms.
Qualified SQL DBA committed to data integrity.
Experienced Database Administrator on Production Servers using SSCM,SSMS, performance tuning tools such as profiler,DTA.
Hands on experience on SQL Server Replication, Backup/Restore, Disaster recovery and planning.
Troubleshoot performance problems, fine-tuning of databases and index Analysis.
Excellent communication skill, critical thinking and problem solving skills.
Experience in Batch processes, Import/Export, Database Monitoring tools and Application support.
24/7 Production Database on Call Support.
Microsoft SQL DBA certified
Overview
12
12
years of professional experience
4
4
Certification
Work History
SQL Database Administrator
EOH – IOCO Data Services & Integration
05.2022 - Current
Responsible for installation, configuration, and complete administration of different versions of SQL Server (2008 to 2022)
Apply Service Pack (SP) and hotfixes on SQL server 2008R2,2012,2014, 2016, 2017, 2019, 2022
Configure Replication and Database mirroring.
Application support for front-end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues, and memory leaks.
Extensively worked with SQL Profiler, Activity monitor, DMVs, DMFs, and DTA to tune databases, queries, and performance-related issues like memory CPU and I/O issues.
Analyze long-running slow queries and tune to optimize application and system performance
I am configuring and maintaining Log-Shipping and troubleshooting issues.Rebuild t indexes at regular intervals for better performance.
Implementation of SQL Logins, Roles, and Authentication Modes as part of Security Policies for various categories of user
It is involved in troubleshooting and fine-tuning of databases for its performance.
Improve performance of SQL Queries and stored procedures using SQL Profiler.
Implemented company policies, technical procedures, and standards for preserving the integrity and security of data, reports, and access
Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures, and Contingency plans. We are testing and implementing these procedures.
Provide 24/7 technical database support for SQL Database systems.
Created optimal technical solutions to user needs with in-depth system analysis
Produced high-standard database solutions to meet stability, reliability, and performance metrics
Managed workload independently but collaborated with colleagues to complete larger-scale tasks in distributed team environment
Modified databases to meet needs and goals determined during theplanning process
TECHNICAL SUPPORT SPECIALIST
MiTek Industries
04.2016 - 04.2022
Installation, configuration and upgrading of SQL Server 2008/2008R2,2012 with service packs and hot fixes.
Upgrading SQL Server 2008/2008R2 to SQL Server 2012 (Side by side upgrade).
Providing On-Call support during business hours.
Monitoring Daily backup jobs and automation of daily restores of development databases.
Monitoring the Disk Space of all the Servers.
Configuring and Monitoring log shipping and Database mirroring on Disaster recovery Servers.
Database snapshot creation for the synchronized databases for Reporting Purposes.
Capturing the events using sql profiler for poor performing queries, deadlocks and blocks and studying the execution plans and fine tuning the applications.
Automating Server Side Tracing in SQL Server and identifying SQL Server performance issues, by analyzing Profiler output.
Disaster Recovery setup and testing it in regular intervals.
Reporting and resolving serious SQL Server alerts.
Implement and Maintain database Security (Create and maintain users and roles, assign privileges)
Working with workflows for any changes on staging and development environment. Involved in the internal and external audits and participating in the business continuity plans of the company.
Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
Designed strategic plan for component development practices to support future projects.
Assisted customers in identifying issues and explained solutions to restore service and functionality
Responded to support requests from end-users and patiently walked individuals through basic troubleshooting tasks
Application Support Engineer
Egis Software
Johannesburg, GP
06.2012 - 08.2016
Administered database and server security by creating and maintaining SQL server logins,permissions, and privileges.
Worked with Developers and QA team to resolve any database or application issues.
Provided ongoing maintenance and administration of assigned systems.
Configured and validated database backup routines and recovery of lost or corrupted data.
Maintained data security and integrity through user authentication and authorization.
Optimized database performance through database performance tuning.
Developed test sets for monitoring database functionality through 24/7 monitoring systems.
Solved the request raised by user support.
Participated in implementation of new releases into production.
Involved in Day-to-day administration of live SQL Servers.
Generated target accounts sales objectives, opportunities, and projection reports to prioritize work
Skills
Replication
Database schema creation and management
Backup and recovery
Ensuring data integrity
Performance management and tuning
High Availability
Data security
General database management
Extensible data type administration
Excellent communication skills
Data privacy applications
Excellent problem-solving abilities
Database design
Azure SQL
Extract, Transform, Load (ETL)
Patch Management
Optimization
Certification
Microsoft Certified: Azure Database Administrator Associate
Microsoft Certified: Azure Data Fundamentals
Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
Administering Microsoft SQL Server 2012/2014 Databases