Tool : SQLyog

Client : Hubzu.com

Development Environment : MySQL 5.7

Role : Database Engineer

Description : Creating Stored Procedure for masking data as per General Data Protection Regulation (GDPR).

Responsibilities:

• Analyzed requirements and created job structure
• Executed procedures for definition and designing of data integration mapping algorithms.
• Identified and implemented corrective measures based on gathered metrics.
• Designed codes for data access along with stored procedures and SQL queries.
• Conducted reviews of database designs and system integration issues for further improvements.

Description : Writing and Monitoring jobs to take different backups using percona(xtrabackup) and set up master-slave replication.

Responsibilities:

• Analyzed requirements and created job structure
• Executed procedures for definition and designing of data integration mapping algorithms.
• Identified and implemented corrective measures based on gathered metrics.
• Designed codes for data access along with stored procedures and SQL queries.
• Conducted reviews of database designs and system integration issues for further improvements.

Tool : Pentaho

Client : Hubzu.com

Development Environment : MySQL 5.7

Role : Database Engineer

Description : Creating multiple Pentaho jobs to perform different tasks.

Responsibilities:

• Analyzed requirements and created job structure
• Executed procedures for definition and designing of data integration mapping algorithms.
• Identified and implemented corrective measures based on gathered metrics.
• Designed codes for data access along with stored procedures and SQL queries.
• Conducted reviews of database designs and system integration issues for further improvements.

Description : Creating Jobs to archive older data from production database in particular duration.

Responsibilities:

• Analyzed Impact and created job using Percona Tools(pt-archiver) accordingly
• Identified and implemented corrective measures based on gathered metrics.
• Designed codes for data access along with stored procedures and SQL queries.
• Conducted reviews of database issues for further improvements.

Creating Stored Procedure for masking data as per General Data Protection Regulation (GDPR). Analyzed requirements and created job structure Executed procedures for definition and designing of data integration mapping algorithms. Identified and implemented corrective measures based on gathered metrics. Designed codes for data access along with stored procedures and SQL queries. Conducted reviews of database designs and system integration issues for further improvements.

Creating Jobs to archive older data from production database in particular duration. Analyzed Impact and created job using Percona Tools(pt-archiver) accordingly Identified and implemented corrective measures based on gathered metrics. Designed codes for data access along with stored procedures and SQL queries. Conducted reviews of database issues for further improvements.

JustDial.com provides Electronic Medical Record facility for the Doctors and Patients, which helps each of them to better maintain and access the records 24*7. Analyzed requirements and created database structure Identified and implemented corrective measures based on gathered metrics. Designed codes for data access along with stored procedures and SQL queries. Conducted reviews of database designs and system integration issues for further improvements. Executed procedures for definition and designing of data integration mapping algorithms. Maintaining and updating incremental time to time Backup and Restore of databases.

Web Porting is a process, which makes eligible contracts visible on different JustDial Modules/Verticals. Analyzed requirements and created database structure Executed procedures for definition and designing of data integration mapping algorithms. Identified and implemented corrective measures based on gathered metrics. Designed codes for data access along with stored procedures and SQL queries. Conducted reviews of database designs and system integration issues for further improvements. Handle micro database and sql injection. Write automatically backup and restore database algorithm.

JustDial has implemented refer & earn module for internal and external buddies and this project was on mongodb and node js.. Analyzed requirements and created database structure. Identified and implemented corrective measures based on gathered metrics. we were taking care of developing architecture of documents and creating mongo queries as needed by the nodejs developer .