Adinarayana Reddy Kasa profile photo 1 on Tal

Adinarayana Reddy Kasa

Lead Administrator | SQL Server DBA |

Greater Hyderabad Area

9+ years of work experience

Wipro
Sep 20214 yrs 11 mosPresent

Hyderabad, Telangana, India

• Moving databases from Prod to Dev/Test servers and vise verse based on requests. • Database Refresh from On-Prem SQL Servers to Azure VM’s and vise-verse. • Working on daily requests on the database changes. • Troubleshooting on job failure alerts. • Granting permissions to users as per policies and security standards. • Performing Operation testing and validate the server and configuring database engine and SQL server as per standards on pre-live servers. • Involved in operational acceptance testing and responsible to make any changes on DB. • Backup and restoring the databases in order to meet business RPO and RTO. • Configured TDE with Azure Key Vault for the Databases in AlwaysOn in Azure VM’s. • Performed DR test (AlwaysOn, DB Mirroring) on Prod and DR servers. • Worked on transaction replication and troubleshooting the issues. • Patched MSSQL to the latest patch level on 2012, 2016 and 2019 Server’s to resolve security vulnerabilities. • Patching Linux servers through Jenkins pipelines. • Performed DB migration from older servers to new built servers. • DB Migration from On-Prem to Azure Cloud by using DMA and DMS. • Performed DB Upgradation from 2012 to 2016 SQL Version. • Created SSIS packages from Excel Source to OLEDB destination to load data on daily / monthly basis. • Configured SQL Agent jobs after creating and deployed package in SQL Server Integration service. • Reviewing and troubleshooting the security vulnerabilities on SQL Server. • Troubleshooting on performance issues like Log, data file / folder full, slow running queries, CPU and Memory utilization. • Created and renewed SSL certificates and map to SQL Servers.
Infosys BPM
Aug 20192 yrs 3 mosOct 2021

Hyderabad, Telangana, India

• Implementing and administrating the database policies and procedures. • Setting up security on server level, database level, object level. • Performing the daily tasks including job fails and troubleshooting issues. • Monitoring disk spaces on all the server and reducing disk sizes by deleting the older backups and other unwanted files. • Identifying the blocking issues and killing the process by getting approvals from client discussions and their suggestions. • Scheduling and maintained routine jobs, alerts and maintenance plans. • Recovered the databases with backups in case of disaster. • Managing security of the database. • Performed standalone and Clustered installations of SQL Server. • Worked on two node (active \ passive) SQL server cluster environment and monitoring through cluster administrator. • Implementing the database security, creating logins, users and assigned permissions and roles. • Rebuilding / monitoring the indexes at regular intervals for better performance. Maintaining indexes and fragmented indexes. • Providing 24/7 support for production, development and test servers on MSSQL servers.
RMSI
Jun 20172 yrs 3 mosAug 2019

Hyderabad, Telangana, India

• Installation, configure and maintained SQL Server. • Creation of new databases, tables, user and assigning permissions. • Schedule backups and restoring databases as per defined backup policy. • Applying services and hot-fixes • Creating users in server and database level and assigning required privileges. • Shrinking transnational logs and database as per requirement. • Moving database from one location to other location. • Performed database refresh activities from Prod to Dev/QA. • Checking status of backup, troubleshooting the failed backups and restoration & recovery of databases. • Implemented and maintained Log shipping and Database Mirroring.

Education

Bachelor of Technology, Mechanical Engineering

Malla Reddy College of Engineering & Technology

20124 yrs2016

Intermediate, MPC

Andhra Pradesh board of Intermediate

20102 yrs2012

Join Adinarayana and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Adinarayana Reddy Kasa on Tal

Headline

Lead Administrator | SQL Server DBA |

About

