Now you can Instantly Chat with Poonam!
About Me
I have total 6 years of experience as database engineer. In this duration I have worked on MySQL development and MySQL Administration. Currently I am working with Altisource Business solutions Ltd from last 2 years and 9 months. Earlier I worked w...
Show MoreSkills
Positions
Portfolio Projects
Description
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
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.
Description
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
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.