Rajat Bhasin

Experience

• 

  Tata Consultancy Services

  Mar 2007 - Apr 2010

  Asst. System Engineer

  Worked as Database Administrator for DB2 LUW. • Involved in installing DB2 UDB on AIX.• Implemented both Multi-partitioned and single partition Database.• Applied fixpaks on DB2.• Migrated DB2 instance from 17 nodes to 33 nodes, by adding two new BCU with eight partitions each.• Successfully performed drill Activity of DB2 by creating replicated environment of production and restoring the database from backup Image.• Installed and worked on Query Patroller.• Worked on Tivoli Storage Manager for DB backup.• Giving Production support for 8TB partitioned Database. Show less

• 

  IBM Global Business Services

  Apr 2010 - Dec 2010

  Sr. System Engineer

  Worked as Database Administrator for DB2 LUW. • Creating and Designing Database Logical Data model to Physical Data Model.• Designing buffer pools, table spaces. • DB2 development Activities.• Worked on Table Partitioning, MQT and MDC.• Worked with export, import, load utilities to manage table data.• Performance monitoring and tuning.

• 

  IGATE

  Dec 2010 - Jul 2015

  • Providing Database Administration Support on Production, QA and Development database servers.• Working as SME (Subject Matter Expert) on DB2 UDB upgrade, migration and New features Implementations.• Worked on POC and implementation of various IBM tools like OCM, OPM, OWQT.• Capacity planning for new application and designing of databases per the requirements.• Worked in Performance tuning ,up-gradation and migration projects. • Worked on POC for new features comes with DB2 10.1 and DB2 10.5• Present the POC to group of DBAs to implement new feature in MetLife Applications.• Documenting the Standard Operating Procedures and Maintaining Operational Handbooks• Provide production support to MongodDB database• Worked on Installation, Upgrade, Configuration, Administration, Monitoring, Maintenance of Mongo 2.2, 2.4, 2.6. Setting up Cluster and High Availability Disaster Recovery solutions for MongoDB. Show less • Provide support to all UDB Environment including Development, UAT and Production support.• Worked in Performance tuning ,up-gradation and migration projects. • Maintained the databases (DDL, DML) performing the database administration tasks such as creation of databases, creating DB objects.• Established recovery and backup processes for databases , according to service level requirements• Participate in database technical reviews and walkthroughs of database design.• Performed daily analysis of statistics and database behavior and recommending improvements, using RUNSTATS Utility, creating an historical database with the tables and indexes statistics (size, nlevels, Clusterratio, extents)• Created scripts to perform several Database tasks, such us Backups, Extraction, Load, Archiving and other related task with the different Databases environments.• Database migration from SQL/ Oracle to UDB DB2. Show less

  • Technical Specialist

    Feb 2013 - Jul 2015

  • Technical Lead

    Dec 2010 - Jan 2013
• 

  MetLife

  Jan 2013 - Jan 2014

  • DBA

    Jan 2013 - Jan 2014

  • DBA

    Jan 2013 - Jan 2014
• 

  HCL Technologies

  Aug 2015 - Mar 2020

  Senior Consultant

  Defined IT Infrastructure transformation strategy, cost optimisation solutions. Led technology transformation initiatives for legacy application transformation. Built teams to deliver solutions in various countries including US, Europe, along with India. Perform technical development for cloud solutions as part of a design and development frameworkExtensive experience in deploying cloud assessment and discover tools like Cloudscape, cloudamize (discover tool promoted by Azure)and Movere (Discovery tool promoted by AWS).Define strategy and technology vision with key business partners within business echo system. Build estimates and program related budgeting, purchasing, and implementation plans. Define new architecture for target Cloud environment and coordinate to ensure technology architecture compliance with existing standards. CNP-Database is HCL internal Database practice team, works for enablement and competency building for HCL in various cloud native database technologies.As an architect, I am responsible for:Technical solutioning for RFP’s for both traditional on-prem & cloud-native databases.Creating advisory report based on the database assessment for the feasibility of database migration on to cloud platform including both homogeneous and heterogeneous migrations.Developed database as a service for various database with opensource automation engine ‘Ansible’. Show less

• 

  MongoDB

  Mar 2020 - now

  • Manager, Solutions Architect

    Feb 2024 - now

  • Senior Solutions Architect

    Feb 2021 - now

  • Solution Architect

    Mar 2020 - Feb 2021