• 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 

• 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

• 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