Oracle PL/SQL Developer Resume Los Angeles, CA - Hire IT People

SUMMARY

10 years of experience in Oracle Development, SQL Database Development.
10 years experience with PL/SQL skills, experience in an Oracle 10g and 11g environments.
3 Years experience with T - SQL scripts for SQL Server.
6 years experience with Oracle database related utilities such as SQL Plus and SQL Loader and Toad.
5 years Perform Performance tuning of complex SQL queries.
Extensive experience in porting applications including Informix to Oracle.
6 Years experience with Oracle Forms & Reports Developer.
Participated in requirements and design of data warehouse architecture and Financial Industry.
Provided root cause analysis and permanent fix of production problems
Installation, administration and maintenance of Oracle 11g
Full life cycle project experience starting from system analysis, system design, system integration, data modeling and control, production system support, programming and training.
Experience with Oracle OLTP and OLAP databases and ETL concepts. understanding of snowflake and star schema design strategies and process.
Worked as Leader and appreciated for excellent people-skills with leadership skills, good team player.
Knowledge of Java and WEB Services.
6 Years experience Unix and Windows, Linux experience.
Installing, operating and maintenance of LAN H.W & S.W.
Giving super for trouble shouting of any problem with computer H.W & S.W.
Have experience with Unix scripting
Have background in Project Costing and Billing.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Oracle PL/SQL Developer

Responsibilities:

Perform Performance tuning of complex SQL queries.
Develop PL/SQL Procedures, Functions, Packages, Views, Cursors and Triggers.
Work with Oracle 10g and 11g and with SQL Server 2005 and 2008.
Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.
Installed the Oracle software using silent feature and also created databases
Supported & maintained the Production/Development databases on various servers
Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
Review scripts from developers before deployment.
Optimize Stored Procedures for better performance.
Worked with Forms & Reports Developer
Worked with Unix and Windows, Linux

Environment: Oracle 9i/10g to 10gR2, SQL Server 2005/2008

Confidential

Oracle PL/SQL Developer

Responsibilities:

Perform daily DBA tasks (export, import, review PL/SQL code, deploy release etc.).
Perform Performance tuning of complex SQL queries.
Performed Data Warehouse using PL/SQL Packages, Views, Cursors, Procedures and Functions.
Write technical design specifications for projects.
Work with System Architect and business to gather data requirements and define system architecture.
Identify any issues as soon as possible in the planning process and resolve them.
Participate in analysis, modeling, and design.
Worked with Forms & Reports Developer
Work with a team to estimate the level effort for the projects.
Worked with Unix and Windows, Linux
Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Environment: Oracle 9i/10g, PL/SQL, UNIX, LINUX

Confidential

Oracle PL/SQL Developer

Responsibilities:

Develop PL/SQL Procedures, Functions, Packages, Views, Cursors and Triggers.
Perform Performance tuning of complex SQL queries.
Write technical design specifications for projects.
Work with System Architect and business to gather data requirements and define system architecture.
Identify any issues as soon as possible in the planning process and resolve them.
Participate in analysis, modeling, and design.
Work with a team to estimate the level effort for the projects.
Perform Export/Import data using Oracle utilities expdp and impdp.
Performed Data Warehouse processing using PL/SQL Packages, Procedures and Functions.
Write efficient SQL queries.
Worked with Unix and Windows, Linuxsss
Lead Development team.

Confidential

Programmer/Analyst

Responsibilities: