Anik Gupta Senior Information Technology Engineer

Database Management and Administration (14.0 yr.)

Summary

Accomplished software engineer boasting over 14 years of expertise in the IT services industry, specializing in database management systems, particularly IBM DB2 and PostgreSQL. Key attributes include adeptness in installation, upgrade, performance tuning, HADR setup, and data encryption. Proven project management skills underscored by leading infrastructure teams. Distinctive achievements include AWS Certified Solutions Architect, with hands-on experience in orchestrating solutions for database services in AWS, and ITIL V4 certification, indicating a strong grasp of best practices in IT service management. Demonstrated ability to automate tasks and enhance system efficiencies, as well as a background in ServiceNow, underlines a commitment to process optimization. The engineer's substantial experience in diverse domains such as banking, finance, and e-commerce provides a robust foundation for tackling varied project demands.

Work Experience

Senior Information Technology Engineer, Infrastructure Leadership and Support for Banking Clients

Duration: Nov 2021 - Present
Summary:

Oversaw infrastructure including banking clients' DB2 databases, with a focus on upgrading to version 11
5, patch management, automation, performance troubleshooting, HADR setup, TSM and TSA configuration, monthly OS patching, database monitoring, and 24/7 support

Responsibilities: Upgrading DB2 databases to version 11.5, applying fix packs, automating tasks, troubleshooting, setting up HADR, configuring TSM and TSA, monthly OS patching, monitoring databases with IBM DMC, and providing 24x7 database support.
Technologies: DB2 11.1 and 11.5, HADR, TSA, TSM, DSM, DMC

Senior Information Technology Engineer, PostgreSQL Database Optimization and Management

Duration: Nov 2021 - Present
Summary: Resolved PostgreSQL performance issues, established backup and PITR recovery strategies, optimized queries and indexes, set up streaming replication, and executed database upgrades from PostgreSQL 11 to 14 and migrations from Oracle to PostgreSQL.
Responsibilities: Rectification of Postgres performance issues, analysis of database logs, setting up backup and recovery strategy with pgbackrest, installing and upgrading Postgre databases, performing query and index optimization, setting up streaming replication, database upgrade and migration, schema design and application support.
Technologies: Postgre 11, 12, 13, 14, pg_badger, pgbackrest, pg_top, pg_stat_statements, pg_repack, pg_center, repmgr, pg_basebackup, pgbouncer

Senior Consultant, Infrastructure Leadership for US Clients

Duration: Jun 2014 - Oct 2021
Summary: Led infrastructure teams across DB, OS, Network, and Cloud, managing Postgre, MongoDB, and Oracle databases with disaster recovery and CDC, implementing AWS solutions, DB2 federation, data encryption, ITIL process management, and ServiceNow orchestration.
Responsibilities: Managing Infrastructure DB, OS, Network and Cloud Teams, setting up HADR and CDC for databases, AWS solutions implementation, data encryption, process harmonization, infrastructure management for ITIL processes, ServiceNow orchestration, and 24x7 database support.
Technologies: DB2, MYSQL, Postgre, MongoDB, Netezza, Splunk, Attunity, AWS, Ansible, ServiceNow

Senior Operations Professional, DB2 Database Upgrades and Management

Duration: Aug 2012 - May 2014
Summary: Performed DB2 UDB version upgrade, managed database backups and restores, fine-tuned performance, created HADR configurations for disaster recovery, handled replication issues, deployment of database objects, and database task automation.
Responsibilities: Upgrading DB2 UDB from 9.1 to 11.1, managing backups and restores, applying patches, scheduling backups, performance tuning, HADR setup, handling replication with CDC, and automating tasks.
Technologies: DB2, HADR, DB2 UDB 9.1 to 11.1, Remedy

Database Administrator, DB2 Database Administration

Duration: Jun 2009 - Aug 2012
Summary: Handled DB2 DBA tasks, performing health checks, managing database objects, supporting weekend maintenance, managing software installations and upgrades, resolving user queries, configuring environments, and monitoring database performance.
Responsibilities: Resolving DB2 DBA issues, health checks, database objects management, DBA weekend maintenance, DB2 software installations and instance upgrades, user query handling, administrative activities, environment configuration changes, performance monitoring.
Technologies: DB2, AIX, Maximo, PowerBuilder, Novell IDAM

Education

Warszawska Wyższa Szkoła Informatyki/Warsaw School of Computer Science
Master's Degree, Cloud Computing
2020 - 2022
Hindustan institute of technology
Bachelor of Technology (B.Tech.), Computer Science
2005 - 2009

Certification

AWS Certified Solutions Architect - Associate
Issued Aug 2021 - Expires Aug 2024
Az-301: Microsoft Azure architect Design
AZ-300 :Microsoft Azure architect technologies
C2090-730: DB2 9 Family Fundamentals
611: IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows
614: IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and Windows
Service Now certified implementation Specialist in ITSM
Service Now certified system administrator
IT Information Library Foundations Certification (ITIL)V4
Administering a SQL Database Infrastructure
kanban in practise
Project Management Professional (PMP)®
Issued Aug 2020 - Expires Aug 2023
IT Information Library Foundations Certification (ITIL) V3
Microsoft Azure Fundamentals