NISHITHA KAVULURI

Nishitha.kavuluri@gmail.com
Mobile: +1 215-666-0636

Personal Brand Statement

Professional with an overall experience of 9+ in IT. My main area of experience has been into
Infrastructure services. I have worked primarily in the domain of Database Administration,
Application Support & Maintenance. My technological forte is SQL Server 2005, 2008 and 2008R2,
2012, 2014, 2016, 2017, 2019, and Azure SQL databases. Having 9+ years of experience as a
Microsoft SQL Server DBA and 3+ years of experience on Microsoft SQL Azure cloud.

Technical Exposure
 Technical expertise in Microsoft SQL Server (SQL server Production support 24x7)
 Administration, Installation, and configuration of SQL Server 2005, 2008 & 2008R2, 2012/2014,
2016, 2017 and 2019.
 Working on Migration / Upgradation of databases from SQL Server 2005 to 2008 R2 and 2008R2
to 2012, 2016, 2017, 2019 and from On-premises SQL Server to Azure cloud.
 Good experience in implementing High Availability & Disaster Recovery solutions using Always
ON, Clustering, Replication, Mirroring, and Log Shipping.
 Administration of Azure SQL databases with 10TB of database size.
 Migrating SQL servers from OnPrem to Azure using DMA, backup & restore method.
 Maintaining Azure SQL databases with ALWAYS-ON failover cluster high availability with six
nodes in 2 different data centers.
 Good Experience on all Azure PAAS, SAAS, and IAAS platforms.
 Designing new SQL servers & databases with Microsoft recommendations.
 Experience in creating and configuring Azure VMs, Azure managed Instance, and Azure SQL
databases.
 Designing the Azure setup for the customers and providing the QA, UAT, DEV, and PROD
environments in Azure.
 Working on Azure synapse Analysis and creating linked servers.
 Working on Azure DevOps.
 Migration of Azure SQL databases using the BACPAC file method.
 Experience in deploying SQL Databases in AZURE.
 Experience in SQL Server Licensing.
 Good experience in database Security.
 Experience with Robo copies from Onprem SQL server to Azure blob storage.
 Experience in Moving Data in and out of Windows Azure SQL Databases using SAS and Blob
Storage.
 Experience in Database migrations in Azure Managed Instance and Azure VM.
 Developed advanced SQL queries and stored procedures to generate data reports.
 Performed SQL Query performance tuning by creating/modifying indexes, setting transaction
isolation levels and changing query structures.
 Creating new Virtual machines in Azure portal.
 Experienced with VMWare, creating and managing Virtual Machines, troubleshot network, fire-
wall issues.
 Extending disk volumes for Azure SQL databases
 SQL Server licensing reports and reconciliation.
 Adding SQL node to the existing Always On failover Cluster.
 Applying monthly security patches on AlwaysOn Azure SQL cluster nodes.
 Planning OS upgrade from windows 2016 to 2019 along with Azure SQL Server cluster nodes.
 Adding CPU capacity to azure SQL Server nodes based on the requirement to scale up.
 Good Knowledge on SQL Server 2016 and 2017 features.
 Database development and administration of the SQL Databases with applications. Server
configuration, performance analysis/tuning and problem resolution using database performance
and analysis tools. Development of stored procedures, Extract-Transform Load (ETL) packages
and user-defined.
 Good Understanding & Knowledge on Cloud computing architecture, technical design and built
cloud service models including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and
Software as a Service (SaaS)
 Experienced with deployments, Maintenance and troubleshooting applications on Microsoft
Cloud infrastructure Azure.
 Automating deadlock capturing and server health\performance using Extended Events.
 Executing jobs through PowerShell scripts.
 Working on SQL Azure database.
 Troubleshooting long running Rebuild and Re-organize indexes.
 Good experience in SQL Database design & architecture.
 Good Experience in Backup & Recovery scenarios.
 Experience in applying Service Packs and hot fixes whenever required.
 Instinctive communicator with excellent interpersonal, analytical and problem-solving skills.
 Implemented the naming standards for the entities, attributes, alternate keys, and primary keys
