Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Additional Information
Timeline

BHAVIN KATRODIYA

Sr. Database Developer
Bangkok,Thailand

Summary

A logical, analytical thinker with exceptional database skills possesses rich industry experience of around 9+ years as a Database professional, Developer, Engineer, Administrator, Optimizer and Maintainer with hands on skill for DB Design and architecture, Implementation of complex Business Applications using the Relational Database Management System (RDBMS) like Microsoft SQL Server, Oracle.

Overview

3
3
Certifications
6
6
years of post-secondary education
8
8
years of professional experience

Work History

Sr. Database Developer

Agoda
Bangkok, Thailand
07.2019 - Current
  • Be a part of development team to implement business critical and complex logic to sql.
  • Built databases and table structures following architecture methodology for web applications.
  • Created and implemented database designs and data models.
  • Delivered complex business requirements without any issues by leveraging strong troubleshooting skills and extensive oversight.
  • Keen to resolve database performance bug by expert tuning skill with analyzed business cases understanding and produce best output.
  • Tested programs and databases to identify issues and make necessary modifications.
  • Set up and controlled user profiles and access levels for each database segment to protect important data.
  • Cultivated and maintained effective working relationships with other developers and members of product, Finance and website department.
  • Evaluated, designed, implemented and modified databases and database applications.
  • Coordinated with project management staff on database development timelines and project scope.
  • Knowledge sharing related to performance tuning to database developer and software developer.
  • Initiated work on data warehouse for one of team.

Database Administrator

infoAnalytica, Inc
Ahmedabad, Gujarat
05.2019 - 07.2019
  • Strong hands-on database development ability with report to the Senior Technology Director Leadership team in Product Development.
  • Proficient in MS SQL database Development, design, implementation, performance tuning, and capacity planning.
  • Application development using Microsoft SQL Server 2017, AWS, MongoDB with front end interfaces.
  • Ensure performance, security, and availability of databases when any disaster happen.
  • Collaborate with other junior and non-technical developer and clients.

Sr. Database Developer – L1

Clarion Technology
Ahmedabad, Gujarat
09.2016 - 05.2019
  • Manage and prepared database design, architecture, or schema and create database-level objects as per business needs.
  • Major involvement in database development tasks and performance tuning optimization. Review and approved MS SQL database scripts develop by database professional or non-technical team members.
  • Resource Management using RedGate Tool. Implemented Replication using always-on high availability server.
  • Convert Oracle Database objects into MS SQL Server to achieve the same functionality as an oracle.
  • Dealing with deadlocks and database maintenance activity as per timeline and review SQL agents and monitoring too.
  • Be part of backup and restore team to define a proper strategy of minimum data loss and performed DBA activity on a lower database environment.
  • Troubleshooting the challenges overproduction, Pre-release, UAT, and local.
  • As a Senior database developer guide to the team and define business solutions with optimum database techniques.
  • Involved in module-level project management with a team size of 35+.
  • Loading the data from different sources like XLS, CSV, and loading from other SQL Server databases as well for further processing.
  • Developed basic SSIS packages as well for data loading and Data-warehousing works for a client.

Software Engineer

SPEC-INDIA
Ahmedabad, Gujarat
01.2013 - 08.2016
  • Based on functionality creation of application objects such as tables, indexes, views, synonyms, sequences,
    procedures and functions at optimum level to achieve targets.
  • Coding and performance tuning for business critical requirement or functionality.
  • Creation of Database Trigger for security purpose as well as maintaining table history for further analysis.
  • Involved in the module level project management with a team size of 20+.
  • Worked with developers, quality assurance, business analyst, and system engineer to ensure software quality, product excellence, and achieving the overall mission of keeping the Oracle 10g/11g Application environment running smoothly.
  • Created test cases , Technical Design Documentation, POCs of all the activities before go to live.
  • Provide support in night batch failure critical situation.
  • Client communication related to his current business requirement and understanding of current data pattern of
    table.
  • Database migration and management of database servers.
  • Manage pixel perfect design report to give rich output in exported report in any format (Excel, Word, CSV, PDF) in Jasper Soft technologies.

Education

Master of Computer Applications - Computer Application

Gujarat Technological University, Ahmedabad
07.2010 - 01.2013

CGPA : 8.62

Bachelor of Computer Applications - Computer And Information Sciences

Gujarat Technological University
05.2007 - 06.2010

% - 74.24

Skills

Database Optimization

undefined

Accomplishments

  • Going Extra Mile - Couple of times winner of Going Extra Mile award at Clarion.
  • Nominated as SPEC STAR - Three Times nominate for the SPEC STAR Award.
  • First Prize in Shell-Scripting - National Level Technical Meet Tech-Drishti @ Gandhinagar.
  • First Prize in Paper Presentation Competition - National Level Student Symposium IGNITE @ Changa.
  • First Prize in Hardware Competition - Green Genius, SVCCS @ Bhavnagar.
  • First Prize in Quiz Competition - Intra-College Event TechPrayas-2012
  • @ Gandhinagar.
  • Third Prize in Quiz Competition - Hosted By IEEE as part of Techno Khoj 2010 STAR, @ Vallabh Vidyanagar.
  • Judo Federation of India - 2nd Public School National Judo Championship 2000 @ New Delhi

Certification

ORACLE CERTIFIED ASSOCIATE [98\100]

Additional Information

Date of Birth : 30-Aug-1990

Gender : Male

Marital Status : Married

Nationality : Indian

Language Proficiency : Gujarati (Mother tongue), Hindi, English

Hobbies : Playing Cricket & Volleyball & TT, Listening Music, Travelling, Reading Magazine

Timeline

Sr. Database Developer - Agoda
07.2019 - Current
Database Administrator - infoAnalytica, Inc
05.2019 - 07.2019
Sr. Database Developer – L1 - Clarion Technology
09.2016 - 05.2019
Software Engineer - SPEC-INDIA
01.2013 - 08.2016

ORACLE CERTIFIED ASSOCIATE [98\100]

08-2012

MICROSOFT TECHNOLOGY ASSOCIATE [81\100]

08-2012

ORACLE Database 10g: SQL EXPERT [96\100]

07-2012
Gujarat Technological University - Master of Computer Applications, Computer Application
07.2010 - 01.2013
Gujarat Technological University - Bachelor of Computer Applications, Computer And Information Sciences
05.2007 - 06.2010

Similar Profiles

  • Cheng Yun Zhang

    Cheng Yun ZhangCheng Yun Zhang

    Customer Experience Specialist at AgodaCustomer Experience Specialist at Agoda

    View Profile
  • VIONA TRINATHANAEL

    VIONA TRINATHANAELVIONA TRINATHANAEL

    Customer Experience Specialist at AgodaCustomer Experience Specialist at Agoda

    View Profile
  • Jin Woo Yang

    Jin Woo YangJin Woo Yang

    Specialized Account Manager at AgodaSpecialized Account Manager at Agoda

    View Profile
BHAVIN KATRODIYASr. Database Developer