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.

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                              : 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.

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.