Soumitra Bhandary — Software Engineer

Specialist in ClickHouse , Postgres , MSSQL and REDIS Database Administration . Automation using Ansible. Click house DBA: Administered and managed large-scale ClickHouse distributed clusters supporting high-volume analytical workloads (300TB–500TB datasets) for real-time and batch analytics platforms. • Designed and implemented multi-shard, multi-replica ClickHouse architectures to ensure high availability, fault tolerance, and horizontal scalability for enterprise data platforms. • Installed, configured, and maintained ClickHouse clusters across multiple nodes, including shard configuration, replica management, and distributed tables for high-throughput analytical queries. • Engineered data partitioning and sharding strategies based on query patterns and data lifecycle to optimize query performance, data distribution, and storage efficiency. • Implemented ClickHouse replication using ReplicatedMergeTree engines to ensure data durability and seamless failover across nodes. • Configured and managed ZooKeeper/ClickHouse Keeper for cluster coordination, replication management, and distributed metadata consistency. • Tuned ClickHouse server configurations including max_threads, max_memory_usage, merge settings, background pool sizes, and query execution parameters to improve system throughput and stability under high concurrency. Postgres DBA: 1. Postgres DB server set up in cloud based or in house servers . 2. High availability (master - slave or master - master) replication setup across region. 3. DR server set up. 4. Configure and manage Postgres database fail over process with REPMGR / EFM . 5. Load balancing using pgpool. 6. Set up one single point access for the application server to Postgres DB configured with HA using Virtual IP (watchdog). 7. Backup recovery using BARMAN and BART (EDB Tool) 8. Point in time recovery of Postgres database in HA mode. 9. Performance tuning of existing DB queries. 10.Db components like stored procedure / functions . packages / triggers /views complex reporting queries development. Kubernetes administrator: 1. Experience in container orchestration using Kubernetes. 2. Managing K8s deployment / replicaset / pods 3. Implementation of helm chart based deployment. Database Architect / Database engineering: 1. Migration and design of various database architecture for leading healthcare , financial , insurance and telecom customer. 2. Having experience of working with very large size (TB range). 3. SQL performance troubleshooting of complex queries (in Producation) in very large size (TB range) datbases.

Stackforce AI infers this person is a Database Architect specializing in high-availability solutions for enterprise-level applications.

Location: Bengaluru, Karnataka, India

Experience: 15 yrs 3 mos

Skills

Clickhouse Database Administration
Database Architecture
Postgresql Database Administration
High Availability Setup
Automation
Database Migration
Team Leadership
Database Development

Career Highlights

Expert in ClickHouse and PostgreSQL database administration.
Proven track record in high availability and disaster recovery setups.
Strong automation skills using Python and Ansible.

Work Experience

Kickdrum

Database Architect (4 yrs 6 mos)

Micro Focus

Software Engineer (2 yrs 4 mos)

Juniper Networks

Software Engineer 4 -Postgres Database Administrator (7 mos)

Motorola Solutions

Senior Software Specialist - Postgres Database Administrator (7 mos)

Kronos Incorporated

Lead Postgres (EDB) Database administrator (2 yrs)

Tata Consultancy Services

IT Analyst (1 yr 2 mos)

System Engineer (4 yrs 1 mo)

Education

Bachelor of Technology - BTech at College of Engineering and Management, Kolaghat (CEMK)

Soumitra Bhandary

Software Engineer

Bengaluru, Karnataka, India15 yrs 3 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in ClickHouse and PostgreSQL database administration.
Proven track record in high availability and disaster recovery setups.
Strong automation skills using Python and Ansible.

Stackforce AI infers this person is a Database Architect specializing in high-availability solutions for enterprise-level applications.

Contact

Skills

Core Skills

Clickhouse Database AdministrationDatabase ArchitecturePostgresql Database AdministrationHigh Availability SetupAutomationDatabase MigrationTeam LeadershipDatabase Development

Other Skills

ClickHouseDatabase AdministrationHigh AvailabilityFault ToleranceData PartitioningSharding StrategiesReplicationZooKeeperPerformance TuningPostgresLoad BalancingBackup RecoveryStored ProceduresTriggersAWS RDS

About

Experience

15 yrs 3 mos

Total Experience

2 yrs 6 mos

Average Tenure

4 yrs 6 mos

Current Experience

Kickdrum

Database Architect

Dec 2021 – Present · 4 yrs 6 mos · Bengaluru, Karnataka, India · Remote

ClickHouseDatabase AdministrationHigh AvailabilityFault ToleranceData PartitioningSharding Strategies+5

Micro focus

Software Engineer

Aug 2019 – Dec 2021 · 2 yrs 4 mos · Bengaluru, Karnataka, India

PostgresHigh AvailabilityReplicationLoad BalancingBackup RecoveryPerformance Tuning+4

Juniper networks

Software Engineer 4 -Postgres Database Administrator

Jan 2019 – Aug 2019 · 7 mos · Bengaluru Area, India

Postgres Database Administrator and RDBMS Expert
1. Postgres Database Administration in AWS RDS/ Google cloud based environment .
2. Configure and maintain Postgres Bidirectional replication (BDR) with multiple master node.
3. Master Slave HA Replication set up and maintenance . Configure fail over manager using REPMGR.
4. Automation of deployment and DB server monitoring process using python and shell scripting.
5. Point in time recovery of postgres database in HA mode.
6. Pgbadger implementation for DB server monitoring .
7. Installation and configuration of Enterprise Fail over Manager (EFM) to manage the auto fail over in HA set up in EDB .
8. Set up Postgres Enterprise Manager (PEM) browser to access database using http URL and monitoring of the Postgres database.
9. Scripting using shell and python.
10. Postgres DR server set up with HA replication cluster.
11. Taking snapshot at disk level and restoration of the same snapshot using google / AWS APIs in cloud.
12. Point in time recovery of postgres Database .
13. Performance tuning of existing SQL DB queries.

PostgresAWS RDSPythonShell ScriptingAutomationMonitoring+1

Motorola solutions

Senior Software Specialist - Postgres Database Administrator

Jun 2018 – Jan 2019 · 7 mos · Bangalore

1. Postgres Database Administration in AWS RDS/ Google cloud based environment .
2. Configure and maintain Postgres Bidirectional replication (BDR) with multiple master node.
3. Master Slave HA Replication set up and maintenance .
4. Automation of deployment and DB server monitoring process using python and shell scripting.
5. Point in time recovery of postgres database in HA mode.
6. Pgbadger implementation for DB server monitoring .
7. Installation and configuration of Enterprise Fail over Manager (EFM) to manage the auto fail over in HA set up in EDB .
8. Set up Postgres Enterprise Manager (PEM) browser to access database using http URL and monitoring of the Postgres database.
9. Scripting using shell and python.
10. Postgres DR server set up with HA replication cluster.
11. Taking snapshot at disk level and restoration of the same snapshot using google / AWS APIs in cloud.
12. Point in time recovery of postgres Database .
13. Performance tuning of existing SQL DB queries.

PostgresAWS RDSPythonShell ScriptingMonitoringPostgreSQL Database Administration+1

Kronos incorporated

Lead Postgres (EDB) Database administrator

May 2016 – May 2018 · 2 yrs · Noida Area, India

Working as Lead Postgres (EDB) Database administrator at KRONOS SOLUTION PVT LIMITED.
1. Postgres Database(EDB) Administration in a cloud based Work Force management product.
2. EDB installation in cloud set up.
3. Replication set for high availability in different region (both Synchronous / Asynchronous).
4. DR environment set up and monitoring including replication.
5. EFM installation and configuration to manage the auto fail over in HA / replication set up.
6. Taking snapshot at disk level and restoration of the same snapshot using google APIs in Google cloud.
7. PEM server and agent installation for monitoring purpose.
8. Point in time recovery of Postgres database in HA / replication mode.
9. Taking back up and restoration of the Postgres Database .
10. Unix shell scripting
11. Performance tuning of existing complex DB queries.

PostgresEDBCloud SetupHigh AvailabilityPerformance TuningPostgreSQL Database Administration+1

Tata consultancy services

2 roles

IT Analyst

Feb 2015 – Apr 2016 · 1 yr 2 mos · Kolkata Area, India

Worked as a team lead for Cognos BI Migration Project in healthcare domain.
Primary responsibility was
1. Leading a team size of 6 resources
2. Moving reports in Cognos BI server from one dedicated server to one shared server.
3. All the SQL based reports need to be replaced with the query subject using Framework manager and publish them through package.
4. Upgrade the Cognos Bi server from 10.1.1 to 10.2.2.

Cognos BISQLDatabase DesignETLDatabase MigrationTeam Leadership

System Engineer

Dec 2010 – Jan 2015 · 4 yrs 1 mo · Kolkata Area, India

Worked as Database Team Lead in two Development projects of HRMS application and Attrition Modeler Application having 3.3 lac of active employee.
Primary Responsibility was
1. Leading a Database development team of 16 resources.
2. Analysis of the requirement and as per the requirement Database design of HRMS application.
3. Migration of data base (size 500 GB) from existing ERP-HRMS to new customized HRMS application using PL / Sql procedures.
4. Development of various HRMS modules like Recruitment, Employees conﬁrmation, Deputation and location transfer, Data processing for Payroll , Data processing for MIS reporting using PL/Sql Packages,procedures and functions.
5. Interface development from HRMS to various other application through ETL. 5. HRMS Job Scheduling using Informatica .

Database DevelopmentPL/SQLETLTeam Leadership