Suresh Bc

Having 10+ years of total experience in which, 8 years of experience as a DB2 UDB DBA in handling of production, test and development boxes on Aix, Linux and Windows Environments. Good experience in DB2 UDB V8.x, 9.X, 10.X, 11.X and 12.1 Installations, Configurations and Administration. Good knowledge on DB2 Architecture.

Database performance tuning by configuring database and DBM Parameters. Good experience in 24*7 production environment support. Ability to troubleshoot day-to-day problems encountered on production as well as development database environments.

DB2 UDB DBA - Allianz Technology - Pune

(2015-07)

Sr DB2 DBA - Allianz Technology - Pune

(2019-06)

Euler Hermes, now known as Allianz Trade is a global leader in trade credit insurance and a member of the Allianz Group. The company specializes in providing businesses with solutions to manage their trade credit risk and support their growth by protecting them against potential payment defaults by their customers.

• Working on creating Instances, Databases, Bufferpools, Tablespaces, database & tables objects as per business requirement.
• Involved in db2 installations.
• Creation of instances and databases
• Decomissing the instance and corresponding databases.
• Monitoring the backups, filesystem space & TSM etc.
• Restoring databases based on the requirement.
• Working with export, import, load utilities to manage table data.
• Using RUNSTATS, REORGCHK and REORG to enhance application performance.
• Carring out any performance analysis by taking snapshot in case of any performance degrades.
• Supporting database issues for different environments which had been setup.
• Working on Database restores including REDIRECTED restores within production, stage and development environment as per user request.
• SQL Tuning using db2advisor and db2explain tools.
• Ability to troubleshoot day-to-day problems encountered on production as well as development database environments.
• Installing latest fix packs on the servers.
• Experience on upgradation from 11.5 to 12.1.
• Working on Q-Replication.
• Good Knowledge on PostgreSQL, creating databases, tablespaces, schemas and tables using pgadmin.
• Experience in encrypting databases.
• Good experience on STOS, Vulnerability and Encrypting & Decrypting the databases.
• Good knowledge on taking backup and restore the backup as per the requirement in PostgreSQL using pgadmin.

DB2 DBA & FileNet admin - Allianz Technology - Pune

(2015-06 - 2019-06)

ABS Greece: In Greece, ABS supports local insurance operations by providing a comprehensive platform for managing policy administration, claims processing, and customer interactions. ABS CEE (Central and Eastern Europe): In the CEE region, ABS is adapted to meet the diverse regulatory and market requirements. ABS AWP (Allianz Worldwide Partners): For Allianz Worldwide Partners, which provides assistance services, ABS is used to streamline operations.

ABS Turkey: In Turkey, ABS is utilized to manage a wide range of insurance products.

Allianz Real Estate: Allianz's Corporate Real Estate Management is responsible for managing the company's real estate portfolio.

• Working on creating Instances, Databases, Bufferpools, Tablespaces, database & tables objects as per business requirement.
• Monitoring the backups, filesystem space & TSM etc.
• Restoring databases based on the requirement.
• Working with export, import, load utilities to manage table data.
• Using RUNSTATS, REORGCHK and REORG to enhance application performance.
• Carrying out any performance analysis by taking snapshot in case of any Performance degrades.
• Working on Application migration as per business requirement.
• Supporting database issues for different environments which had been setup.
• Working on Database restores including REDIRECTED restores within production, stage and development environment as per user request.
• SQL Tuning using db2advisor and db2explain tools
• Good experience in generating DDL's using DB2LOOK command on existing database and its objects.
• Worked as an application DBA in ABS.
• Online and Offline backup of database and table space level backup and restore.
• Good experience in Upgrade FileNet, WebSphere and ICN(IBM Content Navigator).
• Good experience managing documents stored in S3 buckets and maintaining their metadata in DB2 servers.

BE - Electrical and Electronics Engineering - Anna university Chennai