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