Summary
Overview
Work History
Education
Skills
Work Availability
Timeline
Generic

SHEKHAR ATHINENI

Infra Technology Specialist
Hyderabad

Summary

A highly skilled and experienced SQL DBA with a track record of successful database management. Seeking a challenging role where I can utilize my expertise to optimize database performance, security, and scalability.

Overview

7
7
years of professional experience
4
4
years of post-secondary education

Work History

SQL Server DBA

COGNIZANT
Hyderabad
09.2021 - Current
  • SQL DBA with hands-on experience in Installation, Configuration and Administration of SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019, 2022
  • Certified by Microsoft MCSA SQL Server 2016 Database Administration
  • Certified by Microsoft Azure Database Administrator (DP-300)
  • Hands on experience in installing SQL Server through Unattended, Slipstream
  • Experience on SQL Server patching like applying Service packs, Cumulative updates
  • Hands on experience in installation and configuration of SQL Reporting server
  • Hands on experience in installation and configuration of SQL Server Integration services
  • Having good experience in DIME (Data in motion encryption), TDE (Transparent Data encryption) encryptions
  • Upgradation and Migration of SQL 2005/2008 DBs to SQL 2008R2/2012, SQL 2008 /2008R2 to 2012/2014/2016/2017/2019/2022
  • Knowledge in different types of backups and troubleshooting
  • Knowledge on recovering databases during the disaster and has knowledge on page level restore and point in time restore
  • Implemented Backup strategy and Point-in-time recovery for production and development environments Based on RPO and RTO in SLA
  • Experience in Recovering system Databases during the corruptions
  • Monitoring and maintenance of servers in Production /Test/UAT/Dev Environments
  • Experience in configuring and maintaining the SQL Server DR feature like Log Shipping
  • Configuring and maintaining HA features like DB Mirroring, Replication & Clustering
  • Configuring and Validating Windows Cluster configuration and SQL Server Clustered instances on Physical as well as Virtual Environments
  • Experience in configuring and maintaining Always On Availability Groups
  • Good knowledge in T-SQL, developed SP, Triggers and Views
  • Managing Security by creating users, logins, roles and granting permissions as per the request with approval
  • Monitoring performance issues and troubleshooting
  • Fixing orphaned users using stored procedures
  • Performed Table partitioning and data archival activities for very large Databases (VLDB) for better performance
  • Daily activities like monitoring Databases, Jobs, error logs, log files size and free space in the data drives and connectivity of the databases
  • Having experience in troubleshooting when the Temp DB and Log File full
  • Managed Disk I/O, CPU and Memory bottle neck for better performance
  • Performed Query optimization, indexing, and troubleshooting SQL Server related issues
  • Having experience on moving System databases
  • Good experience in resolving Blockings & Deadlock issues
  • Rebuilding or Re-organizing indexes based on the fragmentation percentage
  • Creating Linked server and re-indexing update stats jobs
  • Having experience on troubleshooting I\O errors, SSPI Handshake and stack dump errors
  • Having experience in attending CAB meetings and Troubleshooting calls
  • Resolve incidents and service requests as per the agreed SLAs and timelines
  • Responsible for gathering/analyzing client requirements by interacting with them on a regular basis to provide post implementation support
  • Good communication skills and great team player with a reputation of integrity, strong analytical and problem-solving skills, Self-motivated and Proactive person
  • Good experience on Azure services Like Azure VM, VNet and Resource groups
  • Having experience in Migrating On-prem databases to Azure Cloud using DMA, Azure Database Migration service
  • Having experience in Migrating On-prem Sybase, DB2, Oracle databases to Azure SQL by using SSMA tool
  • Provide technical support and guidance to developers, end-users, and ensure database documentation is up-to-date.

Senior Software Engineer

