Sruthi Kotte

Email : admdhc@r.postjobfree.com Mobile: +91-630*******

Professional summary:

Having more than 6 years of experience as SQL Server Database Administrator and Support of SQL Server 2016/2014/2012/2008R2/2008/2005 in Production, Development and QA environments along with 2+ years of exp in MS Azure Cloud SQL DBA in IaaS and PaaS.

SQL AZURE / Microsoft Cloud Database Services

Good Hands on experience in Microsoft Azure administration.

Hands on experience in Virtual machines,Azure storage, Azure SQL Database, Azure AD, Azure VNET,VNET peering.

Experience in deploying SQL Databases in Azure PaaS and iaaS

Experience in creating Azure loadbalancer, scaleset,availability set.

Good experience in SQL Azure and Azure Cloud Services.

Good experience in migrating databases from on-prem to Azure.

Good experience in migrating on-prem AD to Azure AD.

Created SQL AZURE Databases and Setting up Firewalls.

Good Experience in to Monitoring and troubleshooting Microsoft Azure SQL databases.

Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.

Exposed Virtual machines and cloud services in the VNets to the Internet using Azure

Created, managed, monitored VM using Windows Azure portal admin

Experience in Designing Azure Resource Manager Template and in designing custom build steps using PowerShell.

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

SQL Database Administrator

Extensive experience in installation, administration and maintenance of MS SQL Server 2012/2008R2/2008/2005 versions.

Experience in working with production and 24 x 7 on call environments.

Experience in Installation, Configuration, Upgrade and Patch management of MS SQL Server.

Experience in investigating and applying necessary SQL Server database service packs and patches

Administered, maintained, developed and implemented Standard Operating Procedures for ensuring the security and integrity of the company database SQL server authentication, server roles, database roles and permissions.

Expert in Database Backup, Refresh and Disaster Recovery procedures.

Performing periodical backups and restoring them when required.

Experience in Migrating the SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012.

Experience in high availability SQL Server solutions, including Log shipping, Mirroring, Replication and Clustering

Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

Deploying new code base release to UAT and Production Environments

Having knowledge on SQL Server always on

Monitoring space on server, handling issues with Log files, Shrinking Log and Data files.

Migration of databases between the servers and Performed Database Refreshes.

Configuring, Scheduling and administering Jobs, Tasks and Maintenance Plans.

Good experience in resolving blocking Issues by using DBCC commands.

Experience in performing Weekly and Monthly Health checks for SQL Servers and Databases.

Experience in interacting effectively with clients.

Self-motivated, quick learner and interest to learn new concepts and technologies.

CORE RESPONSIBILITIES:

Monitoring SQL related incident tickets, change requests and service calls for 24/7 environment.

Monitoring the sql servers by accessing remotely & analyzing the databases size.

Installation, configuration and maintenance of MS SQL Server 2005/2008R2/2012.

Checking the status of Backup, Troubleshooting the failed backups and Restoration of databases.

Monitoring SQL Server Error log and Windows Event log.

Scheduling sql jobs using sql server agent.

Monitoring SQL Server Agent Jobs - Review for failed SQL Server Agent Jobs.

Ensuring data consistency in the database through DBCC commands.

Checking Storage - Validate we have sufficient storage on our drives to support databases, backups, batch processes etc.

Adding users in the database and granting necessary permissions as and when required.

Involved in implementation of Replication,Log shipping, mirroring and Clustering

SQL Server Service packs and patches management.

Security - Remove unneeded logins and users for individuals that have left the organization, had a change in position, etc.

Monitoring database files and shrink files to free up disk space.

Preparation of required documents such as Root Cause Analysis, Request for Change etc.

Keep the Solution Manager informed of task accomplishment, issues and status for the respective application.

Responsible for raising bugs to fix the bugs in production environment.

Attending Change Control Board meetings & planning the Change Control production movement for all applications owned.

Experience Summary:

Total 6 Years of IT Experience in Database administration - MS SQL Server & Azure SQL DBA.

Currently Working as SQL DBA in Cognizant Technology solutions Hyderabad from March 2021 to till date

Currently Working as SQL DBA in Bank of America(BA continuum), Hyderabad from May 2019 to March 2021 .

Worked as a SQL DBA in IBM India Pvt, Hyderabad from May 2015 to March 2019.

PROFESSIONAL EXPERIENCE:

Database : MS SQL Server 2000/2005/2008/2008R2/2012/2014,2016.

Database Tools : Enterprise ManAger, SSMS, Query Analyzer, SQL Profiler.

Operating System : Windows server 2003/2008,2012, Win 7/XP.

Ticketing Tools : ITSM, Service-Now,Nexus

Monitoring Tools : Foglight,Nagios,Scom

Backup Tools : NetBackup,commuvault,TSM

VPC Tools : Citrix

Cloud Technologies : Microsoft AZURE Administration

EDUCATIONAL PROFILE:

Btech from Tirumala Engineering college with an aggregate of 75%, during 2010-2014.

PROJECT PROFILE:

Project #1

Client : Bank of America

Environment : Windows2012 Server,Windows Server2008, Windows2003 Server,

Database : MS SQL Server 2005 and MS SQL Server 2008, 2008R2,2012,2014,2016

Duration : May 2019 to March 2021

Role and Responsibilities:

Monitoring and solving incident tickets, change requests and service calls in 24/7 environment, adhering to SLAs.

Installation, Configuration and Administration of SQL Server 2000/2005/2008/R2/2012/2014/2016.

Experience in configuring, monitoring and trouble shooting on Mirroring, Log Shipping and Replication

Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, granting the privileges to users and groups.

Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.

Performing SQL server daily health check and preparing a report based on it.

Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.

Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.

Scheduled and maintain Jobs, Alerts and Maintenance Plans

Script Execution and revert the results to the user.

Carrying out Installations and upgradations of SQL server Database engine and client tools through all the versions and administrating the same.

Constantly checking functionality of the environment and taking necessary action when an alert is thrown from alerting mechanism by taking a prompt action based on its severity and considering the resolution of the issues as most primitive tasks.

Worked on DTS/SSIS Package Import and Export for transferring data.

Involved in implementation of replication like Snapshot and Transactional.

Involved in implementation of Log shipping and mirroring

Working with Change Requests (Any changes in Production database need to Create Tickets and this should be approved by Global DBA team after changes made in stage and development environment).

Keep the Solution Manager informed of task accomplishment, issues and status for the respective application.

Responsible for raising bugs to fix the bugs in production environment.

Assist project team in achieving best possible design solution for functional requirements for the applications ownedManaging UAT infrastructure for all applications owned

Handle the release management in UAT and production environments.

Attending Change Control Board meetings & planning the Change Control production movement for all applications owned.

Project #2

Client : Sony

Environment : Windows Server2008, Windows2003 Server

Database : MS SQL Server 2005 and MS SQL Server 2008, 2008R2,2012,2014,2016.

Duration : May 2015 to Mar 2019

Role and Responsibilities:

Monitoring and solving incident tickets, change requests and service calls in 24/7 environment, adhering to SLAs.

Used various DBCC commands like check dB, show contig, show statistics etc. for checking database/table consistency and system performance.

Performed daily support, troubleshooting, monitoring, optimization and tuning of SQL server

Monitoring SQL server logs, Application logs and analyzing the logs.

Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.

Restoring Databases in Development /Testing environments on request basis.

Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing updates.

Providing 24 X 7 dedicated supports to all Production, QA & Development MS SQL Server Environments.

Working on Standard Database Maintenance tasks, Backups and Recovery Plans.

Performing SQL server daily health check and preparing a report based on it.

Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.

Knowledge on log shipping and other high availability methodologies.

Applying SQL Server patches and Service Packs,monthly Reboot activities during the maintenance window.

Raising Change requests for any production change to be made and other defined requests for their respective purpose.

Weekly and Monthly analysis reports for the Database Growth and Performance statistics

Monitoring Foglight and BMC Alerts.

Update Standard Operating Procedures (SOP), if there is any change

Distribution of Knowledge with in Team considering any new issue and document it for future usage if it surfaces back.

Personal Details:

Name : K.Sruthi

Date of Birth : 14-11-1992

Sex : Female

Nationality : Indian

Marital Status : Married

Languages known : English, Hindi & Telugu.

Address : Nagaram,laxmi nagarcolony, Hyderabad - 500083

Contact this candidate