Sql Server Manager

Kasi Reddy

Doha, Qatar : +974-******** : **********@*****.***

ViSiON

Aspiring a challenging and motivating position to work in an organization that offers challenging tasks and enhances my career growth.

Professional Summary

Having 7 Years 8 Months of experience as a SQL Server DBA

Having knowledge on Hadoop Administration

Microsoft Certified Technology Specialist

Technical Skills:

Databases

Microsoft SQL Server 2017, 2016, 2014, 2012, 2008R2, 2008, 2005, 2000

Tools

SSMS, Enterprise manager, Query analyzer, Profiler, Perfmon, DTA, SCOM, SPOTLIGHT, Tivoli, Redgate SQLBackup, Networker, Networker for SQL Server, DMS, Oracle SQL Developer, DBSPI, Nagios

Ticketing Systems

BMC Remedy ITSM, Service-Now, BMC Remedy user, BMC Service Desk Express, BMC Footprints, Datapipe, IPSoft, HPSM, JIRA

Language

Transact-SQL, Basics in VBS, Bash, PowerShell, html

Operating systems

Windows 2003/2008/2008R2/2012/2016, Windows 7, 8, 10, Linux

Applications

MS Office

Big Data

Hadoop 1.X, 2.X

Skills include:

Installation and maintenance of SQL Server

Upgradation of Databases from lower version of SQL Servers to higher version, Service packs, Cumulative updates, hotfixes and Edition upgrade, Migrations

Capacity planning for new installations, Database Security, Backups & Disaster recovery procedures, point-in-time recovery on request, DR Setup

Maintenance plans implementation, monitoring setup, proactive monitoring

Execution Plans, Performance Monitoring, DBCC Commands

Excellent working knowledge on High availability options. (AlwaysON, Clustering, Replication, Log shipping, Mirroring)

Knowledge in writing Stored procedures, cursors and triggers

Having excellent documenting and communication skills

7 X 24 X 365 SQL Server database support and On-call Support

Handling internal and client meetings, Leading a team of size 10

Good knowledge in Hadoop architecture, design and development of Big Data platform including large Clusters, Hadoop ecosystem projects

Involved in Hadoop Cluster setup and monitoring Hadoop Clusters

Experience

Working as Database Admin in Commercial Bank, Qatar since Apr 19 – Till Date

Worked as Consultant in Commercial Bank, Qatar since Nov 18 – Feb 19

Worked as Senior Consultant in InfoBase Systems, Hyderabad since Feb 18 – Nov 18

Worked as Senior Consultant in Capgemini India Pvt. Ltd., Bangalore since JAN 16 – Feb 18

Worked as SQL Server DBA-Technical Lead in Continuserve Softech India Private Limited, Bangalore, India since DEC 2011 –JAN 2016

Education

Master of Science from University of East London, London, UK, 2010

Bachelor of Technology from JNTU, Hyderabad, AP, India, 2008

Projects:

Project#

Client

Duration

Team Size

Description

Commercial Bank

Commercial Bank

Nov 2018 to Till Date

4

Commercial Bank is a private sector bank operating in Qatar since 1975. The bank offers a range of products and services across retail, and corporate banking divisions

SBM

State Bank of Mauritius

Feb 2018 to Nov 2018

10

State Bank of Mauritius is the second largest bank in Mauritius with a market share of about 25% of domestic banking assets

NL_MCT

NL Multi client, Netherland

Jan 2016 to

Feb 2018

8

NL_MCT is a support project by Capgemini for

all Netherland geography customers; it includes around 25 clients such as Energy, banking, hospitality, Education, health care etc.

Multi-Client

Staywell, IHG, Staffmark, HBC, Recall US

Dec 2011 to

Jan 2016

9

Multi-Client project by Continuserve for US clients; it includes different domains such as Health management and insurance, Hospitality, Recruiting, Telecom, Document management

ROLES & RESPONSIBILITIES: (Including all projects)

Monitoring SQL Server instances

Monitoring and troubleshooting SQL Server agent jobs

Installing new SQL Server Stand-alone and clustered instances

Upgrading SQL Server, Patching up the SQL Servers

Preparing installation documents and checklists

Configuring database mail, SQLMail

Creating and managing maintenance plans and jobs

Implementation of AlwaysON High availability, adding newly created databases to existing AAG

Implementation of SQL Server cluster

Implementation of database mirroring, Log shipping

Performing SQL statements execution

Creation of logins, user mapping to databases, granting object level permissions

Creating new databases on client requirement

Working on the tickets

Monitoring available space on databases

Troubleshooting corrupted databases when the situation occurs

Performing database refreshes from PROD to Non-Prod, Fixing orphan users

Migrating databases from one server to another server

Performing Backups and restores

Monitoring the Database Server's Health and Tuning Accordingly

Managing Database Users and Security

Performing disaster recovery process when situation occurs

Monitoring disk space and freeing up space

Moving files from one drive to another drive whenever space issue occurs

Monitoring SQL Server instances after monthly window patch management

Handling weekly internal and on-call meetings

Indexes creation on tables for better performance on request

Re-index and reorganization of indexes and performing integrity checks of databases

Performing database maintenance tasks and resolve database related problems

Troubleshooting long running queries, database slowness and server slowness

Writing stored procedures and cursors

Implementing monitoring alerts for new systems

Troubleshooting SSIS package execution failures

Creation of SSAS partitions

Training new hire (s)

Hadoop Admin:

Managing and Administering the overall Hadoop infrastructure

Commissioning and decommissioning of nodes in cluster, rebalancing of HDFS

Monitoring cluster using tools like ambary, Ganglia, Nagios

Manage and review Hadoop log files

Backup and recovery

Quota administration, notification in case of space problems

Keeping a track of all the running Hadoop job

Resource and security management

Career Highlights

Certified as Microsoft Technology Specialist (SQL Server® 2008, Implementation and Maintenance)

Received award from Capgemini management for outstanding contribution in 2017 Q1

Leading team of 10

Having a successful and proven track record, Client appreciations several times

Implemented a new SQL Server cluster environments and AlwaysON for a new client on-time

Resolved slowness of Queries, databases and instances

Fixed outstanding Monitoring system issues Capgemini, SBM and Commercial Bank

Automated daily health checks, capacity monitoring, Inventory, patch compliance etc.

Implemented scripts to get daily health-reports, capacity report in HTML format via email

Implemented scripts that deploy monitoring for multiple instances in a single step

Implemented data archival scripts for a complex healthcare system

Implemented Hadoop Clusters

(Kasi Reddy)

Contact this candidate