I will fix and optimize oracle plsql and sql server stored procedures
Senior Software Architect, Oracle and SQL Server, DOT NET, Python Trading Bots
About this Gig
Slow procedures? Wrong results? Errors in production?
I'm a Senior Software Architect with 12+ years on core banking databases (Oracle and MS SQL Server), where correctness and speed both matter.
What I do:
- Fix bugs in stored procedures, functions, triggers and packages
- Tune slow queries using execution plans, indexing and rewrites
- Write new PL/SQL or T-SQL logic from your requirements
- Review cursors, loops and exception handling
- Data migration and transformation scripts
What you get:
- Working, tested SQL with comments
- A before/after timing note for tuning work
- A short explanation of what changed and why
Please message me before ordering with your database version and the object(s) to fix.
Database type:
Centralized database
•
Relational database
Platform:
MS SQL
•
Oracle
•
PL/SQL
•
SQL Server
Expertise:
Data warehouse
•
Design
•
SQL
•
Performance
My Portfolio
FAQ
Which database versions do you support?
Oracle 11g to 23ai and SQL Server 2012 to 2022.
Do you need access to my database?
No. Scripts, a schema and sample data are enough. Remote access is optional.
Is my data safe?
Yes. Masked or sample data works fine, and I don't keep copies after delivery.
