# lekha Tripathi

lekha Tripathi is a remote worker on Himalayas, Senior Database Developer at Zensar Technologies, based in India.

Source: https://himalayas.app/@lekhatripathi

```text
Senior Database Developer at Zensar Technologies, migrating PostgreSQL functions to Snowflake and optimizing SQL.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 2907k+ INR |
| Job categories | Database Developer |
| Skills | Database Development, SQL, PostgreSQL, Snowflake, Microsoft SQL Server, MySQL, Oracle, Database Design, Data Modeling, Stored Procedures, Database Functions, SQL Query Optimization, Index Tuning, ETL, Data Ingestion |
| Portfolio | https://chinookapparel.co.uk |

## What I'm looking for

```text
I’m looking to apply my database development, SQL optimization, and data engineering experience to contribute to organizational growth while continuing to enhance my technical knowledge and professional capabilities.
```

## About

```text
At Zensar Technologies, I'm developing database functions, stored procedures, and complex SQL queries for the CBRE project. I’m also converting PostgreSQL functions to Snowflake-compatible functions and optimizing queries.

At EY, I developed and maintained database functions, converted SQL Server stored procedures into PostgreSQL functions, and performed query optimization and testing.

Earlier, I worked on database development at Techouts and Pragyanet, including database design, project analysis, and testing. Across projects, I’ve also created Python scripts for data ingestion and data quality checks, and worked with PostgreSQL, Snowflake, SQL Server, and MySQL.
```

## Experience

### Senior Database Developer (current)

[Zensar Technologies](https://himalayas.app/companies/zensar). Sep 2024 - Present

```text
Developing stored procedures, functions, audit triggers, views, and complex SQL queries. Converting and migrating PostgreSQL functions to Snowflake-compatible functions and optimizing SQL queries for performance.
```

Skills: PostgreSQL, Snowflake, SQL, Stored-Procedures, Functions, Triggers, Views, Query-Optimization, Data-Ingestion, Data-Quality, Technical-Documentation

### Senior Database Developer

[EY](https://himalayas.app/companies/ey). Mar 2022 - Aug 2024

```text
Developed and maintained stored procedures and database functions, converting SQL Server stored procedures into PostgreSQL functions. Optimized SQL queries and performed data ingestion and processing activities.
```

Skills: SQL-Server, PostgreSQL, Stored-Procedures, Functions, Query-Optimization, Indexing, Data-Ingestion, Data-Processing, Testing, Troubleshooting

### Database Developer

Techouts. Aug 2021 - Feb 2022

```text
Developed stored procedures and optimized SQL queries. Performed data ingestion and database loading activities, and prepared SQL deployment scripts and technical documentation.
```

Skills: SQL, Stored-Procedures, Query-Optimization, Data-Ingestion, SQL-Server, Indexing, Testing, Troubleshooting

### Database Developer

Pragyanet. Feb 2014 - Aug 2021

```text
Communicated with clients to gather and analyze project requirements, prepared project documentation and technical specifications, and designed and created databases. Performed manual, regression, and integration testing.
```

Skills: Requirements-Gathering, Project-Analysis, Documentation, Database-Design, Manual-Testing, Regression-Testing, Integration-Testing, SEO, SMO

## Education

### Ramdeobaba

Master of Computer Applications, Computer Applications

```text
Master of Computer Applications (MCA) from Ramdeobaba, Nagpur, Maharashtra.
```

## Tech stack

- Amazon Redshift
- Snowflake
- Microsoft Azure
- MySQL
- PostgreSQL
- Microsoft SQL Server
- Oracle
- .NET
- Adobe Photoshop
- React
- jQuery
- JavaScript
- Python
- PHP
- Windows
- WordPress
- Git
- SQL
- AWS
- Microsoft Office
- HTML
- CSS

To contact lekha, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Faizan Ansari](https://himalayas.app/@faizanansari): SQL developer, Persistent Systems
- [Devi Lal Hudda](https://himalayas.app/@devilalhudda): Database Developer, Nagarro Software Pvt. Ltd.
- [SALEEM KHAN](https://himalayas.app/@saleemkhan): Database Developer, Genpact
- [Vinay Jha](https://himalayas.app/@vinayjha): Senior Database Developer, VVDN Technologies
- [Anusha Sainath](https://himalayas.app/@anushasainath): Senior SQL Developer, GTRTek
- [Shruth Sbk](https://himalayas.app/@shruthsbk): Senior Database Developer II, Blackline
- [Pallavi Acharya](https://himalayas.app/@pallaviacharya): Senior Software Specialist, Excelra Pvt. Ltd.
- [Raghavendra H T](https://himalayas.app/@raghavendraht): Senior Database Programmer, Mango Sciences, Inc.
- [Anurag Rajpoot](https://himalayas.app/@anuragrajpoot): Database Engineer, Ethereal / Stellar Innformatics (P) Ltd.
- [Ranjana K A](https://himalayas.app/@ranjanaka): Database Administrator (DBA), Geodis
