Author : Harsh Kumar Pandit, reachable at : email@example.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.