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 Architecture / BI Architecture & SQL Server Development / 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
|
|
