Projects with requirements with technical focus on Unix/Linux automation & integration or Oracle Development. Scripting, root cause investigations.
Aktualisiert am 21.07.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 01.08.2024
Verfügbar zu: 100%
davon vor Ort: 5%
Oracleentwicklung
Linux-Scripting
Performance-Management
Automation/Steuerung
Integration
Software Deployment
Root Cause Analysis
SQL
Datenbankmodellierung
Systemintegration
Monitoringsysteme
German
Mother Tongue
English
Fluent

Einsatzorte

Einsatzorte

Dubai (+500km) EU (+500km)
Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

9 years 1 month
2015-09 - now

Internal Projects

Owner / Founder, IT Consultant
Owner / Founder, IT Consultant
  • Introductory engagements in projects of external clients in EU / Middle-East:
    • Proposal of new system & process architecture based on new requirements
    • Proof of concept by prototype development
    • Proposal for HDD space scaling for Linux Production hosts
    • Gap, impact & process analysis with workflow, optimization and automation
  • Financial Management:
    • A solution based on a combination of JavaScript, JSON, KDB+/q, Python, Node.js and Perl to manage bookings of private, business and investment accounts with categorized transactions
  • Business Expense Reporting:
    • Aggregation of business expenses and reporting in Perl
  • Automated Entity Transformation:
    • Automated performance benchmark testing of different data structures, code designs and methodologies with reporting, in Perl
  • ElasticSearch:
    • Setup of ES Cluster and high performance testing, in Perl, Python, shell scripting
  • Infrastructure:
    • Router, DHCP setup & configuration, DNS server configuration
    • ftp server setup & configuration
    • Virtual Machine env setup
  • Oracle:
    • Oracle Database installation, config, design, Setup, Dev & performance tuning
    • ETL process design & pipeline development for data accumulation in datalake
    • Dashboard & Business Report creation with APEX, AppBuilder & SQL Workshop
  • AWS:
    • Configuration Management (AWS account, root & IAM user configuration)
    • Python development on AWS Cloud9 IDE, Regression Test automation in Python
  • Automated Server Setup & Deployment:
    • Ansible Configuration & Inventory & Playbook Management
    • Setup of new servers and processes, upgrades incl. process validation
    • Standardization of server setup, root cause investigations
  • Linux hardening:
    • Linux hardening as part of Sys setup to requirements for Linux security
    • ?Root and other user security policies, system connectivity security incl BIOS hardening and more.
on Request
3 months
2023-10 - 2023-12

Oracle Database Migration for multi-regional PLM System

Database Migration Lead Engineer [contract]
Database Migration Lead Engineer [contract]
  • Solution Design & implementation of data export/import & transformation processes incl. system integration & validation
  • Proof of concept with new re-structured migration concept, minimizing and eliminating key critical risks and time-consuming processes
  • Architectural Design documentation for Management, stakeholders and Business Users
  • Database structure and data analysis incl database size estimation for subsets of whole source databases and estimate for the target database with transformed data
  • Data cleansing & correction according to discussed and agreed rules
  • Test and validation processes
  • Process automation
  • Linux automation to standardise and automation migration processes
  • Oracle ETL & data transformation processes
  • Convert business requirements into technical transformation strategy incl validation and verification processes & documentation

ZFL / AHTech / Airbus ? EU/Germany
1 year 2 months
2022-09 - 2023-10

Oracle Database Migration for multi-regional PLM System

Database Migration Lead Engineer [contract]
Database Migration Lead Engineer [contract]
  • Solution Design & implementation of data export/import & transformation processes incl. system integration & validation
  • Proof of concept with new re-structured migration concept, minimizing and eliminating key critical risks and time-consuming processes
  • Architectural Design documentation for Management, stakeholders and Business Users
  • Database structure and data analysis incl database size estimation for subsets of whole source databases and estimate for the target database with transformed data
  • Data cleansing & correction according to discussed and agreed rules
  • Test and validation processes
  • Process automation
  • Linux automation to standardise and automation migration processes
  • Oracle ETL & data transformation processes
  • Convert business requirements into technical transformation strategy incl validation and verification processes & documentation

ZFL / AHTech / Airbus ? EU/Germany
4 months
2021-10 - 2022-01

Some short automation

  • Exchange Trading Singapore, Financial Sector (introductory: test, monitoring & process automation)
  • Some short automation, ETL & system engineering introduction in for financial sector companies in Cyprus & Switzerland

Exchange Trading Singapore, Financial Sector
4 months
2021-07 - 2021-10

System & Database Integration

Linux Engineer
Linux Engineer
Financial Sector client, Austria
4 months
2021-05 - 2021-08

introductory engagement prototype development

Confidential client, Middle-East, Financial Sector
1 year 2 months
2020-02 - 2021-03

Infrastructure Support, Automation/Integration

Quantitative Application Support and DevOps Linux: shell Perl Python ...
Quantitative Application Support and DevOps
Automation & Integration of monitoring and trade feed processes:
  • Proof of Concept, development & implementation of automated system processes
    • Monitoring: linking crontab based systems to Geneos efficiently: providing more visibility of until then unrecognized issues
    • re-build multi-phased feeds to external vendors and develop a singlephased more efficient solution
    • Automation of validation & monitoring processes, sanity checks, release processes
    • Development of new Report Management System for distributed multicluster environment, Stats reporting, Sanity checks
  • Process, Fix & Enhancement solution development, Python & C++
  • Infrastructure Support, Process & Workflow optimization & automation
  • Kerberos authentication (setup, troubleshooting & root cause analysis & fixes)
  • SAN/NAS storage configuration, attachment troubleshooting & verification
  • FIX client onboarding automation, FIX latency troubleshooting, FIX adaptor setup & FIX issue root cause investigations in Production
  • Architectural Design:
    • Requirements vs system gap analysis
    • Conversion of high-level business requirements into technical specification with technical proof
    • Overall IT System analysis and advisory on process optimizations
    • Advise on architectural improvements and alterations to minimize data loss and system outages
    • Business presentations for new solutions incl impact analysis
    • Investigation of current production issues, root cause analysis and redesign of current architecture
  • Process, Monitoring & Test automation, TeamCity regression test automation, Root cause investigation of found bugs (direct or side-effects of other bugs)
  • Deployment automation to multi-cluster with over 300 nodes and evaluation, Ansible playbook & inventory management, troubleshooting, standardization
  • Oracle:
    • PL/SQL Development, new feed implementations & Query/index/Optimizer tuning
    • OEM in distributed environment (Performance & Hardware usage monitoring):
      • Performance Monitoring & resolution of perf issues / tuning down to hardware level, real-time query monitoring and more
      • CPU, memory, storage monitoring management
    • Development of frontend app, reports & dashboards with Oracle APEX Available for new opportunities for remote work or/and on-site worldwide
    • Database Design, architectural review & advise, presentation of proposed solutions to management and stakeholders
    • Evaluating process functionality against new requirements and draw new designs
    • Migration process design & implementation
    • ETL process dev & integration incl. testing and deployment; amendments/fixes of existing feeds
    • Big Data analysis & statistics creation to forecast long term trends in business data usage and database usage
    • Visualization of new proposed process flows for business user/stakeholder presentations
  • Production Support for Bond trading system, root cause investigations, solutions for identified workflow & security issues e.g. with multi-threaded processes in C++ components, mainly also Python
  • Advise on Architectural Design, tools, algorithms and methods for a scalable, most reliable distributed systems running on best performance
  • Security risk & impact assessment; propose solution and system-wide impact analysis before and after solution integration
  • TeamCity test validations (QA), root cause investigations, process management
  • Firewall/Proxy configuration changes
  • New host setup & business app installation, validations
  • CI/CD pipeline development, test & deployment automation
Linux: shell Perl Python C++ Java SQL Oracle SQL Server Maria database git Linux system management Grafana TeamCity Prometheus Ansible Sys Config Management Cameron FIX Engine BitBucket JIRA Confluence ServiceNow CI/CD Agile Oracle SQL*Loader & internal loader tools APEX Appbuilder & SQL Workshop
Deutsche Bank ? London
7 months
2019-09 - 2020-03

Deployment Automation & Integration of Regulatory Validation Application

Unix Engineer, Deployment Automation/Integration [contract] Linux/Sun Solaris Process automation shell ...
Unix Engineer, Deployment Automation/Integration [contract]
  • System Gap Analysis, identification of safety issues and proposals to fix them
  • Proof of Concept & implementation of new automated deployment processes incl. manual tasks restricted by external vendor and internal UBS constraints
  • Automation of deployment process incl setup & development of a solution interfacing third party deployment components, security policies and administrative account permissions with Nexus, Puppet, Artifactory etc., Test automation within CI/CD pipeline
  • Deployment Automation of Fenergo (external vendor product) incl. Tomcat & ElasticSearch (incl SearchGuard plugin) setup on single- and multi-clustered nodes (incl. load-balanced/failover hosts) in different environments incl documentation & evaluation
    • Configuration of required Tomcat Apache & ElasticSearch & SearchGuard plugin with host specific configs and certificates
    • Configuration & performance tuning to host specific requirements
  • System architecture proposals to run deployment of external vendor?s software more efficiently and specify requirements for external vendor?s deployment packages
  • Architecture adjustments to avoid deployment failures of current deployment processes and advice design changes with best practice process management to reduce certain risks
  • Automation and standardization of Tomcat & ElasticSearch CA certification constrained by UBS internal tools & policies
  • Oracle: ETL process root cause investigation, performance tuning, PL/SQL, SQL, query analysis & upload process root cause investigation & fine tuning
  • Gap Analysis based on new requirements
  • Partial re-design of database model plus new database tables and other objects incl stored procedure
  • Security Risk Analysis & Risk Assessment; proposal, development & integration of new solutions incl impact evaluations
Linux/Sun Solaris Process automation shell Perl Puppet Windows SQL IIS & MySQL DB environment setup Nexus Artifactory Maven etc. Documentation: Confluence Wiki Agile
UBS ? London
9 months
2018-05 - 2019-01

Automation & Integration of aggregated business information for AI

Software Engineer, Automation/Integration Engineer, Data Architect [contract] Process automation Perl Python ...
Software Engineer, Automation/Integration Engineer, Data Architect [contract]
Automation & Integration of aggregated business information for AI:
  • System & Data Analysis based on Linux/Oracle backend & Web Frontend
  • Proof of concepts, development of new AI data referencing solutions
  • Automation of multi-facetted data consolidation processes, scripting etc. incl upstream ElasticSearch
  • Oracle Enterprise Manager (OEM):
    • Performance monitoring & tuning query to hardware level
    • Alert setup, configuration & management for outages, security breaches and more
  • Dashboard development & backend process integration for Business (Tableau, ElasticSearch, APEX AppBuilder & SQL Workshop)
  • Advisory and execution on
  • Test automation, development strategy adjustments involving now data integrity and completeness
  • Data architecture, development strategy & architectural design incl incoming and outgoing data feeds
  • Database schema design, setup and implementation of new structure incl code
  • Process code analysis, identification of short comings, bugs resulting in impact analysis, code fixes and proof of concept incl process to fill gap of missed data incl all dependencies
  • Scalability, archiving, high availability
  • General architecture & design issues
  • Presentation of new strategies, concepts and process flows to senior business users & stakeholders
  • Chair of meetings with Business users & stakeholders with presentations, presenting new strategies and what their business could get from a new solution even beyond the requirements, demonstrating also the safety of a solution
Process automation Perl Python ElasticSearch SQL PL/SQL Development performance tuning (SQL statement index data analysis & aggregation database design & normalization; database migration optimization SQL statement optimizer tuning
BAE Systems ? Applied Intelligence ? Qatar
10 months
2017-06 - 2018-03

Automation of multi-phased migration processes of global datacentre

Data Centre Migration Specialist, Production Support [contract]
Data Centre Migration Specialist, Production Support [contract]
Automation of multi-phased migration processes of global datacentre:
  • System Analysis, gap analysis
  • Automation of migration & validation processes (Perl)
  • Configuration Management (incl YAML, JSON, XML, sdc)
  • Development of analysis, validation and control processes, Agile, GIT
  • System architecture & design; Code & Config Standardization
  • Gap Analysis and system design advice incl. documentations
  • Collaborate with internal Dev, network, infra & QA teams for system setups etc.
  • Oracle: new database host integration, PL/SQL migration code dev, data analysis & transformation, performance tuning: query-, index-, optimizertuning, ExplainPlan etc. (manually & OEM perf monitoring/tuning)
  • Linux: high performance tuning (process CPU & memory management, Linux shielding, capacity management etc.), shell, Perl, Python scripting; Kernel & TCP network tuning, window scaling, bandwidth usage optimization etc.; Linux shielding setup and configuration, benchmark & aggregated testing
  • KDB+/q: root cause investigation, troubleshooting of integrated solution
  • API & FIX Connectivity & Latency troubleshooting; FX feed optimizations, Perl, shell


Support of FX Prod Env, high availability:

  • root cause investigation, process and memory interrogation
  • Change & Release Management, Automation, Performance Tuning
  • new features & bug fixes, strategy and architectural design
  • root cause analysis, troubleshoot, debug Java based backend components, latency troubleshooting, GC issues etc.
  • dealing directly with internal and external users, traders, brokers, front office
JP Morgan Chase - London / Great Britain
1 year 4 months
2016-02 - 2017-05

High Performance

Production Engineer, shell/Perl Development, System Integration [contract]
Production Engineer, shell/Perl Development, System Integration [contract]
High Performance, High Security Solution: Design, Development, Implementation & testing of high-performance file & content validation solution for Reporting:
  • Setup, development, test and integration of high-performance Perl (and shell) scripts to validate authenticity of generated reports by internal teams for LCH members/clients and assure data integrity
  • Security assessment, analysis and validation; architectural design from scratch
  • Shell (Korn shell, bash)/Perl development on Linux: multi-threaded, procedural & OO; (plus temporary smaller Windows solution) incl. file, SQL, JSON, YAML, XML
  • Test Automation: Unit, Integration, Regression testing and automated functional testing


Database Management:

  • Oracle Setup & Implementation of new business logic, PL/SQL Dev & index-, query-, Optimizer-tuning, Explain Plan, ETL process management incl testing and deployment; FE App dev by Oracle APEX App Builder & SQLWorkshop
  • Development of data aggregation and validation processes
  • Gap Analysis & architectural design improvements, proof of concept 


Production Support:

  • Change and Release Management
  • Setup of environments, prod and pre-prod, and run testing in pre-prod envs
  • Coordinate testing with QA teams in pre-prod envs
  • Dealing also directly with internal/external clients, users


System Integration:

  • Automation of Deployment process from dev into higher envs up to production env.
  • Integration of new components into system architecture, also Java based apps
  • Scalable deployment methods & procedures delivering long term time savings with reliable deployment procedures after Agile methodology
  • Automation of test processes, configuration management & verifications
  • dashboard development for system performance & processing validation and business reports (automation & Tableau, Oracle APEX)

LCH Clearnet Ltd. - London / Great Britain
2 years 11 months
2012-06 - 2015-04

1, 2 & 3rd line Production Support:

Data Analyst, Senior Production Support Analyst (AVP) [permanent] Unix (HP-UX Sun Solaris AIX)/Linux (RedHat) shell (sh ...
Data Analyst, Senior Production Support Analyst (AVP) [permanent]
BAU/Adhoc Production Support for Equities & Fixed Income
  • ensuring system stability and high availability with clients & front-end users
  • Data Analysis, research for data inconsistencies, business report generation
  • Automation of manual processes, environment setup processes, reconciliation and business processes as well as backend calculations etc.
  • Oracle Development: PL/SQL for database migration, data transfer and fixes and enhancements with new business logic implementation
  • Scheduling across network as well as on dedicated servers (crontab, Control-M, inhouse build scheduler with dependency logic, Windows scheduler etc.)
  • Batch processing: implementation, maintenance & development/design, restructuring, simplifications, analysis
  • analysis, root cause investigation, fixes
  • implementation/integration SQL & PL/SQL in Oracle Data Warehouse backend
  • reworking C++ code into Perl with new features on top of existing functionality
  • bringing fixes and enhancements from Dev forward to Production via QA
  • data, query and code analysis
  • environment setup & automation


Project work:

  • Oracle Data Warehouse development: PL/SQL development, mass data upload and transfer by SQL*Loader, stored proc dev, database migrations, performance tuning (explain plan, auto trace but also via OEM); Implementation & Support of concepts, logical and physical DB models
  • successful decommissioning of major components of an old trading/reporting system and switching over to new one based on Oracle data warehouse
  • Setup and fully automation of pre-prod envs with daily rolling environments on Unix (Solaris) and Linux (Redhat) fully scheduled setups and feed and calculation/batch processing incl reconciliations
  • OS (SUN Solaris to Linux RedHat) and database migrations using scripting (SQL, PL/SQL, shell, Perl etc.)
  • FX trading: FIX, API & TCP/IP network latency root cause investigations, FIX connectivity issues on low latency platform On all: reconciliations to ensure proof of no data/logic breaks etc.


By:

  • cooperate with Clients, Network, internal development teams, in/external Business users globally
  • Sybase/Oracle Database management, feed management/development/automation
  • Oracle database design, development SQL, PL/SQL & stored procs, packages etc, Performance Tuning, SQL*Loader, *LOB cols, Report creation by APEX AppBuilder
  • Incident management covering Dev, test and prod envs Documentation, specification and description/documentation for Releases
  • Utilization & performance monitoring & improve processes & procedures
  • release & environment management/automation
  • mentor & train more junior team members (up to 3 locally and 6 abroad (Singapore, India, New York))
  • lead small teams through new projects, distributed team: 4 in APAC, 2 in NY, 2 in Europe, chair team meetings and inter-relational team meetings (2NY, 3 Singapore and India)
  • mentor and coach university apprentice (1) locally
Unix (HP-UX Sun Solaris AIX)/Linux (RedHat) shell (sh ksh) Perl scripting Unix/Linux System tools & management Windows Sybase/Oracle SQL PL/SQL SQL Server Control-M Nagios self-developed monitoring tools FIX connectivity latencies Cameron FIX Engine Remedy Jira internal tools ITIL Agile; Versioning: svn SubVersion
Credit Suisse - London / Great Britain
11 months
2010-11 - 2011-09

1st & 2nd line Trading Floor Support

Senior eFX/FX/FIX Support Analyst [contract, 11 months] Unix/Linux shell (bash sh ...
Senior eFX/FX/FIX Support Analyst [contract, 11 months]
  • BAU/Adhoc Trading Floor Production Support for up to 300+ traders worldwide, Front Office
  • Client Onboarding: client/user/account setup and configuration in RET AD (Reuters) for trading portals as Quantus, 360T, Currenex, Bloomberg, FXall, RTFX, RET Admin, RET Trader/Client applet
  • Trading backend configuration: FX Market Data, MM, trading connections, limits, margin groups and configurations
  • Change Control / Release & environment management: planning to implementation & documentation of new releases Team Management
  • Leading small local team through mass onboarding project (Java based)
  • Set tasks and prioritize
  • Gather regular status reports
  • Chair team meetings to discuss open issues and alternative solutions
  • Monitor progress of tasks assigned to team members and discuss new estimates
  • Mentoring more junior team members
  • Assist and support in technical matters where technical skills are not efficient or advanced as expected. All team members should be able to support trading platforms on all levels reliably due to shift works; so no risk periods.


Project Work:

  • Plan concept and realisation of mass onboarding process
  • Provide capacity forecasts for next 1, 3, 6, 12 months and 3 years
  • Propose architectural changes to ensure scalability of entire trading system based; storage changes, process and storage separation concepts etc.
  • Analysis of performance issues of trading system and rectification by architectural changes
  • FIX connectivity and latency issue troubleshooting on low latency trading for third projects
  • Latency investigations based on TCP/IP sniffer results/network captures
  • Architecture tuning


By:

  • cooperate with Traders, Sales, Test, Network, internal development teams, internal/external Business users and 3rd party vendors
  • plan and implement new trading strategies, data handling, onboarding procedures,upload, synchronization and migration tools
  • Coordinate implementations with infrastructure, NOC and network teams
  • SUN Solaris to Linux RedHat migration of trading system, covering shell, Perl scripts,SQL and PL/SQL codes, setup and implementations on new systems incl scheduling etc.
  • lead team members through mass onboarding project (6 support, integration and development)
  • train more junior team members up to scratch (4 locally, 1 abroad (Munich))
Unix/Linux shell (bash sh ksh) Perl SQL scripting Windows Control-M Nagios Reuters RET SQLServer Apache configuration & certificate management JavaScript Remedy HP QC & SM Jira AMD Reuters GIT
UnicreditGroup ? London / Great Britain
6 months
2010-02 - 2010-07

Front Office Trading Floor Support for FX Sales/Liquidity team

Senior FX FIX Support Analyst [contract, 6 months] Unix (AIX Solaris) / Linux (RedHat SuSE) shell (bash ...
Senior FX FIX Support Analyst [contract, 6 months]
FIX Support Production environment, setup, configuration & monitoring


Project Work:

  • Deal/cooperate with up to 8 external clients as sole point of contact


Main issues:

  • Onboarding new clients
  • Latency issue investigation and resolution
  • Client connectivity testing/issues
  • Setup and configure FIX Market Data & Trading connections
  • Exchange connectivity: upgrades, integration work, implementations
  • FX Low Latency Trading Platform: trading connections, market data & pricing/rates feeds; performance & latency root cause investigations and fixes
  • FIX protocol: Onboarding of new clients from pre-production environments until go live in production
  • providing initial information to clients
  • setup, FIX connectivity tests
  • conformance certification testing & test plans
  • upgrades, migrations


By:

  • troubleshoot issues on FIX, API, network, TCP/IP (sniffer analysis, l/r roundtrip times, retransmission of TCP packages), router and firewall levels in Production and pre- roduction environments
  • Release & environment management
  • Development of internal applications (latency reports)/scripts (shell, nawk, Perl (incl debugger)), perf tuning on Linux/Solaris. JavaScript
  • Development of FIX connector enhancements; onboarding & test automation, FIC client simulator for stress test and to reproduce performance issues
  • Control Management: Bugzilla, Perforce issue tracking/management system to support traders & internal teams and keep agreed SLA?s
  • Leading small projects for integration work with 1.5 people locally, 1 off-shore in New York. In cooperation with client?s technical teams.
Unix (AIX Solaris) / Linux (RedHat SuSE) shell (bash sh ksh) Perl scripting XML; Unix tools and management processes
Velocity Systems International Ltd., BGCPartners Inc. - London / Great Britain
4 years 11 months
2004-08 - 2009-06

1st Line Technical Support of Trading Floor Applications

Senior Equities/FX & FIX Support Analyst [contract & perm] Unix (AIX HP-UX SunSolaris ...
Senior Equities/FX & FIX Support Analyst [contract & perm]
  • 1st Line Technical Support of Trading Floor Applications, eTrading platforms, FIX based low latency trading platforms incl external client support
Unix (AIX HP-UX SunSolaris Debian) Linux (RedHat SuSE) various Windows servers
NYSE Euronext Ltd., Allegro Development Ltd., FX Alliance Ltd., EMC2/Documentum Europe Ltd. - London / Great Britain
5 years 9 months
1998-11 - 2004-07

Performance Tuning in all aspects

Core Java/Oracle Developer, DBA for Financial Exchange/Services [permanent]
Core Java/Oracle Developer, DBA for Financial Exchange/Services [permanent]
  • Core Java/Oracle Development
  • Oracle DBA
  • Performance Tuning in all aspects
  • Forms & Reports
MeTechnology AG, Brokat Infosystems AG, bbv AG, c.a.r.u.s. AG, Apoll AG, Fernbach Software S.A., ClarITeam S.A. ? Germany / Great Britain

Aus- und Weiterbildung

Aus- und Weiterbildung

4 years 11 months
1990-09 - 1995-07

University Studies

Graduated with an equivalent to the British Master?s degree, Martin-Luther-University Halle-Wittenberg - Halle / Germany
Graduated with an equivalent to the British Master?s degree
Martin-Luther-University Halle-Wittenberg - Halle / Germany
  • Mathematics, Physics
  • Subsidiary subjects: Information Technology, Astronomy

Kompetenzen

Kompetenzen

Top-Skills

Oracleentwicklung Linux-Scripting Performance-Management Automation/Steuerung Integration Software Deployment Root Cause Analysis SQL Datenbankmodellierung Systemintegration Monitoringsysteme

Produkte / Standards / Erfahrungen / Methoden

Oracle Database Design, Modelling, Development and Performance Tuning & Administration
Since 1998 ? 2004 as Core Oracle Database Development
Since 2004 in Production / Application Support, Oracle Development


Oracle Database Design & Modelling

  • Development of Logical Entity Relationship Models and Physical Database Models, Normalisation of Database models based on Business requirements incl maintenance of historical records, performance and process optimisations, multi-language capabilities, mechanisms for archiving and more
  • Database metadata normalisation to eliminate redundant data, enable efficient querying, simplification of updates later on etc.
  • Database Model Management either manually in scripts but better also with e.g. Oracle SQL Developer Data Modeller (or similar tools also for Sybase, MS SQL Server, MySQL like Visio etc.) to keep the database model inline with generated scripts to create all database objects 


Oracle Database Development (SQL, PL/SQL) & Administration

  • Development of scripts to setup the entire database systematically and in a modular way inclusive Tablespaces, Users, Roles with appropriate permissions and all required database objects (e.g. tables, views, constraints, (primary-, foreign keys, check-, unique constraints etc.) indexes, sequences, materialized views, partitioned tables and indexes, database links and more
  • Storage-, Session- & Tablespace Management
  • Development of Stored Procedures, functions, triggers based on Business requirements
  • Implementation and integration of ETL processes to
    • Upload mass data of streamed data and files to database level
    • Process & transform data based on non-IT-specific guidelines
    • Provide data for the presentation level (DWH) to provide ready data for a frontend
  • Data Migrations: data analysis & cleansing, Oracle analytical functions
  • Data mapping if source and target database structure are different
  • Source/target data validation after migration
  • Development of Data extraction, loading and transformation processes (ETL, ELT), complete automation
  • ETL process tools: SQL*Loader, Informatica, SQL scripting, advanced Oracle features, SQL combined with


Unix/Linux shell and Perl scripting

  • New developments for frontend applications in Oracle Forms & Reports, Oracle APEX AppBuilder & SQL Workshop (Apps, reports, dashboards), backend Stored Procedures, packages, functions, triggers etc. incl system integration, scheduling
  • Development of new links based on data of different data sources (AI)
  • Frontend App creation and configuration with Oracle AppBuilder and SQL Workshop (part of APEX)
  • Implementation and integration of business logic in PL/SQL, migration (PL/SQL, Unix/Linux), Performance Tuning (query-, index-, optimizer, I/O, process and workflow tuning, ExplainPlan, tkprof) but also Oracle Enterprise Manager (OEM):
    • Realtime query monitoring, Performance monitoring & tuning, Dashboard configuration
    • CPU, memory, storage monitoring in distributed environments
    • Alert setup, configuration & management for outages, security breaches and more
  • Datamart integration and process automation
  • Data Analysis: source code, query and data analysis; generation of business reports
  • Root Cause Analysis incl performance bottlenecks and provide appropriate solution


Technical Summary

  • Hybrid Support/Data Analyst / Oracle Developer (Unix/Linux scripting, SQL & PL/SQL), Automation, Integration, Perf Tuning
  • eFX/ FX FIX (Equities) Dev / Support Analyst & Oracle Development for Financial Exchange, spot & derivatives Trading Systems as well as AI (21 years)
  • FIX protocol based low and ultra-low latency trading platforms: client onboarding, latency root cause investigations, configuration management & automation (10 years)
  • Architectural Design of System & Databases (9+ years)
  • Oracle performance tuning, SQL, PL/SQL, Query & Optimizer tuning, ExplainPlan, tkprof, OEM, data transformation & ETL process management & root cause analysis, testing & deployment (16+ years)
  • Unix/Linux sys management, shell/Perl/Python scripting, Windows as well (18 years)
  • Data Analysis, Data Architecture, architectural design, Security & Risk Analysis & Solution Architect
  • System Integration & Implementation, Issue & Data Analysis, root cause investigation, rollout of fixes & enhancements from DEV via QA to Prod (16+ years)
  • 1st, 2nd & 3rd line Production/trading floor Support & project delivery (16 years)
  • Mentoring, coaching and leading other team members through new projects (11 years)


Skills

  • Technologies: Perl, shell scripting on Unix/Linux, network & database connectivity, Linux/Oracle perf tuning
  • System Integration & Implementation: overall responsibility for technologies and dev strategies used system wide; automation of deployment processes; automated CI/CD pipeline
  • Trading floor / Prod Support: BAU / Adhoc issue management on up to 300+ traders on trading floors worldwide, internal & external clients; bringing fixes and enhancements from Dev forward to Production via QA, incl reconciliations
  • Low Latency / High Frequency trading platforms: performance tuning, root cause investigations for latency issues and fixing them; env setups; monitoring etc.
  • Performance issue root cause investigation on low latency trading platforms, covering FIX, API, network latencies; Linux Kernel & TCP network tuning, window scaling, bandwidth usage optimization etc.
  • FIX connectivity: Client spec, setup, configuration, full onboarding program into prod, latency/connectivity issues
  • Oracle Development: implementation and integration of Business Logic in PL/SQL, migration (PL/SQL, Unix), performance tuning, SQL*Loader, advanced Oracle features, SQL combined with Unix/Linux shell and Perl scripting
  • Automation of manual processes, setup and configuration procedures as well as reconciliation scripts and business tasks
  • Convert/rework code in compiled languages (Java, C++, C#) into advanced scripting like Perl
  • Data Analysis: source code, query and data analysis; generating business reports
  • Scheduling & Batch processing: Scheduling processes across networks as well as calculation in batch processing
  • System integration: implementation management, migrations, upgrades/releases from dev, test into prod; Amazon AWS Server Cluster setup and integration; Linux Containers, AWS root & IAS user setup and configuration, AWS Python dev 
  • Tool & report development / Scripting: for trading, internal applications, utilization & performance / prod monitoring, capacity management/forecasts, reconciliations, reporting and automation/simplification of routine manual tasks to achieve higher efficiency & system stability for improved business value.


Key Technologies

  • Key Technologies: Unix/Linux shell (bash, sh, ksh), Perl, SQL, PL/SQL, SQL*Loader, sed, awk, nawk, Python etc., FIX protocol; Linux shielding, sysctl etc.; System Monitoring (Geneos, Splunk, Control-M, Nagios etc.)
  • Root cause investigations & working on permanent resolution cooperating with traders, test & dev, providing temporary workarounds to traders/Business. Verifying issues by trying to reproduce in separate envs and provide detailed steps to dev/advise for fixes and provide temporary fixes until permanent fixes are ready.
  • Interacting with globally distributed support, infrastructure, development, network, firewall, test teams, stakeholders, internal and external business users & 3rd party vendors and playing a leading role in project progression, architect new solutions/features to exceed client?s expectations, keeping SLA?s.
  • Dig deeper into complex issues, debug code to find root cause, fix it and provide an overall best code solution with no side effects and risks possible.
  • Unix/Linux System Resource, memory, process & capacity management, application/system maintenance and investigations of application/system crashes, connectivity issues and latencies on FIX, API, network (TCP/IP), router and firewall level.
  • Release, Environment & Change Management incl. documentation, DR and outage management. Full SDLC, ITIL, Agile.
  • Apache configuration and certificate management.
  • Familiar in Java(Script), SQL-Server, Sybase, Control-M, C#, XML, Html/CSS.
  • Proactive, passionate about efficient code, performance tuning, Linux, long term flexible technologically advanced but also performance-wise best solutions for scalable platforms, keen, ambitious and motivated in-depth & in time investigator, focussed on supporting demanding clients, performance & efficiency, but also thriving a project successfully forward, coming up with additional solution proposals to guaranty long term performance & system stability/reliability. The broad range of skills and the ability to make quick, still technologically confident and correct decisions in critical situations in production environments can contribute a lot towards a more stable and available trading platforms and the success of projects delivered in time


Einsatzorte

Einsatzorte

Dubai (+500km) EU (+500km)
Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

9 years 1 month
2015-09 - now

Internal Projects

Owner / Founder, IT Consultant
Owner / Founder, IT Consultant
  • Introductory engagements in projects of external clients in EU / Middle-East:
    • Proposal of new system & process architecture based on new requirements
    • Proof of concept by prototype development
    • Proposal for HDD space scaling for Linux Production hosts
    • Gap, impact & process analysis with workflow, optimization and automation
  • Financial Management:
    • A solution based on a combination of JavaScript, JSON, KDB+/q, Python, Node.js and Perl to manage bookings of private, business and investment accounts with categorized transactions
  • Business Expense Reporting:
    • Aggregation of business expenses and reporting in Perl
  • Automated Entity Transformation:
    • Automated performance benchmark testing of different data structures, code designs and methodologies with reporting, in Perl
  • ElasticSearch:
    • Setup of ES Cluster and high performance testing, in Perl, Python, shell scripting
  • Infrastructure:
    • Router, DHCP setup & configuration, DNS server configuration
    • ftp server setup & configuration
    • Virtual Machine env setup
  • Oracle:
    • Oracle Database installation, config, design, Setup, Dev & performance tuning
    • ETL process design & pipeline development for data accumulation in datalake
    • Dashboard & Business Report creation with APEX, AppBuilder & SQL Workshop
  • AWS:
    • Configuration Management (AWS account, root & IAM user configuration)
    • Python development on AWS Cloud9 IDE, Regression Test automation in Python
  • Automated Server Setup & Deployment:
    • Ansible Configuration & Inventory & Playbook Management
    • Setup of new servers and processes, upgrades incl. process validation
    • Standardization of server setup, root cause investigations
  • Linux hardening:
    • Linux hardening as part of Sys setup to requirements for Linux security
    • ?Root and other user security policies, system connectivity security incl BIOS hardening and more.
on Request
3 months
2023-10 - 2023-12

Oracle Database Migration for multi-regional PLM System

Database Migration Lead Engineer [contract]
Database Migration Lead Engineer [contract]
  • Solution Design & implementation of data export/import & transformation processes incl. system integration & validation
  • Proof of concept with new re-structured migration concept, minimizing and eliminating key critical risks and time-consuming processes
  • Architectural Design documentation for Management, stakeholders and Business Users
  • Database structure and data analysis incl database size estimation for subsets of whole source databases and estimate for the target database with transformed data
  • Data cleansing & correction according to discussed and agreed rules
  • Test and validation processes
  • Process automation
  • Linux automation to standardise and automation migration processes
  • Oracle ETL & data transformation processes
  • Convert business requirements into technical transformation strategy incl validation and verification processes & documentation

ZFL / AHTech / Airbus ? EU/Germany
1 year 2 months
2022-09 - 2023-10

Oracle Database Migration for multi-regional PLM System

Database Migration Lead Engineer [contract]
Database Migration Lead Engineer [contract]
  • Solution Design & implementation of data export/import & transformation processes incl. system integration & validation
  • Proof of concept with new re-structured migration concept, minimizing and eliminating key critical risks and time-consuming processes
  • Architectural Design documentation for Management, stakeholders and Business Users
  • Database structure and data analysis incl database size estimation for subsets of whole source databases and estimate for the target database with transformed data
  • Data cleansing & correction according to discussed and agreed rules
  • Test and validation processes
  • Process automation
  • Linux automation to standardise and automation migration processes
  • Oracle ETL & data transformation processes
  • Convert business requirements into technical transformation strategy incl validation and verification processes & documentation

ZFL / AHTech / Airbus ? EU/Germany
4 months
2021-10 - 2022-01

Some short automation

  • Exchange Trading Singapore, Financial Sector (introductory: test, monitoring & process automation)
  • Some short automation, ETL & system engineering introduction in for financial sector companies in Cyprus & Switzerland

Exchange Trading Singapore, Financial Sector
4 months
2021-07 - 2021-10

System & Database Integration

Linux Engineer
Linux Engineer
Financial Sector client, Austria
4 months
2021-05 - 2021-08

introductory engagement prototype development

Confidential client, Middle-East, Financial Sector
1 year 2 months
2020-02 - 2021-03

Infrastructure Support, Automation/Integration

Quantitative Application Support and DevOps Linux: shell Perl Python ...
Quantitative Application Support and DevOps
Automation & Integration of monitoring and trade feed processes:
  • Proof of Concept, development & implementation of automated system processes
    • Monitoring: linking crontab based systems to Geneos efficiently: providing more visibility of until then unrecognized issues
    • re-build multi-phased feeds to external vendors and develop a singlephased more efficient solution
    • Automation of validation & monitoring processes, sanity checks, release processes
    • Development of new Report Management System for distributed multicluster environment, Stats reporting, Sanity checks
  • Process, Fix & Enhancement solution development, Python & C++
  • Infrastructure Support, Process & Workflow optimization & automation
  • Kerberos authentication (setup, troubleshooting & root cause analysis & fixes)
  • SAN/NAS storage configuration, attachment troubleshooting & verification
  • FIX client onboarding automation, FIX latency troubleshooting, FIX adaptor setup & FIX issue root cause investigations in Production
  • Architectural Design:
    • Requirements vs system gap analysis
    • Conversion of high-level business requirements into technical specification with technical proof
    • Overall IT System analysis and advisory on process optimizations
    • Advise on architectural improvements and alterations to minimize data loss and system outages
    • Business presentations for new solutions incl impact analysis
    • Investigation of current production issues, root cause analysis and redesign of current architecture
  • Process, Monitoring & Test automation, TeamCity regression test automation, Root cause investigation of found bugs (direct or side-effects of other bugs)
  • Deployment automation to multi-cluster with over 300 nodes and evaluation, Ansible playbook & inventory management, troubleshooting, standardization
  • Oracle:
    • PL/SQL Development, new feed implementations & Query/index/Optimizer tuning
    • OEM in distributed environment (Performance & Hardware usage monitoring):
      • Performance Monitoring & resolution of perf issues / tuning down to hardware level, real-time query monitoring and more
      • CPU, memory, storage monitoring management
    • Development of frontend app, reports & dashboards with Oracle APEX Available for new opportunities for remote work or/and on-site worldwide
    • Database Design, architectural review & advise, presentation of proposed solutions to management and stakeholders
    • Evaluating process functionality against new requirements and draw new designs
    • Migration process design & implementation
    • ETL process dev & integration incl. testing and deployment; amendments/fixes of existing feeds
    • Big Data analysis & statistics creation to forecast long term trends in business data usage and database usage
    • Visualization of new proposed process flows for business user/stakeholder presentations
  • Production Support for Bond trading system, root cause investigations, solutions for identified workflow & security issues e.g. with multi-threaded processes in C++ components, mainly also Python
  • Advise on Architectural Design, tools, algorithms and methods for a scalable, most reliable distributed systems running on best performance
  • Security risk & impact assessment; propose solution and system-wide impact analysis before and after solution integration
  • TeamCity test validations (QA), root cause investigations, process management
  • Firewall/Proxy configuration changes
  • New host setup & business app installation, validations
  • CI/CD pipeline development, test & deployment automation
Linux: shell Perl Python C++ Java SQL Oracle SQL Server Maria database git Linux system management Grafana TeamCity Prometheus Ansible Sys Config Management Cameron FIX Engine BitBucket JIRA Confluence ServiceNow CI/CD Agile Oracle SQL*Loader & internal loader tools APEX Appbuilder & SQL Workshop
Deutsche Bank ? London
7 months
2019-09 - 2020-03

Deployment Automation & Integration of Regulatory Validation Application

Unix Engineer, Deployment Automation/Integration [contract] Linux/Sun Solaris Process automation shell ...
Unix Engineer, Deployment Automation/Integration [contract]
  • System Gap Analysis, identification of safety issues and proposals to fix them
  • Proof of Concept & implementation of new automated deployment processes incl. manual tasks restricted by external vendor and internal UBS constraints
  • Automation of deployment process incl setup & development of a solution interfacing third party deployment components, security policies and administrative account permissions with Nexus, Puppet, Artifactory etc., Test automation within CI/CD pipeline
  • Deployment Automation of Fenergo (external vendor product) incl. Tomcat & ElasticSearch (incl SearchGuard plugin) setup on single- and multi-clustered nodes (incl. load-balanced/failover hosts) in different environments incl documentation & evaluation
    • Configuration of required Tomcat Apache & ElasticSearch & SearchGuard plugin with host specific configs and certificates
    • Configuration & performance tuning to host specific requirements
  • System architecture proposals to run deployment of external vendor?s software more efficiently and specify requirements for external vendor?s deployment packages
  • Architecture adjustments to avoid deployment failures of current deployment processes and advice design changes with best practice process management to reduce certain risks
  • Automation and standardization of Tomcat & ElasticSearch CA certification constrained by UBS internal tools & policies
  • Oracle: ETL process root cause investigation, performance tuning, PL/SQL, SQL, query analysis & upload process root cause investigation & fine tuning
  • Gap Analysis based on new requirements
  • Partial re-design of database model plus new database tables and other objects incl stored procedure
  • Security Risk Analysis & Risk Assessment; proposal, development & integration of new solutions incl impact evaluations
Linux/Sun Solaris Process automation shell Perl Puppet Windows SQL IIS & MySQL DB environment setup Nexus Artifactory Maven etc. Documentation: Confluence Wiki Agile
UBS ? London
9 months
2018-05 - 2019-01

Automation & Integration of aggregated business information for AI

Software Engineer, Automation/Integration Engineer, Data Architect [contract] Process automation Perl Python ...
Software Engineer, Automation/Integration Engineer, Data Architect [contract]
Automation & Integration of aggregated business information for AI:
  • System & Data Analysis based on Linux/Oracle backend & Web Frontend
  • Proof of concepts, development of new AI data referencing solutions
  • Automation of multi-facetted data consolidation processes, scripting etc. incl upstream ElasticSearch
  • Oracle Enterprise Manager (OEM):
    • Performance monitoring & tuning query to hardware level
    • Alert setup, configuration & management for outages, security breaches and more
  • Dashboard development & backend process integration for Business (Tableau, ElasticSearch, APEX AppBuilder & SQL Workshop)
  • Advisory and execution on
  • Test automation, development strategy adjustments involving now data integrity and completeness
  • Data architecture, development strategy & architectural design incl incoming and outgoing data feeds
  • Database schema design, setup and implementation of new structure incl code
  • Process code analysis, identification of short comings, bugs resulting in impact analysis, code fixes and proof of concept incl process to fill gap of missed data incl all dependencies
  • Scalability, archiving, high availability
  • General architecture & design issues
  • Presentation of new strategies, concepts and process flows to senior business users & stakeholders
  • Chair of meetings with Business users & stakeholders with presentations, presenting new strategies and what their business could get from a new solution even beyond the requirements, demonstrating also the safety of a solution
Process automation Perl Python ElasticSearch SQL PL/SQL Development performance tuning (SQL statement index data analysis & aggregation database design & normalization; database migration optimization SQL statement optimizer tuning
BAE Systems ? Applied Intelligence ? Qatar
10 months
2017-06 - 2018-03

Automation of multi-phased migration processes of global datacentre

Data Centre Migration Specialist, Production Support [contract]
Data Centre Migration Specialist, Production Support [contract]
Automation of multi-phased migration processes of global datacentre:
  • System Analysis, gap analysis
  • Automation of migration & validation processes (Perl)
  • Configuration Management (incl YAML, JSON, XML, sdc)
  • Development of analysis, validation and control processes, Agile, GIT
  • System architecture & design; Code & Config Standardization
  • Gap Analysis and system design advice incl. documentations
  • Collaborate with internal Dev, network, infra & QA teams for system setups etc.
  • Oracle: new database host integration, PL/SQL migration code dev, data analysis & transformation, performance tuning: query-, index-, optimizertuning, ExplainPlan etc. (manually & OEM perf monitoring/tuning)
  • Linux: high performance tuning (process CPU & memory management, Linux shielding, capacity management etc.), shell, Perl, Python scripting; Kernel & TCP network tuning, window scaling, bandwidth usage optimization etc.; Linux shielding setup and configuration, benchmark & aggregated testing
  • KDB+/q: root cause investigation, troubleshooting of integrated solution
  • API & FIX Connectivity & Latency troubleshooting; FX feed optimizations, Perl, shell


Support of FX Prod Env, high availability:

  • root cause investigation, process and memory interrogation
  • Change & Release Management, Automation, Performance Tuning
  • new features & bug fixes, strategy and architectural design
  • root cause analysis, troubleshoot, debug Java based backend components, latency troubleshooting, GC issues etc.
  • dealing directly with internal and external users, traders, brokers, front office
JP Morgan Chase - London / Great Britain
1 year 4 months
2016-02 - 2017-05

High Performance

Production Engineer, shell/Perl Development, System Integration [contract]
Production Engineer, shell/Perl Development, System Integration [contract]
High Performance, High Security Solution: Design, Development, Implementation & testing of high-performance file & content validation solution for Reporting:
  • Setup, development, test and integration of high-performance Perl (and shell) scripts to validate authenticity of generated reports by internal teams for LCH members/clients and assure data integrity
  • Security assessment, analysis and validation; architectural design from scratch
  • Shell (Korn shell, bash)/Perl development on Linux: multi-threaded, procedural & OO; (plus temporary smaller Windows solution) incl. file, SQL, JSON, YAML, XML
  • Test Automation: Unit, Integration, Regression testing and automated functional testing


Database Management:

  • Oracle Setup & Implementation of new business logic, PL/SQL Dev & index-, query-, Optimizer-tuning, Explain Plan, ETL process management incl testing and deployment; FE App dev by Oracle APEX App Builder & SQLWorkshop
  • Development of data aggregation and validation processes
  • Gap Analysis & architectural design improvements, proof of concept 


Production Support:

  • Change and Release Management
  • Setup of environments, prod and pre-prod, and run testing in pre-prod envs
  • Coordinate testing with QA teams in pre-prod envs
  • Dealing also directly with internal/external clients, users


System Integration:

  • Automation of Deployment process from dev into higher envs up to production env.
  • Integration of new components into system architecture, also Java based apps
  • Scalable deployment methods & procedures delivering long term time savings with reliable deployment procedures after Agile methodology
  • Automation of test processes, configuration management & verifications
  • dashboard development for system performance & processing validation and business reports (automation & Tableau, Oracle APEX)

LCH Clearnet Ltd. - London / Great Britain
2 years 11 months
2012-06 - 2015-04

1, 2 & 3rd line Production Support:

Data Analyst, Senior Production Support Analyst (AVP) [permanent] Unix (HP-UX Sun Solaris AIX)/Linux (RedHat) shell (sh ...
Data Analyst, Senior Production Support Analyst (AVP) [permanent]
BAU/Adhoc Production Support for Equities & Fixed Income
  • ensuring system stability and high availability with clients & front-end users
  • Data Analysis, research for data inconsistencies, business report generation
  • Automation of manual processes, environment setup processes, reconciliation and business processes as well as backend calculations etc.
  • Oracle Development: PL/SQL for database migration, data transfer and fixes and enhancements with new business logic implementation
  • Scheduling across network as well as on dedicated servers (crontab, Control-M, inhouse build scheduler with dependency logic, Windows scheduler etc.)
  • Batch processing: implementation, maintenance & development/design, restructuring, simplifications, analysis
  • analysis, root cause investigation, fixes
  • implementation/integration SQL & PL/SQL in Oracle Data Warehouse backend
  • reworking C++ code into Perl with new features on top of existing functionality
  • bringing fixes and enhancements from Dev forward to Production via QA
  • data, query and code analysis
  • environment setup & automation


Project work:

  • Oracle Data Warehouse development: PL/SQL development, mass data upload and transfer by SQL*Loader, stored proc dev, database migrations, performance tuning (explain plan, auto trace but also via OEM); Implementation & Support of concepts, logical and physical DB models
  • successful decommissioning of major components of an old trading/reporting system and switching over to new one based on Oracle data warehouse
  • Setup and fully automation of pre-prod envs with daily rolling environments on Unix (Solaris) and Linux (Redhat) fully scheduled setups and feed and calculation/batch processing incl reconciliations
  • OS (SUN Solaris to Linux RedHat) and database migrations using scripting (SQL, PL/SQL, shell, Perl etc.)
  • FX trading: FIX, API & TCP/IP network latency root cause investigations, FIX connectivity issues on low latency platform On all: reconciliations to ensure proof of no data/logic breaks etc.


By:

  • cooperate with Clients, Network, internal development teams, in/external Business users globally
  • Sybase/Oracle Database management, feed management/development/automation
  • Oracle database design, development SQL, PL/SQL & stored procs, packages etc, Performance Tuning, SQL*Loader, *LOB cols, Report creation by APEX AppBuilder
  • Incident management covering Dev, test and prod envs Documentation, specification and description/documentation for Releases
  • Utilization & performance monitoring & improve processes & procedures
  • release & environment management/automation
  • mentor & train more junior team members (up to 3 locally and 6 abroad (Singapore, India, New York))
  • lead small teams through new projects, distributed team: 4 in APAC, 2 in NY, 2 in Europe, chair team meetings and inter-relational team meetings (2NY, 3 Singapore and India)
  • mentor and coach university apprentice (1) locally
Unix (HP-UX Sun Solaris AIX)/Linux (RedHat) shell (sh ksh) Perl scripting Unix/Linux System tools & management Windows Sybase/Oracle SQL PL/SQL SQL Server Control-M Nagios self-developed monitoring tools FIX connectivity latencies Cameron FIX Engine Remedy Jira internal tools ITIL Agile; Versioning: svn SubVersion
Credit Suisse - London / Great Britain
11 months
2010-11 - 2011-09

1st & 2nd line Trading Floor Support

Senior eFX/FX/FIX Support Analyst [contract, 11 months] Unix/Linux shell (bash sh ...
Senior eFX/FX/FIX Support Analyst [contract, 11 months]
  • BAU/Adhoc Trading Floor Production Support for up to 300+ traders worldwide, Front Office
  • Client Onboarding: client/user/account setup and configuration in RET AD (Reuters) for trading portals as Quantus, 360T, Currenex, Bloomberg, FXall, RTFX, RET Admin, RET Trader/Client applet
  • Trading backend configuration: FX Market Data, MM, trading connections, limits, margin groups and configurations
  • Change Control / Release & environment management: planning to implementation & documentation of new releases Team Management
  • Leading small local team through mass onboarding project (Java based)
  • Set tasks and prioritize
  • Gather regular status reports
  • Chair team meetings to discuss open issues and alternative solutions
  • Monitor progress of tasks assigned to team members and discuss new estimates
  • Mentoring more junior team members
  • Assist and support in technical matters where technical skills are not efficient or advanced as expected. All team members should be able to support trading platforms on all levels reliably due to shift works; so no risk periods.


Project Work:

  • Plan concept and realisation of mass onboarding process
  • Provide capacity forecasts for next 1, 3, 6, 12 months and 3 years
  • Propose architectural changes to ensure scalability of entire trading system based; storage changes, process and storage separation concepts etc.
  • Analysis of performance issues of trading system and rectification by architectural changes
  • FIX connectivity and latency issue troubleshooting on low latency trading for third projects
  • Latency investigations based on TCP/IP sniffer results/network captures
  • Architecture tuning


By:

  • cooperate with Traders, Sales, Test, Network, internal development teams, internal/external Business users and 3rd party vendors
  • plan and implement new trading strategies, data handling, onboarding procedures,upload, synchronization and migration tools
  • Coordinate implementations with infrastructure, NOC and network teams
  • SUN Solaris to Linux RedHat migration of trading system, covering shell, Perl scripts,SQL and PL/SQL codes, setup and implementations on new systems incl scheduling etc.
  • lead team members through mass onboarding project (6 support, integration and development)
  • train more junior team members up to scratch (4 locally, 1 abroad (Munich))
Unix/Linux shell (bash sh ksh) Perl SQL scripting Windows Control-M Nagios Reuters RET SQLServer Apache configuration & certificate management JavaScript Remedy HP QC & SM Jira AMD Reuters GIT
UnicreditGroup ? London / Great Britain
6 months
2010-02 - 2010-07

Front Office Trading Floor Support for FX Sales/Liquidity team

Senior FX FIX Support Analyst [contract, 6 months] Unix (AIX Solaris) / Linux (RedHat SuSE) shell (bash ...
Senior FX FIX Support Analyst [contract, 6 months]
FIX Support Production environment, setup, configuration & monitoring


Project Work:

  • Deal/cooperate with up to 8 external clients as sole point of contact


Main issues:

  • Onboarding new clients
  • Latency issue investigation and resolution
  • Client connectivity testing/issues
  • Setup and configure FIX Market Data & Trading connections
  • Exchange connectivity: upgrades, integration work, implementations
  • FX Low Latency Trading Platform: trading connections, market data & pricing/rates feeds; performance & latency root cause investigations and fixes
  • FIX protocol: Onboarding of new clients from pre-production environments until go live in production
  • providing initial information to clients
  • setup, FIX connectivity tests
  • conformance certification testing & test plans
  • upgrades, migrations


By:

  • troubleshoot issues on FIX, API, network, TCP/IP (sniffer analysis, l/r roundtrip times, retransmission of TCP packages), router and firewall levels in Production and pre- roduction environments
  • Release & environment management
  • Development of internal applications (latency reports)/scripts (shell, nawk, Perl (incl debugger)), perf tuning on Linux/Solaris. JavaScript
  • Development of FIX connector enhancements; onboarding & test automation, FIC client simulator for stress test and to reproduce performance issues
  • Control Management: Bugzilla, Perforce issue tracking/management system to support traders & internal teams and keep agreed SLA?s
  • Leading small projects for integration work with 1.5 people locally, 1 off-shore in New York. In cooperation with client?s technical teams.
Unix (AIX Solaris) / Linux (RedHat SuSE) shell (bash sh ksh) Perl scripting XML; Unix tools and management processes
Velocity Systems International Ltd., BGCPartners Inc. - London / Great Britain
4 years 11 months
2004-08 - 2009-06

1st Line Technical Support of Trading Floor Applications

Senior Equities/FX & FIX Support Analyst [contract & perm] Unix (AIX HP-UX SunSolaris ...
Senior Equities/FX & FIX Support Analyst [contract & perm]
  • 1st Line Technical Support of Trading Floor Applications, eTrading platforms, FIX based low latency trading platforms incl external client support
Unix (AIX HP-UX SunSolaris Debian) Linux (RedHat SuSE) various Windows servers
NYSE Euronext Ltd., Allegro Development Ltd., FX Alliance Ltd., EMC2/Documentum Europe Ltd. - London / Great Britain
5 years 9 months
1998-11 - 2004-07

Performance Tuning in all aspects

Core Java/Oracle Developer, DBA for Financial Exchange/Services [permanent]
Core Java/Oracle Developer, DBA for Financial Exchange/Services [permanent]
  • Core Java/Oracle Development
  • Oracle DBA
  • Performance Tuning in all aspects
  • Forms & Reports
MeTechnology AG, Brokat Infosystems AG, bbv AG, c.a.r.u.s. AG, Apoll AG, Fernbach Software S.A., ClarITeam S.A. ? Germany / Great Britain

Aus- und Weiterbildung

Aus- und Weiterbildung

4 years 11 months
1990-09 - 1995-07

University Studies

Graduated with an equivalent to the British Master?s degree, Martin-Luther-University Halle-Wittenberg - Halle / Germany
Graduated with an equivalent to the British Master?s degree
Martin-Luther-University Halle-Wittenberg - Halle / Germany
  • Mathematics, Physics
  • Subsidiary subjects: Information Technology, Astronomy

Kompetenzen

Kompetenzen

Top-Skills

Oracleentwicklung Linux-Scripting Performance-Management Automation/Steuerung Integration Software Deployment Root Cause Analysis SQL Datenbankmodellierung Systemintegration Monitoringsysteme

Produkte / Standards / Erfahrungen / Methoden

Oracle Database Design, Modelling, Development and Performance Tuning & Administration
Since 1998 ? 2004 as Core Oracle Database Development
Since 2004 in Production / Application Support, Oracle Development


Oracle Database Design & Modelling

  • Development of Logical Entity Relationship Models and Physical Database Models, Normalisation of Database models based on Business requirements incl maintenance of historical records, performance and process optimisations, multi-language capabilities, mechanisms for archiving and more
  • Database metadata normalisation to eliminate redundant data, enable efficient querying, simplification of updates later on etc.
  • Database Model Management either manually in scripts but better also with e.g. Oracle SQL Developer Data Modeller (or similar tools also for Sybase, MS SQL Server, MySQL like Visio etc.) to keep the database model inline with generated scripts to create all database objects 


Oracle Database Development (SQL, PL/SQL) & Administration

  • Development of scripts to setup the entire database systematically and in a modular way inclusive Tablespaces, Users, Roles with appropriate permissions and all required database objects (e.g. tables, views, constraints, (primary-, foreign keys, check-, unique constraints etc.) indexes, sequences, materialized views, partitioned tables and indexes, database links and more
  • Storage-, Session- & Tablespace Management
  • Development of Stored Procedures, functions, triggers based on Business requirements
  • Implementation and integration of ETL processes to
    • Upload mass data of streamed data and files to database level
    • Process & transform data based on non-IT-specific guidelines
    • Provide data for the presentation level (DWH) to provide ready data for a frontend
  • Data Migrations: data analysis & cleansing, Oracle analytical functions
  • Data mapping if source and target database structure are different
  • Source/target data validation after migration
  • Development of Data extraction, loading and transformation processes (ETL, ELT), complete automation
  • ETL process tools: SQL*Loader, Informatica, SQL scripting, advanced Oracle features, SQL combined with


Unix/Linux shell and Perl scripting

  • New developments for frontend applications in Oracle Forms & Reports, Oracle APEX AppBuilder & SQL Workshop (Apps, reports, dashboards), backend Stored Procedures, packages, functions, triggers etc. incl system integration, scheduling
  • Development of new links based on data of different data sources (AI)
  • Frontend App creation and configuration with Oracle AppBuilder and SQL Workshop (part of APEX)
  • Implementation and integration of business logic in PL/SQL, migration (PL/SQL, Unix/Linux), Performance Tuning (query-, index-, optimizer, I/O, process and workflow tuning, ExplainPlan, tkprof) but also Oracle Enterprise Manager (OEM):
    • Realtime query monitoring, Performance monitoring & tuning, Dashboard configuration
    • CPU, memory, storage monitoring in distributed environments
    • Alert setup, configuration & management for outages, security breaches and more
  • Datamart integration and process automation
  • Data Analysis: source code, query and data analysis; generation of business reports
  • Root Cause Analysis incl performance bottlenecks and provide appropriate solution


Technical Summary

  • Hybrid Support/Data Analyst / Oracle Developer (Unix/Linux scripting, SQL & PL/SQL), Automation, Integration, Perf Tuning
  • eFX/ FX FIX (Equities) Dev / Support Analyst & Oracle Development for Financial Exchange, spot & derivatives Trading Systems as well as AI (21 years)
  • FIX protocol based low and ultra-low latency trading platforms: client onboarding, latency root cause investigations, configuration management & automation (10 years)
  • Architectural Design of System & Databases (9+ years)
  • Oracle performance tuning, SQL, PL/SQL, Query & Optimizer tuning, ExplainPlan, tkprof, OEM, data transformation & ETL process management & root cause analysis, testing & deployment (16+ years)
  • Unix/Linux sys management, shell/Perl/Python scripting, Windows as well (18 years)
  • Data Analysis, Data Architecture, architectural design, Security & Risk Analysis & Solution Architect
  • System Integration & Implementation, Issue & Data Analysis, root cause investigation, rollout of fixes & enhancements from DEV via QA to Prod (16+ years)
  • 1st, 2nd & 3rd line Production/trading floor Support & project delivery (16 years)
  • Mentoring, coaching and leading other team members through new projects (11 years)


Skills

  • Technologies: Perl, shell scripting on Unix/Linux, network & database connectivity, Linux/Oracle perf tuning
  • System Integration & Implementation: overall responsibility for technologies and dev strategies used system wide; automation of deployment processes; automated CI/CD pipeline
  • Trading floor / Prod Support: BAU / Adhoc issue management on up to 300+ traders on trading floors worldwide, internal & external clients; bringing fixes and enhancements from Dev forward to Production via QA, incl reconciliations
  • Low Latency / High Frequency trading platforms: performance tuning, root cause investigations for latency issues and fixing them; env setups; monitoring etc.
  • Performance issue root cause investigation on low latency trading platforms, covering FIX, API, network latencies; Linux Kernel & TCP network tuning, window scaling, bandwidth usage optimization etc.
  • FIX connectivity: Client spec, setup, configuration, full onboarding program into prod, latency/connectivity issues
  • Oracle Development: implementation and integration of Business Logic in PL/SQL, migration (PL/SQL, Unix), performance tuning, SQL*Loader, advanced Oracle features, SQL combined with Unix/Linux shell and Perl scripting
  • Automation of manual processes, setup and configuration procedures as well as reconciliation scripts and business tasks
  • Convert/rework code in compiled languages (Java, C++, C#) into advanced scripting like Perl
  • Data Analysis: source code, query and data analysis; generating business reports
  • Scheduling & Batch processing: Scheduling processes across networks as well as calculation in batch processing
  • System integration: implementation management, migrations, upgrades/releases from dev, test into prod; Amazon AWS Server Cluster setup and integration; Linux Containers, AWS root & IAS user setup and configuration, AWS Python dev 
  • Tool & report development / Scripting: for trading, internal applications, utilization & performance / prod monitoring, capacity management/forecasts, reconciliations, reporting and automation/simplification of routine manual tasks to achieve higher efficiency & system stability for improved business value.


Key Technologies

  • Key Technologies: Unix/Linux shell (bash, sh, ksh), Perl, SQL, PL/SQL, SQL*Loader, sed, awk, nawk, Python etc., FIX protocol; Linux shielding, sysctl etc.; System Monitoring (Geneos, Splunk, Control-M, Nagios etc.)
  • Root cause investigations & working on permanent resolution cooperating with traders, test & dev, providing temporary workarounds to traders/Business. Verifying issues by trying to reproduce in separate envs and provide detailed steps to dev/advise for fixes and provide temporary fixes until permanent fixes are ready.
  • Interacting with globally distributed support, infrastructure, development, network, firewall, test teams, stakeholders, internal and external business users & 3rd party vendors and playing a leading role in project progression, architect new solutions/features to exceed client?s expectations, keeping SLA?s.
  • Dig deeper into complex issues, debug code to find root cause, fix it and provide an overall best code solution with no side effects and risks possible.
  • Unix/Linux System Resource, memory, process & capacity management, application/system maintenance and investigations of application/system crashes, connectivity issues and latencies on FIX, API, network (TCP/IP), router and firewall level.
  • Release, Environment & Change Management incl. documentation, DR and outage management. Full SDLC, ITIL, Agile.
  • Apache configuration and certificate management.
  • Familiar in Java(Script), SQL-Server, Sybase, Control-M, C#, XML, Html/CSS.
  • Proactive, passionate about efficient code, performance tuning, Linux, long term flexible technologically advanced but also performance-wise best solutions for scalable platforms, keen, ambitious and motivated in-depth & in time investigator, focussed on supporting demanding clients, performance & efficiency, but also thriving a project successfully forward, coming up with additional solution proposals to guaranty long term performance & system stability/reliability. The broad range of skills and the ability to make quick, still technologically confident and correct decisions in critical situations in production environments can contribute a lot towards a more stable and available trading platforms and the success of projects delivered in time


Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.