Oracle Developer/Performance Tuning Expert Resume

SUMMARY:

Track record of success in developing and improving diverse Oracle systems
Results - driven and accomplished Oracle specialist with 15+ years of experience planning, developing and implementing system solutions for a diverse client base. Demonstrated expertise in performance tuning, data modeling, application design and troubleshooting Oracle databases. Able to introduce advanced Oracle functionality to increase reliability and streamline system operations. Proven s in effectively collaborating with various technology teams within fast-paced, deadline-driven environments. Able to complete multiple tasks effectively and master complex software, tools and business concepts. Exemplary interpersonal skills used to interact and build strategic alliances with clients, senior leaders, associates, vendors and third parties.
Oracle Database Design Problem Solving
Oracle Performance Tuning Database Management
Systems Analysis Troubleshooting/Resolution

TECHNICAL SKILLS:

Tools: Oracle (V 7.3.4-18); SQL Plus; SQL Developer; Oracle Enterprise Manager; Version Management (SVN/CVS); Bash Scripting (Linux); *NIX operating systems

Languages: Advanced Oracle SQL: Efficient Queries against billions of rows; Multi - Set Operations; Analytic Functions; Hierarchical Queries; Query Hints; SQL Tuning (AWR, ASH, Explain Plan, SQL Trace, TK Prof); Advanced PL/SQL: Conditional Compilation; Collections & Records; Pipelined Functions; Transaction Control; Error Handling; Ref Cursors; Bulk Operations; Autonomous Transactions (seldom used); Advanced Oracle Features: Partitioning; Compression; Index Organized Tables; Auditing; Security; Advanced Queuing; Index Key Compression; Pluggable Databases; Statistics Gathering Strategies; VPD; External Tables/SQL Loader;

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Developer/Performance Tuning Expert

Responsibilities:

Successfully completed and deployed a project to production with no reported production bugs one month ahead of schedule and under budget with an original five-month timeline.
Reduced critical public facing SQL query from 8+ minutes to 8 seconds with 5 minutes’ worth of analysis.
Tasked with improving performance of a program which required 46 hours to complete. With one days’ effort reduced the run time to 6 hours utilizing multiple tuning techniques including a “lateral view”; new feature of 12c in a main query to make query much more efficient.
Addressed numerous SQL’s that were utilizing sub-optimal execution plans and tuned them (query rewrite, better indexes, hints, etc).
Troubleshooting an upgrade issue which traced back to a VPD implementation, advised clients on how best to proceed.

Confidential

Oracle Developer/Performance Tuning Expert

Responsibilities:

Made recommendation to client regarding utilization of Oracle index Key Compression. Analyzed existing system (many hundreds of tables) and determined that the client could save over 200GB of disk space by implementing Oracle Index Key Compression on their existing indexes.
Reduced process run time which exceeded 24 hours to less than 30 minutes by modifying a program’s algorithm; changes required less than one day’s worth of effort.
Completed a gap analysis of many proposed solutions by analyzing existing business and technical documentation and then proposed final solutions following multiple meetings with business and technical personnel.
Identified and expediently resolved an Oracle production bug related to TEMP table space leak in Oracle (version 11.2.0.3).

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

Details available upon request (omitted for brevity)

Confidential

Senior Oracle PL/SQL Team Lead

Responsibilities:

Details available upon request (omitted for brevity)

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship