Summary
Work History
Education
Skills
Work Preference
Accomplishments
Timeline
AdministrativeAssistant

Kranti Sawant

Mumbai

Summary

Seasoned Database Developer and Administrator with extensive experience in managing and optimizing cloud based database systems. Proficient in designing, implementing, and maintaining database solutions on Google Cloud SQL and AWS RDS. Seeking to leverage expertise in a collaborative environment to enhance data management strategies and drive operational efficiency.

Work History

Database Administrator Lead

Bada Business Pvt. Ltd.
03.2023 - 02.2024
  • Led database projects, overseeing coding, documentation, testing, and debugging
  • Performed performance tuning and query optimization using SQL Profiler and related tools
  • Managed database backups, restorations, and ensured system reliability
  • Developed and optimized SQL code, including stored procedures, functions, tables, views, triggers, indexes, and constraints
  • Provided technical design recommendations for program development and integration
  • Troubleshot production system issues and ensured database performance, security, and availability
  • Analyzed, created, and implemented complex database schemas and queries
  • Monitored server resource usage and performed system upgrades to ensure smooth operations
  • Collaborated with developers to design optimal database solutions.

Database Development Lead

People10 Technologies Pvt. Ltd.
04.2021 - 11.2022
  • Developed and implemented SQL code review processes for query optimization
  • Managed database instances across development, staging, and production environments
  • Implemented backup, recovery, query tuning, and maintenance strategies
  • Ensured high availability and reliability of production databases
  • Designed and optimized database schemas, tables, and indexes
  • Collaborated with development teams to improve SQL query performance
  • Implemented data replication, synchronization, and disaster recovery strategies
  • Conducted capacity planning and scaling activities to support growing data workloads.

Database Administrator

Talisman Tech
07.2019 - 04.2020
  • Supported all aspects of database design, implementation, administration, and maintenance
  • Worked closely with engineering teams to optimize operations and queries
  • Managed database migrations, backups, restores, upgrades, and security operations
  • Created documentation and Standard Operating Procedures (SOPs) for database services.

Database Developer

Vobium Technologies Pvt. Ltd.
10.2016 - 02.2019
  • Developed, tested, implemented, and maintained robust database systems
  • Owned and resolved data related issues, contributing to key design decisions
  • Created stored procedures, triggers, functions, and views
  • Performed database tuning and developed user friendly systems.

Data Analyst

Lumina Datamatics Limited
07.2015 - 08.2016
  • Analyzed complex datasets and presented statistical findings to stakeholders
  • Conducted data extraction, cleansing, validation, and analysis using MySQL scripts
  • Managed and enhanced database systems, implementing new functionalities.

Trainee Database Developer

Alfa Digital
01.2015 - 06.2015
  • Developed and tested database functionalities for websites
  • Wrote MySQL queries, identified technical issues, and managed data backups
  • Assisted in database structure design and table relationships.

Education

Bachelor of Science - Information Technology

KES Shroff College, University of Mumbai
Mumbai, India
11.2013

Skills

  • Database Management: Google Cloud SQL, AWS RDS, MySQL, PostgreSQL, Redis, MongoDB
  • Database Design: Schema design, Indexing strategies, Query optimization
  • Cloud Platforms: Google Cloud Platform (GCP), Amazon Web Services (AWS)
  • Backup and Recovery: Automated backups, Point in time recovery
  • Performance Tuning: Query optimization, Resource utilization monitoring
  • Security: User access control, Encryption, Auditing, Data Masking
  • Data Migration: On premises to cloud migration, Data synchronization, MySQL to MSSQL
  • ETL: SSIS, Python Pipelines
  • Scripting: SQL, Shell scripting, PowerShell, Python
  • Monitoring Tools: Cloud native monitoring tools
  • Other Tools: Git, Bit bucket, SVN, Jira, Kanban Board, Agile Scrum

Work Preference

Work Type

Full TimeContract Work

Work Location

On-SiteRemoteHybrid

Accomplishments

  • Successfully led the migration of databases from on-premises to Cloud RDS with a read-replica setup.
  • Automated database deployment, data masking, and backup processes using AWS CodePipeline.

Timeline

Database Administrator Lead

Bada Business Pvt. Ltd.
03.2023 - 02.2024

Database Development Lead

People10 Technologies Pvt. Ltd.
04.2021 - 11.2022

Database Administrator

Talisman Tech
07.2019 - 04.2020

Database Developer

Vobium Technologies Pvt. Ltd.
10.2016 - 02.2019

Data Analyst

Lumina Datamatics Limited
07.2015 - 08.2016

Trainee Database Developer

Alfa Digital
01.2015 - 06.2015

Bachelor of Science - Information Technology

KES Shroff College, University of Mumbai

Similar Profiles

CREATE PROFILE
Kranti Sawant