Rouget De Ruiter

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.
• I have 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
• Configuring and maintaining Log-Shipping and troubleshooting issues Rebuild 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
• troubleshooting and fine-tuning databases for better 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 a distributed team environment.

Achievements:

• Involved in external audits and participating in the business continuity plans for clients
• Assistant Mentor to AI interns.
• Collaborating with the Data Engineer team to simplify data Migrations.

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.
• 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)

Achievements:

• 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 astrategic plan for component development practices to support future projects.
• Assisted customers in identifying issues and explained solutions to restore service and functionality
• Revived company employee recognition initiative

• Improved customer satisfaction by providing timely and efficient support for various applications.
• Analyzed and mapped data and wrote SQL scripts to extract data from SQL databases.
• Collaborated with developers, analysts and project managers to expedite incident resolutions.
• Interfaced with customers and developers to diagnose problems and implement configuration requirements and solutions.
• Provided 24/7 support for web- and client-based applications, file and data feeds and batch processes to prevent impact to business.
• Reduced downtime by proactively monitoring application performance and addressing potential issues before they escalated.
• Collaborated with cross-functional teams to identify and implement system improvements, resulting in enhanced user experience.
• Performed quality assurance testing on new software releases for alignment with goals for efficiency and performance.
• Optimized system performance by recommending hardware upgrades or configuration adjustments based on usage patterns and load testing results.