Oracle Developer

Oracle Developer — InnovaTech Solutions

Chicago, IL | June 2023 – Present

• Optimized PL/SQL packages, stored procedures, and triggers for an enterprise ERP system, improving database query execution speed by 35% and reducing CPU utilization from 85% to 50%.
• Engineered 14 customized Oracle APEX web applications and interactive reports, which automated key billing workflows and reduced administrative data entry tasks by 45 hours per month.
• Led the database migration of 3.2M customer records from legacy SQL Server to Oracle 19c, ensuring 100% data integrity and achieving zero business downtime during the 48-hour cutover window.
• Conducted query optimization and index tuning on high-frequency tables containing over 500M rows, resulting in a 40% reduction in nightly batch processing runtime across 12 critical modules.

Associate Oracle Developer — CloudSphere Technologies

Chicago, IL | June 2021 – May 2023

• Designed and maintained 45 complex SQL queries, views, and materialized views, improving report generation performance by 28% and supporting 15 business analyst teams across the company.
• Wrote and tested UNIX shell scripts to automate 8 daily database backup checks and data loading operations, reducing manual monitoring requirements by 12 hours per week for operations.
• Collaborated with a team of 6 application developers to design and refine database schemas, reducing application-to-database connection times by 20% over a 6-month development cycle.
• Troubleshed and resolved 110+ database-related support tickets, achieving a 94% on-time SLA resolution rate and reducing the backlog of open database bugs by 35% in a 12-month period.

SQL, PL/SQL, Oracle Database 19c, Oracle APEX, Oracle Forms, Oracle Reports, Database Tuning, Query Optimization, ETL, UNIX Shell Scripting, Java, Git, JIRA

Financial Data Warehouse Migration

Role: Lead Database Developer

Tools: Oracle 19c, PL/SQL, SQL Developer, UNIX Bash

Directed the ETL pipeline design to migrate 5TB of historical transaction data, reducing nightly data loading runtime by 32% and achieving zero data loss.

Custom APEX Inventory Tracker

Role: Oracle APEX Developer

Tools: Oracle APEX, PL/SQL, JavaScript, CSS

Built a customized inventory tracking web application for 150 regional users, which increased inventory tracking accuracy by 25% and saved 18 hours of weekly manual work.

• Oracle Database SQL Certified Associate (2021)
• Oracle Database PL/SQL Developer Certified Professional (OCP) (2023)

• Languages: English (Native), Polish (Conversational)
• Volunteer Work: Technical mentor for regional database administration bootcamps (2023–present)
• Availability: 2 weeks notice