Senior Oracle PL/SQL Developer Resume LAKE OSWEGO, OR - Hire IT People

OBJECTIVE

To work as part of a team in a stimulating and rewarding environment where innovative solutions are encouraged & which will utilize my skills, abilities and education to maximum extent and provide me with an opportunity to enhance my skills.

SUMMARY

Having 9.11 years of experience analysis, development, Tuning, implementation and production Support of client/server Databases and applications.
Sound skills in tuning the SQL queries and PL/SQL programs to achieve the top Performance.
Sound capabilities and solid experience of creating DB Objects, PL/SQL packages, Procedures, Functions, Triggers and scheduled jobs to manipulate and migrate complex data sets in Oracle Databases.
Experience in advanced PL/SQL constructs like Oracle supplied Packages, Nested tables, arrays, Records, Types, Dynamic SQL.
Extensive knowledge on oracle dictionary views and standard sys packages
Experience in Query Optimization, Debugging, Tuning and improvising database performance, using the Oracle AWR, ADDM, SQL Tuning Advisor, Hints, Explain plans, Bulk collects, bulk binds, TKPROF, SQL Trace, SQL Profiler and Indexing etc.
Migrated data to and from Text file to Oracle database using SQL Loader, TOAD IMPORT/EXPORT utilities and UTL files.
Worked extensively in Oracle SQL, PL/SQL and UNIX shell script.
Analyzing software requirements and developing effective solutions and procedures
Participated in different phases of the software life cycle beginning with requirement analysis, approach, design, development, unit test, bug fixing and support phases
Hands on experience in project life cycle including Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation & Support.
Excellent team player with problem - solving and trouble-shooting capabilities.
Quick learner, highly motivated, enthusiastic team player and ability to work effectively in a fast paced environment
Performing database refreshes for UAT/DEV database.
Good Knowledge in UNIX shell script.

TECHNICAL SKILLS

Databases: Oracle 7.x/8.x/9.x,10g

Languages: SQL & PL/SQL, Unix, ORACLE SQL Tuning, PL/SQL Performance Tuning

Utilities: PL/SQL Developer, Toad, Remedy

Operating Systems: Windows 95/98/NT 4.0/2000, AIX, Sun Solaris

Scripting Languages: JavaScript, Shell Script

PROFESSIONAL EXPERIENCE

Confidential, LAKE OSWEGO, OR

Senior Oracle PL/SQL Developer

Responsibilities:

Used advanced Application oriented debugging and performance techniques to Implement the performance, functional testing platforms and to increase the performance of current application batch jobs
Hand on experience in In-depth analysis of the intensive resource SQL’s and PL/SQL Loop and switch context over head
Extensive experience in implementing the partition strategies(including the parallel approach) by analyzing the current database activity and application code
Ripped off several Expensive loops and migrated the logic to individual SQL’s by using advanced SQL concepts(Like merge, insert all, Global temporary tables, Parallel PL/SQL, hints and analytical functions) in order to utilize the oracle and hardware process effectively to get the desired performance
Designed and implemented functional testing environment to test the functionality of the application after restructuring the current SQL’s and PL/SQL code.
Designed and implemented Performance testing environment to test the performance increase when compared to the base line existing code.

Environment: Windows server 2008, Oracle 10g, SQL Server 2005,PL/SQL Developer, Performance Tuning Techniques.

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

Used advanced Application oriented debugging and performance techniques to Implement the performance, functional testing platforms and to increase the performance of current application batch jobs
Hand on experience in In-depth analysis of the intensive resource SQL’s and PL/SQL Loop and switch context over head
Designed and implemented functional testing environment to test the functionality of the application after restructuring the current SQL’s and PL/SQL code.
Designed and implemented Performance testing environment to test the performance increase when compared to the base line existing code.

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

Hand on experience in In-depth analysis of the intensive resource SQL’s and PL/SQL Loop and switch context over head
Designed and implemented functional testing environment to test the functionality of the application after restructuring the current SQL’s and PL/SQL code.
Designed and implemented Performance testing environment to test the performance increase when compared to the base line existing code.

We provide IT Staff Augmentation Services!

Senior Oracle Pl/sql Developer Resume

Lake Oswego, OR

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship