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
07.2010 - 01.2013
CGPA : 8.62
Bachelor of Computer Applications - Computer And Information Sciences
05.2007 - 06.2010
% - 74.24
Skills
Database Optimization
Relational Database Management
Database Development
Database Administrator
Database Design and Architecture
PL\SQL
Client Communication
Jasper Report
Workload Analysis
Data Warehouse
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