Jay Mehta
MUMBAI
Summary
Experienced Greenplum and PostgreSQL Database Administrator with a reasonable number of years of successful track record in managing, optimizing, and maintaining large-scale data production and development environments. Proven expertise in performing expansion, upgrades, and critical activities for Greenplum databases. Adept at ensuring high availability, performance, and security of database systems.
Overview
3
3
years of professional experience
Work History
Database Administrator
National Stock Exchange - IT
MUMBAI
02.2024 - Current
- Manage large-scale ODS and EDW production databases, along with 15 development and UAT databases, ensuring optimal performance and availability.
- Solely responsible for configuring, installing, and initializing a new segment for NSE's 'Liquidity Enhancement Scheme,' handling the end-to-end process.
- Successfully performed version upgrades and downgrades of Greenplum databases to meet operational and technical requirements.
- Led the migration of production databases to a new RHEL version, ensuring zero data loss and no production impact during the transition.
- Conducted multiple mock trading sessions for NSE, maintaining database integrity and ensuring seamless operations without any impact.
- Spearheaded the migration of critical tables and data from Greenplum to Oracle as part of an ongoing future migration project.
- Coordinated and executed two Disaster Recovery (DR) activities, ensuring business continuity and full data restoration without any incidents.
- Developed and deployed automation scripts for regular database maintenance, monitoring, and backup activities, reducing manual intervention and ensuring faster recovery times.
Database Administrator
Tata Consultancy Services
Mumbai
09.2021 - 11.2023
- Team lead for PostgreSQL and Surveillance Greenplum DBA team working for National Stock Exchange (NSE), managing its Production and non-Production environments.
- Successfully managed a team responsible for database monitoring, maintenance, and support, ensuring the availability and performance of critical applications.
- Led the successful expansion of Greenplum clusters to accommodate growing data volumes, ensuring seamless scalability and minimal disruption.
- Coordinated the migration of legacy data into Greenplum, streamlining data access, and improving reporting capabilities for business users.
- Managed the configuration, installation, and recovery operations for databases, conducting daily backups and restores.
- Additionally, led Disaster Recovery (DR) Live Drills across multiple instances.
- Implemented automated monitoring and alerting systems, reducing response time of database incidents.
- Collaborated with development teams to design and optimize database schemas, in-database schema migration, improving data organization, and accessibility.
- Optimized database performance by fine-tuning queries, indexes, and configuration parameters, resulting in improvement in query execution times.
- Played a key role in troubleshooting and resolving critical database issues, maintaining a 99.9% uptime for mission-critical applications.
- Conducted regular health checks and performance monitoring, proactively identifying and addressing potential bottlenecks and issues.
- Actively participated in on-call rotation, providing timely resolution to database-related incidents during off-hours.
- Proficient in conducting in-depth analysis to pinpoint the root causes of SLA breaches, providing comprehensive reports outlining findings, and proposing preventive measures.
Education
B.E - Production Engineer -
Fr. Conceicao Rodrigues College of Engineering
Mumbai06.2021
12th (HSC) -
Sardar Vallabhbhai Patel College of Science and Commerce
Mumbai10th (SSC) -
St. Francis D'Assisi High School
MumbaiSkills
- Greenplum
- PostgreSQL
- SQL
- Linux
Extracurricular Activities
Martial Arts Instructor, Black Belt in Karate. National Level Karate Gold winner.
Hobbies and Interests
Reading books, drawing and martial arts.
Timeline
Database Administrator
National Stock Exchange - IT
02.2024 - Current
Database Administrator
Tata Consultancy Services
09.2021 - 11.2023
B.E - Production Engineer -
Fr. Conceicao Rodrigues College of Engineering
12th (HSC) -
Sardar Vallabhbhai Patel College of Science and Commerce
10th (SSC) -
St. Francis D'Assisi High School
Similar Profiles
SRUSHTI JOSHISRUSHTI JOSHI
Deputy Manager – Investigation Department at NATIONAL STOCK EXCHANGE OF INDIA (Largest stock exchange in India )Deputy Manager – Investigation Department at NATIONAL STOCK EXCHANGE OF INDIA (Largest stock exchange in India )
CA SRUSHTI JOSHICA SRUSHTI JOSHI
Deputy Manager – Investigation Department at NATIONAL STOCK EXCHANGE OF INDIA (Largest stock exchange in India )Deputy Manager – Investigation Department at NATIONAL STOCK EXCHANGE OF INDIA (Largest stock exchange in India )
PRADNYA PINTOPRADNYA PINTO
Chief Manager - Member Compliance at National Stock Exchange LtdChief Manager - Member Compliance at National Stock Exchange Ltd
Prajakta KaigudePrajakta Kaigude
Senior Business Analyst at Transtrack Aeroservices Pvt. Ltd | National Stock Exchange of India (NSE)Senior Business Analyst at Transtrack Aeroservices Pvt. Ltd | National Stock Exchange of India (NSE)
Suraj SethSuraj Seth
Assistant Manager – Direct Tax at CBV & Associates LLPAssistant Manager – Direct Tax at CBV & Associates LLP