We provide IT Staff Augmentation Services!

Senior Oracle Pl/sql Developer Resume

Erie, PA

SUMMARY

  • Oracle PL/SQL with 8+ years of experience in Design, data modelling, analysis, performance tuning.
  • 5 years of experience working with Oracle 8i/9i/10g including PL/SQL programming
  • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Solid experience in translating business requirements into creation of Database Objects.
  • Strong Exposure in writing Simple and ComplexSQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
  • Experience in metadata modeling, development of all three layers (Physical, Business Model and Presentation).
  • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Having a good knowledge and experience in STAR Schema, FACT, Dimension tables,
  • Experience in supporting 8 mission critical application, 10 critical application and 7 non critical applications.
  • Experience working in model of Client, vendor & IT management team.
  • Implemented many industry best practise, IT standards, guidelines and process.
  • Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
  • PL/SQL: Strong back - end programming experience using PL/SQL, SQL, HTML, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes - B - tree Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad - hoc queries using SQL.
  • Developed procedure / packages for OLTP, OLAP data warehousing environment.
  • Good experience in Unix Cron jobs, batch processing with highly complex data model.
  • Expert in monitoring query performance using OEM, TOADD.
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Knowledge of architecture/technology needs of the organization based on business priorities, strategies, goals, and economic viability
  • Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
  • Significant experience in 24/7 Production Environment Support.
  • Knowledge on Informatica Power Center

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, C, Shell Programming (Bourne, Korn), Perl Scripting, Visual Studio.NET 2003/2005.

Databases: Oracle 8i/9i/10g/11g, MS SQL Server 2005/2008, MySQL, MS Access.

Reporting Tools: Oracle Forms & Reports 6i/9i/10g, Crystal Reports 8.0, SQL Server Reporting Services (SSRS), SSIS

Tools: TOAD 8.x/9.x, SQL Developer, PL/SQL Developer, Humming Bird 10, F-Secure 5.3, SFTP, Rational Rose, Microsoft Visio, ER-Studio, Erwin, MS Visio, BI, DWB.

DB Utilities: SQL Loader, Export / Import, Data pump, Explain Plan, TKPROF.

Operating Systems: UNIX, LINUX, Sun Solaris 5.X, Windows NT/XP/Vista/7/8.1, Windows 95/98/2000, Windows Server 2003/2008.

PROFESSIONAL EXPERIENCE

Confidential, ERIE PA

SENIOR ORACLE PL/SQL DEVELOPER

Responsibilities:

  • Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
  • Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
  • Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
  • Used SQL loader to load the data from the files provided by the interfacing applications.
  • Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
  • Created partitioned tables and partitioned indexes to improve the performance of the applications.
  • Wrote PL/SQL Database triggers to implement the business rules in the application.
  • Created external tables to handle huge volumes of data which is not used frequently.
  • Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
  • Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.
  • Implemented all modules logic by using Triggers and Integrity Constraints.
  • Good understanding of database objects and ability to triage issues.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Created materialized views required for the application.

Environment: - -Oracle 11g, Toad, PL/SQL, Reports10g, Forms10g, Data Modeling, Data migration, SQL Navigator, Unix Shell Scripting, Window NT, AIX, FTP, SFTP, NDM, PL/SQL Developer, SQL*Loader, Version Control Software CVS, ElemenTool for Production Support.

Confidential, PITTSBURGH

SENIOR ORACLE PL/SQL DEVELOPER

Responsibilities:

  • Developed stored procedures to extract the data from different sources and load it into data warehouse.
  • Analyzing the data and Mapping the data requirements developing Stored Procedures, Functions and Triggers.
  • Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
  • Maintaining daily batch cycle and providing 24 hour production support.
  • Developed Korn shell scripts to kick off back end PL/SQL, SQL programs.
  • Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
  • Utilized SQL*Loader to load flat files into database tables.
  • Created SQL*Loader scripts to load data into temporary staging tables.
  • Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
  • Partitioned tables and indexes for better performance of application
  • Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
  • Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
  • Involved in handling the changes in compiling scripts according to the database changes.
  • Developed reports using complex queries as per client request as a part of production support.
  • Provided on call support, solved the user issues and made necessary changes.
  • Resolving Production severity Issues in time and meeting the SLA.
  • Writing high quality and well documented code according to standards.

Environment: - Oracle 10g, SQL Server Reports 10g, SQL, PL/SQL, Toad, Oracle RDBMS,SQL

Confidential, RALEIGH, NC

ORACLE PL/SQL DEVELOPER

Responsibilities:

  • Support in requirements gathering from the end users
  • Update design documents according to the changes made to the application
  • Designed/developed/Modified tables, views, stored procedures, packages and functions.
  • Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
  • Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
  • Developed various Reports using the BI Publisher.
  • Used SQL loader to load the data from the files provided by the interfacing applications.
  • Created new Procedures, Functions, Triggers, Materialized Views, Packages, Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
  • Created partitioned tables and partitioned indexes to improve the performance of the applications.
  • Wrote PL/SQL Database triggers to implement the business rules in the application.
  • Implemented all modules logic by using Triggers and Integrity Constraints.
  • Good understanding of database objects and ability to triage issues.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Code SQL Stored Procedures and integrated with application
  • Involve in Unit Testing for the application developed using test cases

Environment: - PL/SQL, Oracle 10g, 11g, Java, Unix shell scripting, Oracle Forms, Oracle Reports, SQL Developer, BI Publisher, Informatica Power Center, Eclipse

Confidential

ORACLE PL/SQL DEVELOPER

Responsibilities:

  • Involved in the maintenance and enhancement of the application.
  • Maintaining Logical and Physical structure of the database.
  • Creating table spaces, tables, views, scripts for automatic operations of the database activities.
  • Coded various stored procedures, packages and triggers to in corporate business logic into the application.
  • Used the technical document to design the database tables.
  • Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping
  • Created control files for SQL*Loader.
  • Gather Database and User Level Statistics and Analyze Overall System Performance.
  • Designed/developed tables, views, various SQL queries, stored procedures, functions.
  • Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
  • Develop UNIX shell scripts to administer the system.
  • Extensively worked with Dynamic SQL, Composite data types & Global Temporary tables.
  • Responsible for purging and archiving the production databases.
  • Used UTL JOB to automate the PL/SQL procedures and packages.
  • Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions.
  • Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.
  • Communicate issues and progress to project manager.
  • Performed logical backup using export and import utilities.
  • Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
  • Involved in Unit Testing Stored Procedures and Functions.

Environment: - PL/SQL, Oracle 10g, 11g, Java, UNIX shell scripting, Oracle Forms, Oracle Reports, SQL Developer, BI Publisher, Informatica Power Center, Eclipse

Hire Now