Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sahith Reddy

Cambridge,ON

Summary

  • 5+ years of experience in Database Administration for large databases in SQL Server 2008,2008 R2,2014 and 2016 and 2022.
  • Experience of migrating databases from On-prom to AZURE SQL MI, Azure SQL databases,configuring high availability geo-replication, and IAAS services.
  • Proficient in the latest versions of Microsoft SQL Server, including SQL Server 2019, 2022 with expertise in installation, configuration, and maintenance.
  • 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 Query store, profiler,DTA.
  • Successfully implemented disaster recovery and high availability solutions, such as database mirroring, Always On Availability Groups, and failover clustering and Log shipping.
  • Hands on experience on SQL Server Replication, Backup/Restore, Disaster recovery and planning.
  • Extensive experience in performance tuning and query optimization, leveraging tools like SQL Server Profiler, Query Store, Extended events, and Execution Plans.
  • Expertise in database security best practices, including encryption, authentication, and access control, to ensure data integrity and compliance.
  • 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.
  • Coordinated database migrations and upgrades between different versions of SQL server.
  • Real-world understanding of SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS) for complex data reporting and analytics.
  • knowledge of how to troubleshoot and fix database problems such deadlocks, blocking, and integrity problems.
  • Familiarity with cloud-based database solutions, including Azure SQL Database and Azure SQL Managed Instance and AWS services for seamless migration and scalability.
  • Expertize in TSQL scripting such as Stored procedures, Functions, Views and trigger's.
  • 24/7 Production Database on Call Support.
  • Microsoft SQL DBA certified

Overview

6
6
years of professional experience

Work History

Senior Azure SQL DBA

FirstNational Financial
06.2022 - Current
  • Involved in planning, setup and implementation of new Azure servers and Managed Instances across entire enterprise.
  • Migration of on-prem SQL Server Databases from SQL 2016 to Microsoft Azure hosted DBs and Managed instances and IaaS VM's.
  • Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of databases.
  • · Managing around 20 Virtual Machines in IAAS & 50 Managed Instances and SQL Servers, supporting a max size of 10 TB hosted in Microsoft Azure.
  • Responsible for installation, configuration and complete administration of different versions of SQL Server (2014,2016 and 2022)
  • Setup High Availability DB infrastructure Clustering in SQL Server.
  • Apply Service Pack (SP) and hot fixes on SQL server 2014, 2016 and 2022.
  • Configure log shipping for multiple databases as part of Disaster Recovery.
  • 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 work with SQL Profiler, Activity monitor, DMVs, DMFs and DTA to tune databases, queries, performance related issues like memory CPU and I/O issues.
  • Analyze long running slow queries and tune same to optimize application and system performance.
  • Reorganize/Rebuilding indexes at regular intervals for better performance.
  • Implementation of SQL Logins, Roles and Authentication Modes as part of Security Policies for various categories of users.
  • Involved in troubleshooting and fine-tuning of databases for its performance.
  • Implemented company policies, technical procedures and standards for preserving integrity and security of data, reports and access.
  • Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.
  • Configured Long Term Retention (LTR) and PITR backups for Mission-critical databases.
  • Administered ETL process using SSIS, Administered SSAS\SSRS instance.
  • Develop automation of database processes, tasks, and procedures. Stage and deploy database changes to production. Setup and manage access and security control.
  • Configured SQL Encryption on Production Servers. Work with Red Gate SQL server Backup tool, Idera, and Grafana performance monitoring tool.
  • Provide 24/7 technical database support for SQL Database systems.

SQL Server DBA

Accenture
07.2019 - 04.2021



  • Installation, configuration and upgrading of SQL Server 2012, 2014 and 2016 with service packs and hot fixes.
  • Upgrading SQL Server 2008/2008R2 to SQL Server 2016 (Side by side upgrade).
  • Providing On-Call support during business hours.
  • Monitoring Daily backup jobs and automation of daily restores of development databases.
  • Monitoring Disk Space of all Servers.
  • Implemented HA and DR plans including Always on High Availability
  • Configuring and Monitoring log shipping and Database mirroring on Disaster recovery Servers.
  • Worked extensively in 4 nodes Active / Passive and Active / Active Clustered Environments to increase scalability and stability of business-critical systems.
  • Database snapshot creation for synchronized databases for Reporting Purposes.
  • Capturing events using sql profiler for poor performing queries, deadlocks and blocks and studying execution plans and fine tuning applications.
  • Frequently performed database maintenance activities like DB stats updates, Index rebuild/reorganize, DB integrity checks to improve database performance.
  • Regularly generated SQL database health check reports and automated database reports using PowerShell scripting.
  • 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)
  • Implemented Database partition to improve performance.
  • Working with workflows for any changes on staging and development environment. Involved in internal and external audits and participating in business continuity plans of company.
  • Implemented company policies, technical procedures and standards for preserving integrity and security of data, reports and access.
  • Designed strategic plan for component development practices to support future projects.

Junior SQL DBA

Accenture
05.2018 - 07.2019
  • 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 24X7 monitoring systems.
  • Solved request raised by user support.
  • Participated in implementation of new releases into production.
  • Involved in Day-to-day administration of live SQL Servers.

Education

Bachelor of Science - Computer Science

JNTU
Hyderabad, India

Skills

  • Log-shipping
  • Transactional Replication
  • Performance management and Query tuning
  • Database schema creation and management
  • Backup and recovery
  • Ensuring data integrity
  • Always On High Availability and Database Mirroring
  • Database and Data security
  • General database management
  • Extensible data type administration
  • Excellent diagnostic skills
  • Enterprise technologies
  • TSQL and PowerShell scripting
  • Excellent communication skills
  • Data privacy applications
  • Excellent problem-solving abilities
  • Database design

Timeline

Senior Azure SQL DBA

FirstNational Financial
06.2022 - Current

SQL Server DBA

Accenture
07.2019 - 04.2021

Junior SQL DBA

Accenture
05.2018 - 07.2019

Bachelor of Science - Computer Science

JNTU

Similar Profiles

  • Grant Brandhoff

    Grant BrandhoffGrant Brandhoff

    Associate Financial Advisor at FourWord Financial and Voya FinancialAssociate Financial Advisor at FourWord Financial and Voya Financial

  • Debra Lark

    Debra LarkDebra Lark

    Financial Advisor at FIrst Financial Bancorp - FInancial Advisory ServiFinancial Advisor at FIrst Financial Bancorp - FInancial Advisory Servi

  • Cody Weisnicht

    Cody WeisnichtCody Weisnicht

    Client Service Representative at Threshold Financial-Ameriprise FinancialClient Service Representative at Threshold Financial-Ameriprise Financial

  • Scott Hunt

    Scott HuntScott Hunt

    Volunteer at Family BusinessVolunteer at Family Business

  • Daviaan Major

    Daviaan MajorDaviaan Major

    Laborer at No Worries ServicesLaborer at No Worries Services

CREATE PROFILE
Sahith Reddy