Job Search Status
Open to workDesired start date: 2 weeks notice
Open To Work
Simran Rathore
Jaipur
Work Preference
Summary
Database developer with over 5 years of experience in PostgreSQL, IBM DB2, ETL, and database migration. Expertise in designing and optimizing data solutions, executing complex migrations, and enhancing data processing efficiency. Proficient in Python, Pandas, NumPy, and foundational machine learning, with a focus on PySpark, Databricks, and cloud-based data engineering. Strong problem-solving skills with a track record of transforming business requirements into scalable data solutions.
Overview
5
5
years of professional experience
Work History
Database Developer and Analyst
A global leading luxury automotive manufacturer
03.2026 - Current
- Collaborated with clients and stakeholders to define business requirements and deliver scalable data-driven solutions.
- Extracted, transformed, and analyzed data from PostgreSQL for accurate reporting datasets.
- Created interactive dashboards visualizing key business metrics to facilitate data-driven decisions.
- Analyzed data trends, identified anomalies, and provided actionable insights for decision-making.
- Conducted root cause analysis on complex database issues and implemented optimized solutions.
- Developed and optimized database indexes, enhancing query performance and reducing execution time.
- Designed database triggers to track application-level data changes for auditing purposes.
- Implemented data change tracking mechanisms, ensuring integrity and accountability across applications.
Database Developer and Analyst
A global leading luxury automotive manufacturer
06.2023 - 02.2026
- Managed and supported database systems for multiple clients across three countries, ensuring high availability and performance.
- Developed SQL queries to analyze business processes and identify trends for accurate reporting.
- Created dashboards and analytical reports to track key business metrics, including vehicle purchases and VIN registration activity.
- Collaborated with stakeholders to translate business needs into relevant KPIs, queries, and visualizations.
- Resolved recurring production issues through root cause analysis, implementing long-term solutions.
- Optimized complex database issues, significantly reducing debugging time and improving efficiency.
- Documented and proposed change requests to enhance system functionality and reporting capabilities.
- Communicated directly with clients to gather requirements, provide updates, and ensure alignment.
Database Developer
A global leading luxury automotive manufacturer
02.2023 - 05.2023
- Executed database migration from DB2 to PostgreSQL, ensuring data accuracy and system compatibility
- Developed and ran data export and import scripts for seamless transition from DB2 to PostgreSQL
- Modified and converted existing DB2 functions, procedures, and queries to PostgreSQL-compatible formats
- Ensured data integrity and consistency during migration through validation and testing
- Identified and resolved migration-related issues, facilitating smooth transition with minimal downtime
- Optimized database components post-migration to meet PostgreSQL performance standards
- Collaborated with teams to validate functionality and ensure migrated system met business requirements
Database and ETL Developer
A global leading luxury automotive manufacturer
11.2021 - 01.2023
- Built and managed ETL pipelines in Talend, including table and column mapping for accurate data flow
- Utilized Talend for data integration, including importing data into Production and Integration environments
- Created and maintained log tables to track system activities, enhancing data traceability and audit capabilities
- Designed and developed multiple database functions and stored procedures to support business logic and application requirements
- Optimized application performance by modifying and tuning database functions, resulting in improved response times
- Implemented table partitioning to manage large datasets, increasing query performance and reducing latency
- Created indexes and performed reindexing to enhance database efficiency and reduce query execution time
- Ensured smooth data processing and system performance through continuous monitoring and optimization
Java Developer
A global leading luxury automotive manufacturer
07.2021 - 10.2021
- Developed and maintained Java-based application code aligning with business requirements and enhancing user experience
- Collaborated with development teams to ensure smooth integration between application and database components
- Executed unit testing to validate application functionality and ensure high code quality prior to deployment
- Ensured code quality and reliability through test case execution and validation
- Identified and resolved defects during testing phases, contributing to increased application stability
Education
Bachelor of Technology - Computer Science and Engineering
JECRC University
Jaipur, Rajasthan, IndiaSkills
- SQL (advanced queries)
- PostgreSQL
- Database design and modeling
- Stored procedures and functions
- Query optimization
- Indexing and partitioning
- Database migration and support
- Data analysis
- Data cleaning
- Data visualization
- Dashboard reporting
- Python programming
- PySpark
- Databricks
- Advanced Excel
- Requirement analysis
- Root cause analysis
Certification
- Training in Data Analytics (Data Analysis, Visualization & Reporting)
- Trained and Build a RAG chatbot
- Training in PostgreSQL Database Management & Performance Optimization
- Training in Advanced Excel (Pivot Tables, Lookup Functions, Data Analysis)
- Training in Python for Data Analysis
Timeline
Database Developer and Analyst
A global leading luxury automotive manufacturer
03.2026 - Current
Database Developer and Analyst
A global leading luxury automotive manufacturer
06.2023 - 02.2026
Database Developer
A global leading luxury automotive manufacturer
02.2023 - 05.2023
Database and ETL Developer
A global leading luxury automotive manufacturer
11.2021 - 01.2023
Java Developer
A global leading luxury automotive manufacturer
07.2021 - 10.2021
Bachelor of Technology - Computer Science and Engineering
JECRC University