Karthik Kumar

Experience

• 

  SANDS Utility Services Pvt Ltd

  Feb 2004 - Feb 2007

  Quality Assurance Engineer

  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 Show less

• 

  ZICOM ELECTRONIC SECURITY SYSTEMS LTD.

  Feb 2007 - Sept 2007

  Executive DBA

  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.

• 

  Nuware Systems Pvt Ltd

  Sept 2007 - Jan 2013

  Team Leader

  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. Show less

• 

  WIPRO Technologies

  Jan 2013 - Feb 2017

  Lead - MSSQL PRD Specialists

  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. Show less

• 

  Innova Solutions Pvt Ltd

  Feb 2017 - Jul 2020

  Technical Architect - Cloud

  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. Show less

• 

  Guardian Life

  Jul 2020 - now

  Delivery Manager