Professional · anonymized
Query optimization and data modeling
SQL queries, stored procedures and relational models on Oracle and PostgreSQL for business-critical processes.
Context
Business-critical processes depended on queries and procedures running on production Oracle and PostgreSQL databases.
Problem
Heavy queries affected the performance of the processes that depended on them.
My role
Query optimization, table modeling and development of stored procedures and functions.
Solution
Review and rewrite of SQL queries, data model adjustments and business logic in stored procedures and functions, running close to the data.
Technical decisions
- Stored procedures for processes that handle many records, avoiding moving data between the database and the application.
- A relational model designed around the business's real queries.
- Changes validated without affecting the production database's performance.
Outcome
Faster, more stable critical processes, with a cleaner database that is easier to maintain.