Seasoned SQL Server Database Administrator with 8 years of proven expertise in managing, optimizing, and securing enterprise-grade database environments. Proficient in SQL Server installation, configuration, upgrades, and performance tuning, with a strong focus on automation and operational efficiency. Experienced in implementing high availability solutions including Always On Availability Groups, Failover Clustering, Log Shipping, and Database Mirroring. Skilled in designing and executing robust backup and recovery strategies, query optimization, indexing, and proactive resource monitoring to ensure business continuity. Adept at troubleshooting complex production issues under pressure and leveraging PowerShell and T-SQL scripting to streamline processes, enhance reliability, and reduce manual effort. Dedicated to delivering secure, stable, and high-performance database solutions that drive organizational growth and resilience.

Location

Greater Hyderabad Area

Work experience

Lead Administrator at Wipro, Sep 2021 - Present · 4 yrs 11 mos, Hyderabad, Telangana, India, • Moving databases from Prod to Dev/Test servers and vise verse based on requests. • Database Refresh from On-Prem SQL Servers to Azure VM’s and vise-verse. • Working on daily requests on the database changes. • Troubleshooting on job failure alerts. • Granting permissions to users as per policies and security standards. • Performing Operation testing and validate the server and configuring database engine and SQL server as per standards on pre-live servers. • Involved in operational acceptance testing and responsible to make any changes on DB. • Backup and restoring the databases in order to meet business RPO and RTO. • Configured TDE with Azure Key Vault for the Databases in AlwaysOn in Azure VM’s. • Performed DR test (AlwaysOn, DB Mirroring) on Prod and DR servers. • Worked on transaction replication and troubleshooting the issues. • Patched MSSQL to the latest patch level on 2012, 2016 and 2019 Server’s to resolve security vulnerabilities. • Patching Linux servers through Jenkins pipelines. • Performed DB migration from older servers to new built servers. • DB Migration from On-Prem to Azure Cloud by using DMA and DMS. • Performed DB Upgradation from 2012 to 2016 SQL Version. • Created SSIS packages from Excel Source to OLEDB destination to load data on daily / monthly basis. • Configured SQL Agent jobs after creating and deployed package in SQL Server Integration service. • Reviewing and troubleshooting the security vulnerabilities on SQL Server. • Troubleshooting on performance issues like Log, data file / folder full, slow running queries, CPU and Memory utilization. • Created and renewed SSL certificates and map to SQL Servers.

Senior Process Executive at Infosys BPM, Aug 2019 - Oct 2021 · 2 yrs 3 mos, Hyderabad, Telangana, India, • Implementing and administrating the database policies and procedures. • Setting up security on server level, database level, object level. • Performing the daily tasks including job fails and troubleshooting issues. • Monitoring disk spaces on all the server and reducing disk sizes by deleting the older backups and other unwanted files. • Identifying the blocking issues and killing the process by getting approvals from client discussions and their suggestions. • Scheduling and maintained routine jobs, alerts and maintenance plans. • Recovered the databases with backups in case of disaster. • Managing security of the database. • Performed standalone and Clustered installations of SQL Server. • Worked on two node (active \ passive) SQL server cluster environment and monitoring through cluster administrator. • Implementing the database security, creating logins, users and assigned permissions and roles. • Rebuilding / monitoring the indexes at regular intervals for better performance. Maintaining indexes and fragmented indexes. • Providing 24/7 support for production, development and test servers on MSSQL servers.

GIS Engineer at RMSI, Jun 2017 - Aug 2019 · 2 yrs 3 mos, Hyderabad, Telangana, India, • Installation, configure and maintained SQL Server. • Creation of new databases, tables, user and assigning permissions. • Schedule backups and restoring databases as per defined backup policy. • Applying services and hot-fixes • Creating users in server and database level and assigning required privileges. • Shrinking transnational logs and database as per requirement. • Moving database from one location to other location. • Performed database refresh activities from Prod to Dev/QA. • Checking status of backup, troubleshooting the failed backups and restoration & recovery of databases. • Implemented and maintained Log shipping and Database Mirroring.

Education

Bachelor of Technology, Mechanical Engineering, Malla Reddy College of Engineering & Technology

Intermediate, MPC, Andhra Pradesh board of Intermediate

Adinarayana Reddy Kasa - Lead Administrator in Greater Hyderabad Area | Tal