We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Culver City, CA

SUMMARY:

  • More than 12 years of experience with PL/SQL and ANSI SQL Development, SQL Database Development, Dynamic SQL
  • More than 10 years of experience in Oracle Database (Table, views, indexs, sequences, synonyms,).
  • Perform Performance tuning of complex SQL queries (Explain Plan, Table Partition, Hints, Indexes).
  • More than 10 years’ experience with PL/SQL skills, experience in an Oracle 10g, 11g and 12g
  • Experience with Oracle OFSAA application
  • 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 T - SQL scripts for SQL Server.
  • Experience with Analytics, SAS (Statistical Analytical System).
  • Extensive experience in porting applications including Informix to Oracle.
  • Experience with Oracle Forms & Reports Developer.
  • Experience with tableau
  • Participated in requirements and design of Data Warehouse Architecture.
  • Experience with ETL concepts. ( ODI & Informatica )
  • Installation, administration and maintenance of Oracle 11g.
  • Experience with Data Management, Data Marts, Data Mapping, Data Modeling.
  • Experience with SQL*Loader, TOAD, PL/SQL Developer.
  • Experience with data modeling tools like ERWIN.
  • Experience with Oracle OLTP and OLAP Data Warehouse
  • Understanding of Snowflake and Star Schema design strategies and process.
  • Knowledge of Java and WEB Services.
  • Experience UNIX and Unix shell scripting and Windows, Linux experience.
  • Experience with Asp.net Net C#, Windows Forms, Visual Studio 2010.
  • Excellent understanding of Entity Relationship Diagrams (ERDs) and the translationf business requirements into them.
  • Installing, operating and maintenance of LAN H.W & S.W.
  • Have background in Project Costing and Billing.
  • Experience with Data immigration to oracle
  • Experience with Oracle DRM (Data Relationship Management).
  • Experience with Agile/ Scrum

TECHNICAL SKILLS:

Oracle 10g/11g/12g, PL/SQL, T-SQL, UNIX, LINUX, Windows.

PROFESSIONAL EXPERIENCE:

Confidential, Culver City, CA

Oracle PL/SQL Developer

Responsibilities:

  • Perform Performance tuning of complex SQL Queries(Table partition, hints, indexes).
  • Perform and maintain the database design Create database objects (Schemas, table space etc.) and Write database procedures, functions, triggers Packages, Views, Cursors and Triggers
  • Perform and maintain database security (create and maintain users and roles, assign privileges)
  • Work with Oracle 11g
  • Write Code Migration experience.
  • 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.
  • Working with SQL Plus and Toad and PL/SQL developer.
  • Working on Data Modeling and OLAP technology.
  • Working with ETL.
  • Optimize Stored Procedures for better performance.
  • Perform daily DBA tasks (export, import, review PL/SQL code, deploy releases, …etc)
  • Working with Data Modeling, Data source mapping, Production process troubleshooting,
  • Working with Unix shell scripting
  • Working with Agile/ Scrum

Confidential, San Francisco, CA

Oracle PL/SQL Developer

Responsibilities:

  • Understand project requirements and develop design specifications.
  • Perform and maintain the database design Create database objects (Schemas, table space etc.) and Create object ( procedures, functions, triggers, Exception, Packages, Views, Cursors and Triggers)
  • Perform initial design reviews and recommend improvements
  • Write Code Migration experience.
  • Working with SQL Plus and Toad and PL/SQL developer.
  • Working on Data Modeling and OLAP technology & ETL. ( ODI )
  • Working on oracle 11g and 12g
  • Perform daily DBA tasks (export, import, review PL/SQL code, deploy releases, …etc)
  • Working with Agile/ Scrum
  • Assist in system integration and acceptance testing and perform bug fixes less experienced staffs on programming guidelines
  • Unix/Linux Shell scripting and Windows batch scripts, FTP and SFTP protocols and data transfer processes
  • Provide technical assistance to other Developers as needed
  • Working with Autosys
  • Woring on Oracle OFSAA application
  • Working with Installation< -- -->, configuration, patching and upgrading of Tableau tool across the environments

