Summary
Overview
Work History
Education
Skills
Timeline
Generic

Shakil Choudhury

Apex,NC

Summary

Accomplished Senior Database Administrator and Infrastructure Engineer with a proven track record of 18 years at Truist Bank and IBM. Expert in DB2 UDB, PostgreSQL, and SAP HANA database management system. Good understanding of MySQL and MongoDB environment. Achieved significant improvements in system efficiency and security, ensuring high availability and data integrity across complex environments. Demonstrating exceptional leadership and collaboration skills.

Overview

22
22
years of professional experience

Work History

Senior Infrastructure Engineer (Database)

Truist Bank
05.2015 - Current
  • Provided expert advice on database design, leading to improved efficiency and scalability in new application project. ( Worked in redesigning of AML database in PostgreSQL v15 env. )
  • Modified databases to meet needs and goals determined during planning process. Table partitioning on HANA databases to overcome the limits of 2 billion rows per partition.
  • Conducted thorough risk assessments on proposed infrastructure changes, mitigating potential negative impacts before implementation. Change management through ServiceNow, tested the changes on Dev, SIT, Stage environment first before implementing on Production.
  • Aligned IT infrastructure strategy with organizational goals by collaborating closely with key stakeholders at all levels of the company. Implemented SAP HANA migration project from HANA 1 to HANA 2 on IBM Power systems using RHEL 8.
  • Ensured high availability of critical databases by implementing proactive monitoring and disaster recovery strategies. Implemented TSA for DB2 UDB, EFM and Patroni for PostgreSQL, Linux Pacemaker HA solution for SAP HANA for HA solution and replication for DR solution.
  • Coordinated with project management on database development timelines. DB2 UDB, PostgreSQL and SAP HANA version upgrade and fixpak and minor release upgrade coordinated with all stake holders and project team.
  • Conducted tests to identify issues and make necessary modifications. Run various scripts on regular and adhoc basis to check database integrity.
  • Implemented disaster recovery strategies, minimizing data loss and ensuring business continuity during unexpected events. Conduct yearly DR test on various database systems.
  • Set up and controlled user access levels across databases to protect important data. Maintain Active directory group for authenticating to databases.
  • Help Database developer to built database objects tables, indexes etc.
  • Resolved complex operational technical issues promptly, minimizing disruptions to daily operations of the organization. ( Meet SLA for all level of incidents)
  • Designed and developed analytical data structures. Built database views to gather data from various databases and feed the data to Tableau server to populate various analytical and graphical plots using Tableau for reporting purpose.
  • Developed scripts and processes for data integration and maintenance. Wrote numerous backup and other maintenance scripts for multiple database systems.
  • Implemented security measures to protect vital business data. HANA encryption, disk level Vormetric encryption.
  • Worked with Vendor management team for negotiating contracts for software licenses and support services while ensuring cost efficiency.
  • Coordinated with application developers to optimize query performance, ensuring seamless integration between databases and applications used throughout the company. ( db2exfmt, explain analyze, reorg, runstats ).
  • Implemented robust backup strategies to safeguard essential data against potential loss or corruption incidents. Implemented various backup solutions eg. Rubrik, Networker Data Domain, TSM etc.
  • Optimized database performance by conducting regular maintenance and implementing best practices. Vacuum, analyze (for PostgreSQL) , reorg, runstats etc (for DB2 UDB).
  • Conducted thorough audits of existing systems to identify areas requiring improvements or updates regularly with internal and external audit team.
  • Established standardized procedures for routine database tasks, increasing overall productivity within the team. Worked with various application team to define optimum maintenance windows for various database systems.
  • Developed comprehensive documentation of database systems, facilitating knowledge sharing among team members and improving training initiatives.
  • Facilitated strong communication between IT departments and business stakeholders through clear reporting on key metrics related to database health and performance indicators. Report disk, CPU, memory usages to all other team eg, storage, OS team.
  • Collaborated on cross-functional teams to implement Security Baseline configuration updates for database systems.
  • Reduced downtime during system upgrades by planning and executing seamless migration processes. Use HA solution to do the upgrade with minimal downtime.
  • Authored various Standard operating procedure for all junior DBAs

Database Administrator

