Shubhra is available for hire
Hire ShubhraShubhra Prakash Nandi
Verified Expert in Engineering
SQL Developer
Kolkata, West Bengal, India
Toptal member since February 13, 2018
Bio
Shubhra has over 19 years of IT experience in application development, systems integration, production support, application maintenance, and quality assurance (QA) projects. He has worn many hats in the development lifecycle, working as a project manager, project lead, business analyst, developer, and QA. Shubhra has also managed the complete SDLC for medium-sized projects.
Portfolio
ISub Softwares
Solution Architecture, Microservices, REST APIs, CTO, IT Consulting...
Ayyeka
MySQL, MySQL DBA, MySQL Clustering, RDBMS, Partitioning, Data Compression...
We Rent Copiers
Server Administration, Linux, CUPS, Print Server, PAM authentication, LDAP...
Experience
- SQL - 16 years
- RDBMS - 15 years
- Data Modeling - 15 years
- MySQL - 10 years
- CTO - 8 years
- Web Services - 8 years
- Solution Architecture - 8 years
- High Availability Disaster Recovery (HADR) - 4 years
Work Experience
CEO | CTO
2016 - PRESENT
ISub Softwares
- Created an end-to-end solution design and architecture for a complex application in a sustainability domain involving REST API, hybrid data model, and cloud infrastructure. Managed five people from requirements gathering to testing and DevOps.
- Created a full MySQL HA cluster with five instances, a hot database backup with snapshots and a replication server, a chained replication for keeping a disaster recovery backup copy offsite, and automated failover for cluster-instance failure.
- Developed the full solution architecture for a SaaS application using RESTful microservices for handling millions of users. Built for a large scale-out on the cloud.
- Assisted the client with the database management of a large MySQL database, using table partitioning, partition archiving, performance tuning, and analysis of database crashes due to deadlocks and waiting for lock timeout, which reduced gap locks.
- Helped a client migrate from a managed MySQL database service on a cloud platform to a VM for better efficiency, tuning, and resource utilization. Set up replication instances for hot backup and point-in-time recovery.
Technologies: Solution Architecture, Microservices, REST APIs, CTO, IT Consulting, Cloud Computing, Disaster Recovery Consulting, Data Migration, High Availability Disaster Recovery (HADR), Startup Consulting, Software Consulting, Data Modeling, Web Services, SQL, Shell Scripting, Linux, MySQL Workbench, MySQL Clustering, Subversion (SVN), Business Continuity Planning (BCP), Business Continuity, Business Continuity & Disaster Recovery (BCDR), Continuous Integration (CI), Project Estimation, Lean Development, Waterfall Development, Disaster Recovery Plans (DRP), Database Replication, Jenkins, Databases, Database Design, Database Architecture, Stored Procedure, Amazon Aurora, Cluster, LDAP, OpenLDAP, Database Administration (DBA), MySQL DBA, PHP Data Objects (PDO), Database Modeling, Containers, Cloud, Bash Script, Software Development Lifecycle (SDLC), GNU, RDBMS, Unix Shell Scripting, Data Engineering, Data Quality, Business Requirements, Business Analysis, Process Design, Process Flows, Query Optimization, DB, Database Backups, Google Cloud SQL, Infrastructure as Code (IaC), Google Cloud, Database Optimization, Data Taxonomy, Data Architecture, Metadata, Performance Tuning, SQL Performance, Quality Assurance (QA), Architecture, Scripting, DevOps, Database Performance, Database Schema Design, JSON, SQLite
MySQL DBA and DevOps Engineer
2024 - 2026
Ayyeka
- Provided standby consultancy support for a high-volume MySQL database. Work included optimization/architecting. The required response time was the next business day (or earlier).
- Provided standby support for upgrades/changes on production - Responded within 48 hours at least. These upgrades/changes usually took place on Sundays, and response time was within one hour or less.
- Provided emergency support for rare events with no prior notice. Provided response within 20 minutes. The availability required was 24/7.
Technologies: MySQL, MySQL DBA, MySQL Clustering, RDBMS, Partitioning, Data Compression, High Availability Disaster Recovery (HADR), Performance Tuning, SQL Performance, Architecture, Scripting, DevOps, Database Performance, Database Schema Design, Database Monitoring, Database Scaling
Senior Linux Administrator
2024 - 2026
We Rent Copiers
- Created a Linux instance on AWS tailored for the CUPS print service.
- Configured CUPS for secure public internet access, ensuring robust security and encryption measures are in place.
- Implemented authentication mechanisms using the Linux machine's user accounts or by setting up an LDAP server.
- Assigned printer-specific permissions to manage access and print queues effectively.
- Assisted in the configuration of network printers and copiers connected through a WireGuard server, ensuring seamless printing across venues in the United States.
- Provided ongoing support and management of the system, addressing any issues or updates as required.
Technologies: Server Administration, Linux, CUPS, Print Server, PAM authentication, LDAP, Architecture, Scripting, DevOps, Database Monitoring, Database Scaling
Database Engineer
2022 - 2022
FlipWell, Inc.
- Created the data model and the database for storing real estate data in AWS.
- Built a REST API to expose the real estate database to external consumers.
- Developed batch jobs to load large CSV data files from external sources into the real estate database.
- Managed the AWS Cloud servers for hosting the database and REST API.
Technologies: Amazon Web Services (AWS), Data Engineering, SQL, REST APIs, Data Modeling, Database Design, Documentation, PHP, PHP MVC, Linux, MySQL Workbench, Databases, Database Architecture, Amazon Aurora, Database Administration (DBA), MySQL DBA, PHP Data Objects (PDO), Database Modeling, Containers, Cloud, Bash Script, Software Development Lifecycle (SDLC), GNU, RDBMS, Unix Shell Scripting, Data Quality, Business Requirements, Business Analysis, Process Design, Process Flows, Query Optimization, DB, Database Backups, Google Cloud SQL, Google Cloud, Database Optimization, Data Taxonomy, Data Architecture, Metadata, Performance Tuning, SQL Performance, Quality Assurance (QA), Architecture, Scripting, DevOps, Database Performance, Database Schema Design, Database Monitoring, Database Scaling
API Developer
2022 - 2022
Isub Softwares (Opc) Private
- Developed a REST API back end and a database for CRM. The CRM database was exposed to external consumers via the REST API.
- Built a robust ACL into the REST API and the database since security was an important consideration.
- Managed the Google Cloud infrastructure of hosting web services and CRM database.
Technologies: REST APIs, Google Cloud Platform (GCP), Database Security, Data-level Security, Secure Web Development, APIs, Web Services, MySQL, MySQL Workbench, Solution Architecture, SQL, Linux, Subversion (SVN), Continuous Integration (CI), Stored Procedure, MySQL DBA, PHP Data Objects (PDO), Database Modeling, Containers, Cloud, Bash Script, Software Development Lifecycle (SDLC), GNU, RDBMS, Project Estimation, Unix Shell Scripting, Business Requirements, Business Analysis, Process Design, Process Flows, Google Cloud SQL, Google Cloud, Data Taxonomy, Data Architecture, Metadata, Quality Assurance (QA), DevOps, Database Schema Design, JSON
Disaster Recovery Specialist
2021 - 2021
Piggy
- Advised the client in its disaster recovery plan providing a detailed and robust mechanism to replicate data continuously to the DR site and processes to perform a failover.
- Explained several pros and cons of various data migration and replication methods. Provided comparative studies of different technologies and cloud vendors for setting up the DR site.
- Wrote auto-scaling scripts to migrate about 500GB of AWS DynamoDB within a time frame tolerable concerning application downtime allowed.
Technologies: Disaster Recovery Plans (DRP), Disaster Recovery Consulting, High Availability Disaster Recovery (HADR), MySQL, Database Replication, Amazon RDS, Amazon DynamoDB, Cloud Architecture, Data Migration, MySQL Clustering, SQL, MySQL Workbench, Business Continuity Planning (BCP), Business Continuity, Business Continuity & Disaster Recovery (BCDR), Continuous Integration (CI), Databases, Amazon Aurora, Cluster, Database Administration (DBA), MySQL DBA, Containers, Cloud, Bash Script, GNU, RDBMS, Project Estimation, Unix Shell Scripting, Business Requirements, Business Analysis, Process Design, Process Flows, DB, Database Backups, Google Cloud, Performance Tuning, SQL Performance, Architecture, Scripting, DevOps, Database Monitoring, Database Scaling
Project Manager
2005 - 2016
Wipro
- Provided project and SDLC management, project planning, project team management, business continuity planning (BCP), and disaster management and recovery (DR).
- Took care of project estimation, risk, change and stakeholder management, as well as mitigation.
- Developed and managed a team, building Oracle OSB web services for clients onboard a vehicle-telematics system based on SoA and utilizing Oracle Fusion Middleware SOA Suite.
- Created a database design for an Oracle OLAP database to provide data to external vendors using database views.
- Handled a large-scale data migration involving multiple systems with message transfers and multiple ODS. Used Oracle XML DBMS packages to process XML messages inside Oracle databases.
- Led the project for a Java-based web application and developed a feature where the user could download completed forms in a PDF format.
- Developed Oracle DBMS packages, procedures, and a file-based program in Pro*C for a large utility company.
Technologies: Oracle Service Bus (OSB), C, UNIX Utilities, Unix Shell Scripting, Oracle RDBMS, Software Project Management, IT Project Management, Lean Project Management, Data Modeling, Oracle SQL Developer, Oracle SQL, SQL, Linux, PL/SQL Developer, Unix, Subversion (SVN), Business Continuity Planning (BCP), Business Continuity, Business Continuity & Disaster Recovery (BCDR), Continuous Integration (CI), Project Estimation, Lean Development, Waterfall Development, Oracle PL/SQL, Databases, Database Design, Database Architecture, Agile Workflow, Oracle Database, Stored Procedure, Oracle Fusion Middleware, Visual Studio 2010, Oracle SOA Suite, PL/SQL Tuning, Pro*C, Database Administration (DBA), Bash Script, Software Development Lifecycle (SDLC), RDBMS, Data Quality, Business Analysis, Business Requirements, Oracle Fusion ERP, Process Design, Process Flows, Query Optimization, DB, Manufacturing Execution Systems (MES), Database Backups, Database Optimization, Data Taxonomy, Data Architecture, Metadata, Performance Tuning, SQL Performance, Quality Assurance (QA), Scripting, DevOps, Database Performance, Database Schema Design, Database Monitoring, Database Scaling
Project History
CardDAV server for LDAP
https://github.com/isubsoft/ldap-carddavI developed a CardDAV server using LDAP for authentication and contact back end. The server offers the following features:
• Authenticate CardDAV users against LDAP
• Multiple address book support
• Global, shared, and private address book support
• Full read/write support between CardDAV clients and LDAP with contact renaming
• Bidirectional sync between LDAP and CardDAV clients for new contacts, modified contacts, and contacts deleted via the CardDAV protocol (contacts deleted directly in LDAP are deleted in CardDAV clients asynchronously)
• Extensive and customizable configuration options to map vCard properties to LDAP attributes, including multi-value and composite value properties and attributes
• Media-like image storage support
• Contact group support
• Authenticate CardDAV users against LDAP
• Multiple address book support
• Global, shared, and private address book support
• Full read/write support between CardDAV clients and LDAP with contact renaming
• Bidirectional sync between LDAP and CardDAV clients for new contacts, modified contacts, and contacts deleted via the CardDAV protocol (contacts deleted directly in LDAP are deleted in CardDAV clients asynchronously)
• Extensive and customizable configuration options to map vCard properties to LDAP attributes, including multi-value and composite value properties and attributes
• Media-like image storage support
• Contact group support
Database HA Cluster
I created a MySQL 5-node (five instances of the MySQL server) InnoDB HA cluster with a multi-master mode of operation (write any instance and read from any). The cluster was configured with multiple features.
CLUSTER FEATURES:
• Automated failover to a healthy instance when an instance goes down.
• Automated recovery when an instance comes back up.
• Strict data consistency across cluster instances.
• Automated load balancing of reading and writing queries over all cluster instances, achieving better throughput than a standalone instance.
The cluster also had no single point of failure. Hot incremental backup was done using a replication instance connected to the cluster using snapshots. The incremental backups were used for the point-in-time recovery of data. There was an offsite replication instance doing chained replication from the onsite replication instance for disaster recovery.
CLUSTER FEATURES:
• Automated failover to a healthy instance when an instance goes down.
• Automated recovery when an instance comes back up.
• Strict data consistency across cluster instances.
• Automated load balancing of reading and writing queries over all cluster instances, achieving better throughput than a standalone instance.
The cluster also had no single point of failure. Hot incremental backup was done using a replication instance connected to the cluster using snapshots. The incremental backups were used for the point-in-time recovery of data. There was an offsite replication instance doing chained replication from the onsite replication instance for disaster recovery.
Senior Linux Administrator
The client wanted to make renting a printer possible via a CUPS-based system, where users could print documents from various conferences and offices where they would rent the printers. The printer would be connected to a central CUPS server that would log and authorize the print operation to the remote printer.
I played the role of a Linux system administrator and DevOps engineer and completed the following tasks:
• Created a Linux instance on AWS tailored for the CUPS print service.
• Configured CUPS for secure public internet access, ensuring robust security and encryption measures are in place.
• Implemented authentication mechanisms using the Linux machine's user accounts or by setting up an LDAP server.
• Assigned printer-specific permissions to manage access and print queues effectively.
• Assisted in the configuration of network printers and copiers connected through a WireGuard server, ensuring seamless printing across venues in the United States.
• Provided ongoing support and management of the system, addressing any issues or updates as required.
I played the role of a Linux system administrator and DevOps engineer and completed the following tasks:
• Created a Linux instance on AWS tailored for the CUPS print service.
• Configured CUPS for secure public internet access, ensuring robust security and encryption measures are in place.
• Implemented authentication mechanisms using the Linux machine's user accounts or by setting up an LDAP server.
• Assigned printer-specific permissions to manage access and print queues effectively.
• Assisted in the configuration of network printers and copiers connected through a WireGuard server, ensuring seamless printing across venues in the United States.
• Provided ongoing support and management of the system, addressing any issues or updates as required.
MySQL DBA and DevOps Engineer
The client was creating a dashboard system for water quality measured using IoT sensors connected to water pipelines all over the world. The IoT devices sent measurements as a data stream to a centrally located MySQL cluster.
My responsibilities included the following:
• Providing standby consultancy support for a high-volume MySQL database cluster. Work included optimization/architecting. The required response time was the next business day (or earlier).
• Offering standby support for upgrades/changes on production - Responded within 48 hours at least. These upgrades/changes usually took place on Sundays, and response time was within one hour or less.
• Delivering emergency support for rare events with no prior notice. Provided response within 20 minutes. The availability required was 24/7.
My responsibilities included the following:
• Providing standby consultancy support for a high-volume MySQL database cluster. Work included optimization/architecting. The required response time was the next business day (or earlier).
• Offering standby support for upgrades/changes on production - Responded within 48 hours at least. These upgrades/changes usually took place on Sundays, and response time was within one hour or less.
• Delivering emergency support for rare events with no prior notice. Provided response within 20 minutes. The availability required was 24/7.
Scalable REST-based Microservices Architecture
I created a solution architecture using RESTful services and microservices for a SaaS product supporting millions of users and thousands of vendors. REST services were written using the PHP Phalcon C extension framework with all microservices being flexible enough to be clustered for high availability and redundancy. The primary objective of this project was to able to scale (or auto scale) out without hampering the availability of the services.
GEN 10
I developed the integration gateway platform for one of the world's biggest automobile manufacturers for their vehicle telematics, onboarding problem diagnostics, remote assistance, crash reporting, turn-by-turn navigation, and infotainment system.
This integration platform uses the latest service-oriented architecture (SOA) suite from Oracle Fusion Middleware. It connects all customers' systems to provide a uniform interface for all end users to consume IT services.
The SOA suite is hosted on a Linux platform. It uses the Agile development methodology and continuous integration to achieve high productivity while keeping new functionality and features flowing for the customer, giving it an edge over its competitors in this fast-growing and competitive IT space in North America and China.
This integration platform uses the latest service-oriented architecture (SOA) suite from Oracle Fusion Middleware. It connects all customers' systems to provide a uniform interface for all end users to consume IT services.
The SOA suite is hosted on a Linux platform. It uses the Agile development methodology and continuous integration to achieve high productivity while keeping new functionality and features flowing for the customer, giving it an edge over its competitors in this fast-growing and competitive IT space in North America and China.
ADS Layer Development
This ADS-layering project was about building an Oracle OLAP database to provide data to external vendors.
The client's operational database stores all customer and vendor transactions for its multi-channel, integrated marketing platform. Currently, the client has batch feeds to provide this transactional data to external vendors, which is time-consuming, complex, and resource-intensive.
To overcome these challenges, I needed to build the ADS-database layer (also known as the provisioning layer by the customer), which can expose the same data to the vendors through database views. Vendors will be able to connect to this database in a restricted manner and query their data.
The client's operational database stores all customer and vendor transactions for its multi-channel, integrated marketing platform. Currently, the client has batch feeds to provide this transactional data to external vendors, which is time-consuming, complex, and resource-intensive.
To overcome these challenges, I needed to build the ADS-database layer (also known as the provisioning layer by the customer), which can expose the same data to the vendors through database views. Vendors will be able to connect to this database in a restricted manner and query their data.
MES System Integration
The project aimed to integrate a manufacturing execution system (MES) suite called PSI Metals with the client's legacy systems. This project was part of the client's initiative to upgrade their system to an industry-wide standard MES product and SAP compliance.
The integration of PSI Metals into the existing system would decommission many existing applications and background processes. It would require new changes for the existing applications to work with PSI Metals, especially with their message-based interaction system. Thus this project would carry out the necessary remediation activities to the existing applications and integrate PSI Metals with the legacy systems.
The project had a high degree of complexity and risk as almost all critical business processes were highly or substantially impacted.
The integration of PSI Metals into the existing system would decommission many existing applications and background processes. It would require new changes for the existing applications to work with PSI Metals, especially with their message-based interaction system. Thus this project would carry out the necessary remediation activities to the existing applications and integrate PSI Metals with the legacy systems.
The project had a high degree of complexity and risk as almost all critical business processes were highly or substantially impacted.
Pro*C (Precompiler) Library for Oracle
An Oracle client library written purely in Pro*C (Oracle C precompiler for embedded SQL). It implements Pro*C ANSI dynamic SQL and provides APIs to application programs by hiding ANSI dynamic SQL directives. It's also designed to be portable across platforms.
Education
2001 - 2005
Bachelor of Technology Degree in Information Technology
West Bengal University of Technology - Kolkata, West Bengal, India
Skills
Libraries/APIs
REST APIs, OpenLDAP
Tools
Jenkins, Visual Studio 2010, Subversion (SVN), MySQL Workbench, Cluster, Oracle SOA Suite, Makefile, Microsoft Visual Studio
Languages
Bash Script, SQL, PHP, C, Pro*C, Stored Procedure
Frameworks
PhalconPHP, PHP MVC
Paradigms
Continuous Integration (CI), Waterfall Development, Database Design, ETL, Microservices, Agile Workflow, DevOps, Service-oriented Architecture (SOA)
Platforms
Amazon Web Services (AWS), Linux, Oracle Database, Google Cloud Platform (GCP), Unix, Oracle, Apache2
Storage
Oracle SQL Developer, Oracle SQL, PL/SQL, Oracle PL/SQL, MySQL, PL/SQL Developer, RDBMS, Databases, Database Architecture, Database Replication, Database Modeling, Amazon Aurora, Database Administration (DBA), DB, Database Backups, Google Cloud SQL, Google Cloud, SQL Performance, Database Performance, SQLite, PHP Data Objects (PDO), JSON, Oracle RDBMS, MySQL Clustering, Amazon DynamoDB, NoSQL, Database Security, ANSI SQL
Other
GNU, Solution Architecture, High Availability Disaster Recovery (HADR), Shell Scripting, Software Development Lifecycle (SDLC), Project Estimation, Documentation, Unix Shell Scripting, Web Services, UNIX Utilities, Disaster Recovery Plans (DRP), Disaster Recovery Consulting, Amazon RDS, Data Migration, Information Technology, CTO, IT Consulting, IT Project Management, Software Project Management, APIs, Containers, Data Engineering, LDAP, Data Modeling, Business Continuity Planning (BCP), Business Continuity, Business Continuity & Disaster Recovery (BCDR), MySQL DBA, Data Quality, Business Requirements, Query Optimization, Database Optimization, Data Taxonomy, Data Architecture, Metadata, Performance Tuning, Quality Assurance (QA), Architecture, Scripting, Database Schema Design, Database Monitoring, Database Scaling, Cloud Architecture, Oracle Service Bus (OSB), Lean Development, Cloud, Business Analysis, Oracle Fusion ERP, Process Design, Process Flows, Oracle Fusion Middleware, PL/SQL Tuning, Load Balancers, Cloud Computing, Startup Consulting, Software Consulting, Data-level Security, Secure Web Development, Lean Project Management, CardDAV, WebDAV, HTTP, Libraries, Client-side, Embedded SQL, Manufacturing Execution Systems (MES), Infrastructure as Code (IaC), Server Administration, CUPS, Print Server, PAM authentication, Partitioning, Data Compression
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring