Experience

• 

  Hcltech

  Feb 2013 - Jan 2016

  Analyst

  My responsibilities as Analyst at HCL Technologies, includes installing, configuring, and upgrading Microsoft SQL Server, addressing issues like blocking, deadlocks, and database problems. I establish backup and recovery procedures, manage database implementations, and handle patching, upgrades, and migrations. Security and documentation are a priority, along with capacity planning. I provide 24/7 support as needed and adhere to ITIL processes. I also automate tasks, resolve critical issues, and closely monitor database growth for optimal performance. Weniger anzeigen

• 

  Tata consultancy services

  Jan 2016 - Feb 2018

  Sr database administrator

  As Database administrator at Tata consultancy services , I provide support in configuring and troubleshooting SQL Server installations spanning multiple versions. My expertise includes implementing high availability solutions like Log Shipping and Always-On, managing transactional replication, and understanding clustering for hardware-based high availability. I excel in data recovery, ensuring successful backups and restorations, and have a strong background in SQL Server security and object-level permissions. Additionally, I have a proven track record in migrations and upgrades, resolving space management issues, and handling orphaned user concerns. Weniger anzeigen

• 

  Accenture

  Apr 2018 - Jan 2020

  S/w application tech support sr analyst

  As a Senior analyst at Accenture, I am responsible for a wide range of tasks related to SQL Server management and administration. This includes installing and configuring SQL Server, as well as deploying service packs to ensure the latest updates and security patches are applied.I design, develop, and implement automated data backup and restoration procedures to safeguard critical data. Additionally, I create user accounts and assign roles to ensure proper access control and security. I regularly monitor and maintain the database environment by checking reports for backup failures and instances excluded from monitoring.Ensuring the database's health and integrity is crucial, and I achieve this by performing routine checks using DBCC commands. I also oversee the execution of maintenance jobs, scheduling them to run daily and on weekends. These tasks include rebuilding indexes, shrinking databases, and performing complete database backups.Monitoring server disk space and log space is essential to ensure the successful execution of all specified jobs. I am also responsible for refreshing the UAT environment with production data to support testing and development efforts.High availability is a top priority, and I achieve this by implementing concepts like Always-On, Log Shipping, and configuring replication between servers. Additionally, I handle database migrations to different servers as needed.Lastly, I work collaboratively as part of the environment team to provide support to the entire project, ensuring that the database infrastructure is reliable and available to meet the project's needs. Weniger anzeigen

• 

  Navisite

  Apr 2020 - Apr 2023

  Consultant

  As a IT Consultant (Database administration) at Navisite, I am responsible for the installation and configuration of SQL Server environments spanning versions 2019, 2017, 2016, and 2014. On a day-to-day basis, my tasks include managing database backup and restoration, monitoring job activities, tracking backup history, and scheduling tasks. I also take care of security management, which involves creating user logins, roles, and granting necessary permissions, along with addressing orphaned user issues.I possess strong expertise in identifying and resolving locking, blocking, and deadlock issues using SQL commands. Additionally, I configure, schedule, patch, and administer routine jobs, tasks, alerts, and maintenance plans. I have a solid understanding of Always On technology to ensure high availability.I am available for 24/7 on-call support to ensure smooth database operations and have experience with database backup and disaster recovery procedures. Furthermore, I have a basic knowledge of ITIL processes such as incident management, change management, service requests, problem management, root cause analysis, service outages, and policy change requests.In addition to my SQL Server responsibilities, I have assisted in the operation and maintenance of web content management systems and applications. I provide technical support to troubleshoot and resolve IIS application problems and assist with server maintenance, troubleshooting, and patching functions. I also have experience deploying and maintaining applications on Microsoft Azure's cloud infrastructure, including deploying Azure IaaS virtual machines and configuring secure VNets and subnets to meet Azure Network Limits. Weniger anzeigen