SRILEKHA K

PostgreSQL Developer

Chennai,TN

Summary

Senior PostgreSQL Developer with 7 years of experience in PostgreSQL database development, PL/pgSQL programming, Oracle to PostgreSQL migration, query optimization, EXPLAIN ANALYZE, indexing, partitioning, JSON/JSONB, CTEs, window functions, dynamic SQL, materialized views and performance tuning. Experienced in Retail Analytics and CRM applications using Agile methodologies.

Overview

Languages

years of professional experience

Work History

Senior Software Engineer

Expleo

07.2024 - Current

Project: Saint-Gobain CRM.|Domain: CRM, Sales, and Distribution.
Designed PostgreSQL tables, views, materialized views, indexes, constraints, and partitioned tables.
Developed complex PL/pgSQL functions, procedures, and triggers.
Optimized SQL queries using EXPLAIN ANALYZE, indexing, and execution plan analysis.
Implemented partitioning for large transactional tables.
Worked extensively with CTEs, window functions, JSON/JSONB, temporary tables, and dynamic SQL.
Supported production deployments, debugging, and performance tuning.
Led software development projects, ensuring timely delivery and adherence to quality standards.
Mentored junior engineers, fostering skill development and enhancing team performance.

SQL Developer

Tata Consultancy Services

05.2019 - 06.2024

Project: Nielsen |Domain: Retail and Consumer Analytics.
Designed and developed PostgreSQL database objects and PL/pgSQL components.
Participated in Oracle to PostgreSQL migration, including assessment, schema conversion, SQL rewriting, and validation.
Optimized complex SQL queries using EXPLAIN ANALYZE, and indexing.
Worked with joins, CTEs, window functions, JSON/JSONB, and dynamic SQL.
Automated ETL workflows using Apache Airflow.
Prepared technical documentation and collaborated in Agile teams.
Developed complex SQL queries to extract, manipulate, and analyze data for reporting needs.
Optimized database performance through indexing strategies and query tuning techniques.

Education

B.E. - Computer Science

Sri Muthukumaran Institute of Technology

Chennai, India

04-2019

Skills

Databases: PostgreSQL

Timeline