IBM Global Service, Canada
11.2013 - 05.2015
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Utilized advanced IBM DB2 Offline, Online backup and restore and roll forward skills in mission critical single and multi-partition database environment.
  • Day to day operation of error checking and incident management through ServiceNow.
  • Performance bottleneck analysis of DB2 databases (DB2 software, Operating system and Storage level).
  • SQL query performance tuning on various OLAP and OLTP systems using db2exfmt, db2advis tool.

Database Administrator

IBM
01.2003 - 03.2013


  • Logical design and physical implementation of DB2 databases in Transactional and Warehouse environment.
  • Detail planning and leading the activities related to maintenance of DB2 UDB databases on SAP and non- SAP environment.
  • Wrote numerous SQL Stored Procedures and Triggers for database operations used by application team.
  • Set up and configured backup of data and logs with TSM (Tivoli Storage Manager) and EMC Networker.
  • Configured database level high availability using HADR (High Available Disaster Recovery) technology and set up TSA (Tivoli System Automation) with HADR systems.
  • IBM DB2 database corruption analysis using db2 inspect and db2dart tool and worked with support team for the proper resolution of corruptions in production and nonproduction database systems.
  • Used expert knowledge in setting up SQL replication and Q replication with decision making databases.
  • Planned and implemented Disaster recovery procedures of mission critical databases with other supporting team. (UNIX, Storage, Network). Applied expert knowledge on GPFS and NFS file system.
  • Worked with UNIX team and wrote shell scripts in setting up databases for HACMP failover.
  • Collaborated with SAP application team and set up HANA (High Performance Analytics) databases for performance benchmark analysis and comparison with DB2 databases.
  • Took technical leadership role in HANA table partitioning, HANA memory usage, table compression, HANA locking and work load management analysis in SAP environment.
  • Worked with middleware team for the setup of WebSphere Application server and DB2 database connectivity and database client performance issue.
  • Took complete responsibilities of DB2 database version upgrade and quarterly patch (fixpack) installation.
  • Mentored junior Database Admins in various projects and day to day operations.
  • Developed numerous Unix shell scripts and Windows batch files for day to day database operations.
  • Worked with IBM documentation team in technical writings for online web publications.
  • Developed internal web applications for Scheduling and APAR management tool using J2EE, Servlets, JSP.

Education

Master of Science - Information Technology And Management

University of North Carolina At Greensboro
Greensboro, NC
12.2022

Bachelor of Science - Computer Science

York University
North York, Ontario, Canada
05.2001

Skills

  • Database Administration (DB2 UDB version 11,12 on Linux, PostgreSQL version 13,14 on Linux, SAP HANA version 2 on Linux , MongoDB , MySQL, SQL Server )
  • High Availability Solutions (Tivoli System Automation TSA, HACMP, Enterprise Failover Manager EFM, Pacemaker, Patroni )
  • Running backups ( Rubrik backup solution for DB2 , SAP HANA, pgbackrest and BART, TSM, Networker Datadomain)
  • Performance monitoring tools (Dynatrace, db2pd)
  • Database Administration (Toad, pgAdmin, DBeaver, HANA Studio, HANA Cockpit, OPS Manager)
  • Systems administration ( Linux RHEL v79, v82 )
  • Cloud Database Management (AWS Aurora for MySQL)
  • Database Security Management (IAM, AD, user management, Security Baseline Compliance)
  • Query Execution Plans (Explain, Analyze)
  • Database Version Control (PostgreSQL, DB2 UDB, SAP HANA version upgrade)
  • Indexing and Partitioning
  • Replication and Clustering (PostgreSQL logical replication, DB2 UDB replication, HANA replication , DR setup)
  • Disaster Recovery Planning ( DR test plan and execution)
  • Incident and Problem Management (ServiceNow)
  • Scripting and Programming Languages ( Shell script, JAVA, R, NET, Tableau, PowerBI, SQL)
  • Project Management ( MS project )

Timeline

Senior Infrastructure Engineer (Database)

Truist Bank
05.2015 - Current

Database Administrator

IBM Global Service, Canada
11.2013 - 05.2015

Database Administrator

IBM
01.2003 - 03.2013

Master of Science - Information Technology And Management

University of North Carolina At Greensboro

Bachelor of Science - Computer Science

York University

Similar Profiles

CREATE PROFILE
Shakil Choudhury