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.
• 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.

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, Cognos

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

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

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

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

PROFESSIONAL EXPERIENCE:

Confidential, VA

Oracle DBA/Sr. PL/SQL Programmer Analyst

• 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 for financial application.
• Modified the application using PL/SQL.
• The databases were oracle 10g and 11g /operating systems are window XP, 2003, 2008 and HP-UNIX.

Confidential, VA

Oracle DBA/ Sr. PL/SQL

• 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 Metalink 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 SQL*Server
• Experience with LINUX/SOLARIS.
• Experience with UNIX shell script
• Extensive experience in Relational and Data modeling for creating Logical and Physical Design of Database and ER Diagrams using data modeling tools like Oracle Designer.

Confidential

Oracle DBA/Developer

• 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.

Confidential, Bethesda, MD

Oracle DBA/Developer/ Sr. PL/SQL

• Designing for High Availability in the various database technologies.
• Managed Jr Oracle DBA and mentored him through entire project. .
• 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.
• Experience with SQL*Server
• 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.

Confidential, Confidential, MD

Oracle DBA/Developer/ Sr. PL/SQL

• 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

Confidential, DC

Oracle Application Developer

• 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

Confidential, Crystal City, VA

Software Engineer

• 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.

Confidential, Springfield, VA

Oracle Database Developer/Database administrator

• 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 Metalink 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 interMedia 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

Confidential, DC

Systems Analyst/ Oracle DBA

• 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

Confidential, MD

Software Engineer

• Analyzed, coded and designed intelligence database using Informix-New Era on the Confidential 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

Confidential, VA

Programmer

• Analyzed, programmed, tested, modified and developed Central Issues Facility (CIF) application using C, Informix and ESQL, shell script, awk
• Worked at DBA tasks and the character based interface developed using ETIP. The software was on Sun 690s and AT&T 3B platform at various sites throughout the US

Environment: Informix, C, Sun 690, ESQL, Shell Script, C shell

Confidential, VA

Programmer/Analyst at Fort Belvoir

• Analyzed, designed and coded an administrative DAILYLOG and WEEKLY STATUS REPORT DBMS application using ORACLE version 5 and 6 included daily-log; weekly status report entry forms (SQL*FORMS)
• Created database tables (SQL*PLUS) daily-log & weekly status reports (SQL*REPORT WRITER) under Unix System V
• Modified SQL tables scripts, report writer files of TOPS Oracle systems
• Performed daily back up on UNISYS 5000 and UNIX SUN SYSTEM
• Created unique index, granted permission to public, created public synonym

Environment: Oracle version 5, 6, SQL*FORM, SQL*Report Writer, SQL*PLUS, Unisys 5000 and UNIX Sun system