Solution Architect - Database Designing & Management
Send a job offer directly to this candidate
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.
Solution Architect at Birla Software Ltd (2021-04 – 2025-09)
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 effort/ cost estimates.
Create proof-of-concepts (POCs) that address business and technical needs. Planning for risks and putting in place requisite measures to mitigate them. Driving the set-up and implementation of quality processes.
Designing and developing databases; providing required support to the Development Teams for Technical design document preparation /review, Coding/code review, process performance improvement. Undertaking performance improvement of Data Warehousing databases. Application tuning Oracle Databases in line with organizational needs.
Managing the design and implementation of application security and database security measures. Managing techno based sessions to oracle developers, providing tips on performance improvements, new features. Migration of High Volume TeraBytes size Data Warehouse project.
Serve as the primary technical contact during implementation, providing documentation and guidance to engineering teams.
Sr.
Engineer at Emirates Airline IT Group (2004-02 – 2020-08)
Module Leader at ABM Knowledgeware Ltd. (2001-02 – 2003-12)
Senior Software Engineer at Geodesic Information System Ltd. (2000-08 – 2001-02)
Software Engineer at Intelligent Computer Services (1998-04 – 2000-08)
Sr.
Engineer at New Standard Engineering Ltd. (1991-02 – 1998-02)
B.E. in Production – V. J. T. I (1990)
