about

dbpandit

Author : Harsh Kumar Pandit, reachable at : harsh.pandit@outlook.com

Professional and highly motivated, having over 7+ years of MYSQL DBA and Development work experience in the software industry with MySQL (5.x), ElasticSearch, Redis & AWS Environment. Also :

  • Experience in Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySQL Server installation, upgrade & migration.
  • Proficient in writing shell scripts as well as knowledge in general systems administration tasks.
  • Experience in AWS Services like launching/managing EC2 instances, ELBs, disk snapshots, Managing security etc.
  • Rich experience in administrating ElasticSearch Clusters (NoSQL Document based Database).
  • Experience in the administration of Web based Internet/Intranet Client/Server multi-tire distributed application, major in database technologies in H&B, Travel and e-commerce domain.
  • Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors, Events and SQL in MySQL,
  • Experienced in designing, modeling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.
  • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
  • Expertise in snapshot, import/export, DB optimization with the help of explain plan.
  • Expertise in database migration from MyISAM format to InnoDB storage engine to increase performance and betterment of integrity constraints.
  • Automate several DBA tasks via Bash/Perl/Python scripting.
  • Good analytical, problem-solving and communication skills.
  • Expertise on technical documentation as project plan, development strategy, user manual, test and implementation strategy.