Confidential

Oracle PL/SQL Developer Lead

Responsibilities:

  • Understand project requirements and develop design specifications.
  • Perform and maintain the database design Create database objects (Schemas, table space etc.) and Create object ( procedures, functions, triggers, Exception, Packages, Views, Cursors and Triggers)
  • Perform and maintain database security (create and maintain users and roles, assign privileges)
  • Perform initial design reviews and recommend improvements
  • Write Code Migration experience.
  • Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
  • Working with SQL Plus and Toad and PL/SQL developer.
  • Working on Data Modeling and OLAP technology & ETL. ( ODI )
  • Write clear codes and prepare coding documentations
  • Perform daily DBA tasks (export, import, review PL/SQL code, deploy releases, …etc)
  • Working with Agile/ Scrum
  • Assist in system integration and acceptance testing and perform bug fixes less experienced staffs on programming guidelines
  • Provide technical assistance to other Developers as needed
  • Working with tableau migration and scheduling.

Confidential, Germantown, MD

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Perform Performance tuning of complex SQL Queries(Table partition, hints, indexes).
  • Perform and maintain the database design Create database objects (Schemas, table space etc.) and Write database procedures, functions, triggers Packages, Views, Cursors and Triggers
  • Perform and maintain database security (create and maintain users and roles, assign privileges)
  • Work with Oracle 10g and 11g and with SQL Server 2005 and 2008.
  • Installed, configured, and maintained Oracle 10g and 11 g and Upgraded from Oracle 10g to 11g.
  • Write Code Migration experience.
  • 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.
  • Working with SQL Plus and Toad and PL/SQL developer.
  • Working on Data Modeling and OLAP technology.
  • Working with ETL. ( ODI )
  • Optimize Stored Procedures for better performance.
  • Perform daily DBA tasks (export, import, review PL/SQL code, deploy releases, …etc)
  • Working with Data Modeling, Data source mapping, Production process troubleshooting,
  • Working with Unix shell scripting
  • Working with Agile/ Scrum
  • Working on Oracle OFSAA application

Confidential, Cary, NC

Sr. Oracle PL/SQL Developer

Responsibilities:

  • Perform Performance tuning of complex SQL Queries(Table partition, hints, indexes)
  • Develop PL/SQL Procedures, Functions, Packages, Views, Cursors and Triggers with SAS
  • Working on Oracle 10g and 11g and with SQL Server 2005 and 2008.
  • Installed, configured, and maintained Oracle 10g and 11 g and Upgraded from Oracle 10g to 11g.
  • Write Code Migration experience
  • 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.
  • Working on SQL Plus and Toad and PL/SQL developer.
  • Working on data modeling and OLAP technology.
  • Optimize Stored Procedures for better performance.
  • Working on UNIX and Windows, Linux.
  • Working with Data Modeling, Data source mapping, Production process troubleshooting,
  • Perform daily DBA tasks (export, import, review PL/SQL code, deploy releases, …etc)

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

Confidential, Cairo, Egypt

Lead Oracle PL/SQL Developer / DBA

Responsibilities:

  • Perform PL/SQL development for a variety of projects including sales calculations, update tables, query tables and triggers for integration.
  • Develop a lot of PL/SQL Procedures, Functions, Packages and Triggers using the new Oracle features like autonomous transactions, start with connect by, analytical functions, etc.
  • Convert code from Oracle to SQL Server.
  • Analyze problems and create solutions for very complex performance tuning situations.
  • Create and modify UNIX Shell Scripts.
  • Create PL/SQL scripts for Oracle and T-SQL scripts for SQL Server.
  • Perform Data Modeling and Design
  • Start to learn Java (Attended training, understood OOB concepts and started to write application).
  • Work in Data Warehouse environment and writing PL/SQL code

Confidential, Cairo, Egypt

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.
  • Identify any issues as soon as possible in the planning process and resolve them.
  • Participate in analysis, modeling, and design.
  • Work with Java and WEB Services.
  • 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.
  • Working on UNIX and Windows, Linux.
  • Lead Development team.

Hire Now