Karthik Kumar Email & Phone Number

Chennai, Tamil Nadu, India

Chennai

Involved in AWS MSP AuditSupporting more than 5+ customers databases hosted in AWS Cloud in EC2 and RDS Instances for various RDBMS flavors like MSSQL, MYSQL, PostgreSQL, DynamoDB and AWS Aurora Providing Cost Optimization Services for more than 3+ customers Infrastructure hosted in AWS Cloud using Cloud Health Tool and based on Trusted Advisor Report.Implemented Homogeneous & Heterogeneous DB Migrations from On-Premise to AWS and AZURE Cloud either Managed SQL Instances or VM\EC2 instances. using methods SQL AZURE, Native Backup & Restore, Import & Export, AWS SCT etc.Minimized Application down time while migrating the database On-Premise to AWS and AZURE Cloud using Replication methods for critical applications.Implemented Azure Function Apps to schedule the Jobs in AZURE CloudExperience in Migrating the Resources running in ONE AWS Account to Multiple AWS Accounts (3 Accounts) based on their business Regions.Involved in Various activities in EC2 and RDS Instances based on the Cost Optimization Report. Experience in Point-in-Time Recovery using SNAPSHOTS Management.Experience in Upgrading Database Instances to Higher Versions in CLOUD Premise with minimal downtime.Using LAMBDA function, taking Snapshots for ES and Root Volumes as per the business requirements.Optimization activities carried out for reclaim the space on the FILE Systems\Storage in Cloud premise using the VACUUM, SHRINK commands etc.Performance tuning based on Parameter\Option groups for Managed Instance in Cloud Premise.Experience in Cloud Migrations from EC2 to RDS with minimal application Downtime.Experience in setting up data warehousing using S3, Kinesis Streams, Kinesis and Redshift. Good Exposure in setting up EMR, Kinesis Streams and Kinesis.Experience in setting up data warehousing using S3, Kinesis Streams, Kinesis and Redshift.Setting up and monitoring / alarming for production Database environments using Cloud Watch and Data Dog.

Chennai Area, India

Awarded Stellar Performance of the year ‘16 in WIPRO Technologies.Exposure to a wide environment of SQL Server Databases with size varying from 2MB to 4TB for 3000+ SQL servers.Provided Primary DBA (L3 and L4 support) responsibilities to Mission Critical Production Database servers.Expertise in Production servers fine tuning and maintenance. Maintaining high availability solutions like Clustering, DB Mirroring, Always-ON, Log shipping, Replication and SRDF with less outage.Migrations and upgrades to the latest hardware with cost effectiveness.Proficient in using SQL server profiler, SQL query analyzer for performance related issues in MS SQL database\MS SQL based applicationsPeriodically perform COB test (Continuity of Business Tests) to ensure the backup servers availability in case of Production server crash or destroyed by natural calamities.Participating production issue calls and updating the customers about the status of the issue.Consolidate the reoccurring issues and provide the permanent fix for the issue by tracking problem tickets.Involving in all major issues\outages providing technical solution within a short time.Alert reduction along with Emails & Service improvements in process of technical expertise.Protecting the servers from vulnerabilities through VTM patches and fixing Audit Violations to retain it as per standards.Handling Service delivery calls (SDR) with providing the RCA of the critical issues and plan to avoid the issue in future.Identifying the Process gaps and recommending improvements to fix.Automating the required areas to reduce time and efforts spent of the DBA Team.

Bangalore

Awarded DBA Quarter of the year ‘09 in NuWare Systems.Install MS SQL servers as per standards and applying ServicePacks on all SQL Servers.Maintaining SQL servers in clustered environments, creating and maintaining log shipping.Performing DR activity when required and needed.Create and decommissioning databases as per the application perspective.Participating in project enhancement activities.Install and upgrade the DBMS software on the database server.Performed Tuning to databases with regards to performance.Procedural Refreshes of the databases.Develop and maintaining a standard backup and recovery strategy.Coordinate with the Application teams on planned database downtimes.Expertise in Upgrade/Downgrade, Migration, Cutover and failed over\back application critical databases. Was part of the Major Data Center move of about 200+SQL Production Servers.Deputed to Onsite (NewYork) for a period of 10 weeks from April 2010 to June 2010 to gather knowledge about the migration from SQL Server 2005 to 2008.

Mumbai Area, India

Installation and Configuration of SQL server.Checking all event logs and error logs.Database backup and Restore management.Database Space Monitoring, Server Space Monitoring, Data Import and Export.Maintaining high availability solutions Log shipping and SQL server Native Replication Setup.

New Delhi Area, India

Awarded as Best Employee of the project for the year ‘06 in SANDS Utility Services.Installing and configuring of MS SQL servers, Design and Creation of databases for reading and survey.SQL Server native Replication setup.Data backup and Restore management, Database Space Monitoring, Data Analysis.Data submission on schedule basis to client for consumer billing.Developing Sp and Authoring of Queries, Data Import and Export.Checking all event logs and error logs, Exception Report generation.Maintaining and updating project documentation