Sridhar Bonala

996-***-**** Email: ade0vz@r.postjobfree.com

PROFESSIONAL SUMMARY

Having 10 +Years of SQL DBA production support experience in Microsoft SQL Server 2000/20005/2008/2012/2014/ 2016 and 2017 Database Administration

Azure experience - extended working knowledge in cloud service, IaaS, PaaS, Azure AD. Configured NSGs for two tier applications. Experience in integrating on premises servers to Azure. Configured VNETs and subnets as per the project requirement. Configured Azure file servers. Configured private and public facing Azure load balancers etc.

SKILLS

SQL Server

Windows Server

Office365

MongoDB

Data science

Backups

Customer Service

SSIS BIDS tool

Azure Cloud

SSRS

CERTIFICATIONS

SQL Server 2016,2012

ITIL Foundation

Architecting Azure Solutions

WORK HISTORY

SQL Server Admin L3/SME: 12/2014 to FEB 2020

Infosys Hyderabad, Telangana

Client : APS

Azure SQL Server:

Design, implement and administer databases on MS SQL Server 2014/2016 platforms for OLTP

Migration of SQL Server Instances from 2008 R2 to,2014,2016

Migrating on-premises SQL Server Database to Confidential

Implemented new SQL Server features by performing successful POCs

Experienced in providing analysis on High availability/Disaster recovery & scalability

Experience in managing Very Large databases (VLDB) and troubleshooting problems

Played architect role for design RFS (New builds, migration activities )

Installing, upgrading and configuring Microsoft SQL Server 2005/2008/2012 /2014 & 2016 instances and its various components like Integration Services, Reporting Services, Client and Connectivity Tools and Analysis Services etc.

Good knowledge on managing SQL Logins, DB users, Roles and Authentication Modes, SQL Service packs & Hot fixes as a part of Security Policies for various categories

Installed & configured Oracle OEM Grid tool for SQL Server monitoring

Expertise in Backing Up, Restoring, and Moving Databases between servers.

Ensuring Point in Time and to the point of failure recovery of databases by implementing appropriate Backup and Recovery strategies.

Migrating or moving databases from one server to the other using Backup/Restore, Linked Servers

Experience in Data migration between Oracle and SQL Server using Linked Servers

Design & Implemented In-memory tables in 2016 OLTP database server

Use of Query Store feature for monitoring performance of database systems

Scripting PowerShell to automate database/Server level activities like monitoring disk space, Status of services etc.,

Good knowledge on Networking concepts and Protocols

Experienced in Securing data with Dynamic Data Masking, Always Encrypted, Row-level security

Designed ETL process to move CDC data for reporting purpose as per business needs

Configuring database instances for Development and Testing purpose

Experience in Windows Azure, migrating database to Azure

Designed Network Security Groups (NSGs) to control inbound and outbound access to network interfaces (NICs), VMs and subnets.

Leveraged VNET system routes and underlying route table that holds Local VNet Rules, On-premise Rules, Internet Rules and IP Forwarding as design basis.

Designed User Defined Routes with custom route tables for specific cases to force tunneling to the Internet via on premise network and control use of virtual appliances in the customer’s Azure environment.

LEVEL3 SR TEAM MEMBER 11/2011 to 12/2014

Tech Mahindra Hyderabad, Telangana

Client : ECX(OM)

Configuring database instances for Development and Testing purpose

Experience in Horizontal and Vertical Partitioning of tables to achieve better Performance and scalability

Fine Tuning Server/Database level setting for optimal performance

Responsible for schema & Data Migration using Sql Package & Right Fax tool from Dev, Test, and QA to Prod Environment

Proficient in PowerShell to monitor database servers’ health & status

Use of SSIS & SSDT for automated/Manual database deployments

Experienced in designing database and code with proper Isolation level to avoid locking and deadlock scenarios.

Implemented Indexes for faster response

Extensive experience in Troubleshooting and Query Tuning complex SQL Code, Stored Procedures, Triggers, Views etc., by analyzing wait stats, Execution plan & updating statistics

Proficient in analyzing I/O, CPU, Memory issues and providing fix using Ignite tool and DMVs

Troubleshooting log file space issues, tempDb contention

Ensuring Database security by restricting and following corporate standards

Perform query optimization & performance tuning using tools like SQL Profiler, SQL Query Analyzer, Index Tuning Wizard, Database Engine Tuning Advisor, DBCC commands, DMVs and Third-Party Tools like Ignite, SQL Sentry Plan Explorer, Dynatrace etc.,

LEVEL2 TEAM MEMBER 06/2009 to 08/2011

Zensar Technologies Pune, Maharashtra

Client : Danaher

Providing 24/7 support for critical production databases

Installation and Configuration of the SQL Server 2008 R2 and Business Intelligence.

Monitoring SQL Server and Windows event logs to find root cause for the problem.

Troubleshooting database level problems like suspect/emergency/single-user/restoring/stand-by modes.

Backing up the databases and restoring them when necessary/required.

Creating the jobs, manually executing and trouble-shooting the jobs.

Identifying orphaned users and fixing them after restoring the backups.

Shrinking the Database, Data file and T-Log files and freeing up the disk space.

Creating, monitoring and trouble-shooting maintenance plans created for rebuild-indexes, reorganize-indexes, statistics updates and database consistency checking.

Removing any unnecessary/ temporary jobs in the server created by the SSIS packages.

Shrinking the temp Database and resolving the disk space issue.

Creating users and mapping users with the appropriate databases and assigning the roles.

Performing the Database refresh by taking the backup and restoring and making the production equivalent.

Creating alerts for the databases to take necessary action before files reaches max size.

Identifying users’ workload and active transactions and what operation is going on take

Operating Systems: Windows Server 2003,2008,2012,2016

Windows XP, Vista, Windows 7,8,10

Tools & Utilities: SSMS, Activity monitor, Perfmon, Profiler, Task manager, BIDS,SSDT, Active Directory/Exchange/Security/Azure PowerShell modules, Azure CLI, Azure storage explorer, Microsoft Azure Data Sync, Enterprise vault discovery accelerator client, service now, TeamViewer,Putty,JIRA.

EDUCATION

MCA from Andhra University, Visakhapatnam during 2003- 2006

Contact this candidate