Mohammed Adil Email & Phone Number

Bengaluru, Ka, In

Bangalore Urban, Karnataka, India

• Contributing in the global premium support team for RDS, Aurora and DMS.• Performance tuning the production database for optimum utilization of Server resources. Includes Query Optimization for slow running queries and unused indexes• Helping customers in troubleshooting and resolving performance issues..• Provide optimal inputs in handling and providing best solutions.• Suggestions in capacity planning for setting up the database environments.• Working on multiple issues in all section for services related to RDS, Aurora and DMS.• Idnetifying customer Alerts and resolve issues to take appropriate action as need.• Managing user creation and providing end-to-end implementation and migrations.

Bengaluru, Karnataka, India

DBMS SQL Administration • Installed SQL servers 2012, 2014 and 2016 as per customer requirement.• Database migration from SQL 2008/2008R2 to 2014 and 2016.• Configured SQL server 2014 and 2016 SQL cluster and applying the latest service packs.• Configured SQL Server AlwaysOn for Disaster Recovery solution.• Having good experience planning and implementation of AlwaysOn multisite cluster.• Completely involved in Data center migration activities• Experienced Configuring and admin the High availability concept using the Always-On feature.• Have built Disaster Recovery strategy between On-prem data Center and AWS Cloud for SQLserver databases using Availability groups.• Monitoring and troubleshooting MongoDB instances.• Administrating and maintaining MySQL/MariaDB clusters (active-passive/Multi- master)• Experienced in Google Cloud SQL build and deploy, also compute engines.• Experienced in AWS RDS SQL Server engines administration including RDS aurora MySQL andMariaDB and RDS Proxy and DMS services.• Provided global support for AWS RDS issues for multiple organizations.DevOps• AWS Elastic search and ELK stack installation, configurations and monitoring.• Managing Elastic administrative tasks.• Built messaging cluster platform for RabbitMQ and Redis.• Experienced in building repositories like GitLab and SVN.• Experienced in Jenkins Continuous Integration administration.System Administration• Windows batch scripts for Service restarts and data space disk alerts across windows servers.• Experience in S3 management.• Configuring cron jobs for MySQL/MariaDB database backups and storage management onUbuntu servers.• Worked with Acunetix vulnerability scanner to check for complete organization websitevulnerability Checks like SQL injection and network bindings.• Worked with a10 networks tool for creating load balancing VIPs and managing servers.

Bengaluru Area, India

Job Responsibilities:• Installation and maintenance of SQL server 2005 and 2012 for new build projects.• Databases created as per application requirement.• Migrated databases from SQL 2000 to SQL 2012 • Maintenance plan for MSSQL server (DBCC, Update statistics, backup etc.).• Applied SQL server patches on production and non-production of SQL servers.• Configured replication, Log shipping and mirroring as per requirement.• Monitoring the database data files and log files available free space.• Database refreshes from production backup to Stage, UAT, Test, QA and Dev environments.• Managing Installation of SQL server 2008 R2 cluster and applying the latest service packs.• Configuring database mail for SQL server alerts • Implementation of SQL Logins, Roles and Authentication Modes.• Created logins and provide access to the users as per requirement.• BMC Remedy incidents tracking, RFCs and service requests.• Checking Fragmentation and Resolving Fragmentation issues.• Rebuilding the indexes on regular intervals for better performance.• Double-Take tool for Disaster Recovery replication and Lite-speed and Comm-Vault for Backup storage.• As a part of the DBA team providing 24x7 production support to the clients.

• Learnt and documented the organization database structure for different divisions• Worked on designing security and audit policies for database support.• Understanding the work process, client and vendor relationship.• Enhanced and equipped myself with the deep knowledge of Database administration.