for the logical model and physical model.
 Done Project Transitioning activities and Service Improvement Initiatives.
 Good experience in troubleshooting Performance related problems.
 Handling P1 / P2 / P3 incidents, Changes, Service requests within the SLA timeframes.
 Good Experience in Onboarding of new servers and new clients.
 Exemplary experience in supporting and managing multiple Production, Staging, Development
instances.
 Proficient in Creation of database maintenance plans, rebuild/defrag indexes, integrity checks.
Creation of TSQL scripts for full, differential, transaction log backups, optimizations, and in-
tegrity.
 Good experience on server and database security management, creating groups, users, roles,
granting permissions, policies.
 Provide Database Health and Performance reports. This includes Database Size and Capacity
Trend, Summary of Database configuration changes, Database Availability and Backup Failed
Jobs.
 Experience in supporting huge databases, troubleshooting the problems and documentation.
 Experience on SSIS packages configuration, execution, and troubleshooting.
 Experience in using Business Intelligence tools (SSIS & SSRS).
 Worked Extensively on ETL process using SSIS package.
 Data analysis and data migration by transferring them using SSIS packages.
 Developing reports on SSRS on SQL Server.
 Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent,
and scheduling DTS/SSIS Packages.
 Experience in configuring SSRS and upgrading the encryption keys.
 Knowledge of Oracle DBA & Netezza DBA.

Professional Certifications
 70-900: Microsoft Azure fundamentals
 70-533: Implementing Microsoft Azure Infrastructure Solutions.
 70-462: Administering a Microsoft SQL Server 2012 & 2014 Database.
 Microsoft SQL Server 2008, Implementation and Maintenance (432).
 Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL
Server 2008 (450)
 MCITP- Microsoft Certified IT Professional SQL Server 2008.

Achievements:
 Awarded as Best Employee of the year 2018 from data Intensity.

PROJECTS HISTORY
Responsibilities at Infosys SEP 2021 to Dec 2021
Role: Technology Lead:

  Experience in Azure environments

  Create, maintain, and execute SQL Server jobs\
  Experience with cloud database backup and transaction recovery techniques
  Migrate SQL server database from on-premise to Azure IAAS/PAAS Migration using Azure.
  Regular MS SQL DBA activities - expertise around DB configurations
  Experience with Azure PaaS databases
  Experience with complex t-SQL queries
 Expertise in performance troubleshooting & tuning
 Good understanding of various performance monitoring tools and metrics available within
Azure SQL
 Good understanding of Azure DB backup and recovery terminologies
 Good understanding of Azure SQL HA/DR features
 Able to handle issues independently.
 Hands-on experience in converting design documents into workable solutions for Azure SQL
 Experience working with all high Availability Concepts including Always-On, and Log Shipping.
Replication.
  Experience in Azure environments
  Implement, configure, and maintain the performance of critical SQL Server RDBMS systems, to
ensure the availability and consistent performance of our corporate applications
 Manage AZURE SQL Server databases through multiple product lifecycle environments, from
development to mission-critical production systems
 Monitor performance, availability, and security of databases and associated processes, and
remediate issues as they arise to provide fast responses to front-end users
 Develop data solutions that utilize cloud-based technologies and platforms.
 Joining Bridge calls whenever needed and troubleshooting the issues within SLA.
 SQL Server licensing reports and reconciliation.
 Designing and provisioning databases on the QA, UAT, DEV, and PROD environments.
 Experience in database Security.
 Handling all kinds of operational issues related to the environment
 Deciding on a proper database Backup strategy & restoration policy and Retention policy.
 Handling team and maintaining a 24/7 environment to support business.
 Develop, implement, and maintain change control and testing processes for modifications to
databases.
 Worked on Always-on Availability group configuration and troubleshooting
 Performed SQL SERVER Patching and Cluster patching on SQL SERVERS.
 Disaster Recovery Failover or for all High availability concepts.
 Assisting clients to go with the best high-availability solution for their business.
 Worked on all kinds of High availability concepts in SQL Server
 Good knowledge of server and database security management, creating groups, users, roles,
