Liju Mathew Varghese
Kochi
Summary
Senior Database Engineer with 20+ years of experience architecting, operating, and modernizing mission-critical database platforms across PostgreSQL, DB2 LUW, Oracle, and SQL Server. Deep expertise in DB2 LUW/PostgreSQL internals, high availability, disaster recovery, migrations, performance optimization, and data growth management in enterprise-scale environments. Proven track record of leading complex database transformations, enabling proactive reliability, and partnering with application and infrastructure teams to deliver scalable, resilient, and cost-efficient data platforms.
Overview
23
23
years of professional experience
1
1
Certification
Work History
Senior Database Engineer
Tata Consultancy Services (TCS)
Kochi
06.2006 - Current
- Led database architecture, design, and evolution for large enterprise systems across PostgreSQL, DB2 LUW, and Oracle platforms.
- Designed and executed complex database migrations, including DB2 LUW to PostgreSQL, IBM ISAS to PDOA, and PDOA to Oracle, ensuring data integrity and minimal downtime.
- Provided deep PostgreSQL operational leadership, including cluster management using Patroni, replication strategies, and disaster recovery design.
- Built and optimized high-availability and disaster recovery solutions, including backup, restore, and failover planning.
- Performed advanced SQL and stored procedure performance tuning, leveraging execution plans, indexing strategies, and workload analysis.
- Designed table partitioning and data purge strategies to manage uncontrolled data growth and improve query performance.
- Implemented DB2 Federation to support cross-database data access and migration use cases.
- Defined and tuned DB2 Workload Management (WLM) workloads, service classes, and thresholds to optimize application performance.
- Worked with GoldenGate replication for data synchronization and migration scenarios.
- Developed custom automation scripts to streamline migrations, monitoring, and operational tasks.
- Established Git-based version control for database objects, automating deployments using GitHub Workflows.
- Partnered closely with application development teams, providing guidance on schema design, query optimization, and migration best practices.
- Acted as a senior escalation point for complex production issues, performing root cause analysis and implementing durable fixes.
Software Engineer
Informatica Business Solutions Pvt. Ltd.
06.2005 - 05.2006
- Developed and maintained ETL workflows using Informatica PowerCenter.
- Set up databases and ETL environments across multiple platforms.
- Conducted performance testing and supported software certification activities.
Software Engineer
IBM Global Services
08.2003 - 06.2005
- Created and managed databases for Siebel CRM deployments.
- Performed Siebel database upgrades, performance analysis, and tuning.
- Conducted root cause analysis for upgrade and runtime issues.
- Reported and tracked defects to improve platform stability.
Education
B.Tech - Computer Science
Cochin University of Science and Technology
Kochi01.2003
Skills
- PostgreSQL Architecture & Internals (Query Planner, WAL, Vacuum, Replication)
- High Availability & DR (Patroni, Automated Failover, Backup & Recovery)
- Database Migrations & Modernization (DB2 → PostgreSQL, Oracle → PostgreSQL)
- Performance Engineering (Query Optimization, Indexing, Partitioning)
- Data Growth & Cost Control (Partitioning, Purge Strategies, Federation)
- Observability & Reliability (Monitoring, Incident Analysis, Automation)
- Automation & Scripting (Shell, Perl, Bash, Awk, Sed)
- GitOps & CI/CD for Databases (GitHub, Workflows, Versioned DB Objects)
Certification
- IBM DB2 UDB LUW Certified Advanced Database Administrator
- Microsoft Certified: Azure Administrator Associate
- Google Cloud Certified – Professional Database Engineer
Tools And Platforms
- ERStudio
- PgAdmin
- IBM Data Studio
- BMC Patrol
- DB2 LUW WLM
- Patroni
- GoldenGate
Timeline
Senior Database Engineer
Tata Consultancy Services (TCS)
06.2006 - Current
Software Engineer
Informatica Business Solutions Pvt. Ltd.
06.2005 - 05.2006
Software Engineer
IBM Global Services
08.2003 - 06.2005
B.Tech - Computer Science
Cochin University of Science and Technology