Subhojit Pal profile photo 1 on Tal

Subhojit Pal

PostgreSQL | PL/pgSQL | Oracle SQL | MS SQL Server | Database Migration | Database Development | AWS

Kolkata

8+ years of work experience

Tata Consultancy Services
Feb 20251 yr 8 mosPresent

Executed large-scale cross-platform migrations, converting Oracle PL/SQL and MS SQL Server T-SQL objects into PostgreSQL PL/pgSQL, ensuring functional parity and production readiness. Refactored tightly coupled database logic to resolve dialect differences, transaction behaviour changes, and exception handling gaps across Oracle, SQL Server, and PostgreSQL, improving system stability during transformation. Designed and implemented a database-native email notification framework by replacing Oracle email mechanisms with PostgreSQL-compatible solutions, enabling automated alerts and workflow notifications. Modernized cross-database connectivity by replacing Oracle DB Links and SQL Server Linked Servers with PostgreSQL Foreign Data Wrappers (FDW), enabling secure, scalable querying without legacy dependencies. Remediated AWS SCT auto-converted objects, rewriting them to meet PostgreSQL performance and syntax standards, reducing runtime errors and stabilizing migration cycles. Diagnosed and resolved AWS DMS migration failures, leveraging CloudWatch logs to improve task stability, minimize reruns, and accelerate full-load migrations. Collaborated with application teams to validate migrated database objects against downstream services, ensuring seamless integration and handover post-migration. Provided performance optimization consulting to application teams, analyzing query execution plans and indexing strategies, which improved transaction throughput and reduced reporting query latency across migrated PostgreSQL workloads.
Accenture in India
Mar 20195 yrs 11 mosJan 2025

Kolkata

(OnProcess Technology had been acquired by Accenture in 2024) Designed and maintained database schemas and normalized data structures in Oracle and PostgreSQL environments. Developed complex SQL queries, stored procedures, and database functions supporting operational and reporting requirements. Optimized SQL queries and indexing strategies, reducing query execution time by up to 30%. Built reusable SQL components and query libraries that improved development efficiency and reduced turnaround time. Extracted and analyzed business data from Oracle 12c databases, delivering timely reports for multiple business units. Collaborated with business users and development teams to translate business requirements into reliable database solutions.
Maven InfoTech Private Limited
Oct 20171 yr 5 mosFeb 2019

Kolkata

Used SQL queries to analyze backend data, validate records, and support customer issue resolution. Assisted in data validation and troubleshooting activities, contributing to improved operational efficiency and service quality.

Subhojit’s AI Stack

claude code
claude code
claude
claude
codex
codex
cursor
cursor
github copilot
github copilot
claudecode
claudecode

Education

Surendranath College

Bachelor of Science

Surendranath College

20133 yrs2016
Irhpala Krishna Mohan Institution

High School Diploma

Irhpala Krishna Mohan Institution

Join Subhojit and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Subhojit Pal on Tal

Headline

PostgreSQL | PL/pgSQL | Oracle SQL | MS SQL Server | Database Migration | Database Development | AWS

About

Database Engineer with over 8 years of experience designing, developing, administering, optimizing, and migrating enterprise database solutions across PostgreSQL, SQL Server, and Oracle environments. Experienced in cross-platform database migrations, SQL Server administration, PL/pgSQL development, query optimization, performance tuning, schema design, and cloud-hosted database platforms. Proven expertise in migrating Oracle PL/SQL and SQL Server T-SQL workloads to PostgreSQL, implementing database automation, troubleshooting AWS DMS migrations, and optimizing SQL Server and PostgreSQL environments. Strong collaborator with application, infrastructure, and business teams, delivering reliable, scalable, and high-performing database solutions.

Location

Kolkata

AI stack

claude code

claude

codex

cursor

github copilot

claudecode

Work experience

Database Engineer at Tata Consultancy Services, Feb 2025 - Present · 1 yr 8 mos, Executed large-scale cross-platform migrations, converting Oracle PL/SQL and MS SQL Server T-SQL objects into PostgreSQL PL/pgSQL, ensuring functional parity and production readiness. Refactored tightly coupled database logic to resolve dialect differences, transaction behaviour changes, and exception handling gaps across Oracle, SQL Server, and PostgreSQL, improving system stability during transformation. Designed and implemented a database-native email notification framework by replacing Oracle email mechanisms with PostgreSQL-compatible solutions, enabling automated alerts and workflow notifications. Modernized cross-database connectivity by replacing Oracle DB Links and SQL Server Linked Servers with PostgreSQL Foreign Data Wrappers (FDW), enabling secure, scalable querying without legacy dependencies. Remediated AWS SCT auto-converted objects, rewriting them to meet PostgreSQL performance and syntax standards, reducing runtime errors and stabilizing migration cycles. Diagnosed and resolved AWS DMS migration failures, leveraging CloudWatch logs to improve task stability, minimize reruns, and accelerate full-load migrations. Collaborated with application teams to validate migrated database objects against downstream services, ensuring seamless integration and handover post-migration. Provided performance optimization consulting to application teams, analyzing query execution plans and indexing strategies, which improved transaction throughput and reduced reporting query latency across migrated PostgreSQL workloads.

Associate - SQL Developer at Accenture in India, Mar 2019 - Jan 2025 · 5 yrs 11 mos, Kolkata, (OnProcess Technology had been acquired by Accenture in 2024) Designed and maintained database schemas and normalized data structures in Oracle and PostgreSQL environments. Developed complex SQL queries, stored procedures, and database functions supporting operational and reporting requirements. Optimized SQL queries and indexing strategies, reducing query execution time by up to 30%. Built reusable SQL components and query libraries that improved development efficiency and reduced turnaround time. Extracted and analyzed business data from Oracle 12c databases, delivering timely reports for multiple business units. Collaborated with business users and development teams to translate business requirements into reliable database solutions.

Associate - Data Support Analyst at Maven InfoTech Private Limited, Oct 2017 - Feb 2019 · 1 yr 5 mos, Kolkata, Used SQL queries to analyze backend data, validate records, and support customer issue resolution. Assisted in data validation and troubleshooting activities, contributing to improved operational efficiency and service quality.

Education

Bachelor of Science, Surendranath College

High School Diploma, Irhpala Krishna Mohan Institution