granting permissions, and policies.
 Exemplary experience in supporting and managing multiple Production, Staging, and
Development instances.
 Handling outages during Application failures due to database issues or directly Database
failures.
 Documenting and constantly updating the standards, environment, and backup, disk space in-
formation.

Responsibilities at NTTDATA/ BCBSRI, Apr 2021 to Aug 2021

Role: Azure SQL DBA:
 Administration of Azure SQL databases with 20TB of database size.
 Experience in SQL Server Licensing.
 Designing Azure setup for UAT, DEV, and PROD environments as per client requirements.
 Configuring Azure managed Instance, Azure SQL databases.
 Creating Azure VMs and Installing SQL servers as per the best recommendations from
Microsoft.
 Upgrading SQL servers from 2008, 2012, 2014 to 2017 & 2019 as per the application
compatibility.
 Maintaining the PHI and PII data with data masking.
 Planning and Migrating SQL servers from OnPrem to Azure using DMA, backup & restore
method and through log-shipping.
 Database migrations through SAS from on prem to Azure managed Instance.
 Creating and troubleshooting MSDTC services.
 Following and working on Azure Advisory recommendations for smooth running of SQL
databases.
 Creating private endpoints in for Azure resource Groups.
 Experience on DevOps moving the data to GitHub maintaining branches.
 Performance tuning of all on prem SQL databases and Azure SQL databases.
 Performing day to day activities such as planning backup strategies, scheduling maintenance
jobs.
 Documenting and constantly updating the standards, environment and backup, disk space
information.
 Communicating with client on daily basis to discuss on going activities.
 Exemplary experience in supporting and managing multiple Production, Staging, Development
instances
 Performed SQL SERVER Patching and Always on Cluster patching.
 Configuring SSRS and migrating SSRS from Onprem to Azure.
 Multitasking capacity to meet the SLA under tight deadlines.
 Handling P1 / P2 / P3 incidents, Changes, Service requests within the SLA timeframes.
 Assisting customer to go with the best high availability solution for their business.
 Played a key role in Migration plans & dates of all SQL server and Oracle databases.

Responsibilities at INFOSYS /Microsoft, July 2020 to Oct 2020

Role: Technology Lead:
 Administration of Azure SQL databases with 10TB of database size.
 Migrating SQL servers from OnPrem to Azure using DMA, backup & restore method and
through log-shipping.
 Maintaining Azure SQL databases with ALWAYS-ON failover cluster high availability with six
nodes in 2 different data centers.
 Experience in deploying Azure SQL Databases.
 Experience with Robo copies from Onprem SQL server to Azure blob storage.
 Experience in Moving Data in and out of Windows Azure SQL Databases and Blob Storage.
 Creating new Virtual machines in Azure portal.
 Extending disk volumes for Azure SQL databases.
 Applying monthly security patches on all Azure SQL cluster nodes.
 Planning OS upgrade from windows 2016 to 2019 along with SQL Server cluster nodes.
 Adding CPU capacity to azure SQL Server nodes based on the requirement to scale up.
 Troubleshooting long running Rebuild and re-organize indexes.
 Adding multiple tempdb files as a part of performance tuning.
 Performing day to day activities such as planning backup strategies, scheduling jobs.
 Creating maintenance plans and scheduling them without conflicting with other jobs.
 Creating T-log backups through log shipping for all Azure SQL databases.
 Generating reports of Azure SQL Server health reports.
 Handling outages during Application failures due to database issues or directly Database
failures.
 Documenting and constantly updating the standards, environment and backup, disk space
information.
 Communicating with client on daily basis to discuss on going activities.
 Handling the escalation calls with the customers.
 Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent,
and schedule DTS/SSIS Packages.
Responsibilities at Plant Infotech/ GE HealthCare Jan 2019 to Jan 2020
Role: Sr SQL Server DBA:
 Administration of 250+ servers and 2000+ databases with 2TB of database size.
 Handling the escalation calls with the client.
 Designing new databases with Microsoft recommendations.
 Experience working with Azure SQL Database Import and Export Service.
 Develop, implement, and maintain change control and testing processes for modifications to
databases.
 Track blocking, deadlocks, long-running queries, and high-resource consuming queries.
 Automating deadlock capturing using Extended Events.
 Worked on Always on Availability group configuration and troubleshooting
 Performed SQL SERVER Patching and Cluster patching on SQL SERVER 2008R2.
 Disaster Recovery Failover over for all High availability concepts.
 Assisting client to go with the best high availability solution for their business.
 Worked on all kinds of High availability concepts in SQL Server
 Multitasking credentials with excellent planning, execution, monitoring, as well as the ability to
handle multiple tasks in high-pressure environments and under tight deadlines.
 Good knowledge of server and database security management, creating groups, users, roles,
granting permissions, policies.
 Exemplary experience in supporting and managing multiple Production, Staging, Development
instances.
 Handling outages during Application failures due to database issues or directly Database
failures.
 Documenting and constantly updating the standards, environment and backup, disk space infor -
mation.
 Refresh databases for Development, Test and production servers.
 Daily, weekly and monthly reporting to Management.
 Good experience in 3rd party monitoring tool like Idera SQL Safe, Idera SQL Diagnostic manager,
eMite, Site scope. Worked on ticketing tool like Service Now, VFire, Service desk management,
On Guard, support central.
 Worked Extensively on ETL process using SSIS package.
 Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent,
and schedule DTS/SSIS Packages.

Responsibilities at Data Intensity, May 2017 to Oct 2018

Role: Senior Consultant (SQL Server DBA):
 Handled 60+ different customers in the shared environment
 Dedicatedly handled 2 major customers – SPOC
 Experienced with deployments, Maintenance and troubleshooting applications on Microsoft
Cloud infrastructure Azure.
 Designed VNets and subscriptions to conform to Azure Network Limits.
 Experience troubleshooting automated backups and metric management.
 Ability to select correct tier for Azure SQL Databases and Azure SQL Date warehouses.
 Experience in Horizontal and Vertical Partitioning of tables to achieve better Performance and
scalability in SQL Azure.
 Onboarding new customers and handling meetings with customers.
 Designing new databases with Microsoft recommendations using DBA discoveries and server
health checks for customer Onboarding process.
 Track blocking, deadlocks, long-running queries, and high-resource consuming queries.
 Performed SQL SERVER Patching and Cluster patching on SQL SERVER 2008R2.
 Disaster Recovery Failover over for Mirroring and Log shipping.
 Applying Service Packs and hot fixes.
 Creation of databases on Azure and associating with respective storage
 Handling P1 / P2 / P3 incidents, Changes, Service requests with in the SLA timeframes.
 Assisting customer to go with the best high availability solution for their business.
 Creating the documents like Run books and shared with team for day-to-day operations.
 Worked on all kinds of High availability concepts in SQL Server such as Log shipping, Mirroring,
replication and AlwaysOn failover cluster.
 Good knowledge of server and database security management, creating groups, users, roles,
granting permissions, policies.
 Exemplary experience in supporting and managing multiple Production, Staging, Development
instances.
 Handling outages during Application failures due to database issues or directly Database
failures.
 Documenting and constantly updating the standards, environment and backup, disk space
information.
 Refresh databases for Development, Test and production servers.
 Daily, weekly and monthly reporting to Management.
 Provide Database Health and Performance reports. This includes: Database Size and Capacity
Trend, Summary of Database configuration changes, Database Availability and Backup Failed
Jobs.
 Consistently met the client expectations both in terms of production and initiatives.
 Good experience in 3rd party monitoring tool like Idera SQL Safe, Idera SQL Diagnostic manager.

Responsibilities at Wipro Pvt Ltd/CITI Bank, Jun 2016 to Oct 2016

