About

Himanshu Singh is a highly skilled Database Consultant with over 12 years of experience in database administration, development, and architecture. He has a full life cycle experience in OLTP and OLAP, Data Warehousing, on-premises, and in-cloud environments. Himanshu has excellent experience in deploying, maintaining, and migrating databases on Amazon RDS and EC2 and to AWS cloud infrastructure. He has hands-on experience in AWS technologies like AuroraDB, RedShift, EC2, KMS, etc. Himanshu has experience in creating and maintaining MySQL replication topologies and MySQL cluster for High Availability, HA Proxy, MySQL Fabric, and Max Scale. He has set up read-write split with ProxySQL and AWS Aurora DB. Himanshu has also automated and manual processes for backup for recovery and disaster management. He has experience in MySQLdump, Percona XtraBackup utility, and enterprise backup, AWS snapshots, and point in recovery. With a micro-level understanding of PL/SQL, Himanshu is sufficiently experienced in day-to-day development tasks and an expert in optimization and creating complex SQL queries, views, functions, procedures, and triggers, etc. He has experience in database conversion from Oracle and SQL Server to MySQL and PostgreSQL. Himanshu has an excellent understanding of MySQL Database Performance and SQL Statement Tuning. Himanshu is skilled in monitoring, optimization, import & export of the database, creating & granting roles, etc. He has experience in database clustering, replication, table partitioning, monitoring, and troubleshooting issues, data compression, SQL statement profiling, data encryption in production and developer environments. Himanshu has experience in setting up and supporting NoSQL databases like MongoDB and JSON datatype in MySQL and Postgres. Himanshu has excellent interpersonal skills leading application development teams as well as DBA teams. He has analyzed and resolved production performance issues, making specific recommendations to significantly increase the performance and reliability of MySQL based systems and applications. Himanshu has provided needed database-related shell scripts. He has managed database access and security for development and production databases. Himanshu is currently working as a Database Consultant at Global Logic. In the past, he has worked with companies like Halodoc as a Senior Database Administrator and FreeCharge as a Principal Architect Database Manager. Himanshu holds a B.Tech degree in Computer Science from Roorkee Institute of Technology. His tech stack includes SQL, AWS, MySQL, Senior Software Engineer,