Anonymes Profil aus München, System architect, IT Brater, Head of IT (CTO) auf www.freelancermap.ch

Database Architect

Fidor Solutions

Web: fidor.com
Database Architect (Freelancer, Fulltime )

My role
* The bank's database consultant
* Improving design, security and performace of all MySQL DB clusters in
the bank

My main Activities

* Database consutling - Daily Business
* Preparing bank for security database audits twice a year
* Taking actions to improve DB security of the whole bank DB system
* Communication with management about current situation and possible
improvements
* Extensive performance analysis and tuning (SQL, Backups, Monitoring,
Reporting)
* Speeding up SQL queries up to 100.000 times.
* Speeding up backups (20 minutes instead of 7 hours)
* Access management backlog /granting access to users
* Reducing backlogs
* Writing many scripts for automatisation purposses
* Docker Containerisation Project, Kubernetes, Docker swarm
* Deployment and release processes quidence
* Proposed new design of the DB clusters and replication workflows (1
Terabyte per database node)
* Analyse, design, coding (Bash, MySQL, SQL, XML Parsers, Profilers) and
administration of the whole Fidor Bank database landscape (Unix /
CentOS, Redhat, VM WARE, Corosync, MySQL Enterprise Monitoring, Jira,
Confluence, Github) - several hundred MySQL databases
* Designed Percona Cluster, Maria DB Galera clusters, MySQL Enterprise
DB, high available DB Clusters

* Proposed db monitoring changes (Nagios, bash & cron jobs)
* Tuning of the replication performance between remote datacenters
* Documentation

Other activities:

* Data recovery from VM Ware Snapshots
* Designed new data storage system
* Designed and written reporting system
* Daily performance analyse and tuning of slow queries
* DB analysing, data modeling, design
* Reporting and monitoring of the whole system in two datacenters
* Designed architecture of the whole banks's data clusters
* Written auto-repair replication processes
* Responsible for db migrations
* Written interfaces for data mining team
* Designed and coded monitoring interface for MySQL in Nagios
* Designed and also improved database infrastructure
* Designed and developed daily cronjobs
* Designed and developed process automatizations for several interfacess
and systems
* Designed and written reporting system for bank's clients
* Designed and developed new performant backup systems based on
MySQL Enterprise solution
* Daily support for the Fidor's departments
* Written documentation
* Communication, reporting and presentations to management

System architect

Hallhuber GmBH; GERRY WEBER International AG

GERRY WEBER International AG (Halle/Westfalen)
Web: www.hallhuber .de
System architect (Freelancer, Full time & Part time)

My role
* Senior software and system designer
* Senior IT-consultant

My main Activities

* Analyse, design, coding and administration of the whole Hallhuber's
finantial data workflow using Gliffy, SAP Import/Export API, DB2, MsSQL,
MySQL, PHP, Bash, caching, Unix/CentOS, Windows, Magento,
synchronisations, replications, backups, CSV, XML, HTML, CSS,
JavaScript, data modeling, UML, SOA, data virtualisation, XLS Parsing,
Bitrix, Monitorix, NetData, ..
* Full redesign of the whole Hallhuber's finantial data workflow for:
* ca. 230 Branches (daily sails)
* Credit cards statements (several banks, several countries)
* Visa cards statements (several banks, several countries)
* Bank statements of all Hallhuber's banks in all countries
* Online avise exports and imports (several payment providers, several
countries), like: Amazon, Amex, Paypal, Zalando, Concardis
* salaries of all employees (full time & part time & tests)
* 25 online shops in many EU countries - daily sales data analysys, data
mining

Other activities:

* Designed and coded big data storage system
* Performance analyse and tuning
* DB analysing, data modeling, design, reporting and monitoring of the
whole system
* Designed SAP in/out finantial data requests and the architecture

* sFTP structure design
* auto-fixing all daily sales data form all Hallhuber shops
* As a Project Manager, responsible for technical migration of the old
Finantial system to SAP-FI, incl. Database migrations
* Written interfaces to Hallhuber's banks, SAP-FI, DB2/Comarch, MySQL
databases
* Infoniqa CMS export analyse
* Designed and coded monitoring interface for all other financial interfaces
(Massenbuchungen)
* Designed and developed database infrastructure
* Designed and developed daily cronjobs
* Designed and developed process automatizations for several interfacess
and systems
* Designed and written reporting system
* Designed and developed backup system (Pandora Server)
* Designed and developed high available monitoring system (hot stand-by)
* Daily support for the Hallhuber's "Finance-Buchhaltung" department
* Written documentation
* Communication, reporting and presentations to management

IT Brater

Bayerischer Rundfunk

Web: www.br.de
IT Brater (Freelancer / Freiberufler)

My Main Activities
As a main database administrator, I am responsibile for the company's DB
migration from Oracle to MySql/Percona Cluster Galera.
I am also responsible for development and maintenance of internal blogs and
cms systems based on the Wordpress CMS (php, JavaScript, html, NodeJS,
MySql, Apache, Nginx, Varnish, Unix).
I am maintaining internal systems based on Virtualisation/VMware vSphere
Hypervisor/VMware ESXi, NFS.
I am working with NetApp - MetroCluster system, build high-availability virtual
cluster based on CentOS and Red Hat Enterprise 6 in connection with a cluster
layer Corosync and Pacemaker.
One of my main duties are optimisation of high availability systems and
processes and training of the company's stuff.

