Summary
Highly skilled PL/SQL Developer with over 6 years of experience specializing in the design, development, and optimization of complex Oracle database solutions. Proven ability to enhance data integrity, system performance, and operational efficiency through robust SQL and PL/SQL programming. Adept at the full software development life cycle, from requirements gathering to deployment and maintenance in fast-paced environments.
Experience
Senior PL/SQL DeveloperGlobalTech Solutions
- Optimized complex PL/SQL packages and procedures, reducing query execution times by an average of 30% for critical business reports.
- Led the migration of legacy data from Oracle 12c to 19c, ensuring seamless data integrity and zero downtime for over 50 production applications.
- Developed and maintained over 20 ETL processes using Oracle Data Integrator (ODI), improving data loading efficiency by 25% and supporting daily data warehouse updates.
- Collaborated with cross-functional teams to design and implement new database schemas and stored procedures, supporting the launch of 3 major product features within tight deadlines.
- Mentored junior developers on best practices for SQL and PL/SQL coding, contributing to a 15% increase in team code quality metrics.
PL/SQL DeveloperDataWorks Inc.
- Developed and maintained robust PL/SQL code for backend database systems, handling over 10TB of financial transaction data.
- Implemented performance tuning strategies on SQL queries and indexes, improving system response times for user-facing applications by 20%.
- Automated daily data reconciliation processes using SQL and shell scripting, reducing manual effort by 15 hours per week.
- Created and managed stored procedures, functions, and triggers to enforce data integrity and business rules across multiple applications.
- Assisted in the design and deployment of new data models, ensuring scalability and compliance with industry standards.
Projects
Automated Data Validation Tool
- Developed a PL/SQL-based tool to automate validation of incoming data feeds against predefined business rules, significantly reducing manual data quality checks by 70%.
- Implemented dynamic rule configuration allowing business users to define new validation criteria without code changes, enhancing operational flexibility.
Inventory Management System Backend
- Designed and implemented the Oracle database backend for an inventory management system, supporting over 10,000 product SKUs and millions of daily transactions.
- Created a suite of PL/SQL procedures and functions to manage inventory levels, order processing, and supplier data, improving data consistency by 99.5%.
Oracle Performance Monitor Script
- Developed a set of SQL and PL/SQL scripts to monitor key Oracle database performance metrics (e.g., AWR, ASH, wait events), providing real-time insights.
- Created an automated reporting mechanism to alert administrators of potential bottlenecks, leading to proactive issue resolution and a 10% reduction in critical downtime.
Education
The University of Texas at AustinBachelor of Science in Computer Science
- Graduated Magna Cum Laude with a GPA of 3.8/4.0
- Recipient of the Dean's List for six semesters
- Relevant coursework included Database Management Systems, Data Structures, and Algorithms
Skills
Database Technologies
Oracle Database 19c/12cSQLPL/SQLSQL*PlusTOADSQL Developer
ETL & Data Warehousing
Oracle Data Integrator (ODI)Informatica PowerCenterData ModelingData MigrationETL DevelopmentData Warehousing
Programming & Scripting
Bash ScriptingPython (basic)XMLJSONGit
Tools & Methodologies
JIRAConfluenceAgile/ScrumVersion ControlPerformance TuningUnit Testing