Ranjith Kumar Routhu

Experience

1. Sr Database Administrator & Application Dba

   GE医疗

   Jun 2017 — Present

   Following the Agile Scrum Methodology • Building Production & Staging Servers on both Cluster and standalone environments (SQL SERVER 2012/2014/2016) • Handled Large size databases up to 10TB • Production Database Servers Monitoring on 24*7 environment • Configure, Maintaining & Monitoring High Availability Solutions (Always On, Clustering, Replication technologies) • Implemented Resource Governor to manage SQL Server workload and system resource consumption. • Implemented Page Level Compression • Performance Tuning on Slow Running Databases • Troubleshooting High CPU & High Memory Usage query’s • Identify deadlocks and Blocking and resolving issues. • Finding Missing indexes and create new indexes • Experience working with SQL Database Migration Wizard SQLAzureMW and Azure SQL Database • Create Database(s) on SQL AZURE • Setting up SQL Azure Firewall • Create, manage SQL Server AZURE Databases • Migrating SQL Databases from on premises to SQL Azure • Enable SQL Database auditing on Azure Cloud • Enable SQL Database threat detection Azure • Data loading from various sources into SQL Server Databases using SQL Server Integration services(SSIS) • Extract JSON data from source system and load into SQL database using SSIS • Deploy SSIS Packages on Staging, Production Environments • Deploying database DACPAC. • Build, Deploy and Publish Dacpac\'s using Microsoft Visual Studio 2015/2017 versions. • Writing Query\'s and stored procedures, User defined Functions(T-SQL) • Design Indexes and Rebuild, Reorganize indexes • Backup & Recovery Management • PowerShell Scripting for automate Job Tasks • Fixing Database corruptions and recovery databases from DB crashes • Table partitioning (Range Partitions) on Large size tables • Performed SQL cluster upgradation from SQL Server 2008R2 to SQL Server 2014 and 2016 Versions • Installation of SQL Server with Multiple instances, Service packs and Hot Fixes. • Implemented Capacity planning, sizing and database growth