Candidate Information Title Oracle Developer Database Administration Target Location US-VA-Manassas	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes SENIOR ORACLE DATABASE DEVELOPER Brooklyn, MD Developer Oracle Fairfax, VA Sql Server Database Developer Alexandria, VA Database Administrator Oracle Germantown, MD Oracle Database Administration Chantilly, VA Oracle PL/SQL, Oem, Ssh, Putty,SQL Developer Tcp/Ip,Grid Infrast Bowie, MD Oracle Database Administrator Upper Marlboro, MD

NatasaTOSummary:Over 14 years of experience in Oracle Developer&more than 5 years of Database Administration/ Architect on production&development databases&expertise on Unix/Windows Administration.Expert on Database Backup/Restore/Import Export/Refresh/Data Pump.Experience with Backup&Disaster Recovery using Export, Data Pump, RMAN&VERITAS NetBackupExpertise on Database upgrade from 9i to 10g&10g to 11g&12c.Development experience with Oracle/Developer2000.Expertise on SQL, PL/SQL programming on OEM.Pioneer in working with PL/SQL including Procedures, Functions, Cursors&Triggers.24X7 production database supports on Window, UNIX, Linux&Solaris environment.Experience on database patch certification&installation.Experience on UNIX/SOLARIS/LINUX.Experience in Administration activities such Installation, Configuration, Client/server connectivity, Creating&Managing Repositories, Users, User Groups, Folders, User Roles, Profiles&Privileges.Experience on creating index&stats on objects.Experience in capacity planning&space management.Good consulting&communication skills, knowledge of client-relationship building techniques&project methodologies with good team building skills.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& Workstation, MVS mainframesTechnologies:XML, XSL, XSLT, HTMLLanguages:C, C++, VBScript, Java,JavaScript, SQL, PL/SQL, HTML, DHTML, Perl, Java,Pro*CDatabases: Oracle 5/6/7/8/8i/9i/10g/11g/12c Informix, Ingress, MS Access, SQLServerGUI S:Visual Basic 6.0, Power Builder6.0, Informix New Era, OracleDeveloper/2000Database Utilities:Oracle Form &Report 11gr2 (Developer/2000, Form 6i, Report 6i), SQL*Reports*Writer, SQL*PLUS, SQL*Writer, SQL*Loader, Oracle Designer, Oracle 9IAS,Oracle ADFCertifications:Training from USDA at LEnfant Plaza Washington D.C. - Introduction Java.Training from Nova Community College - Intermediate Java.Nova Community College at Annandale VA, GPA 4.0 - Introduction C++, Introduction to Oracle Database Administrator 8i,Introduction Java, Intermediate Java& Advanced Java.Scholarship at Rockwell University at Tyson Corner, VA.Award: Certificate of Appreciation giving by Integrated Microcomputer System Service, Inc.Certificate of Appreciation giving by Department of Commerce.Training from Oracle University- PL/SQL, Oracle 9IAS, Oracle Designer 6i.License in Home HealthCare.Member of Honor Society.Education:B.S. in Information System Management from University of Maryland, College Park MD.Security: background investigate is cleared.Drug test is fine. Public Trust,Top Secret and Secret are inactiveProfessional Experience:Caring Hands of America August 2020 to present - Personal Care Aid (PCA)Prepares Patient Care PlansAssesses and evaluates patients needs and medical conditionKeeps track of medication scheduleConducts patient exercisesAssist the patient in day-to-day basic functionsPrepares patients meals according to meal planPerforms house chores to make house clean, safe and livableMaintains records and files of patients orders and prescriptionsAssists in moving or transporting the patientMonitor progress of the patientProvides companionshipPrepares necessary reportsFieldNation, VirginiaApril 2019 - Sept 2022PL/SQL DeveloperResponsible for developing packages, stored procedures, functions, views, and other database objects. Triggers, constraints, foreign keys, joins, Oracle system functions using Oracle 11g and 12c, etc.Troubleshoot the errors for Packages, procedures and functions.Oracle Developer Tools; is familiar with Source Control, CI, RMAN.Hands on writing Cursors, User-defined Object types, Records, and collections in PL/SQL Programming for generating worksheets, Arrays & Queues.Wrote the triggers for inserting, updating and deleting.Working hands-on experience of PL/SQL and advanced DBMS concepts.Strong Analytical, Problem Solving and Communication skills.Understanding of SDLC.Write Unit test cases, perform functional and integration testing during various phases of the product life cycle.Strong Skills in Exception Handling extensively debug PL/SQL Code, DDL, DML and display the error messages in the application.Experience in creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.Knowledge with payroll systems, specifically with Unanet ERP (Time and Labor).ITG MD-Dept of Commerce, Suitland MDJune 2017 -Aug 2017Oracle Developer/Oracle DBAWrote the documents how to migrate Oracle 11g to Oracle 12c.Work with re-engineering & analyst for SAFER, TRANSPORTATION & ESPS applications.CONCEPT Solution INC MD-Dept of Commerce, Suitland MDSep 2014  June 2017Oracle PL/SQL DeveloperRewrite the PL/SQL store procedures codes to create an obligation for ORSI.Fixed errors of store procedure with OCI.Wrote the flowcharts for the packages named EAI_FM040_CREATE&EAI_FM040_close.Worked to identify the dependences for the following applications:Dapps,EOD,EmployeeInterface,NFC,ESPS,ICDS,OAR+ with OCI.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, to migration to another applications etc.Wrote Oracle SQL Script files to find all the privileges for the tables using oracle 11g and 12c.Create SQL files of the objects such as tables, packages&views for seven applications: ESPS, GI, ER601, ITBP, OAR, CUR,&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.Installing 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&OAR+.Installed the oracle WebLogicForms&Reports 11g R2.Worked with TOAD&Oracle Developer.Work with forms&reports 11g R2 to fix the errors for the following applications:ESPS,ICDS,OAR+ and ITBP.Created more than 8 SQL script files to do migration for 7 applications such as ESPS,ICDS, OAR+,ITBP,ICDSetc.Worked UNIX/LINUX Shell Scripting.Conversed oracle Form to backend PL/SQL Store Procedure for developing ADFsapplications.Wrote the docs for SOA OAR,ESPS, ICDS, ITPPs applications, etc.Wrote table triggers for updating,inserting&deleting.Capital Home CareSept 2013 - April 2018Personal Care Aid (PCA)Assisted patient with bathing, oral hygiene, grooming, and dressing.Helped patient move in and out of bed, bath, and automobile.Scheduled and accompanied patient to medical appointments.Maintained and obtained household supplies and ran errands.Cooked appetizing and satisfying meals and snacks.22nd Century Technologies Inc. (NIH Project), Arlington VAJan 2013 - Mar 2013Oracle DBAWrote script SQL file to drop all the rows of tables, cleaned the schema such as objects procedures,views,synonyms,type,functions,index,database links, etc.Fix errors regarding import pump script file. Grant privilege to DBA users, roles&SYSDBAHelp Team Leader to do migration of Oracle 10gr2 to Oracle 11gr2 under OSWindows 2008 R2, Sun Solaris.Perform tuning Oracle Servers.Health&Human Service/Hire Strategy, RestonVANov 2011 - Jan 2012Oracle DBA/Senior PL/SQL ProgrammerInstalled 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&monitor oracle database version 11 release 2 using OEM.Provide production management&support for Oracle products installed for hosted customersProvide 24x7 coverage outside of business hours.Fix all the errors from creating load scripts&open scripts.Worked with 508 compliances.Modified the application using PL/SQL. To modify triggers, functions&packages, etc.The databases were Oracle 10g&11g /operating systems are window XP, 2003, 2008&HP-UNIX.Perform tuning Oracle Servers.Tier One Technologies, USMS, Arlington VAOct 2010  Nov 2011Oracle DBA/Sr. PL/SQLCreated 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&11gR2.Monitored Oracle 11g using TOAD, SQL*Server.Installed Oracle 8i at client site&the server site Oracle 11g R2.Installed SQL*Developer.Very familiar with Metalink&created SR when the problems arise.Applied Patch for all the Oracle Servers.Applied JAVA Patch for Oracle Servers.Wrote store procedures, functions&packages in PL/SQL&modified the financial application.Fix the SQL statements errors for tuning the JDISdatabase version 11 release 2 in order to make the JDIS database faster than ever.Disabled a lot of Informix users&Oracle users.Created a lot of 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&running. If they were not up&running,had to troubleshoot them&make them run.Experience with LINUX/SOLARIS.Experience with UNIX Shell Script.Experience with PL/SQL such as wrote the functions, triggers, procedure&packages.Hi-Tech Virginia/Dept. of Army, ArlingtonVASep 2009 - Sep 2010Oracle DBA/DeveloperWrote packages for whole application&installed oracle application server Oracle 10g.Oracle enterprise manager, wrote the schema script files for tables, index&unique constraints.Perform development&maintenance work on the platform artifacts to maintain currency with corporate standards&client needs.Conduct or perform data modeling exercises in support of specific needs for data, reports, or analyses.Review methodology&developing/testing procedures for loading data into database to ensure quality of dataMaintain 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,represented.National Naval Medical Center, Bethesda MDOct 2007  Sep 2009Oracle DBAManaged Junior Oracle DBA&mentored.Ability to adapt to changing environment&requirementsmanage multiple tasks.Perform Database Configurations for Oracle on UNIX (Solaris).Database creation, maintenance, migration, cloning&patching.Database backup, recovery&repair using RMAN.Database troubleshooting&problem resolution.Managed&monitor oracle database version 11 release 2 using OEM.Provide production management&support for Oracle products installed for hosted customers. Provide 24x7 coverage outside of business hours.Responsibilities include database loading; development&management of operational procedures; environment management; database health (e.g., monitoring, proactive&reactive responses).Resource planning; database upgrade planning; backup & recovery strategy planning&implementation.Installing database software, maintaining appropriate maintenance levels&tuning.Evaluating, recommending, installing&configuring database related software to meet customer requirements.Experience with UNIX/LINUX/SOLARIS.Account creation&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, SolarisWalter Reed Medical Center, WashingtonDCMar2005 - Oct 2005Oracle Application DeveloperPerformed PL/SQL errors fixes. Help them to fix errors related to modify the application at Telemedicine department using Oracle database 9i, TOAD&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, ColdFusionDepartment of Defense, Crystal City VAMar 2004  Nov 2004Software EngineerPerformed data fixes&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.Experience geographic information systems.Modified the HTML files.Fixed errors regarding to JavaScript files.Created the users for Oracle Schema.Deliver metadata&document extract requirements to customers.Environment: Win XP, Oracle 8i, 10g, Irwin, Perl, Pl/SQLDepartment of Defense, Springfield VAFeb 2001- Mar 2003Oracle Database Developer/Database AdministratorInstalled Oracle 8i database, Oracle Designer, 9iAS application Server at client&server site under MS/2000.Database recover, backup&repair using RMAN.Experience geographic information systems.Develop Ad Hoc Reports.Knowledge&experience with data conversion&reverse engineering.Analyzed development processes for data requirements focusing on logical&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&maintained data dictionaries or repositories (changing the size repository) included name of fields, domains&Data Type.Generated logical CAD2&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&BLOB Data Type.Loaded the tested data into CAD2 tables&RCS tables using SQL*LOADER. Each table of CAD2&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 a lot of Portlets such as Forms, Reports, Dynamic page using Oracle Web Portal (Oracle 9iAS), Web HTML, JavaScript,PL/SQL.Wrote PL/SQL Store Procedure for creating the forms of the application.Utilized HTML, JavaScript, PL, PL/SQL to develop&enhance website design&performance, improve database interaction&validate data.Created the users for Oracle schema. Fixed errors regarding alter tables(constraints integrities),calculated the size of database,reserved space for exporting&importing whole application.Performed CAD2 database imports&exports.Wrote the PL/SQL script files to modify&create the new tables.Performed the CAD2 application fixes&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&server site, SQL*LOADER, Pro*C, ColdFusion, SQL*Server