Natasa Cuc To

Phone: 571-***-****

E-Mail: adt34s@r.postjobfree.com

Summary:

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 NetBackup

Expertise 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 mainframes

Technologies:XML, XSL, XSLT&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, SQLServer

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

Database 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 ADF

Certifications:

Training from USDA at L’Enfant 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 Health Care

Member of Honor Society

Experience:

FieldNation-Virginia

April 2019 to Sept 2022

PL/SQL Developer

Responsible for developing packages, stored procedures, functions, views, and other database objects. Triggers, constraints, foreign keys, joins, Oracle system functions, 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.

ITG MD-Dept of Commerce - Suitland, MD

June 2017 -Aug 2017

Oracle Developer / Oracle DBA

Wrote 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, MD

Sep 2014 – June 2017

Oracle Developer/Oracle DBA

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

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 Web LogicForms&Reports 11gr2.

Worked with TOAD&oracle developer

Work with forms&reports 11gr2 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 ADFs’applications.

Wrote the docs for SOA OAR,ESPS, ICDS, ITPP’s applications, etc.

Wrote table triggers for updating,inserting&deleting.

Capital Home Care Sept 2013 to April 2018-Personal 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, VA

Jan 2013 - Mar 2013

Oracle DBA

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, etc.

Fix errors regarding import pump script file. Grant privilege to DBA users, roles&SYSDBA

Help 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–Reston,VA

Nov 2011 - Jan 2012

Oracle DBA/Senior PL/SQL Programmer

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

Fix all the errors from creating load scripts&open scripts.

Worked with 508 compliance.

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

Oct 2010 – Nov 2011

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&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 arises

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 statement’s 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– Arlington,VA

Sep 2009 - Sep 2010

Oracle DBA/Developer

Wrote 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 data

Maintain common data dictionaries, including such elements as business names, definitions, allowable values, business rules,&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, MD

Oct 2007 – Sep 2009

Oracle DBA

Managed Junior Oracle DBA&mentored.

Ability to adapt to changing environment&requirements&manage 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, Solaris.

Walter Reed Medical Center - Washington, DC

Mar2005 - Oct 2005

Oracle Application Developer

Performed 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. Work as

Environment: Win 2000, Oracle 9i, 10g, PL/SQL, TOAD, JavaScript, Pl/SQL, Pro*C, ColdFusion.

Department of Defense - Crystal City VA

Mar 2004 – Nov 2004

Software Engineer

Performed 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/SQL.

Department of Defense - Springfield, VA

Feb 2001- Mar 2003

Oracle Database Developer/Database administrator

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

Education:

B.S., Information System Management, University of Maryland, College Park, MD 1990

Security: background investigate is cleared.Drug test is fine. Public Trust,Topsecrect and Secret are inactive

Contact this candidate