Meet Deepak Mahto, a seasoned Database Professional dedicated to streamlining and modernizing the process of database migration to the cloud.
His journey began as an Oracle Developer, where his fascination with the inner workings of databases led him to specialize in performance tuning. Deepak's passion evolved towards enabling migrations and guiding customers through the transition to PostgreSQL on Google Cloud. He takes pride in managing complex migrations, including the impressive feat of converting approximately 1 million lines of code and facilitating large-scale data transfers. Deepak has been an avid blogger since 2014, keen on sharing his vast knowledge and experiences with databases. Hailing from Mumbai, his professional path has taken him across India's tech hubs. Now based in Mumbai and working with Google Cloud, Deepak cherishes his roles as a husband and a proud father.
Today, we're focusing on PostgreSQL Migration, and we discuss:
Migration Path Overview:
Initial assessment of current database setup.
Identifying data types and schema in the existing system.
Planning for data transfer and system downtime.
Challenges in Cloud Migration:
Adjusting to different performance characteristics in the cloud.
Ensuring data security during and after migration.
Managing changes in maintenance and operations.
Code Conversion to PL/pgSQL
Converting 1 Million Lines of Code:
Tools and scripts used for automated code conversion.
Strategies for handling complex or unique code structures.
Testing and validation process post-conversion.
Speedy and Quality Migration
Faster, High-Quality Migration:
Utilizing PostgreSQL extensions for enhanced functionality.
Best practices for data integrity checks during migration.
Balancing speed with thoroughness in the migration process.
Where to find Deepak Mahto
• LinkedIn: https://www.linkedin.com/in/mahtodeepak/
• blogLink: https://databaserookies.wordpress.com/
Where to find Ajay
• Newsletter: databytego.com
• LinkedIn: https://www.linkedin.com/in/ajkpatel/
Share this post