Over 5 years Database experience with design, development and administration experience in both OLTP and OLAPExpert in Creating Indexes, Views, complex Triggers, effective Functions, and appropriate stored Procedures to facilitate efficient data manipulation and data consistency. Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.Extensive knowledge of clustering environment. Experience in creating jobs, Alerts and Scheduled SSIS Packages.Good knowledge of BigData and worked in (Hadoop cluster & Hive)Excellent experience of managing BI environment (SQL SERVER, ORACLE 11g & AMAZON REDSHIFT), which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.Experience in Data warehouse such as dimensional modeling, Star/Snowflake schemas, Data marts.