1alayn.de
Focus areas
Operations and high availability
Installation, patching, backup and recovery, standby databases. In production on Oracle Database Appliance.
Performance and monitoring
Finding and fixing bottlenecks, making metrics visible before they turn into incidents.
Automation
Rollout and patching as code instead of manual work. Repeatable, documented, reviewable.
Other databases
Not only Oracle: SQL Server and MySQL in operation, MariaDB replication for development, PostgreSQL in progress.
Platform and security
Linux and AIX on the database side, security guidelines based on BSI (German Federal Office for Information Security).
Development
Database-centric Java applications, data models and logic inside the database, web applications in PHP.
used in productionlab or self-study
Selected work
-
Migration to Oracle 19c and ODA
Moving the production database from Oracle 12c on AIX (IBM Power8) to Oracle 19c on Oracle Database Appliance, 2023. Platform change from AIX/Power to Linux/x86 and upgrade from 12c to 19c.
-
Oracle 19c Data Guard with Ansible
Playbooks for the complete build: prepare the OS, install Grid and database, create primary and standby, configure Data Guard Broker. Zero-downtime patching via switchover, with automatic role detection, rollback and credentials in Ansible Vault.
-
Beyond Oracle
MS SQL Server in daily operation: backup and restore, monthly test database refreshes. Experience with MySQL in production. MariaDB replication on two nodes for the developers.
PostgreSQL in Docker containers and an operations concept for a new PostgreSQL-based application. Oracle 19c RAC cluster in a private VMware lab for hands-on practice: Clusterware, ASM, interconnect, services.
-
Security handbook based on BSI
Written from scratch and maintained for the production Oracle database: hardening, privileges, procedures.
-
Database monitoring
Grafana dashboards for database metrics. Nagios checks in Perl.
-
Workflow core for a business process
Data model design, logic in PL/SQL (stored procedures/packages, triggers), external applications in Java.
Experience
-
since 2023
Oracle Database Administrator (full time)
GfI Gesellschaft für Informations- und Datenverarbeitung mbH, Bremen, Germany
- Migration from Oracle 12c (AIX, IBM Power8) to Oracle 19c on Oracle Database Appliance, 2023
- Operating Oracle 19c on Oracle Database Appliance: installation, configuration, patch management
- Building and running Data Guard, backup and recovery with RMAN
- Automating rollout and patching with Ansible
- MS SQL Server in daily operation with backup and restore, monthly test database refreshes
- MySQL in production, MariaDB replication on two nodes for the development team
- Operations concept for a new PostgreSQL-based application
- Interface to development and external support, technical documentation
-
10/2004 - 2023
Java Developer, Oracle DBA alongside from 2008
GfI Gesellschaft für Informations- und Datenverarbeitung mbH, Bremen, Germany
- Database-centric Java applications (JDBC, workflow)
- Database design and data modelling, PL/SQL procedures and triggers
- From 2008 responsible for the Oracle databases alongside development
- Technical coordination of database and server infrastructure for new sites
-
12/2000 - 09/2003
Programmer
Commercial bank for the construction industry (JSC), Omsk, Russia
-
03/2000 - 11/2000
Network Administrator
State supervisory authority for radio and communications, Omsk, Russia
-
10/1995 - 03/2000
Software Developer
Promex Company, Omsk, Russia
Education, languages, location
- Diplom-Ingenieur (FH)
- German engineering degree, recognised by the Free Hanseatic City of Bremen, 2004
- Diploma in Telecommunications Engineering
- Omsk State Technical University, 1992 - 1997
- German
- business fluent
- Russian
- native
- English
- working language
- Based in
- Delmenhorst, near Bremen, Germany
- Working model
- on site, hybrid or remote
- Relocation
- possible, within the EU and to Switzerland
Sailing
In my free time I sail the North Sea and the Baltic on the yacht DANUNA from Bremen. In 2026 I sailed in the MidsummerSail, about 900 nautical miles from Wismar to Töre in northern Sweden.