04 / Databases & SQL

Database development and SQL performance

I develop and optimize database logic with a focus on SQL Server, Oracle, PostgreSQL and Informix.

Typical challenges

  • Slow queries or processing routines
  • Complex stored procedures that require maintenance
  • New application-to-database interfaces
  • Data models that need to evolve

Services

  • T-SQL, PL/SQL and stored procedures
  • Query and index analysis
  • Data modeling and integrations
  • Validation, troubleshooting and reporting

Technologies and practical experience

  • SQL Server with T-SQL, stored procedures, views, indexes and performance tuning.
  • Oracle SQL and PL/SQL, together with PostgreSQL and Informix in existing environments.
  • Data quality, data models and reliable SQL interfaces for line-of-business applications.
Example: E.ON

A data matching process was reduced from 12–16 hours to 60–90 minutes; a later local processing step took about ten minutes, excluding upstream Oracle transfer time.