Sivaraj T

SQL DEVELOPER

Chennai

Summary

At MSC Technologies, I spearheaded the development of ETL applications, enhancing reporting efficiency by optimizing SQL queries and procedures. My expertise in SQL analytics and agile methodology significantly improved data integrity and server performance. I excel in performance tuning and proactive server management, embodying a results-driven approach with a blend of technical and collaborative skills. Adept at leveraging new tools and methods to solve problems and enhance productivity.

Overview

years of professional experience

Languages

Work History

SQL Developer

MSC Technologies

09.2021 - Current

Designed and developed customized extract, transform, and load (ETL) applications per client specifications using SSIS.
Streamlined data retrieval processes for a more efficient reporting system (SSRS), optimizing stored procedures and SQL queries.
Ensured data integrity by implementing appropriate validation rules using TSQLT, an open-source testing framework, and RedGate Tool Belt within the SQL Server environment.
Managed access control within the SQL Server environment by implementing role-based security measures, ensuring appropriate permissions were granted based on user needs.
Monitored and maintained SQL Server instances, CPU, memory usage and server health proactively using Redgate Tool belt to ensure better server usage and security vulnerabilities.

Education

Bachelor of Engineering - Computer Engineering

KLN COLLEGE OF ENGINEERING

Madurai, India

04.2001 -

Skills

SQL analytics

Software

Azure DevOps Build and Deployment Process

Redgate toll belt for server monitor and maintance

TOAD Data Modeler for server level data model creation and mainatance

Interests

Musics

Timeline