Oracle Developer Resume
Suitland, MD
PROFESSIONAL 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/98Unix 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, JavaPro*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, Suitland, MD
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, Arlington, VA
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, Arlington,VA
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.
Oracle DBA/Developer/ Sr. PL/SQL
Confidential, Bethesda, MD
Responsibilities:
- Managed Jr Oracle DBA and mentored.
- Ability to adapt to changing environment and requirements and manage multiple tasks.
- Perform Database Configurations for Oracle on UNIX (Solaris).
- Database creation, maintenance, migration, cloning, and patching
- Database backup, recovery, and repair using RMAN
- Database troubleshooting and problem resolution
- 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
- Responsibilities include: database loading; development and management of operational procedures; environment management; database health (e.g. monitoring, proactive and reactive responses);
- Resource planning; database upgrade planning; backup and recovery strategy planning and implementation;
- Installing database software, maintaining appropriate maintenance levels and tuning.
- Evaluating, recommending, installing and configuring database related software to meet customer requirements
- Experience with UNIX/LINUX/SOLARIS.
- Account creation and management.
- Knowledge of ETL tool.
Environment: Oracle 10g,Oracle 11g, PL/SQL, SQL server, Windows 2003,HP, Linux, Unix, SQL* Loader, Unix system V.,MS Access, Solaris, Perl.
Oracle DBA/Developer/ Sr. PL/SQL
Confidential, MD
Responsibilities:
- Database recover and backup using RMAN
- Knowledge of Mortgage Industry and its practices in sql server
- Create Database link and loading the test data using SQL*Loader
- Performed PL/SQL errors fixes.
- Modified the application using PL/SQL.
- Developed and maintained data dictionaries or repositories(changing the size repository) included name of fields, domains and data type
- Created user documentation for entire application.
- Develop Ad Hoc Reports.
Environment: Win 2000, Oracle 9i, 10g, PL/SQL, TOAD, JavaScript, Pl/SQL, Pro*C, ColdFusion, Perl
Oracle Application Developer
Confidential, Washington, DC
Responsibilities:
- Performed PL/SQL errors fixes. Help them to fix the errors related to modify the application at Telemedicine department using Oracle database 9i, TOAD and OS was Windows 2000
- Wrote the PL/SQL procedures for entire application
Environment: Win 2000, Oracle 9i, 10g, PL/SQL, TOAD, JavaScript, Pl/SQL, Pro*C, ColdFusion
Software Engineer
Confidential, Crystal City VA
Responsibilities:
- Performed data fixes and analyzed the application focusing on logical tables. Help them to fix the errors related to Oracle database 8i.
- Wrote the pl/sql procedure for application
- Ran the virus Norton to avoid the virus from the download files
- Loaded the data into tables using SQL*LOADER
- Modified the HTML files
- Fixed errors regarding to JavaScript files
- Created the users for Oracle Schema
- Deliver metadata and document extract requirements to customers.
Environment: Win XP, Oracle 8i, 10g, Irwin, Perl, Pl/SQL.
Oracle Database Developer/Database administrator
Confidential, Springfield, VA
Responsibilities:
- Installed Oracle 8i database, Oracle Designer, 9iAS application Server at the client and server site under MS/2000
- Database recover, backup and repair using RMAN.
- Develop Ad Hoc Reports.
- Knowledge and experience with data conversion and reverse engineering
- Analyzed development processes for data requirements focusing on logical and physical data modeling in a relational database environment
- Performed data fixes. Analyzed CAD2 application focusing on the functional of the application. Wrote the TAR at Metal ink for database changes required
- Developed and maintained data dictionaries or repositories (changing the size repository) included name of fields, domains and data type
- Generated logical CAD2 and RCS tables by using parts of Oracle Designer 6i such as the Entity Relationship Diagram (ERD); Database Design Transformer (DDT)
- The CAD2 logical tables had the regular data type such as VARCHAR2
- NUMBER, CHAR, DATE.
- The RCS logical tables had the regular data type and BLOB data type
- Loaded the tested data into CAD2 tables and RCS tables using SQL*LOADER. Each table of CAD2 and RCS had one million records
- Wrote PL/SQL with package DBMS BLOB to manipulate the blob data type as well as used Oracle inter Media Relational Interface for the RCS tables.
- Wrote PL/SQL procedure for the single sign on application.
- Created lot of Portlets such as Forms, Reports, Dynamic page using Oracle Web Portal (Oracle 9iAS), Web HTML, JavaScript, and PL/SQL.
- Wrote PL/SQL procedure for creating the forms of the application.
- Utilized HTML, JavaScript, PL, PL/SQL to develop and enhance website design and performance, improve database interaction and validate data
- Created the users for Oracle schema. Fixed errors regarding alter tables(constraints integrities),calculated the size of database, reserved space for exporting and importing whole application
- Performed CAD2 database imports and exports
- Wrote the PL/SQL script files to modify and create the new tables
- Performed the CAD2 application fixes and enhancement
- Wrote the PL/SQL files to fix the data validation/integrity issues
Environment: Oracle 8i, Oracle Designer, Oracle 9iAS, HTML, C++, JAM, Informix, C, 10g, JavaScript, DHTML, PL/SQL, SQL*PLUS, Perl, Window 2000 at client and server site, SQL*LOADER, Pro*C, ColdFusion, sql*server
Systems Analyst/ Oracle DBA
Confidential, Washington, DC
Responsibilities:
- Analyzed, Programmed and tested the new complex Oracle Database application called Individual Training Account (ITA) using Oracle 8i, Developer/2000 Form 6.0,Report 6.0 under client site was window NT version 4.0 and the server site was Sun Solaris
- Reviewed and modified technical documents such as program specification and test plans in Word Perfect. Also modified existing code renovation in Informix 4GL for Y2K Compliance and unit tested the software
- Modified HTML codes
- Converted the documents from Word into Word Perfect. Modified and fixed errors files
- Created the Spreadsheet updateable file using Quattro Pro 8
Environment: Oracle 8i server site is Sun Solaris and client site Win NT ver. 4.0, Quattro Pro 8, WordPerfect, Oracle Developer/2000, PL/SQL, Trigger, Function and procedure, sql*server
Software Engineer
Confidential, Rockville, MD
Responsibilities:
- Analyzed, coded and designed intelligence database using Informix-New Era on the Army Global Command and Control System (AGCCS) project
- Wrote Informix New Era codes to build additional Graphic User Interface (GUI) for existing intelligence application. The development was working under Window NT operating system.
- Wrote message trace diagram, logical view diagram, software requirement for rd Reference Data Location (SRD lor) using Rational Rose/C++ . Knowledge and experience with Rational to include ClearCase, Clear Quest, Test Manager, and Test Robot
- Updated SDF’s; conversed use case Document for all applications to new format
Environment: Informix new Era, Rational Rose /C++, Win NT, Power Builder 6.0,Informix