Payel Gupta
Khobar,Saudi Arabia
Summary
Highly skilled professional with extensive expertise in databases including Oracle 12c, SQL Server, and MySQL. Proficient in programming languages such as SQL, PL/SQL, Python, and Shell Scripting. Demonstrates strong capabilities in ETL processes, data migration, performance tuning, and backend optimisation. Adept at using Unix/Linux environments and SQL Loader tools. Experienced in generative AI concepts, prompt engineering, and vector databases design and implementation. Proven track record in L2/L3 production support, application enhancement, incident management, and business requirements interpretation. Committed to knowledge sharing within the team and maintaining documentation standards. Career goals include leveraging technical skills to drive innovative solutions in database management and AI technologies.
Experienced [Job Title] with strong background in data analysis and problem-solving. Skilled at developing complex database structures and writing unique queries to extract and manipulate data. Knowledgeable about SQL and familiar with various database management systems.
Overview
10
10
years of professional experience
Work history
Database Developer
Tata Consultancy Services
Kolkata, India
2019.12 - 2025.04
- Client: Diligenta (UK Insurance)
- - Developed and optimized PL/SQL procedures, functions, and complex SQL queries
- - Improved query performance by approximately 30%
- - Provided production support and backend debugging
- - Collaborated with business and onsite teams
- Customised existing databases to meet unique business requirements without compromising on performance or security.
- Trained junior developers on best practices in database development and management, enhancing team capability over time.
- Managed multiple projects concurrently, ensuring timely completion within scope.
- Troubleshot and resolved database issues swiftly, reducing downtime significantly.
Application Support & Enhancement
Cognizant Technology Solutions
Kolkata, India
2017.02 - 2019.11
- Client: McDonald's
- - SQL and PL/SQL application support
- - Automated backend reports and reduced manual effort
- Carried out day-to-day duties accurately and efficiently.
- Demonstrated respect, friendliness and willingness to help wherever needed.
- Worked flexible hours, covering nights, weekends and bank holidays.
- Successfully delivered on tasks within tight deadlines.
Database Developer
Cognizant Technology Solutions
Kolkata , India
2016.03 - 2017.02
- Client: Zipcar
- - Managed Oracle Data Warehouse and ETL processes
- - Performed query optimization and performance tuning
- Implemented SQL scripts to automate routine tasks, thereby increasing productivity levels in the team.
- Provided ongoing maintenance and support for all databases, ensuring optimal operation at all times.
- Optimised databases for improved application performance.
BAU Support / Developer
Cognizant Technology Solutions
2015.02 - 2016.03
- Client: AstraZeneca
- - Production support and system enhancements
- - Shell scripting and SQL automation
Education
M.Tech - Computer Science
West Bengal University of Technology
B.Tech - Computer Science
West Bengal University of Technology
Skills
- Databases: Oracle 12c, SQL Server, MySQL
- Programming: SQL, PL/SQL, Python, Shell Scripting
- Data & Backend: ETL, Data Migration, Performance Tuning
- Tools & OS: Unix/Linux, SQL
- Loader
- AI & Modern Technologies: Generative AI (LLM concepts, Prompt Engineering), Vector Databases (Design & Hands-on Implementation)
- Expertise Areas: L2/L3 Production Support, Application Enhancement, Backend Optimization, Incident Management
- Business requirements interpretation
- MySQL expertise
- Knowledge of oracle
- Understanding of postgresql
- Knowledge sharing within team
- ETL process knowledge
- PL and SQL programming
- Python programming knowledge
- Database tuning expertise
- Documentation
- Database analysis
- Relational database management
- Deadline-oriented
Timeline
Database Developer
Tata Consultancy Services
2019.12 - 2025.04
Application Support & Enhancement
Cognizant Technology Solutions
2017.02 - 2019.11
Database Developer
Cognizant Technology Solutions
2016.03 - 2017.02
BAU Support / Developer
Cognizant Technology Solutions
2015.02 - 2016.03
B.Tech - Computer Science
West Bengal University of Technology
M.Tech - Computer Science
West Bengal University of Technology