Erdöl Biramen

is available. ✅

Selbstständig, SQL Server DBA / Engineer / System Core Infrastructure Architect, ALSTOM Power Schweiz AG
Suhr, Schweiz

Fähigkeiten und Kenntnisse

IT-Services: Experience in Databases
RDBMS
SQL Server
Analysis Services
SSAS
Reporting Services
SSRS
Integration Services
SSIS
DTS
OLAP
DW
Datawarehousing
BI
Business Intelligence
DBA
TSQL
Stored Procedures
Tirggers
Development
Programming
Replication
Clustering
.NET
VB.NET
C#
ASP.NET
XML
XSLT
XML Schemas
XPath
XPointer
XQuery
System Center Operations Manager (SCOM )
System Center Virtual Machine Manager (SCVMM)
Hyper-V
IIS
Application-Support
Atlassian Confluence
Atlassian Jira
Atlassian Bamboo
Atlassian Bitbucket
Oracle SQL Developer
Management Studio
Microsoft Visual Studio

Werdegang

Berufserfahrung von Erdöl Biramen

  • Bis heute 14 Jahre und 7 Monate, seit Jan. 2011

    SQL Server DBA / Engineer / System Core Infrastructure Architect

    ALSTOM Power Schweiz AG

    DUTIES: Administering and supporting of SQL Server running on Windows failover clusters. Patching (via SCCM & WSUS) Multi-Server Deployment of System Center Suite Inventory & Assessment Kerberos Troubleshooting Active Directory Management & Troubleshooting DNS Management & Troubleshooting Products and technologies used: SCCM, SCOM, SCSM, Orchestrator MAP Toolkit Sqlping3 CMS – Central Management Server PBM – Policy Based Management Multi-Server Administration UCP – Utility Control Point

  • Bis heute

    Developer

    ISPS Software Nicosia/CY

  • 5 Monate, März 2015 - Juli 2015

    Data-Migration & ETL & Performance Tuning

    Direct client

    DUTIES: Migration of existing data from client’s ERP systems (OPACC and SAGE) into the self-developed MSSQL DB. Performance-Tuning of the DB-Server and the target DB. Products & technologies used: SQL Server 2014 SSIS SSMS, VS 2015, SSDT, SSDT-BI BIDSHelper Excel 2013 C#

  • 4 Monate, Sep. 2014 - Dez. 2014

    Reports-Developer & BI-Developer

    Direct client

    DUTIES: Several smaller projects in the area of Reporting & BI Products & technologies used: SQL Server 2012/2014 (incl. SSIS, SSAS, SSRS) SSMS, VS 2015, SSDT, SSDT-BI BIDSHelper Excel 2013, PowerPivot SharePoint 2013 C#

  • 3 Monate, Juli 2014 - Sep. 2014

    BI-Architect

    Swiss Re

    • Contributing to deployment planning of the BI-Stack components • Designing & documenting the security architecture of the new Microsoft BI-platforms o Authentication & authorization within the components of the BI-stack o Impersonation & Kerberos delegation between the components • Supporting the project manager in technical meetings and in her interactions with other teams SQL Server 2012/2014 (incl. SSIS, SSAS, SSRS) Excel 2013 SharePoint 2013 (Excel Services, PowerPivot, PerformancePoint)

  • 6 Monate, Jan. 2014 - Juni 2014

    DBA / Developer / Performance Tuning Expert

    XEROX Legal Services

    DUTIES: • Analysis of bad performance of VRLBs, making tuning recommendations and implementing them • Writing T-SQL queries, stored procedures, triggers and .NET-based client application code Products & technologies used: SQL Server 2008 R2 Windows Server 2008 R2 VMware ESX VMWare vSphere Client

  • 3 Monate, Sep. 2013 - Nov. 2013

    DB & Web Developer

    Direct Client

    Re-implementing an existing in house application as a web application so that the clients could access it thus eliminating work related to manual data entry and imports/exports. • Gathering and analysis of requirements • Creating the functional specification document • Designing and implementing the application (Full-life-cycle) Products used: Access SQL Server Visual Studio VSTest NUnit log4net .NET 4.5.1 C# ASP.NET WCF AJAX Razor JSON

  • 5 Monate, Jan. 2013 - Mai 2013

    BI-Developer / .Net Developer

    ALSTOM Power AG

    • Developing a tool using SSIS and .Net to discover MS SQL instances within the company’s global network • Modeling of a DWH for storing data about servers hosting MS SQL components • Developing SSIS-Packages for loading into the DWH data about HW & SW assets from several source-systems • Modeling of a SSAS database for analysis & reporting • Creating various cube-based SSRS reports • Setting up a SharePoint site for reporting via Power Pivot, Power View

  • 2 Jahre und 8 Monate, Mai 2010 - Dez. 2012

    SQL Server DBA / Windows Server Admin

    ALSTOM Power Schweiz AG.

    DUTIES: Administering and supporting of SQL Server running on Windows failover clusters. Products and technologies used Windows Server 2003 R2 / Windows Server 2008 / Windows Server 2008 R2 SQL Server 2005 / SQL Server 2008 / SQL Server 2008 R2 Analysis Services 2005 / Analysis Services 2008 Reporting Services 2005 / Reporting Services 2008 Integration Services 2005 / Integration Services 2008 Sharepoint 2010 Cluster Admin System Center Operations Manager (SCOM 2007 R2) System Center Configurat

  • 1 Jahr und 1 Monat, Dez. 2010 - Dez. 2011

    BI Developer

    VONTOBEL Bank AG

    DUTIES: .) integrating data-feeds for bond indices as benchmark portfolios into the main portfolio management application (Allocare AMS) .) DB-Programming as well as designing of SSIS-packages and Windows Batch-Scripts to implement data-interfaces between various systems (Allocare AMS, Princeton DVS, Avaloq usw) Products and technologies used: SQL Server 2005 BIDS 2005 BIDS Helper Excel 2003 / Word 2003 XML Notepad 2007 SourceSafe

  • 3 Monate, März 2010 - Mai 2010

    .NET / SQL Server Developer

    ASSIST (SK) s.r.o.

    DUTIES: Developing a Windows client application for freelancers to help them decide the hourly-rates they should charge for their services considering various job- and location related factors as well as their personal preferences. Includes a multidimensional, multivariate analysis of the dependencies between the calculated rates and users’ subjective selection and weighting of various factors. Products and technologies used SQL Server 2008 R2 Analysis Services Reporting Services Windows 2008 Serve

  • 2 Monate, Jan. 2010 - Feb. 2010

    SQL Server Developer / DBA + Windows/IIS Admin

    Assist (SK) s.r.o.

    DUTIES: Migration of Windows 2003 Failover Clusters to Windows 2008 R2 Changing from Quick-Migration to Live-Migration (trough using a CSV) Cluster-Installation of SQL Server 2008 on Windows 2008 R2 Migration of SQL Server 2005 Databases to Version 2008 Migration of SSIS Packages to Version 2008 Code- and Index- Review for performance optimization of databases Products and technologies used: • Windows Server 2008 R2 • IIS 7.5 • SQL Server 2008 • SSIS

  • 6 Monate, Juli 2009 - Dez. 2009

    System Administrator

    Assist (SK) s.r.o.

    DUTIES: Virtualizing the entire IT infrastructure (servers, desktops, applications and storage) Setting up the virtualization hosts (using Hyper-V) Setting up failover clustering for Hyper-V servers Setting up Clustered Shared Volume using Starwind iSCSI Enterprise as iSCSI target UEFI-based installation of guest OS Setting up SQL Server (in clustered setting) and IIS, both as VMs Setting up Visual Studio 2008 Team Foundation Server

  • 5 Monate, Feb. 2009 - Juni 2009

    Database development / BI-Development

    T-COM

    DUTIES: Migrating and enchancing an existing MS Access-based sales forecasting application to SQL Server 2005. Creating a multidimensional analysis database Configuring Reporting Services, creating reports Installing & configuring the development, test and production web servers using IIS 6 Creating necessary models and documentation Products and technologies used: • Win2003/2008 • IIS 6.0 • Virtual Server 2007 • SQL Server • SSAS • SSRS • SSIS • BIDS • VB.NET / C# • ErWin • Visual Studio

  • 4 Monate, Sep. 2008 - Dez. 2008

    Migration Specialist & ETL/BI - Developer

    DWS Fund Luxembourg

    DUTIES: Comparing and synchronizing the schema of production and development databases Creating new SSIS packages for loading and transforming data from host systems Re-configuring the replication to cater for the changed database schema Products and technologies used: • SQL Server 2000 / 2005 • Visual Studio 2005 • DTS / SSIS • VB.NET • C# • SourceSafe • Excel 2003 • Quest TOAD for SQL Server, ApexSQL Diff, Redgate SQL Compare, DBGhost

  • 8 Monate, Dez. 2007 - Juli 2008

    Database / ETL Developer

    LandesBank von Hessen und Thüringen

    DUTIES: Enhancing an existing web application and its backend database designed for management and evaluation of endangered bank loans according to IFRS. Products and technologies used: • SQL Server 2000 / 2005 • Visual Studio 2005 • DTS / SSIS • Excel 2003

  • 2 Monate, Nov. 2006 - Dez. 2006

    Product Support Specialist for SQL Server

    Hewlett Packard in Dublin/IE

    DUTIES: Supporting Microsoft SQL Server customers in German speaking countries Products and technologies used: • SQL Server 2000 / 2005 • SQL Server Profiler • Windows 2000 / 2003 • Clarify • Terminal Services • Virtual Server • Easy Session • MPS-Reports & Viewer • RowSetViewer • ReplDiag • PSSDiag • ODBC-Trace • Windows Debugger • Debug Monitor • CloneDB • DTCPing • LeakDiag • LDGrapher

  • 1 Jahr, Jan. 2005 - Dez. 2005

    Reports & Reporting Architecture Developer

    Dresdner Bank Kleinwort Wasserstein Frankfurt/D

    DUTIES: Developing financials reports and the underlying architecture Products and technologies used: • SQL Server 2000 • Analysis Server • SQL Server 2000 Reporting Services • DTS-programming, • ASP.NET • C# • Visual Studio .NET 2003 • Visual SourceSafe 6

  • 2 Monate, Nov. 2004 - Dez. 2004

    Senior .NET Developer / SQL Server Developer/DBA

    Getronics Bruxelles/B

    DUTIES: SQL Server DBA / Developer tasks and some .NET Testing Products and technologies used: • Microsoft SQL Server 2000 DBA tasks • Programming of stored Procedures and triggers • DTS-programming, • SQL Best Practices Analyzer • ApexSQL • DBGhost • Visual Studio .NET 2003 • Visual SourceSafe 6

  • 7 Monate, Aug. 2001 - Feb. 2002

    Multidimensional Reporting with Ms Analysis Server

    Hewlett Packard in Grenoble/FR

    DUTIES: Developing a new multidimensional analytical solution for the finance department to better track and analyze all customer support related activities in Europe. Products and technologies used: • SQL Server 2000 and DTS • Analysis Services 2000 • Knosys ProClarity 4.0 • Excel 2000

Ausbildung von Erdöl Biramen

  • University of Economics in Vienna

Sprachen

  • Deutsch

    Fließend

  • Englisch

    Fließend

  • Türkisch

    Muttersprache

  • Russisch

    Gut

XING – Das Jobs-Netzwerk

  • Über eine Million Jobs

    Entdecke mit XING genau den Job, der wirklich zu Dir passt.

  • Persönliche Job-Angebote

    Lass Dich finden von Arbeitgebern und über 20.000 Recruiter·innen.

  • 22 Mio. Mitglieder

    Knüpf neue Kontakte und erhalte Impulse für ein besseres Job-Leben.

  • Kostenlos profitieren

    Schon als Basis-Mitglied kannst Du Deine Job-Suche deutlich optimieren.

21 Mio. XING Mitglieder, von A bis Z