Summary
Overview
Work History
Skills
Certification
Timeline
AdministrativeAssistant
Rougét De Ruiter

Rougét De Ruiter

Gauteng

Summary

  • 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

Timeline

SQL Database Administrator

EOH – IOCO Data Services & Integration
05.2022 - Current

TECHNICAL SUPPORT SPECIALIST

MiTek Industries
04.2016 - 04.2022

Application Support Engineer

Egis Software
06.2012 - 08.2016
Rougét De Ruiter