Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sathiyanarayanan Radhakrishnan

Summary

Results-driven MS SQL DBA with over 6 years of experience in the IT industry. Specializes in managing and optimizing SQL Server environments for high availability and performance. Skilled in database design, optimization, troubleshooting, and implementing effective solutions to meet organizational needs. Possesses entry-level knowledge of Cloud SQL database solutions and continuously seeks to expand expertise in the ever-evolving field of database management and cloud computing.

Overview

8
8
years of professional experience

Work History

Specialist, MSSQL DBA

HCL Tech
04.2023 - Current

Project: Unilever


  • Proactive monitoring of system performance and identifying/troubleshooting potential database related issues
  • Managing and troubleshooting issues with respect to High availability (AOAG/Mirroring/Log shipping/WSFC/Replication/Distributed AG)
  • Applying service packs/cumulative updates/Hotfixes to ensure stability and security
  • Expertise in Performance tuning on database including cloud SQL databases and suggesting application level tuning changes
  • Performing manual Backup and restore in RDBMS and SSAS including point in time recovery (*Performing restore from EMC Networker backup tool as well)
  • Effectively involved in Disaster recovery activities during annual DR drill and actual DR situations
  • Managing access to the users in RDBMS/SSAS/SSRS
  • Setting up and managing database maintenance activities (Integrity/Index optimization/Update stats)
  • Managing and remediating vulnerabilities with respect to the SSL certificate, Enforce password policy and ODBC/OLEDB.
  • Creating, scheduling, and modifying SQL Agent jobs to manage SQL database related activities
  • Maintaining Database security by implementing data encryption (TDE)
  • Monitor and tune all aspects of SQL Server infrastructure like Disk, CPU, Memory by using Profiler, Dynamic management views
  • Implementing and configuring Linked server between two SQL servers
  • Implementing SQL Server Audit to track user access and ensuring compliance
  • Performing Backup and restore using Azure blob storage in Azure SQL DB and Azure SQL MI
  • Performing Export and import database and overall instance restore from GCP backups in GCP Cloud SQL
  • Troubleshoot issues with respect to service unavailability in SSAS/SSRS
  • Identifying and resolving issues on data load/cube performance in SSAS, SSIS Package failure and Web portal/webservice URL not working in SSRS
  • Possess basic knowledge on PostgreSQL and MySQL and having hands on experience on Azure/GCP Cloud PostgreSQL and MySQL databases

MSSQL DBA

VWR, Part Of Avantor
01.2019 - 04.2023

Project: In-home Projects


  • Managed all aspects of the SQL Server databases, including installation, configuration, and maintenance.
  • Configured HA Solutions such as Mirroring/Log shipping/Replication/AOAG
  • Performed upgradation and migration from databases from 2008R2 to 2017
  • Co-ordinate with application teams and help in issue resolution

Associative

VWR, Part Of Avantor
01.2017 - 01.2019

Project: In-home Projects


  • End user experience in Step Trailblazer and SAP P20 and P45
  • Macro-Enabled Excel sheets with Multiple Data Validation to exclude the spelling issues, inconsistency and extra spacing in Error Analysis Report
  • Kaizen Project – Lead Time Reduction in Sub-process, STIBO-IT Integration
  • Experience in New Hires Process Training and creating Training materials and Reference Documents and monitoring Grad Bay (New hire Performance Monitoring)

Education

B. Tech -

Vel Tech High Tech Engineering College
Chennai, India
01-2016

Skills

  • Database expertise: SQL Server 2008/2012/2014/2016/2017/2019/2022
  • Operating Systems: Windows Server 2008/2012/2012R2/2016/2019/2022
  • Languages: SQL, T-SQL, PowerShell (Basic), Batch Scripting
  • Cloud Skills: Azure SQL Database, Azure SQL Managed Instances, GCP Cloud SQL
  • SQL Server BI Tools: SSIS, SSRS, SSAS
  • Other SQL Skills: PostgreSQL and MySQL (Basic)
  • Tools: SSMS, pgAdmin, MySQL Workbench Launcher, SQL Server Profiler
  • Ticketing Tool: Service Now

Timeline

Specialist, MSSQL DBA

HCL Tech
04.2023 - Current

MSSQL DBA

VWR, Part Of Avantor
01.2019 - 04.2023

Associative

VWR, Part Of Avantor
01.2017 - 01.2019

B. Tech -

Vel Tech High Tech Engineering College
Sathiyanarayanan Radhakrishnan