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, Jharkhand05-2015
CLASS XIIth -
A.N. College
Patna, Bihar, State Board03-2011
CLASS Xth -
High School Akuna
Patna, Bihar, State Board03-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
Similar Profiles
Praneeth KoliviPraneeth Kolivi
Program Manager at ACL Digital ( Client Qualcomm )Program Manager at ACL Digital ( Client Qualcomm )
Magdalena KrupaMagdalena Krupa
Operations and Sales Director, Board Member at Vision Express Poland, Essilor Luxottica GroupOperations and Sales Director, Board Member at Vision Express Poland, Essilor Luxottica Group
Jake ROBERTSJake ROBERTS
Outside Sales Consultant at Essilor LuxotticaOutside Sales Consultant at Essilor Luxottica