Hemkalyan Pal

About Hemkalyan Pal

Having total of 14 years of experience in UDB DB2 LUW, open source RDBMS and NoSQL database (MongoDB, PostgreSQL) Technology, AWS Cloud Solution with DR solution in LINUX,Z-LINUX, AIX, UNIX and Windows environment.• Expertise and specialist in DB version migration• Setup in production Db2 HADR Automation with Pacemaker• Set Up a Highly Available Database on AWS with IBM Db2 Pacemaker• Experienced (Amazon RDS) for Db2• Worked with different Versions of db2 installation,Fixpack• Use to take backup for databases and experience in scheduling it.• Expertise in db2restore, Redirect restores, Table restore,• Expertise in data movement utilities (load, import, export, db2move)• Scheduling and performing reorg, and run stats, compression, Admin move Table.• expertise on tuning of DB and DBM cfg parameters.• Done performance tuning, query tuning as per requirement.• Implementing TSMAP cluster • Expertise in creating Database object.· Experience in maintenance of databases and troubleshooting.• Implement Database performance Manager.• Analysis DB2DART process with hardware configuration • Working with in Mongo Db database replication, sharding, operations, Performance tuning• Resolves issues regarding patches and impact analysis, and application issue resolution and with developers, business analysts, and end users to provide system administration support• Assists in designing, building, deploying and maintaining MongoDB databases• Involved in the daily activities of configuration and system administration associated with non-production environments• Optimizes system operation, performance, and resource utilization and participate in system capacity analysis and planning• Executes extremely large, highly complex MongoDB projects/ datasets. Assists in documenting cluster strategies and architectures• Assists in the installation, configuration, and upgrading of non-production MongoDB software and related products• experience in IT industry comprising of build release management, software configuration, design, development and cloud implementation.• Cognitive about designing, deploying and operating highly available, scalable and fault tolerant systems using (AWS). • Extensively worked using AWS services along with wide and in depth understanding of each one of them.• Highly skilled in deployment, data security and troubleshooting of the applications using AWS services. • Experienced in implementing Organization DevOps strategy • PostgreSQL database administrator designing and deploying PostgreSQL databases

Experience

1. Senior Database Specialist

   IBM

   Sep 2019 — Present · IN

Education

• Bankura Unnayani Institute Of Engineering

  B.Tech, Computer

  2006 — 2010

Skills

• Performance Tuning
• Databases
• Ibm Aix
• Storage
• Db2
• Database Administration
• Itil
• Db2 V10.1
• Microsoft Office
• Sql
• Linux
• Microfocus
• Java
• C
• Unix
• Itil V3 Foundations Certified