About Me

Having 15+ Year of total IT experience with high proficiency Database Consultant (MySQL) and Cloud Databases along with 5+ year hands on experience in SQL Server DBA. 4+ year hands on experience AWS (Amazon Web Services) with Redshift Cluster and RDS... SQL Server DBA. 4+ year hands on experience AWS (Amazon Web Services) with Redshift Cluster and RDS DBA. Good working experience on MariaDB, MongoDB Administration and PostgreSQL with Installation, Upgradation and configuration on Linux/Windows including database backup/restore with recovery process, Export/Import the data to various formats, configuring Logging features, query profiling and diagnosis issues and Performance tuning, Query tuning and index optimization. Hands-on-Experience to setup MongoDB ReplicaSet and deployment of Sharding. Good experience in RDBMS Technologies (MySQL/PostgreSQL/MSSQL) in Dev/QA/Production environments. Working on Service Improvement Plan, Automation. Experience to provide design and solution for high traffic and high availability environment. Good experience to assist development and reporting groups in optimizing SQL statements in applications, batch jobs, and reports and in designing and using databases and database applications and processes for maximum performance, security, reliability, and availability. Good experience to creates, distributes, and enforces standards for user account, group, and database security and configuration for all production databases and for non-production databases. Experience to design and implement the database to follow OLTP/OLAP standards which makes system robust and Provide proactive and reactive data management support. Experience to handle client (UK/US), involved in knowledge transition and coordinate with offshore team to provide required support. Experience on Project Management, Point of Escalation, Service Improvement Plan, Automation, Operation Support/BAU, Database Transition, Database Transformation, Cloud Computing, Virtualization, Clustering Solutions, DR deployment, Database/Data Center, Consolidation, Strategic Consulting, Training & Development, Risk management, Validation & Delivery and Capacity Planning. Monitors performance issues on all production and non-production databases and implementing performance monitoring and trending on all databases and improve performance using performance data collected to verify performance improvements. Expertise of Database Migration with cross platform (Oracle/PostgreSQL/MSSQL/Maria to MySQL). Experience in AWS DMS (Data Migration Service) and Scheme Conversion Tool. Proficient in AWS (Amazon Web Services) with working experience on EC2, RDS, Elastic Cache, VPC, S3, Glacier, Cloud Watch, SNS/SQS, ELB and Auto Scaling etc. Proficient in Azure Cloud Services with working experience on Azure SQL-MI, Azure SQL Server, BLOB Storage Account, Azure Function, Azure PaaS DB Service (MySQL/Maria/Cosmos DB), Automation with PowerShell and terraform. Experience on Database RFS activity and provide end to end solution to the client as a value-add. Experience onshore Transition, Knowledge Transfer (KT) and set up all the things for new project. Working Knowledge of source code management tools GIT and BitBucket. Basic knowledge of Jenkins CI Tool installation and integration. Good knowledge of Docker Container configuration and integration along with Docker Swarm. Basic knowledge of SCM (System Configuration Management) tool like Chef and Ansible. Experience to formulate a plan for archival and data retention policies/procedures, deployment backups, load balancing, fail over, develop recover procedures and support recovery from loss of data Create Shell, PHP, PowerShell, Python Scripts for database maintenance, Migration, Monitoring and Backup Hands-on-Experience of Database Performance Tuning Troubleshoot (Database and Query level) Optimization of queries, indexes, tables and database Good hands-on-experience of MySQL/MariaDB SSL Implementation and Configuration Performance Tuning activities includes configure slow logs, Creating Explain Plan, Creating SQL Tuning Tasks to find out the Execution plan of slow performing SQL queries and suggest developers accordingly Experience to make SQL Queries, create view, procedures, functions and triggers in MySQL Knowledge of DRBD Setup, Memcached and Cluster configuration Perform DR Drill test wherein the DR site DBs are brought up using switchover and failover, in co-ordination with storage and another team Moving of data files, log files from slow performing mount point to fast performing mount points Developed UNIX shell scripts and SQL scripts to carry out routine checks on MySQL databases. This includes checking whether all databases are running, disk space availability, checking errors logs, DB Backup, check and repair tables, monitoring replication etc. Database refresh (Complete refresh and data-only refresh, point in time recovery) from different environment like, Production, QA, Staging, and Development Implementation of Group Replication and troubleshoot the issues Hands on Experience to Implementation/Managing of InnoDB Cluster DB Functional and compatibility testing after upgrade from lower version Good Working knowledge of MySQL NDBD Cluster Good knowledge of GALERA Cluster for MySQL and MariaDB MySQL installation and configuration by Docker Container