Database development professional with extensive experience in designing, implementing, and optimizing database systems using Oracle and MySQL. Skilled in creating and managing complex stored procedures, functions, and triggers. Adept at query optimization, data migration, and performance tuning. Detail-oriented team player with strong analytical skills, capable of handling multiple projects with precision and efficiency. Proven ability to translate business requirements into effective database solutions, ensuring high performance and reliability..
Overview
2
2
years of professional experience
2
2
Certifications
Work History
Database Developer
Eskadenia Software Company
11.2022 - Current
Develop and optimize stored procedures, functions, triggers, and packages using PL/SQL and MySQL procedural languages.
Strong expertise in dynamic SQL for flexible query generation and complex reporting needs.
Advanced SQL tuning, including optimization techniques such as indexing, query refactoring, and execution plan analysis.
Extensive experience in database refactoring to enhance performance and scalability.
Proficient in data migration, ensuring seamless transitions between database systems with minimal downtime.
Developed scripts and processes for data integration and maintenance.
Experience with PL/SQL collections (nested tables, VARRAYs, associative arrays) for efficient data handling.
Built databases and table structures for web applications.
Expertise in BULK COLLECT and FORALL statements to optimize batch processing and improve performance.
Proficient in exception handling mechanisms to ensure robust error handling and maintain data consistency.
Strong experience in implementing complex business logic through PL/SQL triggers, procedures, and packages.
Skilled in managing autonomous transactions in PL/SQL for independent transaction control within larger processes.
Experience with cursor management and ref cursors for dynamic query execution and improved resource utilization.