Michael B.
BatumiGeorgia
100% Job Success
Top Rated

Microsoft SQL Server, BI, SSIS, SSRS, Power BI, SSAS, TSQL, ETL

• Database developer and architect with over 10 years of experience. Able to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization. • Strong hands-on experience using Microsoft SQL Server databases and related tools. • Cloud (Azure or AWS) and on-prem environment • Experience in Extraction, Transformation and Load (ETL) strategy, design, and implementation. • Experience in DWH and Reporting systems development and maintenance • Design and implementation of normalized data structures, de-normalized structures, and dimensional structures • Business logic development in SQL language • SQL stored procedures and functions • Design, build and maintain SQL scripts and complex queries for data processing • Management and implementation of database models, data flow diagrams, database schemas, DB scripts and DTD schemas • Database performance tuning and SQL query optimization • Experience in design, build and deployment effective SSIS packages. • Using SSIS to move, load, and transform data. • Experience with logging and error handling in SSIS Packages. • Building/publishing/sharing dashboards/reports in SSRS and Power BI Technical Skills • Databases: MS SQL Server, PostgreSQL, Google Spanner, Google BigQuery, MySQL, Oracle • Microsoft BI Tools: Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Power BI • BI/Reporting Tools: Oracle-Hyperion BI, SAP BI, Oracle BI, DOMO • Programming languages: SQL (TSQL, PLPGSQL, etc.), MDX, Python, R, C, C++, Pascal (Turbo Pascal, Object Pascal) • Modeling: IDEF0, IDEF1, IDEF1X, IDEF3, DFD, UML (BpWin/ErWin, Rational Rose).

Michael B. has more jobs. Create an account to review them

Skills

  • Performance Optimization
  • Database Architecture
  • SQL Programming
  • Transact-SQL
  • PostgreSQL Programming
  • Microsoft SQL Server
  • Database Optimization
  • Query Tuning

Get started working with Michael quickly with these predefined projects.

Get started working with Michael quickly with these predefined projects.

You will get expert level consulting on Microsoft SQL query optimisation

From $100
1 day delivery