Senior Data Engineer with 4 years of experience in SQL, MySQL, and AWS; Optimized MySQL database performance by 83% during peak hours through query optimization and performance tuning. Proven leadership having led a team of 6 engineers to deliver efficient ETL pipelines using AWS Glue and Lambda.
Overview
8
8
years of professional experience
Work History
Senior Data Engineer
Diamatics Consultancy Services Pvt. Ltd.
09.2022 - 12.2025
Designed and streamlined databases in MySQL, including tables, views, indexes, and constraints for improved performance
Optimized MySQL object performance by conducting routine audits and refactoring inefficient stored procedures, leading to a reduction in database response times by an impressive ~80% during peak usage hours.
Engineered and optimized SQL queries, resulting in a ~80% reduction in query response time and a ~80%+ increase in data retrieval efficiency.
Directed and designed ETL processes using AWS services like Glue and Lambda, ensuring efficient data transfer and transformation.
Deployed and managed AWS RDS for database hosting and performance optimization.
Orchestrated a complex MySQL database migration from version 5.7 to 8, ensuring minimal downtime and preserving data integrity throughout the process.
Mentored and developed a team of three database engineers, overseeing daily operations and driving project completion.
Configured and coordinated AWS services like EC2, RDS, Load Balancers, Route 53, and Certificate manager to ensure high availability, reliability, and secure communication.
Data Engineer
Diamatics Consultancy Services Pvt. Ltd.
04.2022 - 09.2022
Created and maintained over 100 MySQL objects, including tables, views, indexes and stored procedures.
Constructed and executed intricate SQL queries to extract actionable insights from complex datasets, empowering data-driven decision-making processes.
Employed Python and Pandas to cleanse data and prepare datasets for database ingestion.
Accelerated database performance through query optimization reducing query execution time by 40%.
Product Implementation Engineer
Good Methods Global
02.2018 - 07.2019
Developed over 100 SQL queries to validate data migration, ensuring data integrity post-migration in MS SQL Server.
Designed and executed SQL queries to derive actionable insights, addressing business needs and answering key performance indicators (KPIs).
Integrated and visualized query results in Power BI, creating dynamic dashboards to facilitate data-driven decision-making.
Collaborated with cross-functional teams to execute test cases and optimize migration processes.
Mentored new recruits on SQL querying and best practices for query optimization and data manipulation.
Education
BTech - Computer Science And Engineering
Marian Engineering College
Kerala, India
09-2017
Skills
Database Technologies: MySQL, MS SQL Server, DynamoDB, MongoDB
Database Management and Optimization: Query Optimization, Stored Procedures, Functions, Performance Tuning, Data Modelling
Cloud Technology: AWS
ETL Technologies: AWS Glue, AWS Athena, AWS Lambda, Step Function
Infra Management: EC2, Elastic Load Balancer, Route53, Nginx, Certificate Manager, API Gateway, AWS CloudFront, AWS CloudWatch
Programming Language: Python
Data Visualization: Power BI
Operating System: Linux, Windows
Languages
English
Bilingual or Proficient (C2)
Malayalam
Bilingual or Proficient (C2)
Hindi
Intermediate (B1)
Timeline
Senior Data Engineer
Diamatics Consultancy Services Pvt. Ltd.
09.2022 - 12.2025
Data Engineer
Diamatics Consultancy Services Pvt. Ltd.
04.2022 - 09.2022
Product Implementation Engineer
Good Methods Global
02.2018 - 07.2019
BTech - Computer Science And Engineering
Marian Engineering College
Similar Profiles
Manjima DManjima D
Senior Data Engineer at Diamatics Consultancy Services Pvt. Ltd.Senior Data Engineer at Diamatics Consultancy Services Pvt. Ltd.