Bharat Financial
Hyderabad
10.2019 - 08.2021
  • SQL Server DBA with hands-on experience in Installation, Configuration and Administration of SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019, 2022.
  • Certified by Microsoft MCSA SQL Server 2016 Database Administration.
  • Certified by Microsoft Azure Database Administrator (DP-300).
    Hands on experience in installing SQL Server through Unattended, Slipstream.
  • Experience on SQL Server patching like applying Service packs, Cumulative updates.
  • Hands on experience in installation and configuration of SQL Reporting server.
  • Hands on experience in installation and configuration of SQL Server Integration services.
  • Having good experience in DIME (Data in motion encryption), TDE (Transparent Data encryption) encryptions.
  • Upgradation and Migration of SQL 2005/2008 DBs to SQL 2008R2/2012, SQL 2008 /2008R2 to 2012/2014/2016/2017/2019/2022.
  • Knowledge in different types of backups and troubleshooting.
  • Knowledge on recovering databases during the disaster and has knowledge on page level restore and point in time restore.
  • Implemented Backup strategy and Point-in-time recovery for production and development environments Based on RPO and RTO in SLA.
  • Experience in Recovering system Databases during the corruptions.
    Monitoring and maintenance of servers in Production /Test/UAT/Dev Environments.
  • Experience in configuring and maintaining the SQL Server DR feature like Log Shipping.
  • Configuring and maintaining HA features like DB Mirroring, Replication & Clustering.
  • Configuring and Validating Windows Cluster configuration and SQL Server Clustered instances on Physical as well as Virtual Environments.
  • Experience in configuring and maintaining Always On Availability Groups.
  • Good knowledge in T-SQL, developed SP, Triggers and Views.
    Managing Security by creating users, logins, roles and granting permissions as per the request with approval.
  • Monitoring performance issues and troubleshooting.
  • Fixing orphaned users using stored procedures.
  • Performed Table partitioning and data archival activities for very large Databases (VLDB) for better performance.
  • Daily activities like monitoring Databases, Jobs, error logs, log files size and free space in the data drives and connectivity of the databases.
  • Having experience in troubleshooting when the Temp DB and Log File full.
  • Managed Disk I/O, CPU and Memory bottle neck for better performance.
  • Performed Query optimization, indexing, and troubleshooting SQL Server related issues.
  • Having experience on moving System databases.
  • Good experience in resolving Blockings & Deadlock issues.
  • Rebuilding or Re-organizing indexes based on the fragmentation percentage.
  • Creating Linked server and re-indexing update stats jobs.
  • Having experience on troubleshooting I\O errors, SSPI Handshake and stack dump errors.
  • Having experience in attending CAB meetings and Troubleshooting calls.
  • Resolve incidents and service requests as per the agreed SLAs and timelines.
  • Responsible for gathering/analyzing client requirements by interacting with them on a regular basis to provide post implementation support.
  • Good communication skills and great team player with a reputation of integrity, strong analytical and problem-solving skills, Self-motivated and Proactive person.
  • Good experience on Azure services Like Azure VM, VNet and Resource groups.
  • Having experience in Migrating On-prem databases to Azure Cloud using DMA, Azure Database Migration service.
  • Having experience in Migrating On-prem Sybase, DB2, Oracle databases to Azure SQL by using SSMA tool.
  • Provide technical support and guidance to developers, end-users, and ensure database documentation is up-to-date.
  • Worked with project managers, developers, quality assurance and customers to resolve technical issues.
  • Checked client code for bugs and weaknesses using approved troubleshooting methods.

SQL Database Administrator

ICICI BANK LTD, VARA INFOTECH
Hyderabad
11.2016 - 09.2019
  • ICICI Bank, stands for Industrial Credit and Investment Corporation of India, it is an Indian multinational banking and financial services company headquartered in Mumbai, Maharashtra, India, with its registered office in Vadodara
  • In 2017, it is the third largest bank in India in terms of assets and fourth in term of market capitalization
  • It offers a wide range of banking products and financial services for corporate and retail customers through a variety of delivery channels and specialized subsidiaries in the areas of investment banking, life, non-life insurance, venture capital and asset management
  • The bank has a vast network of 4,850 branches and 14,404 ATMs in India and has a presence in 19 countries including India
  • We offer the infrastructure, network, Windows and Database administration services for ICICI BANK LTD

Education

Bachelor of Science - Electrical, Electronics And Communications Engineering

Jawaharlal Nehru Technological University
Hyderabad
04.2008 - 04.2012

Skills

Technical Skillsundefined

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

SQL Server DBA

COGNIZANT
09.2021 - Current

Senior Software Engineer

Bharat Financial
10.2019 - 08.2021

SQL Database Administrator

ICICI BANK LTD, VARA INFOTECH
11.2016 - 09.2019

Bachelor of Science - Electrical, Electronics And Communications Engineering

Jawaharlal Nehru Technological University
04.2008 - 04.2012

Similar Profiles

CREATE PROFILE
SHEKHAR ATHINENIInfra Technology Specialist