Shayan Mazumdar

About Shayan Mazumdar

Overall 12+ years of experience in IT industry.Currently working as a Lead Database Engineer in Synchronoss Technologies. I currently work on Cassandra & Elasticsearch as my primary skills and work on AWS, MySql as my secondary skill besides having prior experiences on DB2 & PostgreSQLAPACHE CASSANDRA -6+ years of working IT experience Cassandra Database administrationExperience of working on Apache Cassandra 3.11.4, 3.11.13, 4.0.10, 4.1.7 versionsBuild and maintain the Cassandra clustersDevelop data models and perform planning of architecture, functions, recovery standards and implementationHave experience of working with Cassandra query languageHave experience of working on Cassandra upgrade, Cassandra installation, Cassandra graviton migration, Cassandra migration from on-prem to cloudHave worked on medusa, reaper, grafana tools2+ years of working IT experience in MySQL Database Administration2+ years of working IT experience in Elasticsearch Database administrationDB2 UDB LUW -9+ years of working IT experience in DB2 LUW Database administrationExperience on DB2 v(9.5), v(9.7), v(10.5)Good knowledge of DB2 architectureManaging of DB2 databases using db2top,db2pd, snapshot, diaglog, db2lookManaging user space and database spaceManaging active log, archive log, tempspace utilizationDetecting and resolving issue like lockwait, deadlock, set integrity pending, tablespace backup pending, load pending.Maintaining table indexes using reorg and runstats utilityMonitoring DB backups and issues related to themRestoring Production databases to non-prod environment and issues related to them.Refreshing table data using export, load utilityExperience of working in performance related issuesHave worked on DPFThis resume is made with CVwizard.com.Have worked on db2 installation, db2 fix pack, db2 upgradeHave worked on HADR set up, TSAMP, rolling upgrades, version upgrade in HADR setupHave knowledge on Q-replicationPOSTGRESQL -6+ years of working IT experience Postgresql Database administrationExperience of working in Banking, Finance, Logistics, Energy domainsExperience on versions 9.5, 9.6, 10, 13Good knowledge of MVCC architectureHave worked on build from source installation, cluster upgrade, replication setup, backup and restoreHave worked on oracle to Postgresql migration using Ora2PG toolHave worked on performance tuning of queriesDetect and resolve long running queries, waiting queries, blocking queriesHave experience of working on pgadmin, pgbackrest, pgpool, repmgr

Experience

1. Solutions Architect

   Wipro

   Jul 2025 — Present · Bengaluru, IN

Education

• Biju Patnaik University of Technology, Odisha

  Bachelor of Technology (B.Tech.), Electrical, Electronics and Communications Engineering

  2008 — 2012

Skills

• Database Administration
• Db2
• Unix
• Databases
• Software Installation
• Access
• Management
• Sql
• Linux
• Ibm Aix