We provide IT Staff Augmentation Services!

Oracle Developer Resume

SUMMARY

  • Over 14 years of experience in Oracle Developer and more than 5 years of Database Administration/ Architect on production and development databases and expertise on Unix/Windows Administration.
  • Expert on Database Backup/Restore/Import Export/ Refresh/ Data Pump.
  • Experience with Backup and Disaster Recovery using export, data pump, RMAN and VERITAS Netbackup.
  • Expertise on Database upgrade from 9i to 10g and 10g to 11g.,12c
  • Development experience with Oracle/Developer2000.
  • Expertise on SQL and PL/SQL programming on OEM.
  • Pioneer in working with PL/SQL including Procedures, Functions, Cursors and Triggers.
  • 24X7 production database supports on Window, UNIX, Linux and Solaris environment.
  • Experience on database patch certification and installation.
  • Experience on UNIX/SOLARIS/LINUX
  • Experience with SQL*Server 2008
  • Experience in Administration activities such Installation, Configuration, Client/server connectivity, Creating and Managing Repositories, Users, User Groups, Folders, User Roles, Profiles and Privileges.
  • Experience on creating index and stats on objects.
  • Experience in capacity planning and space management.
  • Good consulting and communication skills, knowledge of client - relationship building techniques and project methodologies with good team building skills.

TECHNICAL SKILLS

Operating Systems: Win XP, Win-2000 client/server version 5, Win NT 3.1, 3.5, 3.51, 4.0, Win 95/98, Unix Sun Solaris, UNIX system V, Unix Red Hat Linux, Unix HP 9000, MS-DOS and Workstation, MVS mainframes

Technologies: XML, XSL, XSLT and HTML

Languages: C, C++, VBScript, JAVA, JavaScript, SQL, PL/SQL, HTML, DHTML, Perl, Java, Pro*C

Databases: ORACLE 5, 6, 7, 8, 8i, 9i, 10g,11g,12c Informix, Ingress, MS Access, SQL Server

GUI’ S: VISUAL BASIC 6.0, Power Builder6.0, Informix New Era, Oracle Developer/2000

Database Utilities: Oracle Form and report 11gr2 (Developer/2000, form 6i, report 6i) SQL*Reports*WRITER, SQL*PLUS, SQL*WRITER, SQL*LOADER, ORACLE DESIGNER, ORACLE 9IAS,Oracle ADF

PROFESSIONAL EXPERIENCE

Oracle Developer

Confidential

Responsibilities:

  • Rewrite the PL/SQL procedure code to create an obligation for ORSI. Fixed errors of procedure. Wrote the flowcharts for the packages named EAI FM040 CREATE AND EAI FM040 close.
  • Worked to identify the dependences for the following applications: Dapps, EOD, Employee Interface, NFC, ESPS,ICDS,OAR+.
  • Wrote a lot of extraction using XML. Review the XML oracle training.
  • Wrote the SQL script files to find the objects such as Procedures, Funcs, Views, Tables ect.
  • Wrote Oracle sql script files to find all the privileges for the tables.
  • Create .sql files of the objects such as tables, packages and views for seven applications: ESPS, GI, ER601, ITBP, OAR, CUR, and ICDS for data modeling using TOAD Data Modelers.
  • Work with supervisor for the Cron jobs files to find out what the shell scripts did on the above seven applications. Fix the connection of COMPFDR1.
  • Assist my Leader to connect to COMPFDR1 of TOAD.
  • Fix the errors from the sample oracle xml codes.
  • Write the extract XML code for a lot of services. Intalling JAVA JRE 1.7.0.7.2. Learn SOA online. Completed the Data Stewardship Training.
  • Completed install JAVA JRE 1.7.0.7.2.
  • Completed to test the five applications named CUR, ESPS,GI, ICDS AND OAR+.
  • Installed the oracle Web Logic Forms and Reports 11gr2.Worked with TOAD and oracle developer. Work with form and report 11gr2 to fix the errors .
  • Work with re-engineering and analyst for SAFER,TRANSPORTATION and ESPS applications.
  • Created more than 8 SQL script files to do migration for 7 applications such as ESPS,ICDS,OAR+, ITBP,ICDS ect…Worked unix/linux shell scripting.
  • Conversed oracle Form to backend PL/SQL for developing ADFs’ applications.
  • Wrote the docs for SOA OAR,ESPS, ICDS, ITPP’s applications..ect.
  • Wrote table triggers for updating, inserting and deleting.
  • I have experience working in 3-4 TB of data and extensive Mortgage Industry experience.
  • Create a lot of BI publisher reports of oracle 11g release 2.

