Mohammad Kasid Email & Phone Number

Noida, Up, In

Gurugram, Haryana, India

Noida, Uttar Pradesh, India

Gurgaon, India

Roles and Responsibilities:• Designing solution built over RDBMS and NoSQL technologies for automated and/or on-demand scaling• Re-designing DB Service architecture for Integration between bare metal data center to cloud computing ready services.• Disaster recovery automation, System Architecture, Performance tuning, Data Science and Strategic Development using Open Source Database Systems i.e. MySQL, MongoDB• Service automation, Capacity planning, Performance Analysis, DB Profiling, Query Optimization for MySQL, MongoDB

Noida Area, India

Performed Conversion of Native MySQL to Galera Cluster Created Zamanda Backup copy verification utility using bash script which will bring MySQL instance using ZRM-TAR copy and generate a comparison report with master. Experience in schema designing, database design and reverse engineering, Backup and Recovery, Database Security and automation Performed automation of routine database activities like Installation and configuration, Switchovers-Failovers, Upgrade, Backup and Recovery on high availability environment for a various database like MySQL, MongodbWritten bash script to track the unix user activity on various services (Like puppet, cron etc.) and sending alert/notification mail in controlled fashion.Created a demon to track malicious queries and process-list fluctuation in all MySQL instances. Malicious queries is being considered on few params like query without 'where' clause , query with '*' etc.

Noida Area, India

Supporting around 500+ MySQL servers. Installing various versions of MySQL on CentOS/Redhat LinuxCreating Triggers and procedures.Creation of DatabaseConfiguring Database ParametersConfiguring Backups (ZRM backup)Creating Users and assigning privilegesCreating Tables, Indexes, ConstraintsMonitoring LocksPorting data between databasesConfiguring Replication  Master-Master replications  Master-slaves replications  Replications with Repeater  Replications with filter options  Handled stored procedure and triggers in mixed based replications Checking Completion of BackupsUser creation and management.Managing Galera cluster installation, configuration and monitoring.Have upgraded MySQL 5.5.25 to 5.5.51 for the security concern as vulnerability reportedUpgrading MySQL from 5.5. to 5.7Responsibilities as a Mongo DBA:Handling 40+ Mongo DB instances.Have enhanced Mongo DB monitoring template for zabbixCreated our own script for Mongo DB backup which takes backup on snapshot basis and keep backup at remote location by compressing it on fly.Upgraded all Mongo instances from 2.6 to 3.2 Having good experience of MMAPv1 and Wired Tiger engines.Written a smart Bash shell script to install Mongo DB instance as standalone or as replica set.

Bengaluru Area, India

Responsibilities as a MySQL/Mongo DBA:Supporting around 5000+ MySQL/800+ Mongo server. Ensuring MySQL/MongoDB servers run at optimal health. Managing installation of various versions of MySQL/MongoDB across multiple environments.Implemented of comprehensive backup and database replication solutions. Performance benchmarking, documentation, upgrades, operational guidelines, security and account maintenance.Knowledge of MySQL InnoDB and MyISAM Database engines.Huge experience in MySQL replication setup and configuration (have experienced to manage almost 40 instances in a single topology with the concept of repeater (Load balancer or relay slave))Huge experience in switch over (promoting relay-slave or slave as master).Experience in Mongo replication setup and configuration (setting up replication along with Arbiter/hidden Secondary)Established standard operating procedures for administering MySQL databases.Troubleshoot database issues, maintain database systems availability and scalabilityDatabase Performance optimization by finding and diagnosing slow-running queries.Monitoring database health, usage, growth of database size and disk spaces on regular basis.Experience of Database troubleshooting pertaining to performance etc.Experience of McAfee database security auditing tool. Experience in Galera cluster Replication and monitoring.Oncall experience in a critical production environment on multiple database technologies ( MySQL/MongoDB/Vertica/Oracle/postgresql).Have been trained as JAVA developer (Core + spring/hibernate) and triumphed the In-house exam within MindTree, later moved with DBA role.