Database Expert | Data warehouse Developer | ETL | Business Intelligence | Data Analytics | Power BI | Data Visualization
Over 9 years Database experience with design, development and administration experience in both OLTP and OLAP
• Data Steward
• Expert 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.
• Provided maintenance and development of bug fixes and patch sets for applications.
• 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.
o Experience in Data warehouse such as dimensional modeling, Star/Snowflake schemas, Data marts, fact and dimension tables identification and OLAP.
o Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from different DB sources and Flat File sources.
o Experience in Data Modeling skills using MS VISIO and ERWIN.
• Excellent verbal/written communication skills and strong analytical abilities, and can perform well both independently and as a team player.
Work Terms
- I can work on Fix Rate or also available on per hour basis.
- You can contact me on Skype and Google Meet all the time.
Attachments (Click to Preview)
-