Oracle DBA

Confidential

Responsibilities:

  • Wrote script SQL file to drop all the rows of tables, cleaned the schema such as objects procedures, views, synonyms, type, functions, index, database links ect..
  • Fix errors regarding import pump script file. Grant privilege to DBA users, roles and sysdba.
  • Help Team Leader to do the migration Oracle 10gr2 to oracle 11gr2 under os window 2008 r2. /Sun Solaris.

Oracle DBA/Sr. PL/SQL Programmer

Confidential, Reston, VA

Responsibilities:

  • Installed Oracle application testing suite version 3.90.0286 (OATS).
  • Test the financial application call PMS (Payment Management System).
  • Upgrade the IE from 7 to 8.
  • Managed and monitor oracle database version 11 release 2 using OEM.
  • Provide production management and support for Oracle products installed for hosted customers. Provide 24x7 coverage outside of business hours
  • Fix all the errors from creating load scripts and open scripts.
  • Worked with 508 compliance
  • Modified the application using PL/SQL. To modify triggers, functions and packages etc...
  • The databases were oracle 10g and 11g /operating systems are window XP, 2003, 2008 and HP-UNIX.

Oracle DBA/ Sr. PL/SQL

Confidential, Arlington, VA

Responsibilities:

  • Created 4 profiles Oracle 11g R2. Fixed errors Oracle 11gR2
  • Very familiar with PL/SQL on OEM
  • Managed a lot of servers: Informix 9, 10; Oracle 10g and 11gR2
  • Monitored Oracle 11g using TOAD, SQL * SERVER
  • Installed Oracle 8i at client site and the server site Oracle 11g R2.
  • Installed SQL*Developer
  • Very familiar with Meta link and created SR when the problems arises.
  • Applied Patch for all the Oracle servers
  • Applied JAVA Patch for Oracle servers.
  • Wrote procedures, functions and packages in PL/SQL and modified the financial application
  • Fix the SQL statement ‘s errors for tuning the JDIS database version 11 release 2 in order to make the JDIS database faster than ever
  • Disabled a lot of Informix users and Oracle user.
  • Created a lot new users for the client
  • Fixed Oracle Database errors at the tested servers
  • Wrote the report for making sure all the Oracle Servers are up and running. If they are not up and running then troubleshoot it and make it run
  • Experience with LINUX/SOLARIS.
  • Experience with UNIX shell script
  • Experience with PL/SQL such as wrote the functions, triggers, packages.

Oracle DBA/Developer

Confidential

Responsibilities:

  • Wrote packages for whole application and installed oracle application server oracle 10g,
  • Oracle enterprise manager, wrote the schema script files for tables, index and unique
  • Constraints.
  • Perform development or maintenance work on the platform artifacts to maintain currency with corporate standards and client needs.
  • Conduct or perform data modeling exercises in support of specific needs for data, reports, or analyses.
  • Review methodology and developing/testing procedures for loading data into database to ensure quality of data.
  • Maintain common data dictionaries, including such elements as business names, definitions, allowable values, business rules, and the like.
  • Contribute to systems or applications development cycle, providing guidance for the forms in which data are stored, retrieved, and represented.

Hire Now