Technical Specialist

Suresh Rangineni

Bengaluru, Karnataka, India

***************@*****.*** +91-978*******

linkedin.com/in/suresh-rangineni-256028196

Summary

• Around 6+ years of IT experience with SQL Server 2000 till 2019 administration in production support environment.

• Work experience in 24x7 Production support for SQL Server 2000 to 2019.

• Experience in AWS – Deploying and managing RDS instances, workspaces, EC2 and security.

• Experience in Azure – Deploying and managing Azure databases, managed instances, Data factories, Azure VM’s etc.

• Security Management in AWS and Azure.

• User and database management in Azure databases\managed instances from SSMS.

• Create data factory and deploy SSIS runtime in Azure.

• Deploy SSIS projects.

• Create and manage Elastic pools.

• Upgrade RDS instances to up to date.

• Strong hands on experience in configuring and troubleshooting Always on environment.

• Experience in installing and configuring BI tools(SSIS\SSAS\SSRS)

• Experience in Installation and Configuration in different versions like SQL Server 2000 until 2019.

• Resolving the Disk space issues, finding the root cause and implementing the permanent fixes.

• Creating and Administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options.

• Experience in applying the service packs and cumulative packs for standalone servers and in cluster nodes.

• Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups.

• Experience in database migration from one server to another.

• Experience in implementing SQL Server security and Object level permissions like maintaining creation of users, configuring permissions and assigning roles to users.

• Having strong knowledge of Log Shipping, Database Mirroring, Transaction Replication,

• Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update statistics and monthly maintenance plans such as clean up history etc. to run the databases efficiently.

• Good knowledge on Cluster installation and adding the nodes in the res Experience

Technical Specialist

Cognizant

Jun 2020 - Present (9 months +)

Client : KFC (Singapore, India, Canada, Australia, Peru, Philippines, Thailand) Position : DBA and Technical Application Manager

SQL Version : MS SQL Server 2012 until 2019

Environment : Windows 2003 until 2016

Duration : June 2020 to till date

Suresh Rangineni - page 1

Responsibilities:

# Working on Incidents and changes assigned

# Planning and executing the upgrades and migrations

# Attend various internal and project meetings.

# Working and coordinating with external suppliers\consultants on project work

# Managing AWS and Azure databases.

# Deploy RDS instances, creating firewall rules, security groups.

# Create and configure Azure databases, managed instances.

# Security Management in AWS and Azure.

# User and database management in Azure databases\managed instances from SSMS.

# Create data factory and deploy SSIS runtime in Azure.

# Create and manage Elastic pools.

# Upgrade RDS instances to up to date.

# Keep the CMDB up to date with infra details.

# Coordinating with offshore team for changes and project activates.

# Performing Upgrade of SQL servers from Old to new versions.

# Monitoring and keep the always on environment up to date and resolve the issues if any.

# Performing data refresh activities from production to Dev/Test on need basis.

# Planning and Performing Upgrading SQL servers.

# Managing Always-on cluster(s).

Technical Lead

Cognizant

Sep 2016 - Jun 2020 (3 years 10 months)

Client : GSSC (Global Shared Services Centre) & EOC – Supported around 56 + Clients Position : DBA & Team Lead

SQL Version : MS SQL Server 2005 until 2019

Environment : Windows 2003 until 2016

Duration : Sep 2016 to June 2020

Responsibilities:

# Daily checking the assigned tickets and resolve the tickets depends on the priority levels.

# Daily checking the issues like backup failures, failed logins and resolving DB issues.

# Resolving disk space issues and data base growth issues.

# Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups. (Native & Tool)

# Performing data refresh activities from production to Dev/Test on need basis.

# Performing the Failover operations in the cluster environment and troubleshooting activities

# Performing Upgrade of SQL servers from Old to new versions

# Applying SQL server service packs to Cluster environment and mirror servers.

# Experience in using Performance Monitor, SQL Profiler and tracing long running queries and deadlocks.

# Repetitive issues analysis and proposals for permanent resolutions.

# Closing the tickets with in the SLA time and Monitoring the SLA.

# Working on Service Now

# Preparing and executing for DR activity.

Suresh Rangineni - page 2

# Managing and helping the team in technical challenges. Sql Database Administrator

KARYA Technologies

Jun 2015 - Sep 2016 (1 year 4 months)

# Daily checking the assigned tickets and resolve the tickets depends on the priority levels.

# Experience in database migration from SQL Server 2000 to 2005 and SQL Server 2005 to SQL Server 2008R2.

# Daily checking the issues like backup failures, failed logins and resolving DB issues.

# Resolving disk space issues and data base growth issues.

# Monitoring the temp log full and transactional log full issues.

# Database installation and administration of MS SQL Server 2008 R2 and 2012.

# Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups.

# Performing data refresh activities from production to Dev/Test on need basis.

# Resolves database performance issues, database capacity issues and other data issues related to database.

# Maintain database consistency check using DBCC command on weekly basis.

# Performing the Failover operations in the cluster environment and troubleshooting activities

# Experience in using Performance Monitor, SQL Profiler and tracing long running queries and deadlocks.

# Migration and up gradation of servers and databases

# Repetitive issues analysis and proposals for permanent resolutions.

# Closing the tickets with in the SLA time and Monitoring the SLA Software Engineer

Atlas Systems

Nov 2014 - Jun 2015 (8 months)

Client : IBM India Pvt Ltd

Position : Software Engineer - DBA

SQL Version : MS SQL Server 2005 until 2019

Environment : Windows 2003 until 2016

Duration : NOV 2014 to June 2015

Responsibilities:

# Daily checking the assigned tickets and resolve the tickets depends on the priority levels.

# Daily checking the issues like backup failures, failed logins and resolving DB issues.

# Resolving disk space issues and data base growth issues.

# Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups. (Native & Tool)

# Performing data refresh activities from production to Dev/Test on need basis.

# Performing the Failover operations in the cluster environment and troubleshooting activities

# Performing Upgrade of SQL servers from Old to new versions

# Applying SQL server service packs to Cluster environment and mirror servers.

# Repetitive issues analysis and proposals for permanent resolutions.

# Closing the tickets with in the SLA time and Monitoring the SLA.

# Managing and helping the team in technical challenges. Suresh Rangineni - page 3

Education

Sri Venkateswara Institute of Science and Technology Bachelor's degree, Electrical and Electronics Engineering 2008 - 2012

Completed My Bachelor Engineering with 6.3 % GPA - 2012 Licenses & Certifications

Administering a SQL Database Infrastructure - Pearson VUE Issued Jun 2018 - Expires Jan 2021

G841-6464

Skills

backup • customer relations • database administration • Service-now.com • SQL • Database Administration • Internet of Things (IoT) • Amazon Web Services (AWS) • Amazon EC2 • SQL Azure Honors & Awards

Appreciations - Cognizant

Dec 2020

# Awarded with “Star Performer” for better understanding the process and for the appreciations received.

# Awarded “Well-done” for taking the initiatives for long pending issues.

# Having good knowledge of Upgrading and Migrating several versions of SQL services

# Worked for various projects across UK and US regions.

# Received appreciations from many customers.

Promotion - Cognizant

Feb 2021

# Recently got promoted from Technical Lead to Technical Specialist. Suresh Rangineni - page 4

Contact this candidate