Rajnish
1,311
reputation
4
14
23
- 16+ years of experience in Implementing and managing high transaction databases ,Implementing Data Warehouse solution with appropriate data analytics. Data Architect with 16+ years of experience in Implementing and managing high transaction databases ,Implementing Data Warehouse solution with appropriate data analytics. My expertise are Designing Data Warehouse Architecture, Handling Highly Transactional Database, DataAnalytics Solution on AWS/GCP/Snowflake/BigQuery/MySQL/MongoDB/Tableau/Python Experience in ETL/ELT designs, conceptual & logical Data Modeling with experience in various industry models like FSLDM, CLDM, OMOP CDM models. Experienced in End to End implementation on Cloud Data Warehouse SNOWFLAKE on AWS . Experienced in Implementing Snowflake advanced concepts like setting up resource monitors, Role based access controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and data ingestion, Creating Stored Procedure, Configure Scheduler on snowflake. Proficient performance tuning and troubleshoot Expertise in deploying Snowflake data sharing, Snowpipe , in RDBMS, complex SQL, Unix Shell Scripting,Python scripting. Worked with a team to 24x7 support for mission critical projects, production support DBA and supported around 100 Databases with sizes from GB's to Terabytes. Performed database upgrades Mysql 5.7.X to 8.0.X using Blue/Green Deployment with minimum downtime. Planned and implemented Disaster Recovery & High Availability Solutions,Data Cleanup,Data Archival , Making easy process to access archived data using AWS-Athena. Managing TB of data on MongoDB, Optimisation Query, Configure TTL for Large collections. Building Pipeline From Scratch using AWS-DMS, Fivetran. DataAnalytics using Python Streamlit and Tableau, building and maintaining Tableau dashboards.