Role: Sr SQL Server DBA:
 Handled very big environment of database size close to 1TB.
 Handling the escalation calls with the customers
 Working on Migration / Upgradation of database from SQL Server 2005 to 2008 R2 to 2012.
 Bi-Weekly governance calls with onshore on operational activities.
 Worked on all kinds of High availability concepts in SQL Server
 Assisted team to implement automated capacity reports
 Performed SQL SERVER Patching and Cluster patching on SQL SERVER 2008R2.
 Handling projects like changing the recovery models of database at a bunch.
 Assisting team to solve the performance related issues.
 Handling all kind of operational issues related to environment
 Deciding on a proper database Backup strategy & restoration policy and Retention policy.
 Handling team and maintaining 24/7 environment to support business
 Performed standalone and Clustered installations of SQL Server
 Implemented the automations in the project which reduced 50% of total incident volume.
 Providing technical suggestions on the performance issues and the architecture setup to the
client for the new infrastructure.
 Conducting monthly review with teams to discuss on continual improvement process.
 Worked on Yearly password changes activities.

Responsibilities at Wissen Infotech/ GE Health Care, Oct 2011 to May 2016

Role: Senior Database Administrator:
 Daily Administration of more than 150 + Production and 100+ Non production servers with 1500
databases and total size of about 700GB.
 Trouble shooting Performance relating problems and giving solutions to the customer to the
fullest satisfaction.
 Track locking, blocking, deadlocks, long-running queries, and high-resource consuming queries.
 Got appreciation emails from Top management.
 Performed In-Place Migrations for around 50 Servers from SQL Server 2005 to SQL 2008R2
 Done the Standalone and Cluster installation of SQL Server 2008R2 for a Business unit
 Done the SQL SERVER Patching and Cluster patching on SQL SERVER 2008R2
 Will be attending weekly team meeting both onshore and offshore team will be involved in the
meeting to discuss about the scheduled change tickets for the upcoming week and any issues in
the previous weeks
 Day to day activity involves monitoring the SQL services, disk space, backups, blocking,
Installations and cluster installations
 Performed the Disaster Recovery (DR) tests for Mirroring, Log Shipping on a clustered
environment.
 Creating maintenance plan for database backups and for the database maintenance.
 Creation of New databases, tables, file groups, users, assigning permissions to users.
 Implemented both the DR Strategies Log shipping and Database mirroring to our customers.
 Working in rotational shift basis 24/7.
 Installed SQL server 2005 on Windows server 2003
 Designed the backup strategies as per the client requirement
 Backup and restoration of databases
 Trained application users
 Documented the Backup Procedure and Explained to the Client.
 Space management for a database.
 Shrinking of database log files as per the client request
 Performing export and import operations.

Responsibilities at Wissen Infotech/ CARQUEST, Nov 2009 to Oct 2011

Role: Database Administrator:
I have served this organization responsible for application support and database support
 Installation and configuration SQL server 2005, SQL server 2008, SQL Server 2008 R2 in all
environments.
 Managing Databases, Storage allocations and Database Access
 Creating and maintaining database users with different levels of responsibilities. Granting roles
and privileges to different users as per the requirement.
 Development and Implementation of Database Backup Strategy.
 Experience in SQL Server 2005 Performance tuning
 Installation and configuration of SQL Server 2005 on windows 2003 servers
 Designed backup and backup strategy based on organizational needs.
 User management
 Creating users in the server and databases and assigning required privileges.
 Shrinking transaction log and databases as per requirement.
 Moving the databases from one location to another location.
 Running backups, checking backup files.
 Setting the business dates for the stores by running Night streams and involved in recovery
process
 Close the citrix heat tickets
 Editing the scripts and executing the scripts
 Transferring the files through ftp, performing system checks
 Validating the system performance
 Executing queries through SQL developer
 Involved in connecting to the remote server and restarting the services if they are not
responding or stopped
 Involved in month end process and checking log files
 Monitoring the servers using Spectrum application tool and assign to their respective groups if
any major or critical alerts occur
 Also Monitor Weblink Servers using WILY tool
 Make sure the availability of various servers, backup process, scheduled schemas and financial
databases & forms
 Monitoring and troubleshooting the server status through VNC connection

Education details
Degree University / Institution Year
MBA (Specialized in Systems) Sri Venkateshwara University, Tirupati 2011