Divesh Sankhla

Senior Consultant at Capgemini (2022-08 – Present)

Led enterprise-scale database migration from Oracle to AWS Aurora PostgreSQL using AWS DMS, ensuring data integrity, performance, and successful production deployment.
Led database development for enterprise applications using PostgreSQL and Oracle PL/SQL, delivering scalable and high-performance database solutions.
Designed and developed complex SQL, PL/SQL, and PL/pgSQL objects including stored procedures, functions, triggers, packages, and views for high-volume transactional systems.
Optimized database performance through query tuning, execution plan analysis, indexing strategies, and schema optimization.
Led technical solution design, code reviews, release planning and mentored database developers.
Worked in Agile/Scrum teams using Azure DevOps, Git, release management, and CI/CD practices while collaborating with business analysts, developers, QA, DevOps, and client stakeholders.

System Engineer at Tata Consultancy Services (TCS) (2019-05 – 2022-08)

Developed and maintained enterprise database solutions using PostgreSQL, Oracle, SQL, and PL/SQL for business-critical applications.
Designed and developed stored procedures, functions, packages, triggers, views, and complex SQL queries to support core business processes.
Improved database performance through query optimization, execution plan analysis, indexing, and database schema optimization.
Built ETL pipelines using SAS DI Studio to integrate high-volume transactional data into enterprise Data Warehouse systems.
Contributed to Data Warehousing (DWH) and DB/BI initiatives, supporting reporting and data integration requirements.
Acted as Module Lead (DB/BI), leading database development activities, mentoring developers, conducting code reviews, coordinating production releases, and providing production support.

About