Summary
Overview
Work History
Education
Skills
Accomplishments
Technical Certifications
Training - Infosys Ltd.
Languages
Hobbies and Interests
Timeline
Generic

Amit Kumar

SQL Server Database Administrator
Bangalore

Summary

Microsoft Certified Solutions Expert in SQL Database Administration with relevant experience in ensuring data accuracy and security, as well as managing performance and improving processes. Possess strong technical abilities in SQL server databases, and data migration strategies. Successfully enhanced system efficiency and reliability through proactive database optimization and maintenance practices. Fostered teamwork and collaboration to meet tight deadlines and address challenging IT issues effectively. Working as 24 X 7 Production Database On-Call Support with some type of DBs i.e. - MSSQL, MySQL, PostgreSQL & Cosmos in Azure cloud. Informix & Progress DB

Overview

9
9
years of professional experience

Work History

Technical Leader

ACL Digital ALTEN Group, Client – Essilor Luxottica.
Bangalore
09.2022 - Current
  • Managed and supported customer base across diverse global regions including Greater China, Japan, UK, Europe, USA, and Singapore
  • Migrated existing databases from one platform to another with minimal downtime.
  • Assisted in disaster recovery planning by testing various backup strategies and scenarios.
  • Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
  • Resolved customer queries related to database issues promptly and accurately.
  • Analyzed system logs regularly to identify any potential problems or suspicious activities.
  • Monitored database performance and implemented changes to improve response times.
  • Optimized storage and archiving practices to manage database size and performance.
  • Conducted regular database capacity planning to accommodate business growth.
  • Installed and configured SQL Server, including AOAG, Log Shipping, Replication, and Cluster Setup.
  • Managed Basic Informix DB and Progress Linux Based DB with proficiency.
  • Implemented change management processes to ensure smooth transition between different stages of development life cycle.
  • Contributed to the development of server requirements by attending initial setup meetings.

I.T. Analyst

TCS: Tata Consultancy Services, Client – Microsoft Azure Cloud.
Bangalore
09.2021 - 09.2022
  • Analyzed project requirements and created test plans accordingly.
  • Created and managed Azure PaaS Servers along with their corresponding Databases.
  • Conducted cost analysis and optimized Azure objects. Achieved increased efficiency in resource allocation.
  • Demonstrated proficiency in working with non-SQL database technologies including MySQL, PostgreSQL, and Cosmos.
  • Handled Service Now tickets and participated in daily status calls to provide updates on ticket progress.
  • Optimized database and server functionality by resolving performance issues.

Senior Database Administrator

FIS: Fidelity Information Services, Client – JEFFERIES.
Bangalore
01.2020 - 09.2021
  • Maintained multiple versions of the same database while ensuring data consistency across them.
  • Proficient in installation and configuration of AOAG and Distributed AOAG.
  • Designed and implemented disaster recovery plans in case of system failure or data corruption.
  • Installed new software releases, patches and upgrades on production servers as required.
  • Implemented strategies for archiving and partitioning large tables.
  • Optimized database and server functionality through effective problem-solving techniques.
  • Managed troubleshooting of login failure alerts by effectively addressing customer concerns via email and phone, aimed at achieving permanent fixes.
  • Implemented change management processes to ensure smooth transition between different stages of development life cycle.
  • Handled multiple basic tasks and alerts related to Oracle and MySQL.

Technology Analyst

Infosys Ltd. Client - Mercedes Benz Research and Development.
Bangalore
06.2015 - 01.2020
  • Installed and configured SQL Server versions 2008R2, 2012, 2016, and 2017.
  • Installed Always-On Availability Groups (AOAG) and configured HA/DR setup.
  • Created IIS websites using Legacy, Load balancer, and Server Certificate to address various issues.
  • Installed and managed a Four Node Cluster on MS Windows Server 2012 Enterprise Edition.
  • Managed and configured SSAS, SSIS, and SSRS tools efficiently.
  • Utilized IBM TSM tool to implement Full/Log/Differential backup strategies for database backup and Point-in-time recovery.
  • Troubleshot and fine-tuned databases to optimize performance.
  • Configured jobs according to customer’s requirements.
  • Ensured optimal performance of hosted databases through monitoring and recommending improvements, such as scheduling jobs for re-indexing and updating statistics.
  • Experienced in implementing Disaster Recovery Planning and Security Management operations.
  • Served as an integral team member during the transition of SQL Server from 2008R2 to newer releases such as SQL Server 2017, 2016, and 2014.
  • Managed the migration of website certificates from an old LB to a new LB, ensuring seamless transition and renewing outdated certificates.
  • Succeeded in promptly resolving high-priority P1/P2/P3 Incidents.

Education

B.E - Electronics & Communication

BIT MESRA
RANCHI, Jharkhand
05-2015

CLASS XIIth -

A.N. College
Patna, Bihar, State Board
03-2011

CLASS Xth -

High School Akuna
Patna, Bihar, State Board
03-2009

Skills

  • Managed SQL database Versions: MS SQL Server 2022, 2019, 2017, 2016, 2014, 2012 and 2008 R2
  • Migration of databases of different versions
  • Setup of HADR - AOAG, Log Shipping, Replication & Failover Clustering
  • Azure Cloud
  • Troubleshot and fine-tuned databases to optimize performance
  • Initial Setup of Server as per customer requirements and suggestions
  • Disaster Recovery
  • RCA for P1 tickets
  • Patching
  • Operating Systems: Windows, Linux (Basic)
  • Tools: Eclipse, IBM Tivoli Storage Manager, SCOM 2012, Service Now, HDA Portal

Accomplishments

  • Received Best Team Award for outstanding performance and valuable contribution in Migration of SQL Database, IIS website certificate migration.
  • Got Appreciation from manager for solving maximum incidents/Tasks/Issue in a month.
  • Received multiple times positive feedback and also appreciation from application owners.
  • Got appreciation for cost optimization by 90 % of cosmos Azure server.

Technical Certifications

  • Microsoft 764 - Administering a SQL Database Infrastructure
  • Azure- 900: Microsoft Azure Fundamentals
  • DP 300: Microsoft Certified: Azure Database Administrator Associate

Training - Infosys Ltd.

Infosys Ltd., Mysore, June'2015 - Nov'2016.

 Learned basics of programming in Python and querying relational databases using SQL Stored Procedures., Learned Basic .NET, C#, HTML and created basic Project Named "Finance Website" with the help of C#, HTML and SQL Server.

Languages

English, Hindi

Hobbies and Interests

Playing Carom, Spending time with friends and family

Timeline

Technical Leader

ACL Digital ALTEN Group, Client – Essilor Luxottica.
09.2022 - Current

I.T. Analyst

TCS: Tata Consultancy Services, Client – Microsoft Azure Cloud.
09.2021 - 09.2022

Senior Database Administrator

FIS: Fidelity Information Services, Client – JEFFERIES.
01.2020 - 09.2021

Technology Analyst

Infosys Ltd. Client - Mercedes Benz Research and Development.
06.2015 - 01.2020

B.E - Electronics & Communication

BIT MESRA

CLASS XIIth -

A.N. College

CLASS Xth -

High School Akuna
Amit KumarSQL Server Database Administrator