Mohammed Iqbal Khan

About Mohammed Iqbal Khan

IT Professional | Lead Performance DBA | Data Engineer | Analyst | Release & …

Experience

1. Lead Database Consultant

   Teradata

   Nov 2014 — Present · Mumbai, IN

   Working as a Primary Performance Tuning DBA, responsible for resolving overall performance issues on production system by way of query and workload tuning involving rewrites and application of various tuning techniques using statistics and other structural changes and TASM. Provided 100%+ ROI year on year basis with CPU savings more than 370+ Million. Worked and implemented script for stats refresh and SP recompile and was involved in migration from 15.10 to 16.20. Also worked on various compression analysis and implementation for the client using MVC. A part from that I was in operation DBA, working on 24*7 Support Environment managed by strict Service Level Agreements with time limits for ticket acknowledging, ticket resolution/Escalation.Creating Teradata objects like Databases, Users, Profiles, Roles, Tables, etc.Modifying Databases, Users, Roles & Profiles.Dropping Databases / Users (In Decommission case/Obsolete). Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles. Creating Store Procedure to Automate Adhoc task. Monitoring the system. Investigating Space Usage & Monitoring the growth of the databases.Copying objects from one database to another database. Executing change requests for DDL & DML statements from the users. Participating in all major upgrades, migration and maintenance activity. Support in BAR upgrades and troubleshoot the issues which occurred during weekly BAR cycle run.

Education

• University of Mumbai

  Bachelor's Degree

  2002 — 2007

Skills

• Iis
• Database Design
• Microsoft Sql Server
• Software Development
• Microsoft Sql S
• Testing
• Performance Tuning
• Databases
• Teradata Data Warehouse
• Sql
• Linux Kernel
• Data Migration
• Servers
• Itil
• Teradata 14 Certified Professional
• Itil Certified