Karthik B R Email and Phone Number

Responsibilities> Transition of implemented projects across Cloud/ DB to Operation teams> Tender review for new Cloud/ DB Tech-Refresh projects> Review of On-prem to Cloud [Azure/ AWS] migration approach/ architectures before presenting to Architecture Board for approvals> Review Migration approachs across same and different Oracle versions considering various factors [Limitations, Effort, Downtime, Environment, Cost ..] - Oracle 11g / 12c to Oracle 19c/ 21c [Exadata/ Non-Exadata] [Migration Methods - Inplace, OGG, XTTS …] - Oracle 19c to Oracle 19c [Oracle Data Guard] - Standardize moving from Non CDB to CDB environment during 19c/ 21c migration> Expore how to align and take benefit of Oracle 19c new featues [Auto Indexing, Flashback, RTS ....]> Review End of Lifecycle for On-prem DBs [Oracle, MS-SQL, DB2...] and identify new version and migration strategy/ approach

Customer: Energy/ Utility Client, Malaysia> Played role of lead architect, proposed/ supported end to end delivery - HA and DR architecture solution for DB2 and MS-SQL databases- Architectural change for moving from 2 node VERITAS cluster to 2 node DB2 HA cluster- Migration of ORACLE, SQL, DB2 DB backups from Commvault to Dell DDDrove both HADR & RE programs accounting to revenue XXM RM> CIAs Proposed- Modify HP-UX Kernel Parameters / Enable INTRA_PARALLEL DB2 DBM config parameters> POCs- [AZURE] - Migrated MSSQL 2019 DB to AZURE PAAS managed instance- [AWS] - Deployment of static website using S3- [AWS] - Setup and Configure AWS VPC in POC environment> Solutions proposed for RFPs- Design and implementation of DAM- DB2 to MS-SQL Migration- Migration to SAP HANA- Tech refresh to EXADATA - Proposal for Backup & DBA Support- Migration of Billing system to SAP HANATechnologies:CLOUD - AWS, Azure, Oracle | DB - MS-SQL, DB2 LUW | DB BACKUP TOOLS - Commvault, Dell DD | CLUSTER MANAGERS - Veritas, HPE Service Guard

Customer: Banking/ Insurance Client, USA, North Europe, UK> Played a dual role of DB Solutions Architect/ SME - DB Admin and managed/ mentored a team of 15 L2/L3 DBAs to support delivery for ORACLE DB, MSSQL DB, DB2 z/OS, IMS z/OS, DB2 Connect, DB2 LUW, SQL & Q-REPLICATION & Mongo DB technologies> Major Projects planned and implemented[DB2 z/OS] - DB2 v10 CM to NFM, DB2 v10 NFM to DB2 v11 CM Upgrade[IMS z/OS] - IMS Segment restructure[IMS z/OS] - IMS v9 to v12 Upgrade[DB2 LUW, MSSQL 2017] - DB2 v10.5 LUW DB to MSSQL 2017 migration using SSMA tool[MONGO DB] - Configure & Monitored Mongo DB deployments using Ops Manager[MONGO DB] - Automated monitoring of Replica sets[MONGO DB] - SOPs proposed for addressing stale replica set issues[MSSQL] - Migration from MSSQL 2014 to 2017[ORACLE] - Develop/ Implement RMAN Backup strategies[ORACLE] - Installation & configuration of Golden gate replication> COMMUNITY CONTRIBUTION [Delivered AWS open house sessions] - Kick Start of AMAZON Cloud, Migration to AMAZON EC2 - AWS VPC - Virtual Private Cloud - AWS Elastic LOAD Balancer

Customer: Banking/ Insurance Client, USA, North Europe, UK> Projects planned and implemented[MAINFRAME] - Migration of Mainframe datacenters from Atlanta, USA to Lognes, France[REPLICATION] - Install/Config Data Propagator, Data Joiner, register/ tune source/ target[REPLICATION] - Upgrade Data Propagator to Infosphere replication server[REPLICATION] - Upgrade Data Joiner to Federation Server[DB2 z/OS, LUW] - Plan/ Execute version upgrades/ fixpack/ SB installation[DB2 z/OS, LUW] - Plan backup/ recovery/ maintenance strategies, create SOPs[DB2 z/OS, LUW] - Plan and implement proactive space monitoring[IMS z/OS] - Administration SOPs for HDAM, HIDAM, HISAM, HALDB [PHDAM, PHIDAM] Databases[IMS z/OS] - DB Initialization / Registration/ DBRC Setup/ RECON Reorganization setup/ Introduce GENGCL for CA, IC & RECOV[DB2, ORACLE, MSSQL] - SOX Audit/ Recertification controls[MSSQL] - Active-Passive, Active-Active clustering setup, Migration to MS-SQL 2008 TDE[MSSQL] - Configuration of Database Mirroring[ORACLE] - Installation/ Configuration of ORACLE 11g/ patch set update[ORACLE] - Preparation of ORACLE test-bedTechnologies:CLOUD - DB - ORACLE, MS-SQL, DB2 z/OS, LUW, MS-SQL, IMS DB | REPLICATION - IBM INFOSPHERE REPLICATION - Q, SQL Replication

Was Responsible for: - Transition of DB2 z/OS, IMS z/OS and DATACOM Database administration support for Australian Insurance entity from Vendor - DB2 z/OS Administration • Online utilities - COPY, REORG, REBUILD, LOAD, RECOVER • Offline utilities - DNS1PRINT, DSN1COPY • Plan and remediate application impact for DB2 v8 NFM to v9 CM Upgrade, v9 CM to v9 NFM Upgrade - IMS z/OS Administration • Support Administration of Full Function DBs - HISAM, HDAM, HIDAM • Perform IMS RECON Maintenance • VSAM to OSAM conversion • Setup and test recovery from Change Accumulation • Setup and test Batch backout Jobs - DATACOM z/OS Administration • DB Utility - BACKUP, EXTRACT, LOAD, RECOVERY, REPORT • Data dictionary Online/Batch Usage • Usage of Reporting Facility • Referencing and understanding of CXX, PXX and FXX Areas

Customer : IBM NetherlandsWas Responsible for :- COBOL DB2 Code deployment, Code migration across environments- COBOL code review and code promotion from UAT to Production- Automation of code deployment using Keyboard Macros- DB2 v8 z/OS Administration • Online utilities - COPY, REORG, REBUILD, LOAD, RECOVER • Offline utilities - DNS1PRINT, DSN1COPY • DB2 data refresh from production to UAT environments • Schedule DB2 admin housekeeping in OPCTechnologies:COBOL II, DB2 DBA, JCL, VSAM, CICS, OPC, SCLM

Customer : DSRC [Inhouse projects]Was Responsible for:- Requirement gathering, mainframe program development- COBOL, DB2, CICS Screen coding- COBOL DB2 code review, implement code standards, code version control- Testcase preparation, Black box/ White box testing- Usage of xpeditor to debug code- Support Inhouse trainingTechnologies:COBOL II, DB2, JCL, VSAM, CICS, PANVALET

Customer: US Based relocation clientWas Responsible for:- Requirement gathering, mainframe program development- COBOL, DB2, CICS Screen coding- COBOL DB2 code review, implement code standards, code version control- Testcase preparation, Black box/ White box testingTechnologies:COBOL II, DB2, JCL, VSAM, CICS, PANVALET