Sasi Kolli

SQL Server DBA

Email Id: ad1vnb@r.postjobfree.com

Ph No: 972-***-****

Professional Summary:

7+ Years of experience in SQL Development and Administration (MS SQL Server 2008/2012/2014/2016/2019) with an in-depth knowledge of DBA activities and development with T-SQL.

Good experience with Installation/configuration/Maintenance of Clustering, Log shipping, Mirroring, Replication and Always On availability solutions on SQL 2016 /2019.

Setting up Test, Development, Staging and Production environments as per the team requirements.

Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using ticketing tools.

SQL Server upgrades to the latest Service packs and migrations from version 2005 to SQL Server 2008 and from SQL Server 2008 to SQL Server 2012 /2016 and 2019.

Extensive troubleshooting skills on Performance issues, SQL Job Failures, Issues on high availability solutions and backup/restore issues.

Experience in creating and configuring new SQL Environments [Dev/QA and Staging] from scratch for the new application deployments.

Experience in manage and maintain all the lower DB environments up and available for development teams.

Extensive experience in Performance Tuning, identifying locks, dead locks, blocking and suggesting solutions to the dev teams to improve the query performance and avoid performance bottle necks.

Design and implement SQL Server standards and best practices for Installation /configuration and monitoring SQL Servers with T-SQL and PowerShell scripting.

Experience using Performance Monitor/Profiler/Extended events to solve dead locks, long running queries.

Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, and Activity Monitor for performance analysis.

Good experience in Data Migration between on prem SQL to Azure and SQL to SQL by using side-by-side upgrade process management.

Experience with Database consistency checks using DBCC & DMV’s Dynamic Management Views.

Proficient with performance monitoring, troubleshooting, security, database migration, high availability, and DR solutions.

Good experience in creating the server level and database level roles as per business requirement.

Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and another heterogeneous relational database such as Oracle and other databases.

Possess strong communication and problem-solving skills in troubleshooting database issues in all the DB environments.

Worked excessively on Idera to monitor the servers and created alerts and templates.

Worked collaboratively with the entire Engineering Team to better understand of the application needs and develop SQL queries, stored procedures accordingly.

AARP – SQL DBA/Developer (July 2020 – Till Date)

Responsibilities:

Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server 2008/2012/2014/2016/2019.

Configure and isolate the user Data, Logs and Tempdb files for Optimal performance.

Backing up database on Scheduled basis, periodically restoring it on a test environment to ensure the quality of backups.

Configure and maintain Transactional Replication to distribute data to multiple downstream applications.

Configure and manage SQL Always on Availability groups on SQL Server 2016 and 2019

Implemented SQL server encryption and decryption (TDE) on business-critical databases.

Responsible for disaster recovery and high-availability solutions.

Migrate existing SQL Server databases to Azure SQL and Azure SQL Managed Instance

Database refresh from production to lower environment as per the business requirements. Automated quarterly/monthly database refresh schedules.

Migrate databases from on prem SQL Server to Azure SQL database and Azure SQL Managed Instance

Performance Tuning of Stored Procedures, Queries.

Managed SQL server Logins, Database users & roles and involved in Daily User Maintenance.

Created Database Maintenance jobs to perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler.

Securing SQL Server, user management, and taking care of permissions and roles.

Providing Database Technical Support for Development Teams

Handle interactions with clients and project prioritization and scheduling.

Design recommendations as per the best practices of Microsoft SQL Server

Creating, optimizing, and modifying the SQL Server Agent jobs.

Documented various processes in confluence.

Monitor database growth activities & Troubleshoot Transaction Log growth Issues.

Automating the Database Maintenance tasks by creating Jobs.

Creating Queries, Stored Procedures, Functions, Triggers, Tables, Views for the development team.

T Mobile – SQL Developer/DBA (April 2018 – June 2020)

Responsibilities:

Monitors and manages SQL Servers and databases on a day-to-day basis.

Develop database designs, stored procedures, triggers, and constraints for new applications in MS SQL Server based on business requirement.

Perform database administration activities, including installation, patching, backup and recovery management, space management and schema management.

Perform monthly DB refresh from production to all the lower environments [Dev/QA and Staging] to get latest data to lower environments for testing

Wrote complex SQL queries using joins, stored procedures and user defined functions as per the business requirement.

Created Indexes and primary keys in Core environment to eliminate duplicates.

Creating users and assigning appropriate permissions.

Responsible for Performance Monitoring, Troubleshooting of SQL Server Database.

Involved in Designing, implementing, and maintaining the Databases.

Coordinating with development staff for code optimization techniques.

Creation of various data objects like Databases, tables, views, and indexes.

Job Scheduling, batch, alert, and Email notification setting.

Monitoring Server Activity & Performance.

Creating DB Maintenance Plans.

Monitoring SQL JOBS and running them manually upon failure notification.

Tuning and optimizing queries and indexes.

Involved in Security Administration- creating users and assigning them roles and privileges.

Involved in Database High Availability Solution Log Shipping.

Involved in Setting up the Replication.

Responsible for Database and Log backup & Restoration, Backup Strategies, and Scheduling Backups.

DST Systems – SQL Developer (Sept 2012 – Mar 2015)

Responsibilities:

Write SQL code to querying large datasets and extracted data from SQL Server.

Import and merge data to SQL Server from multiple sources for further analysis and reporting

Design and develop database objects, tables, stored procedures, views and triggers.

Performance Tuning of SQL queries, procedures and functions.

Creating Queries, Stored Procedures, Triggers, Tables, Views, Constraints as per requirements.

SSRS and SSIS in Business Intelligence Development Studio (BIDS) to create and deploy reports in MS SQL Server environment

SSRS to design different kinds of reports, such as planned, ad-hoc reports.

Export SQL server tables to flat files

Develop user defined functions and views

Configuring SQL jobs to run on schedule basis

Skill Set:

MS SQL Server : 2016/2014/2012/2008 R2/2008/2005

Windows Server : 2016/2012/2008 R2/2008/2003

Languages : TSQL, C, C++, HTML and XML

Database Tools : Sentry One /Idera SQL DM

Office Tools : MS Office, MS Word, MS Project, and MS PowerPoint

Education Summary:

Bachelor’s In Computer Science, Nagarjuna University

Certifications:

Microsoft Azure Fundamentals AZ-900

Contact this candidate