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.

Sr DB2 DBA at Allianz Technology (2019-06 – Present)

Client: Euler Hermes (Allianz Trade).

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.

Allianz

Trade offers a range of services, including credit insurance, bonding, guarantees, and debt collection services with a strong international presence, Allianz Trade helps businesses of all sizes and industries to trade with confidence, both domestically and internationally. The company leverages its vast network and expertise to provide valuable insights and tailored solutions to its clients.

• 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 at Allianz Technology (2015-06 – 2019-06)

Client: ABS-Greece, CEE, Turkey, ACSF, AWP and ARE.

ABS Greece: In Greece, ABS supports local insurance operations by providing a comprehensive platform for managing policy administration, claims processing, and customer interactions. This ensures consistency and efficiency in delivering insurance services tailored to the Greek market. ABS CEE (Central and Eastern Europe): In the CEE region, ABS is adapted to meet the diverse regulatory and market requirements across various countries. It allows Allianz to offer a consistent level of service while accommodating local market nuances and facilitating cross-border operations. ABS AWP (Allianz Worldwide Partners): For Allianz Worldwide Partners, which provides assistance services, ABS is used to streamline operations such as travel insurance, roadside assistance, and health services. The system supports the global reach and diverse service offerings of AWP, ensuring efficient service delivery worldwide.

ABS Turkey: In Turkey, ABS is utilized to manage a wide range of insurance products, including motor, property, and health insurance. The system helps Allianz Turkey to efficiently handle policy and claims processes, ensuring high-quality customer service in a competitive market. Each implementation of ABS is tailored to meet local business needs while maintaining the core functionalities and benefits of the system.

Allianz Real Estate: Allianz's Corporate Real Estate Management is responsible for managing the company's real estate portfolio with three core objectives

• Portfolio Optimization — Overseeing properties in terms of occupancy, flexibility, attractiveness, and cost efficiency.
• Operational Excellence — Managing facilities to ensure user satisfaction and support business goals.
• Sustainability — Collaborating with ESG teams to meet environmental targets through building operations and sustainable practices.
• Projects are managed through defined roles and core processes with all documentation organized in the Allianz DMS using a structured, dossier-based system for easy access and compliance.
• 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 in Electrical and Electronics Engineering – Anna university Chennai