Apply as Developer Hire Developer

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