Name: Srinivasa Reddy
Email id: [Link]@[Link]
Mobile No: +91-9967558368
SQL SERVER & AZURE ADMINISTRATION
Professional Summary:
• 6.5 years of IT experience in Database Administration, Maintenance and Support of MS SQL Server
(2016/2014/2012/2008R2) in Production, Test, Development Environments
• Experience in Database Administration on Production Servers with server configuration, performance
maintenance with outstanding troubleshooting capabilities.
• Working experience on Database Refresh in different environments (Preproduction to Production)
• Experience in Database administration activities for Database Security (creating logins, users, roles, and
assigning permission to them).
• Hands on experience in database backup and recovery procedures.
• Experienced in Always-On Availability Groups (AAG) and Implemented Always-ON (AAG) on SQL Server
2014/2016 with two readable replicas on Preproduction and Production servers.
• Experienced in Handling SQL Server Instances on Cluster environment for Windows Server (Physical and
Virtualization servers) built on SAN using RAID levels.
• Experience in Database Log Shipping process and Transactional Replications.
• Experience in SSIS (Integration Services) and TSQL statements. .
• Experience in processing the source files (Flat files, Excel files) to Data warehouse in
Daily/Weekly/Monthly activities using SQL Server Jobs (SSIS packages and TSQL Statements).
• Experience in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Experience in identifying the issues related to SSIS and troubleshooting them whenever the failure
notifications alerts are triggered.
• Working Knowledge on SQL Performance (Index maintenance, Statistics, Isolation levels, Locks,
Blockings, Wait Types, I/O and Memory Management).
• Experience in Rebuilding the indexes at regular intervals for better performance.
• Analyzing the scripts before deploying on production servers. .
• Experience in using DMV and dynamic management functions for finding out long running queries.
Azure (IaaS & PaaS)
• Creating Azure Virtual Machines both Windows and Linux and Azure Virtual Machine Images (including
SQL Server)
• Understanding of Regions, Availability Zones and Availability Sets.
• Working exposure to different types of Storage available (Blob, File, Queue, Table)
• Understanding on Premium/Standard Storage accounts.
• Creating Shared Storage using File and sharing the files across multiple VMs.
• Creating Blob Storage for storing files, SQL Server Backups and VHDX images.
• Deeper understanding on Networking Components (Virtual Networks, Subnets, VNet Peering, VPNs,
Remote Access to Servers, Private-Public IPs, Load Balancers & Gateways), ExpressRoute.
• Managing Firewall (NSG) rules to VMs and following security norms of Organization.
• Understanding of Active Directory on Azure (Azure AD Connect service)
• Migrating Virtual Machines On-Prem to Azure IaaS VMs (using Azure Site Recovery)
• Creating/configuring Azure SQL Databases (PaaS/DBaaS)
• Using DTU Calculator to assess On-Prem workloads to move to appropriate Service Tiers.
• Creating/Configuring Azure Elastic Pools and Elastic Jobs to automate tasks on SQL Database.
• Exporting BACPAC from Azure SQL Databases.
• Migrating On-Prem Databases to Azure SQL Databases using DMA and exposure to DMA/SSMA tools for
On-Prem and Azure migrations.
Education:
M. TECH | 2012 | JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY
Major: Software Engineering.
Experience:
Working as [Link] Administrator in Capgemini, Mumbai from April 2015 till date.
Worked as SQL Server DBA in Sidhi Infotech, Bangalore from Feb 2013 to March 2015
Technical Skills
· Operating Systems: Windows Server 2003, 2008R2, 2012.2012R2, 2016.
· Databases: MSSQL Server 2008-2016 versions
· ETL Tool: SSIS
· Cloud Computing: Microsoft Azure ( IAAS| PAAS)
· Tools: SSMS, Activity Monitor, Service Now
Projects
1. DATABASE ADMINISTRATOR | CAPGEMINI | APRIL 2015 TILL
DATE CLIENTS | VERTIV CORP and HPE |TEAM | 4.
Installing SQL Server 2008/2008 R2/2012/2014/2016 Standalone Server.
Refreshing Databases as Per Client Request.
Deploying SSIS Packages on UAT and PROD Environments.
Migrating and Upgrading the Databases as Per Requirement.
Troubleshooting The Failed Jobs Based On Alerts.
Configuring the Refresh, Backup, Reorg, Rebuild and Update Statistics Jobs.
Resolving Blocking, TempDB and Space Issues.
Creating Logins, Users and Giving Required Permissions.
Administering and Troubleshooting High Availability Solutions like Log Shipping,
Mirroring Replication and Clustering.
Monitoring and Troubleshooting Server Performance by Using Performance Monitor and Logs.
Identifying and Resolving Blocking and Deadlocking Issues.
Identifying and Troubleshooting SQL Server Using DBCC Commands & DMV’s.
Handling and Solving Operation Calls and Tickets According to Their Priority.
Creating CR’s for Every Customer-Raised Request and from Users, Application Team.
Monitoring, Reviewing & Approving Change Records with 100% SLA.
Strong Knowledge On Clustering and Handling Active-Active Configuration (Patching, Adding
Node, Adding New Disks and Configuring Disk Dependency, Failover, Troubleshooting)
Working Knowledge on Always-On AG and Handled Primary and Two Secondary Replica
Configurations. Also Performed Failover and Troubleshooting of Availability Groups.
Keeping The Track of All Critical Databases & Server Related Information in Inventory.
ENVIRONMENT: WINDOWS ENTERPRISE SERVER 2008R2, 2012, 2016. SQL SERVER
2005, 2008R2, 2012, 2014, 2016. SERVICE NOW,
2. DATABASE ADMINISTRATOR | SIDHI INFOTECH | FEB 2013
TO APRIL 2015 |CLIENTS | USP |TEAM | 8.
Installing SQL Server 2008/2008 R2/2012.
Installing SQL server 2008R2 and 2012 fail over cluster.
Refreshing databases as per client request.
Migrating and upgrading the databases as per requirement.
Troubleshooting the failed jobs based on alerts.
Configuring the refresh, backup, reorg, rebuild and update statistics jobs.
Resolving blocking, TempDB and space issues.
Creating Logins, Users and giving required permissions.
Administering and Troubleshooting High Availability Solutions like Log Shipping, Mirroring.
Monitoring and troubleshooting server performance by using Performance monitor and Logs.
Identifying and Resolving Blocking and Deadlocking Issues.
Handling and Solving Operation Calls and Tickets According to Their Priority.
Creating CR’s for every Customer-raised request and from users, application team.
Monitoring, Reviewing & approving change records with 100% SLA.
Strong knowledge on Clustering and handling Active-Active configuration (Patching, Adding
Node, Adding New Disks and configuring Disk Dependency, Failover, Troubleshooting)
Keeping the track of all critical databases & server related information in inventory.
ENVIRONMENT: WINDOWS ENTERPRISE SERVER 2008R2. SQL SERVER 2008,
2008R2, 2012.