Home‎ > ‎

SQL Server / BI (Business Intelligence)

Freelancer/Contractor in Switzerland/Schweiz for SQL Server Database-, BI- & Reports Developer/DBA (SSIS SSAS SSRS SharePoint .Net)

Below my services in the respective areas:

SQL Server 
/ BI Architecture & 
SQL Server 
/ BI Development
  • Architecture, design and development of large, scalable, mission-critical data-centric solutions
  • Working directly with clients to map business needs to DW/BI solutions centered on Microsoft technologies
  • Assessing existing DW/BI solutions and recommending approaches for modernization
  • Participating in design reviews and assisting with platform selection and allocation of functionality to system components
  • Documenting and presenting solutions to data architects and CTOs
  • Assessing and recommending DW/BI strategies including ETL frameworks
  • Defining data architectures for OLAP systems and large scale enterprise DW solutions
  • Logical and physical data modelling, metadata management, data stewardship, data quality assurance
  • Oversees data migration and integration activities
  • Analyzing performance bottlenecks and recommend tuning optimizations
  • Rapidly prototyping and proving solutions using relational and OLAP databases
  • Working collaboratively with software architects and developers to implement the solutions
  • T-SQL coding of stored procedures, user-defined functions and triggers, .NET programming of CLR-functions
  • SSIS-development
  • SSAS tabular or multi-dimensional data modelling, MDX-Programming, DAX-Programming
  • SSRS-development, developing of reports using Report Designer, Report Builder, PowerView and PowerPivot
  • Publishing reports and PowerPivot data models to SharePoint

SQL Server 
Administration / BI Administration
  • Manually or unattended (via INI-file, SCCM or SCVMM) installation of SQL Server and its components 
  • Licence-cost calculations for various deployment scenarios and license management of existing installations
  • Enforcing Best Practices via PBM (Policy Based Management) or via SCCM (System Center Configuration Manager)
  • Backup and Restore of SQL Server and SSAS databases
  • Troubleshooting and performance tuning of SQL Server instances and the databases
  • Implementing HA-solutions (AlwaysOn, Clustering, Mirroring, Log-Shipping, Hot-Stand-By Server, Replication)
  • Monitoring availability, health, performance, resource usage, events and errors (through SCOM, UCP or 3rd-party tools)
  • Implementing security
  • Configuring and Administering Sharepoint Business Intelligence Center
  • Configuring and Administering SSRS installed in native- or SharePoint-integrated mode
  • Administering SSAS, creating new partitions, re-processing of dimensions, partitions and cubes