
Solution Architect - Database Designing & Management
Send a job offer directly to this candidate
Versatile, high-energy technocrat with the distinction of executing prestigious Information Technology projects of large magnitude within strict time schedules. A Snowflake Architect in Database Design and Migration to Snowflake database. A Technical Professional with functional expertise in Database Design/ System Design with 20 years of rich experience in Oracle database design, Snowflake design, fine-tuning and extending support to technical teams for optimizing application performance with domain knowledge.
Extensive experience in database designing, scripting/ programming, systems analysis and technical support.
Experience in data warehouse database designing, data modelling.
Experience in migrating data warehouse high volume TB data from Oracle to Snowflake cloud database.
Experience on Migrating Oracle Database to Azure data Lake, Azure SQL Data warehouse and controlling and granting database access and Migrating On premise databases to Azure Data lake store using Azure Data Factory. High proficiency in improving database performance, ensuring maximum uptime and data integrity, and rapidly resolving problems.
Experience in migration and development Oracle Database to Exadata database. Excellent communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilizing the same in a productive manner.
Snowflake Architect - Birla Software Ltd - India
(2021-04 - 2025-09)
Sr. Technical Engineer - Emirates Airline IT Group - Dubai, UAE
(2004-02 - 2020-08)
Module Leader - ABM KnowledgeWare Ltd. - Mumbai
(2001-02 - 2003-12)
Senior Software Engineer - Geodesic Information System Ltd. - Mumbai
(2000-08 - 2001-02)
Software Engineer - Intelligent Computer Services - Mumbai
(1998-04 - 2000-08)
Sr. Planning Engineer - New Standard Engineering Ltd. - Mumbai
(1991-02 - 1998-02)
Solution Architect - Birla Software Ltd - India
(2024-04)
Analyze, design and build Modern data solutions in snowflake using Azure / AWS cloud to support visualization of data, AI / ML modules. Understand current Production state of application and determine the impact of new implementation on existing business process.
Logical and Physical data Modelling using tools like Power Designer. Produce architecture diagrams, migration plans, and standards documentation.
Transform and Load data from Sources Systems to Azure Blob using Azure data Factory or AWS S3.
Pipelines in ADF using Linked Services/Datasets/Pipeline/to Extract, Transform and load data from different sources like Azure Blob storage, Azure SQL Data warehouse.
Pipelines to load data from Azure Blob or AWS S3 to Snowflake for Bulk, Streaming, Real time copy. Monitor performance and apply methods to improve query performance, process performance. Managing end-to-end delivery of projects (including database Designing, Development). Design and implement multi-layered architecture (bronze, silver, gold) in Snowflake with clear data lineage. Establish and maintain CI/CD pipelines for data deployments. Designing the business solution and preparing effo
B.E. - Production - V. J. T. I (1990 - 1990)