Profileimage by Mario Rothe Oracle Developer, Linux Engineer, Deployment Automation/Integration, Data Analyst, Prod Support from LondonDubai

Mario Rothe

available

Last update: 30.11.2023

Oracle Developer, Linux Engineer, Deployment Automation/Integration, Data Analyst, Prod Support

Company: CapExTra Technology Solutions Ltd. (UK), XTra Technology Consultancies L.L.C-FZ (U.A.E.)
Graduation: Mathematics, Physics, Information Technology, Astronomy
Hourly-/Daily rates: show
Languages: German (Native or Bilingual) | English (Native or Bilingual)

Attachments

cv-mariorothe-details_301123.pdf
cv-mariorothe-attachment-Oracle_301123.pdf
cv-mariorothe-summary_301123.pdf

Skills

Oracle Developer (Unix/Linux scripting, SQL, PL/SQL, Automation, Integration, Perf Tuning, Query, Optimizer, Unix, Linux sys management, Perl/Python scripting, Perl, shell scripting, Unix/Linux, network & database, Linux Kernel, TCP network, PL/SQL, migration, PL, SQL*Loader, Oracle, Linux shell, Perl scripting, Java, C++, C#, Amazon AWS Server Cluster, Unix/Linux shell, bash, Linux, Resource, memory, TCP/IP, Apache configuration and certificate management, Java(Script), SQL-Server, Sybase, Control-M, XML, Html/CSS, DevOps, crontab, data loss, TeamCity, test automation, PL/SQL Development, Database, ETL, Big Data, algorithms, distributed systems, Firewall, shell, Python, SQL Server, git, Linux system management, Grafana, Prometheus, Sys Config Management, BitBucket, JIRA, Confluence, ServiceNow, CI/CD Agile, Oracle SQL, automated deployment, Puppet, Artifactory, Tomcat, ElasticSearch, Apache, System architecture, database model, Windows, IIS, MySQL DB environment setup, Nexus, Maven, Wiki, Data Analysis, backend, Web Frontend, data integrity, code analysis, bugs, database design, database migration, Configuration Management, YAML, JSON, sdc, system design, PL/SQL migration code, memory management, Python scripting; Kernel, TCP, KDB, API, shell Support, Release Management, bug fixes, Korn, Regression testing, functional testing, Database Management, business logic, Java based apps, Agile, JavaScript, KDB+/q, Node.js, data structures, DHCP setup & configuration, DNS server configuration, ftp server setup, Virtual Machine, Oracle Database, data inconsistencies, data transfer, Windows scheduler, Batch processing, Oracle Data Warehouse, + code, Data Warehouse, DB, Solaris, Redhat, SUN Solaris, FIX, TCP/IP network latency, low latency, Oracle database design, development SQL, ksh, Unix/Linux System tools, management, Sybase/Oracle, Nagios, Remedy, internal tools, ITIL, Versioning, svn, SubVersion, applet, scalability, IP, sniffer, data handling, SUN Solaris to Linux RedHat migration, Perl scripts, Unix/Linux, SQL scripting, Reuters RET, SQLServer, HP QC, SM, network, roundtrip, TCP packages, router, nawk, perf, Linux/Solaris, Bugzilla, Perforce, issue tracking, Documentum, Core Java, Oracle Development, Oracle DBA

Project history

10/2023 - Present
IT Consultant, Founder/Owner, Oracle Migration Specialist, Automation
XTra Technology Consultancies L.L.C-FZ

Expanded services for clients in Europe and Middle-East
Focus still on Oracle Development incl Data modelling, archotectural design, PL/SQL, performance tuning, implementation, integration, testing, rollout, support, root cause analysis.
Automation also on Linux by scripting and system integration.
Current clients: Airbus

09/2015 - Present
IT Consultant, Owner/Founder, Oracle & Linux Automation & integration
CapExTra Technology Solutions Ltd.

Internal Projects:
  • 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 prototype for high performance testing, in Perl, Python, shell scripting
  • Router, DHCP setup & configuration, DNS server configuration
  • ftp server setup & configuration
  • Virtual Machine env setup
  • Oracle Database Design, Setup, Dev & performance tuning
  • Automated Server Setup & Deployment:
  • Ansible workbook Management
  • Workbook configuration adjustments and setup for new setup of new servers
  • Standardization of server setup
  • 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.

02/2020 - 03/2021
Quantitative Application Support and DevOps, Automation/Integration, Infrastructure Support
Deutsche Bank

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 single-phased more efficient solution
    • Automation of validation & monitoring processes, sanity checks, release processes
    • Development of new Report Management System for distributed multi-cluster environment, Stats reporting, Sanity checks
  • Process, Fix & Enhancement solution development
  • Infrastructure Support
  • Architectural Design:
    • Requirements vs system gap analysis
    • Conversion of high-level business requirements into technical specification with technical proof
    • 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 re-design of current architecture
  • Process, Monitoring & Test automation, TeamCity regression test automation, Deployment automation to multi-cluster with over 300 nodes and evaluation, Ansible runbook management
  • Oracle:
    • PL/SQL Development, new feed implementations & Query/index/Optimizer tuning
    • 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 
  • Production Support for Bond trading system, root cause investigations, solutions for identified workflow & security issues e.g. with multi-threaded processes
  • 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, 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, Perl, Java, SQL, Oracle, SQL Server, Maria database, git
Key Tools: Linux system management, Grafana, TeamCity, Prometheus, Sys Config Management, BitBucket, JIRA, Confluence, ServiceNow, CI/CD Agile, Oracle SQL*Loader & internal loader tools

09/2019 - 03/2020
Unix Engineer, Deployment Automation/Integration
UBS

Deployment Automation & Integration of Regulatory Validation Application:
* 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: Process automation, shell, Perl, Puppet
* Windows: SQL, IIS & MySQL DB environment setup
Key Tools: Nexus, Puppet, Artifactory, Maven etc., Documentation: Confluence, Wiki

05/2018 - 01/2019
Software Engineer, Automation/Integration Engineer, Data Architect
BAE Systems - Applied Intelligence

Automation & Integration of aggregated business information:
* 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
* 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
* 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
* Linux: Process automation, Perl, Python, ElasticSearch
* Oracle: SQL, PL/SQL Development, performance tuning (SQL statement, index, optimizer tuning),
data analysis & aggregation, database design & normalization; database migration optimization,
ETL process management & solutions
* BPSS Security clearing

06/2017 - 03/2018
Data Centre Migration Specialist, Production Support
JP Morgan Chase

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-, optimizer-tuning, ExplainPlan etc.
* 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

02/2016 - 05/2017
Production Engineer, shell/Perl Development, System Integration
LCH Clearnet Ltd.

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
* 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

06/2012 - 04/2015
Data Analyst, Senior Production Support Analyst (AVP)
Credit Suisse

1, 2 & 3rd line Production Support:
* 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; 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
* Incident management covering Dev, test and prod envs
* Development of new procedures/scripts
* 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
Key Technologies:
* Unix/Linux 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: FIX connectivity, latencies, Cameron FIX Engine
* Issue tracking: Remedy, Jira, internal tools, ITIL, Agile; Versioning: svn SubVersion

11/2010 - 09/2011
Senior eFX/FX/FIX Support Analyst
UnicreditGroup

1st & 2nd line Trading Floor Support:
* 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))
Key Technologies:
* Unix/Linux, shell (bash, sh, ksh), Perl, SQL scripting, Windows
* Control-M, Nagios
* Reuters RET, SQLServer, Apache configuration & certificate management, JavaScript, Windows, Remedy
, HP QC & SM, Jira, AMD Reuters, GIT.

