Matthias Barfknecht - Database Developer / Database Architect | FRATCH

en
de

Recommended expert

Aschaffenburg, Germany

Experience

Jan 2017 - Present

9 years 1 month

Database Developer / Database Architect

Freelancer

Advised and supported application developers on database topics
Designed and developed interfaces
Optimized database performance
Automated rollout and release processes in the database environment
Implemented security requirements
Delivered metrics to management
Developed new scripts to automate rollouts
Adapted scripts for database deliveries
Identified and resolved issues during Oracle 12 to 19 upgrades
Adjusted database parameters, permissions and roles
Conducted feasibility studies and migrations from AWS EC2 to AWS RDS
Migrated database delivery versioning from SVN to Git/Artifactory using Ruby and Artifactory REST API
Analyzed Statspack/AWR reports and optimized long-running SQL statements
Configured SSL/TLS encryption for Oracle databases including proof of concept and rollout planning
Configured Kerberos authentication for Oracle users with Active Directory and single sign-on
Conducted database technology selection workshops for microservices (SQL, NoSQL, Amazon S3)
Modeled and designed a PostgreSQL Docker instance with liquibase scripts for Git pipeline deployment
Refactored mass data export interfaces and developed PL/SQL packages
Developed PL/SQL packages for REST-service communication and SOAP data conversion
Supported cloud migration of Oracle databases to AWS RDS with migration scripts
Developed and refactored PL/SQL functions/packages for performance and business logic
Planned and prepared new database schemas using execution plan analysis and AWR metrics

Jan 2012 - Dec 2017

6 years

2nd/3rd-Level Support

Analyzed application and data errors
Designed and implemented necessary adjustments using PowerBuilder, Oracle 11g/12c and PL/SQL

Jan 2011 - Dec 2017

7 years

PowerBuilder Application Developer

Developed and enhanced PowerBuilder applications for automated import of IATA SSIM flight schedule data and proprietary airline formats into Oracle databases

Jan 2011 - Dec 2017

7 years

Report Developer

Developed and maintained complex reports using Crystal Reports and Oracle 11g/12c
Created SQL queries and PL/SQL functions for report data
Designed and formatted reports in Crystal Reports

Jan 2010 - Dec 2021

12 years

Database Application Support & Development

Modeled data and developed forms and user interfaces in MS Access applications for clients in trade, banking and consulting
Created reports and performed data analysis using MS Access (up to Access 2019), VBA, ODBC and MS Office

Jan 2010 - Dec 2017

8 years

Logistics-SAP Interface Developer

Developed PowerBuilder Windows services to create and process interface files for data exchange with SAP
Imported SAP IDOC formats (LOIBOM, MATMAS) into Oracle applications
Generated SAP IDOCs (ORDERS, MBGMCR, ALEAUD) from Oracle data
Imported SAP master data in XML format into Oracle databases

Jan 2010 - Dec 2017

8 years

Production Planning Application Developer

Developed modules for a production planning application in the aviation sector using PowerBuilder (10.5, 11.5) and Oracle 11g/12c
Implemented GUIs, business logic and reporting features

Summary

More than 20 years of experience in database development

Specialist in performance optimization of Oracle databases

Database architect

Skills

Performance Analysis And Performance Tuning Of Oracle Db
Database Architecture And Data Modeling
Support And Maintenance Of Database Applications
Automation Of Database Processes
New Development/refactoring Of Complex Database Queries
Design And Implementation Of Interfaces
Pl/sql
Programming Languages: Pl/sql, Sql (Expert)
Powerbuilder, Powerscript (Expert)
Ruby (Very Good)
Shell (Expert)
C, C++ (Very Good)
Relational Databases: Ms Access (Since Access 97) (Very Good)
Oracle (11, 12, 18, 19) (Expert)
Postgressql (Since 10.12) (Expert)
Mysql (Very Good)
Amazon Aurora (Expert)
Amazon Rds (Expert)
Nosql Databases: Mongodb (Very Good)
Amazon Documentdb (Very Good)
Operating Systems: Windows 7/10 (Very Good)
Linux (Various Distributions) (Very Good)
Products: Crystal Reports (Very Good)
Toad For Oracle (Very Good)
Sql Developer (Very Good)
Liquibase (Very Good)
Docker (Very Good)
Svn (Very Good)
Git (Very Good)
Artifactory (Very Good)
Methodology: Scrum
Scaled Agile Framework (Safe)
Kanban
Certified Safe Practitioner
Cloud Products: Awszoifabdb
Aws Technical Professional

Languages

German

Native

English

Advanced

Education

Oct 1996 - Jun 2001

TU Darmstadt

Computer Science · Darmstadt, Germany

Certifications & licenses

AWS Technical Professional

AWS

Certified SAFe Practitioner

Need a freelancer? Find your match in seconds.

Similar Freelancers

Discover other experts with similar qualifications and experience

Interim Consultant for Oracle Database Migrations to the AWS Cloud

Operation and Maintenance of Oracle Middleware Products

Architect/Software Developer/Infrastructure

Oracle Project Management and DBA

Carsten Leschik

Business / Functional Analyst and Oracle Developer DWH

Rolf Gardewischke

Developer & Designer

BI consultant

DevOps Engineer in the DevOps Team

Support/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD

Joachim Bleichert

Further development and maintenance of a company-wide monitoring database

Jakub Szepietowski

Oracle Consultant

Jörg Trappschuh

Database Expert and Software Developer

Oracle Developer

Architect & Technical Team Lead & Senior Developer

Technical Product Owner

Florian Fladung

Senior Backend Developer

Software Developer

Christoph Wagner

System Architect / System Engineer / Programmer

Nikhil Gyamlani

Co-founder / Solution Architect

Senior Backend Developer

Database Architecture for PostgreSQL

Christian Hacker

Qualifications Profile

Co-founder & CEO

Embedded Fullstack Developer

Robert Raźniewski

Software Developer

Michael Pförringer

Setup Azure cloud, Java development, CI/CD pipelines

Architect / Senior Consultant

Data Warehouse Consultant (Development and Analysis)

Exasolution DBA

SSIS Development