Matthias Barfknecht - Database Developer / Database Architect

Q: Where is Matthias based?

Matthias is based in Aschaffenburg, Germany and can operate in on-site , hybrid , and remote work models.

Q: What languages does Matthias speak?

Matthias speaks the following languages: German (Native), English (Advanced) .

Q: How many years of experience does Matthias have?

Matthias has at least 16 years of experience. During this time, Matthias has worked in at least 7 different roles and for 1 company . The average length of individual experience is 2 years and 4 months . Note that Matthias may not have shared all experience and actually has more experience.

Q: What is Matthias's latest experience?

Matthias's most recent position is Database Developer / Database Architect at Freelancer .

Q: What companies has Matthias worked for in recent years?

In recent years, Matthias has worked for Freelancer .

Q: Which industries is Matthias most experienced in?

Matthias is most experienced in industries like Information Technology , Banking and Finance , and Professional Services . Matthias also has some experience in Retail and Aerospace and Defense .

Q: Which business areas is Matthias most experienced in?

Matthias is most experienced in business areas like Information Technology , Business Intelligence , and Supply Chain Management .

Q: Which industries has Matthias worked in recently?

Matthias has recently worked in industries like Banking and Finance , Professional Services , and Retail .

Q: Which business areas has Matthias worked in recently?

Matthias has recently worked in business areas like Information Technology and Business Intelligence .

Recommended expert

Aschaffenburg, Germany

Experience

Jan 2017 - Present

9 years 3 months

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

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Information Technology, Banking and Finance, Professional Services, Retail, and Aerospace and Defense.

Information Technology

Banking and Finance

Professional Services

Retail

Aerospace and Defense

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Business Intelligence, and Supply Chain Management.

Information Technology

Business Intelligence

Supply Chain Management

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

Statistics

Experience

Total positions 7

Experience in Information Technology 16 y

Avg length 8 y 1 m

Longest experience 11 y 11 m

Expertise

Recent roles Database Developer / Database Architect, 2nd/3rd-Level Support, PowerBuilder Application Developer

Main industries Information Technology, Banking and Finance, Professional Services

Main business areas Information Technology, Business Intelligence, Supply Chain Management

Qualifications

Certifications earned 2

Profile

Created

September 2025

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Matthias based?

Matthias is based in Aschaffenburg, Germany and can operate in on-site, hybrid, and remote work models.

What languages does Matthias speak?

Matthias speaks the following languages: German (Native), English (Advanced).

How many years of experience does Matthias have?

Matthias has at least 16 years of experience. During this time, Matthias has worked in at least 7 different roles and for 1 company. The average length of individual experience is 2 years and 4 months. Note that Matthias may not have shared all experience and actually has more experience.

What roles would Matthias be best suited for?

Based on recent experience, Matthias would be well-suited for roles such as: Database Developer / Database Architect, 2nd/3rd-Level Support, PowerBuilder Application Developer.

What is Matthias's latest experience?

Matthias's most recent position is Database Developer / Database Architect at Freelancer.

What companies has Matthias worked for in recent years?

In recent years, Matthias has worked for Freelancer.

Which industries is Matthias most experienced in?

Matthias is most experienced in industries like Information Technology, Banking and Finance, and Professional Services. Matthias also has some experience in Retail and Aerospace and Defense.

Which business areas is Matthias most experienced in?

Matthias is most experienced in business areas like Information Technology, Business Intelligence, and Supply Chain Management.

Which industries has Matthias worked in recently?

Matthias has recently worked in industries like Banking and Finance, Professional Services, and Retail.

Which business areas has Matthias worked in recently?

Matthias has recently worked in business areas like Information Technology and Business Intelligence.

What is Matthias's education?

Matthias attended TU Darmstadt for Computer Science.

Does Matthias have any certificates?

Matthias has 2 certificates. These include: AWS Technical Professional and Certified SAFe Practitioner.

What is the availability of Matthias?

Matthias is immediately available full-time for suitable projects.

What is the rate of Matthias?

Matthias's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.