Key Duties
* main database administrator, senior level (MySQL, Percona, Galera
Cluster, MongoDB, PostgreSQL, Memcached)
* responsible for performance optimization of all databases
* designed and programmed database tools like DB Check, Nagios DB-
Monitoring, Icinga, Backup tools, designed replication solutions like
Master-Maste, Master-Slave, Galera Cluster
* Designing new DB backup and recovery system based on Ceph
Filesystem Storage, redesign of DB tools based on Xtrabackup inclusive
new database recovery system
* databases upgrades from MySQL 5.1 to Percona 5.5 and Percona 5.6
* Maintenance of large and heavy used databases like Sophora, MIR,
Blogs, Confluence, Melin Newsletter, Active MQ, Weather & Traffic DB
* Support for High-Availability systems based on Corosync and Pacemaker
* WordPress senior administrator for more then 180 single and multisite
blogs, developer of blog plugins and themes, microsites designer (PHP7,
PHP5/OOP, MVC, ORM, MySQL, CSS, HTML 4/5, JS & Ajax, Jquery, bash
scripting, foundry loadballancing, apache rewrite rules, HTML/XHTML,
XML, RSS, SEO, SOAP Web Services
* designed RESTFUL JSON-based application server for database
maintenance (DB Check)
* MIR Audio-Video Database performance optimisation, programmed MIR
Check tool, designed and programmed Akamai Check & Purge tool,
optimized Active MQ database locking processes (JSON, XML, PHP, unix
shell scripts, HTML, AJAX, Jquery, NodeJS, ReactJS)

* Newsletter system upgrade to version 4, written stored procedures and
views
* planned, designed, developed, documented and maintened scripts like:
Bing & Google Map plugins for WordPress, absolute URL plugin for
WordPress, ffmpeg Video Snapshot Tool plugin for WordPress, Newsletter
Server Check tool, full backup monitoring tool, CMS Sophora delivery
check and delivery monitoring tool for 15 Servers and AKAMAI, script for
Webserver load test, mysql slow query log evaluation tool, LDAP
authentification system for couple of internal tools, Oracle to MySQL
migration tool inclusive latin1 to UTF8 encoding fixes, Portal-Webaccess
system
* designed and developed scripts for WordPress Blogs migrations from
single to multisite
* management and maintenace of virtual servers based on RedHat and
ESXI MetroCluster
* reporting to management, KANBAN, delivering detailed statistics for
statuses of: Databases, Melin Newsletter, MIR, AMQ, Sophora, WordPress
Blogs

Knowledges, Skills, Dispositions
* Scrum, Kanban, Project Management, Jira, Confluence, Agile Process
Management
* MySQL (MariaDB, Percona, Galera Cluster), PostgreSQL, CouchDB, Redis,
* Apache, JBOSS, NGINX
* WordPress, Magento
* Cloud computing (Amazon EC2)
* Nagios monitoring system, Monitorix (system administrator)
* PHP7 (OOP), MVC, ORM, FuelPHP Framework, Zend Framework
* Mysql (Percona), SQL (load ballancing, replication, ...), Stored
Procedures
* NoSQL DB: Mongodb, Memcached, Redis
* Fulltext search engine: Sphinx
* RHEL, CentOS, Ubuntu, Debian
* Shell scripting
* Server Administration
* Apache Web Server, Nginx
* HTML/XHTML, XML, RSS, XLS, Java Scripts ( JQuery & Ajax ), CSS3
* NodeJS, ReactJS
* Jenkins
* Java
* RESTFUL application server, SOAP, JSON, JSONP
* SEO
* LDAP
* Performance-Optimization
* Subversion, SVN, CVS, GIT
* Web design
* Networking
* IT consultings
* VMWare/vSphere, ESXi, VirtualBox
* RHEL, CentOS
* NetApp, Brocade ADX Loadbalancer
* Varnish, ELK, Docker, Cloud(AWS), CDN (Akamei)
* Sophora
* UML Diagrams

Head of IT (CTO)

Deal United GmbH

Web: www.dealunited.de
Head of IT (CTO)

My Main Activities
Responsible for the reorganization and management of IT department and

responsible for all IT processes in the company
Main Senior Lead Developer
Complete restructure and redesign of the company's IT department and it's
relationship to all other departments (operational risk management, budgeting,
cost evaluation, outsourcing, planning, development, ...)
Agile (Scrum) Development
Specialist on Amazon EC2 Cloud Computing. I have moved 18 company's servers
incl. the infrastructure redesign to Amazon Elastic Cloud.

* Wrote Payment Gateway API to Payon - The Payment Service Provider
* Written interface to gaming portal (bigpoint.com)
* Written api to REST web services
* re-written Administration Portal
* designed and written new Voucher Payment System
* written fully automated company's invoicing system

Leading Senior Software Developer

zonzoo GmbH

Web: www.zonzoo.de
Leading Senior Software Developer

My Main Activities
Team leader.
Responsible for opening new branch in Dubai.

Designed and developed in PHP5 OOP with MVC complete modularized
warehouse and logistic Content Management System (CMS), Backend and
Frontend. That was done all from scratch and for the whole company in cca. 10
countries worldwide (Asia, Europe) with around 20 000 point of sales.
The modules are part of the CMS system that was completely designed and
developed by myself. Designed for heavy loads.
I have designed and developed also an interface to CMS for scanning BARCODEs
and management of all stock items.
Responsible for the launch of the all IT Systems in the new branch in Dubai.
Complete Debian server setup and management, inclusive all unix tunings.
Planning and communication with other departments and customers.

Knowledges, Skills, Dispositions:
* PHP5 (OOP), MVC, ORM, Zend Framework
* MySql, SQL, MySQL-Replikation, Stored Procedures
* Mongodb, Redis, Oracle, PostgreSQL
* Linux (Ubuntu), Unix (Debian), Shell scripting
* HTML/XHTML, XML, RSS, XLS, JS, CSS
* CMS: Drupal, Magento, Joomla

* Redmine, SVN, GIT
* Performance-Optimization
* Unix & Linux OS, Windows, Apache Web Server,
* Unit-Tests, Smarty, Memcached, Subversion, SVN, CVS
* MS Exchange
* Photoshop, GIMP,
* Scrum, SEO, Project Management
* Virtual systems: VMWare, VirtualBox
* Networking, ...

Senior Software Engineer

CHIP Xonio Online GmbH

Web: www.chip.de
Senior Software Engineer

My Main Activities:
Responsible for redesign and improvement of the previouse version of the
Chip.de price-comparison portal (frontend and backend).
As a result of our team job, our team has achieved more then 300% total
increase (klicks, turnover, profit) within the last 3 years.

Knowledges, Skills, Dispositions: Zend Framework, PHP5 (OOP), MVC,
Oracle, MySql, MySQL-Replikation, Stored Procedures, PostgreSQL, Debian
(Unix), Shell scripting, HTML/XHTML, XML, RSS, XLS, Performance-Optimization,
JS (JQUERY, ExtJS), CSS, Unix & Linux OS, Apache Web Server, Unit-Tests,
Smarty, Memcached, Subversion, SVN, CVS, Photoshop, GIMP, Scrum, SEO,
Project Management, Windows, Networking, InterRed-CMS, ...

Software Engineer

Ciao AG

Web: www.ciao.de
Software Engineer

My Main Activities:
One of the main software engineers, directly responsible for the biggest new
custommer data integrations for the whole Europe.
Written object history module for Ciao's proprietary application server.
Improvement of Ciao backend content management system.
Responsible for opening new branch in The Netherlands.
IBM API Data Management, API-Gateway, certification

Software Developer

Inventum GmbH

Web: www.inventum.de
Software Developer

Developer of the new generation search engine, based on categorizing features.

My Main Activities:
Written engine for crawling web space (Web Crawler) and downloading extracted
links/urls and filterd text of selected sites.
Working as a team member in a complex project from the start-up of the
company.
Written complete administration portal for accessing data and also for on-time
management of running processes.
Written user access management security module for enabling/disabling access
to web environment.
Responsible for writing various types of reports to Inventum's management.
Full usage of object-oriented approach.
Written modules for automated processing of huge numbers of documents and
for management of several Apache web servers.

Sales Manager

SWH - Siemens Business Services, s.r.o.

Main finantial sector Sales Manager of the company in Slovakia.

Responsible for delivering companies solutions to finantial sector in Slovakia.
Responsible for selling Call Centers, Management Information Systems and web
based SW projects to banks and insurance companies. Dealing with company's
top managers and executives.

My Main Activities:
Developed strategic client relationships and actively managed existing key
accounts to defend existing business and generated new opportunities for
profitable sales.
Became the first point of contact for cross-industry sales in Slovakia.
Identification of potential partnerships and clients.
Collaboration with internal teams to define the product road map, market
positioning and developer program initiatives.
Hunting for potential customers in the Slovak finantial territory.

Project Manager

Olivetti Slovakia s.r.o., Wang Global Slovakia, Getronics

Responsible for building ATM zones, special projects for scanning and reading
checks and banknotes in ATM machines (international project).
General Job Description:
Leader of an international team of about 30 people developing first automated
ATM banking zone in Slovakia for checking and exchanging banknotes.
Responsibile for the whole management of the project.
Leader of the first "Multimedia Terminal Project" in Slovakia for a bank customer.
Written module for light management of multimedia terminals via internet.
Leader of the first project in the Central Europe for sending SMS messages via
public multimedia terminals.
Received an acknowledgement from Wang Global headquarters (Boston, USA)
for an accelent project management and success in building automated
transactional zones and multimedia systems in Slovakia.

System architect, IT Brater, Head of IT (CTO)

Profilanlagen

Skills

Erfahrung

Sprachen

Projekthistorie