Data Engineer

Mandar Joshi

Phone: 973-***-****

Email: ********@*****.***

Objective: To Associate myself with professionally driven esteemed

organization in a techno functional role.

. SUMMARY: 5+ Years of IT Experience with four years of extensive

experience working as a MySQL Database Administrator.

. Experienced in designing database schemas.

. Highly proficient in resolving complex issues with client's database,

software applications.

. Experienced in Installing, administering, upgrading and Tuning MySQL

. Expert in Setting up the Master/Multi-Slave of MySQL database servers for

both the failover/fault-tolerant scheme and load balancing.

. Expert in setting up Replication and creating SQL records & tables.

. Solid experience on all versions of MySQL RDBMS.

. Created Indexs on MyISAM tables.

. Strong working experience with MyISAM, InnoDB, MERGE, MEMORY and Cluster

engines under MySQL.

. Experience in Database design using ERD and Class Diagrams.

. Solid Experience in Database design and implementation.

. Highly experienced with setting up Triggers and Procedures.

. Strong programming and debugging skills in SQL.

. Excellent experience in writing SQL queries and stored procedures.

. Upgraded MySQL server.

. Ability to work at MySQL Binary logs level used by Disaster recovery

planning.

. Recovered data for the clients by using Binary logs.

. Monitored & Repaired MyISAM, MEMORY and InnoDB tables.

. Solid experience in Optimizing Query, Performance Tuning.

. Copied or Backup the database/Tables Using MySQLDUMP and MySQL HOTCOPY

. Worked with third party tools like Toad, SQLYOG for reporting and quick

results.

. Managed Database Storage Structures. Managing Database blocks, table

spaces and data files, generating DDL.

. Excellent Debugging and Solution implementing skill.

Education:

Master of Science in Computer Science

New Jersey Institute of Technology (NJIT)

GPA: 3.50/4.00

Bachelor of Engineering K. G. C. E Bachelor of

Engineering K. G. C. E

Mumbai University, India

Final Semester Percentage: 65%

=-

Client: EclinicalWorks, MA

Position: MySQL DBA

Duration: June 2009 - Current

. Installed and configured MySQL on Windows XP, Windows Vista

environment.

. Upgraded MySQL version from 4.0.24 to 4.1.22 & 4.1.22 to 5.0.80

. Setup and Configured MySQL Replication for Enterprise Clients.

. Setup the Replication Monitor for the client. Whenever Replication out

of Sync, Users will get an e-mail.

. Performed MySQL Replication setup and administration on Master-Slave

and Master-Master.

. Expertise in setting up the Master/Multi-Slave MySQL database servers.

. Managed/Troubleshot the Master/Slave database servers on a daily

basis.

. Created Indexes on MyISAM tables.

. Performance Tuning on a daily basis for preventing issues and

providing capacity planning using MySQL Enterprise Monitor.

. Writing Tuned sql for inserting data and updating the present data.

. Worked on slow query logs.

. Recovered Data for clients using Binarylogs.

. Ability to work at MySQL binary logs level.

. Used MYSQLBINLOG Utility to create binarylog file into Text file.

. Fine tuning queries, stored procedures and other application related

configurations

. Created data extracts as part of data analysis and exchanged with

internal staff.

. Involved in the creation of tables.

. Writing SQL queries for data retrieval.

. Disaster recovery planning and MySQL security management.

. Monitored/Repaired MyISAM, Memory and InnoDB tables.

. Supported both MyISAM and InnoDB storage engines

. Copied or Backup the database/Tables Using MySQLDUMP and MySQL

HOTCOPY.

. Monitored and troubleshoot high-volume database performance.

. Worked on Query optimization.

. Assisted with sizing, query optimization, buffer tuning, backup and

recovery, installations, upgrades and security including other

administration functions as part of profiling plan.

. Designed databases for referential integrity and involved in logical

design plan.

. Maintained existing system and provided on-call support.

. Coordinated between client and offshore development team.

. Performed troubleshooting of database and report problems.

. Optimized the database schema and query analysis.

. Took the backup of all logs, Database tables on tape drive.

Client: Highmark Insurance, PA

Position: DBA

Duration: April 2008 - May 2009

. Installed and configured MySQL on Windows XP, Windows server2003 and

window server 2008 environment.

. Upgraded MySQL version from 4.0.24 to 4.1.22 & 4.1.22 to 5.0.80

. Setup and Configured MySQL Replication for Enterprise Clients.

. Setup the Replication Monitor for the client. Whenever Replication out

of Sync, Users will get an e-mail.

. Performed MySQL Replication setup and administration on Master-Slave

and Master-Master.

. Expertise in setting up the Master/Multi-Slave MySQL database servers.

. Managed/Troubleshot the Master/Slave database servers on a daily

basis.

. Created Indexes on MyISAM tables.

. Performance Tuning on a daily basis for preventing issues and

providing capacity planning using MySQL Enterprise Monitor.

. Writing Tuned sql for inserting data and updating the present data.

. Worked on slow query logs.

. Recovered Data for clients using Binarylogs.

. Ability to work at MySQL binary logs level.

. Used MYSQLBINLOG Utility to create binarylog file into Text file.

. Fine tuning queries, stored procedures and other application related

configurations

. Created data extracts as part of data analysis and exchanged with

internal staff.

. Involved in the creation of tables.

. Writing SQL queries for data retrieval.

. Disaster recovery planning and MySQL security management.

. Monitored/Repaired MyISAM, Memory and InnoDB tables.

. Supported both MyISAM and InnoDB storage engines

. Copied or Backup the database/Tables Using MySQLDUMP and MySQL

HOTCOPY.

. Monitored and troubleshoot high-volume database performance.

. Assisted with sizing, query optimization, buffer tuning, backup and

recovery, installations, upgrades and security including other

administration functions as part of profiling plan.

. Designed databases for referential integrity and involved in logical

design plan.

. Maintained existing system and provided on-call support.

. Coordinated between client and offshore development team.

. Performed troubleshooting of database and report problems.

. Optimized the database schema and query analysis.

. Took the backup of all logs, Database tables on tape drive.

. Used Humming Bird Exceed for deploying applications on Unix Box, wrote

Ant scripts for deploying application.

Client: Verizon Business, Colorado Springs, CO

Position: MySQL DBA

Duration: Jan 2007 - Mar 2008

Project: IMPACT (NM2E & TRAP)

. Installed and configured MySQL on Windows XP, Windows Vista

environment.

. Upgraded MySQL version from 4.0.24 to 4.1.22 & 4.1.22 to 5.0.80

. Setup and Configured MySQL Replication for Enterprise Clients.

. Setup the Replication Monitor for the client. Whenever Replication out

of Sync, Users will get an e-mail.

. Performed MySQL Replication setup and administration on Master-Slave

and Master-Master.

. Expertise in setting up the Master/Multi-Slave MySQL database servers.

. Managed/Troubleshot the Master/Slave database servers on a daily

basis.

. Created Indexes on MyISAM tables.

. Performance Tuning on a daily basis for preventing issues and

providing capacity planning using MySQL Enterprise Monitor.

. Writing Tuned sql for inserting data and updating the present data.

. Worked on slow query logs.

. Recovered Data for clients using Binarylogs.

. Ability to work at MySQL binary logs level.

. Used MYSQLBINLOG Utility to create binarylog file into Text file.

. Fine tuning queries, stored procedures and other application related

configurations

. Created data extracts as part of data analysis and exchanged with

internal staff.

. Involved in the creation of tables.

. Writing SQL queries for data retrieval.

. Disaster recovery planning and MySQL security management.

. Monitored/Repaired MyISAM, Memory and InnoDB tables.

. Supported both MyISAM and InnoDB storage engines

. Copied or Backup the database/Tables Using MySQLDUMP and MySQL

HOTCOPY.

. Monitored and troubleshoot high-volume database performance.

. Assisted with sizing, query optimization, buffer tuning, backup and

recovery, installations, upgrades and security including other

administration functions as part of profiling plan.

. Designed databases for referential integrity and involved in logical

design plan.

. Maintained existing system and provided on-call support.

. Coordinated between client and offshore development team.

. Performed troubleshooting of database and report problems.

. Optimized the database schema and query analysis.

. Took the backup of all logs, Database tables on tape drive.

Motorola, NJ

Position: Software and Hardware Engineer (Internship)

Aug 06 - Dec 06

Analyzed, designed and developed test cases for Motorola Q phones that

support every single function of Desktop PC. Several projects were

developed to support different carriers at Motorola. Two of these projects

were completed before time thereby increasing the productivity at Motorola.

These projects helped the portfolio managers make decisions based on the

tabulated information provided by these applications.

Project work completed at Motorola(

Hopper Lab: The purpose of hopper lab is to carried out Hopper and LTK and

CETK tests on CDMA Phones. These logs were analyzed and CR's were created.

By looking at STACK obtain from tests, changes were made in CODE. Scripting

is done for solving errors that were obtained during hopper run. These test

logs are used by Motorola to have Microsoft logo on their mobile.

Key Network Analysis (KNA): Perform KNA on new technology PTT on 3G for GSM

network, for mobile that yet to be launched by Motorola. These projects

helped the portfolio managers make decisions based on the tabulated

information provided by these applications

About my Role: Worked as junior programmer with C, C++ for writing DLL's.

After performing Hopper lab tests, the STACK was checked for logs and

necessary code changes were made.

Environment: Windows CE5.0, Jetstream, RSDLite, Radiocomm, Data

Translation, QPST, QXDM, JAVA, C++.

Client: RCF, India

Position: Software Engineer (Full time)

May 04 - May 05

. Monitored/Repaired MyISAM, Memory and InnoDB tables.

. Deployed shell scripts for taking MyISAM backup, InnoDB Hot backup and

for diagnosing MySQL.

. Excellent experience with query optimization.

. Setup and Configured MySQL Replication for Master/Multi-Slave of MySQL

database servers.

. Managed/Troubleshot the Master/Slave database servers on a daily

basis.

. Setup the Replication Monitor on the servers. Whenever Replication out

of Sync, Users will get an e-mail.

. Ability to work at MySQL binary logs level.

. Recovered Data by using Binarylogs.

. Disaster recovery planning and MySQL security management.

. Aptitude for documentation, reporting, innovation and process

improvement.

. Provided assistance to developers on a daily basis.

. Diagnosis MySQL servers problems and fix issues.

. Worked with tool like SQLYOG.

. Wrote the complex queries to retrieve the data.

. Created Indexs on MyISAM tables.

. Repaired MyISAM tables.

. Used MySQLDUMP and MySQL HOTCOPY to backup the database.

. Optimized the complex queries by adding indexes on tables.

Contact this candidate