02/2010 - 07/2010
Senior FX FIX Support Analyst
Velocity Systems International Ltd., BGCPartners Inc.

Front Office Trading Floor Support for FX Sales/Liquidity team
* 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,
re-transmission of TCP packages), router and firewall levels in Production and pre-production
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.
Key Technologies:
* Unix/Linux shell (bash, sh, ksh), Perl scripting, XML; Unix tools and management processes

08/2004 - 06/2009
Senior Equities/FX Support Analyst
NYSE Euronext Ltd., Allegro Development Ltd., FX Alliance Ltd., EMC2/Documentum Europe Ltd.

NYSE Euronext Ltd., Allegro Development Ltd., FX Alliance Ltd., EMC2/Documentum Europe Ltd. - London
/ Great Britain
Senior Equities/FX Support Analyst [contract & perm]
1st Line Technical Support of Trading Floor Applications, eTrading platforms, FIX based low latency
trading platforms incl external client support

11/1998 - 07/2004
Core Java/Oracle Developer, DBA for Financial Exchange/Services
MeTechnology AG, Brokat Infosystems AG, bbv AG, c.a.r.u.s. AG, Apoll AG, Fernbach Software S.A., ClarITeam S.A.

Core Java/Oracle Development, Oracle DBA, Performance Tuning in all aspects

Local Availability

Open to travel worldwide
Flexible on location. Able to work on-site as and when required in Europe, Middle-East and wider area. British & German EU passport holder. Available immediately
Profileimage by Mario Rothe Oracle Developer, Linux Engineer, Deployment Automation/Integration, Data Analyst, Prod Support from LondonDubai Oracle Developer, Linux Engineer, Deployment Automation/Integration, Data Analyst, Prod Support
Register