Anik Gupta — Senior Information Technology Engineer

Expertise in Database Management and Administration (14.0 yr.).

Last verified on July, 2024

Core Skills

IBM DB2

Shell Scripts

Project Management

PostgreSQL

IBM AIX

Bio 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.

Technical Skills

JavaScript Libraries and Tools	Mobx
Data Analysis and Visualization Technologies	Attunity
Databases & Management Systems / ORM	IBM DB2, MongoDB, MySQL, Netezza, PGBouncer, PostgreSQL
Cloud Platforms, Services & Computing	AWS
Operating Systems	IBM AIX
Methodologies, Paradigms and Patterns	Kanban
Project Management & Administration	Project Management
Scripting and Command Line Interfaces	Shell Scripts
Logging and Monitoring	Splunk
Platforms	TSA
Other Technical Skills	DMC, FDW, HADR, IBM TSM, ITILV4, Maximo, Novell IDAM, ora2pg, orafce, pgbackrest, pgbadger, pg_center, pg_repack, pg_top, pgtt, pg_upgrade, PMP, Remedy, repmgr

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

How to hire with Upstaff

Talk to Our Talent Expert

Our journey starts with a 30-min discovery call to explore your project challenges, technical needs and team diversity.

Meet Carefully Matched Talents

Within 1-3 days, we’ll share profiles and connect you with the right talents for your project. Schedule a call to meet engineers in person.

Validate Your Choice

Bring new talent on board with a trial period to confirm you hire the right one. There are no termination fees or hidden costs.

Why Upstaff

Upstaff is a technology partner with expertise in AI, Web3, Software, and Data. We help businesses gain competitive edge by optimizing existing systems and utilizing modern technology to fuel business growth.

Real-time project team launch

<24h

Interview First Engineers

Upstaff's network enables clients to access specialists within hours & days, streamlining the hiring process to 24-48 hours, start ASAP.

x10

Faster Talent Acquisition

Upstaff's network & platform enables clients to scale up and down blazing fast. Every hire typically is 10x faster comparing to regular recruitement workflow.

Vetted and Trusted Engineers

100%

Security And Vetting-First

AI tools and expert human reviewers in the vetting process is combined with track record & historically collected feedbacks from clients and teammates.

~50h

Save Time For Deep Vetting

In average, we save over 50 hours of client team to interview candidates for each job position. We are fueled by a passion for tech expertise, drawn from our deep understanding of the industry.

Flexible Engagement Models

Custom Engagement Models

Flexible staffing solutions, accommodating both short-term projects and longer-term engagements, full-time & part-time

Unique Talent Ecosystem

Candidate Staffing Platform stores data about past and present candidates, enables fast work and scalability, providing clients with valuable insights into their talent pipeline.

Transparent

No Hidden Costs

Price quoted is the total price to you. No hidden or unexpected cost for for candidate placement.

One Consolidated Invoice

No matter how many engineers you employ, there is only one monthly consolidated invoice.

Ready to hire Anik Gupta
or someone with similar Skills?

Book a call with Anik Gupta

Start Hiring