Sql Server Azure Data

Sridhar Bonala

888-***-**** Email: ******.*******@*****.*** www.linkedin.com/in/sridhar-bonala-9b0aa71a0

PROFESSIONAL SUMMARY

Having 16 +Years of SQL DBA and 5 + years Azure Data Factory, Azure Data bricks, Azure Data Lake Storage, Azure SQL Database, ADLS Gen2.

Cloud/Azure experience includes Azure Services, PaaS, laaS, and migrated from premises databases and Legacy databases to Azure, deployed on Azure, Setup development and test environment on Azure.

SKILLS

SQL Server

Azure SQL

Azure Data Lake

SSRS

Azure Databricks

SQL Always On

Azure Data Factory

SSIS BIDS tool

Azure Cloud

Azure cosmos DB

CERTIFICATIONS

SQL Server 2016, 2012.

Azure Data Engineer DP 200, DP 203

ITIL Foundation

Architecting Azure Solutions

WORK HISTORY

Azure Data Factory, Azure Databricks Azure SQL 11/2023 to till date

NexTurn Hyderabad, Telangana

Client: Harsco

Azure SQL Server:

Efficiently migrated on prime SQL Instance to both IaaS and PaaS in Azure Cloud.

Work experience on Change control management Status as PM /Leadership teams.

Managed a centralized MS SQL Server 2016, SQL 2012 and 2008R2 Platform consisting of thousands of mission critical databases.

Worked in High Availability and Recoverability of databases using standard MS SQL technologies including Always On.

Installed, Configured, and Maintained SQL Server 2019, 2017, and 2016 in development, test, and production environment.

Configured and Maintained Fail-Over Clustering using SQL Server 2019.

Experience in Always On environment.

Maintained server and database security including database encryption.

Monitored project status and health Issues management, Risk identification and mitigations.

Responsible for mentoring development team on best practices, tool usage etc.

Provided on Call Support for Prod mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end.

Ensuring that best practices and rules are enacted and enforced.

Participate in software design reviews with developers to ensure that the architecture is scalable to meet long-term performance goals.

Installed and Configured SQL Server Reporting Services (SSRS)

Automated SQL Database servers using automated scripts

Performed root cause analysis on external and internal processes and data to identify opportunities for improvement.

Responsible for capturing various database, server, and application metrics, observing trends that will help longer-term capacity planning and analysis efforts.

Processed that support data transformation, workload management, data structures, dependency, and metadata.

Outstanding leadership and organizational skills, communication skills, problem-solving ability

Extensive experience in Handling hiring process.

Azure SQL, Azure Migrations, ADF, ADB Senior consultant: 10/2020 to 11/2023

TCS Hyderabad, Telangana

Client: PANASONIC

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 2017,2019

Implemented new SQL Server features by performing successful POCs

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

Developed and deployed different types of Reports using different data sources like SQL Server, Excel, CSV files.

Managed SQL Server databases through multiple project lifecycle environments, from development to mission-critical production systems.

Design, setup administrator Always On high-availability (HA) and Disaster recovery (DR) solution in SQL Server 2019.

Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.

Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server.

Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues

Created Azure Data Lake Storage (ADLS) (Gen 1 and Gen 2) and Ingested the Data from Flat files, CSV Files, Json Files and On-Premises Database Tables using Azure Data Factory (ADF)

Performed database and SQL/TSQL Performance Tuning

Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers

Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification

Developed Different Maintenance Plans for database monitoring

Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications

Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check)

Developed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources

Deployed SSIS packages to move data across server, move logins, load data from different data sources.

Setup jobs from SSIS Packages

Used Imp/Exp. Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources

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

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

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.,

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

Designed ETL process to move CDC data for reporting purposes 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-premises Rules, Internet Rules and IP Forwarding as design basis.

Azure SQL, SME Team Lead: 12/2014 to 02/ 2020

Infosys Hyderabad, Telangana

Client: APS

Azure SQL Server:

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

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

Migrating on-premises to SQL Server Database to Cloud

Implemented new SQL Server features by performing successful POCs

Implemented & managed database clustering, failover and load balance technologies as per client requirement.

Moved SSIS packages from On-premises to cloud using Azure Data Factory (ADF) and Azure Data Bricks (ADB).

Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse and backwards.

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

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

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 of managing SQL Logins, DB users, Roles and Authentication Modes, SQL Service packs & Hot fixes as a part of Security Policies for various categories

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 azure and SQL Server using Linked Servers.

SQL DBA L3 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

SQL DBA 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.

Back up the databases and restore 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.

TECHNICAL SKILLS:

Database Expertise: SQL Server 2019,2017,2016,2014, 2012, 2008 R2, 2005.

Database Migration: SQL Server to SQL Server, SQL Server to Azure Cloud

Operating System: Windows Server 2012, 2008 R2, 2003 R2, 2000, VMware

Languages: SQL, T - SQL

Cloud/Azure: Azure Services, PaaS, laaS, Migrated on premises databases

ETL/Data Warehouse Tools: SSIS/DTS, Azure Data factory

Reporting: SSRS (SQL Server Reporting Services)

Third Party Tools: SolarWinds

EDUCATION

MCA from Andhra University, Visakhapatnam during 2003- 2006

Contact this candidate