Joydeep Bhattacharjee Email & Phone Number

Bengaluru, Ka, In

Bengaluru Area, India

Currently, I am a part of a global distributed database team, providing firm-wide support for global database plants.One of my key roles is to collaborate with database users, reviewing the performance of their database jobs and identifying areas for optimization. worked with users for Query optimization, Physical modelling and Warehouse consideration .Furthermore, I have embraced the DevOps mindset and have utilized my programming skills in Python, Perl, and shell scripting to automate database tasks and streamline infrastructure-related jobs. This has allowed for smoother and more efficient deployment and maintenance processes.In addition to my core responsibilities, I am actively involved in developing and optimizing automated database processes . By leveraging my skills in Perl, Python, and shell scripting, I have successfully automated various database activities and infrastructure-related tasks, significantly reducing the overall man-hours required to maintain the existing infrastructure.Overall, I bring a comprehensive skill set, hands-on experience, and a commitment to continuous improvement in optimizing database performance and automating processes. I am passionate about leveraging technology to drive operational excellence and deliver value to organizations.

India

In my previous role within IBM Global Technology Services, I successfully managed multiple accounts for the EMEA banking vertical. My responsibilities encompassed the installation, configuration, and implementation of database software across various platforms.I played a key role in automating backup and database maintenance jobs for customer databases, streamlining processes and improving efficiency. Additionally, I developed a comprehensive automated daily health check system for the DB2 environment, ensuring the smooth operation of customer databases.I excelled in resolving complex issues through root cause analysis and implementing effective corrective measures. This approach enabled me to consistently deliver high-quality solutions and drive continuous improvement.One of my significant contributions was setting up Proof of Concept environments to showcase requested technologies to customers. I provided valuable input, advice, and technical support, particularly in areas such as DB2 upgrades, utilization of new features, and leveraging the capabilities of the latest releases.Through my expertise and dedication, I consistently delivered exceptional results, enhancing customer satisfaction and contributing to the success of each account. I am eager to leverage my skills and experience to drive innovation and deliver value in my next endeavor.

India

During my tenure at a US-based insurance company, I took on the responsibility of migrating customer databases, ranging from small to medium in size, from a standalone p-series platform to a DBaaS (Database-as-a-Service) environment.To ensure a seamless and successful migration, I meticulously developed a comprehensive procedural document outlining the step-by-step process. This document served as a valuable resource for the team and facilitated efficient execution of the migration.By leveraging my expertise in database migration and my ability to navigate complex technical environments, I successfully completed the migration of customer databases to the DBaaS platform. This transition not only ensured improved scalability and flexibility but also optimized resource utilization for the company.I am proud of my contributions in enabling a smooth and efficient migration process, and I look forward to utilizing my skills and experience to drive similar trans-formative initiatives in future endeavors.

India

In my previous role at a US-based insurance organization, I served as an Application DBA, responsible for enhancing and preparing stored procedures, functional and technical specifications, and complex SQL queries.Utilizing my expertise in database management, I effectively utilized Db2 tools and administrative views to identify SQL bottlenecks. This allowed me to provide valuable index recommendations and fine-tune queries to optimize performance and enhance overall efficiency.I take pride in my ability to analyze complex SQL queries and implement optimizations that significantly improve application performance. By leveraging my strong understanding of database architecture and query execution plans, I consistently delivered high-quality solutions that enhanced the functionality and responsiveness of critical applications.I am excited to continue utilizing my skills as an Application DBA to drive innovation and maximize the performance of databases in future roles.

India

I was deployed at client location which was IBM India Pvt limited , where i had to handle L2 Support for US based retail Bank.My roles and responsibilities was to make Changes in Database Manager and Database Configuration following change management process .Activity involved in incident management process where i had to analyzing DB2 Logs, DB2 Notifications Logs and using db2diag utility.Review Daily / weekly /Monthly DBA maintenance logs and notify database users for the cause of failure .DB2 Installation/migration on UNIX and Linux, Fix Pack Installation.

India

Technical Summary :-•Involved in database installation.•Changes in Database Manager and Database Configuration.•Fix pack installation.•Database Maintenance for Production, Testing, Development•Database, Table-space and DB objects creation and maintenance•Analyze and implement DB2 Reorg utility based on the need for database reorganization performance optimization.•Monitor DB2 UDB databases for space utilization and performance degradation and tune as needed. •Determine need for DB2 UDB utilities and implement to enhance performance.•Generate DDL statements for database objects & move database objects .•Backup and Recovery Procedures planning and implementation, Monitoring Backup.•Daily / weekly /Monthly DBA maintenance tasks. •Administration of Database in Production and Test environment with IBM DB2 9/10.•DB2 Installation/migration on UNIX and Linux, Fix Pack Installation and Rollback.•Database Performance Tuning, Troubleshooting, Monitoring and Alerting.•Perform Database Configuration (Instance Configuration and Database Configuration)•Perform Database Storage Management - Tablespace Allocation.•Database Security - Setting up Users and roles, granting and revoking privileges.•Perform Database Backup and Recovery using utilities.Perform various types of Backups and Recoveries such as Offline/Online backups, Incremental Backups.•Database HADR (High Availability and Disaster Recovery) – Setup, Failover, Takeover. Advanced HADR such as setting Multiple Standby Databases.•Running DB2 Problem Determination tools such as db2pd, db2mtrk, db2dart.•Analyzing DB2 Logs, DB2 Notifications Logs and using db2diag utility.•Database Monitoring with Snapshot Monitoring, Event Monitoring and Table Functions.•Coordinating with User Manager Group for setting up new users.