Summary
Overview
Work History
Education
Skills
Languages
Achievements And Interests
Timeline
Generic

Sachin Mallick

Summary

Experienced with database design, implementation, and maintenance. Utilizes SQL and other database management tools to ensure data integrity and optimize performance. Track record of enhancing system efficiency through performance tuning and query optimization.

Overview

4
4
years of professional experience

Work History

Database Engineer

Codvo.ai
05.2024 - Current
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Developed custom scripts to automate routine tasks, resulting in significant time savings for the team.
  • Enhanced scalability of database systems to accommodate business growth, planning for future expansion needs.
  • Reduced query execution time by analyzing and fine-tuning SQL statements in complex applications.
  • Reduced system downtime, proactively monitoring databases and addressing potential issues before they escalated.
  • Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
  • Mentored junior team members through knowledge sharing sessions on advanced concepts in database engineering.

Product Development Engineer

Acidaes Solutions Private Limited (CRMNEXT)
08.2021 - 05.2024
  • Developed and optimized SQL Server databases to enhance performance and reliability
  • Designed and implemented stored procedures, functions, triggers, and views for efficient database management
  • Performed query optimization and performance tuning using SQL Profiler, Performance Monitor, and Activity Monitor
  • Troubleshot high CPU utilization, deadlocks, and database blocking issues to improve system efficiency
  • Managed MongoDB database clusters, including replication, indexing, backup, and recovery operations
  • Implemented disaster recovery (DR) strategies to minimize downtime and data loss
  • Collaborated with cross-functional teams to ensure seamless database integration in software applications

Education

B.Tech - Computer Science Engineering

KIIT University
Bhubaneswar
07.2021

Skills

  • SQL and databases
  • ETL development
  • SQL programming
  • RDBMS
  • Query optimization
  • Backup and recovery
  • Data analytics
  • Database administration
  • NoSQL databases
  • Teamwork and collaboration
  • Time management
  • Multitasking Abilities
  • Data warehousing expertise
  • Data visualization

Languages

English
Hindi

Achievements And Interests

  • State-Level Badminton Player
  • Passionate about Photography, Cooking, and Listening to Music

Timeline

Database Engineer

Codvo.ai
05.2024 - Current

Product Development Engineer

Acidaes Solutions Private Limited (CRMNEXT)
08.2021 - 05.2024

B.Tech - Computer Science Engineering

KIIT University
Sachin Mallick