OBJECTIVE:

• To obtain a challenging Oracle Developer position with opportunity for growth and career advancement.

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

PL/SQL Developer/Oracle Developer/DBA

Responsibilities:

• Used SQL* Loader for Data Conversions and to load the flat files.
• Good understanding of OLTP, OLAP, database desing, logical and physical implementations.
• On hand experience with Advanced PL/SQL Record, Type, Rowtype and Objects.
• Familiar with all Data Definition Language, Data Manipulation Language and Transactional Control Language commands in SQL.
• Developed and maintained Oracle Stored Procedures, Packages, Function, Virtual Columns, Table, Grants, Index.
• Developed applications using advanced PL/SQL features like Native dynamic SQL (NDS), Bulk collect and INDEX BY TABLES.
• Worked extensively on tuning SQL queries and database modules for optimum performance.
• Extensively use of advanced features of Oracle 11g Records, Tables, Object types and Dynamic SQL.
• Utilize tools like TOAD, SQL Developer, Profiler, OEM, etc
• Designing and coding UNIX shell scripts to schedule ad - hoc PL/SQL procedures.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Created Users, Roles and Managing Security & Concurrent Managers administration
• Expertise in RDBMS Tools like SQL Loader, AQT, Import/Export, Data Pump, RMAN, OEM
• Active Database Duplication and Backup Database Duplication.
• Full and incremental backups, hot and cold backups, database recovery
• Exported Databases, schemas, tables using data moving utilities such as SQL Loader, DataPump, export and import, transportable tablespaces

Confidential, Fort Lauderdale, FL

PL/SQL Developer Oracle Developer/ DBA

Responsibilities:

• Finalized an assignment to export from an old Informix database to Oracle production and testing environments
• Some 400 tables, 40 GB of data, using unload Informix tool and SQL Loader Oracle tool.
• Exported objects such tables, indexes, constraints, primary keys and foreign keys including data type conversion such as datetime, interval, numeric, etc
• It was a totally automatic process using Linux Shell scripting
• Some of the tables had 16 million rows
• Converted 4gl and SPL Informix procedures, functions, and triggers to PLSQL procedures, functions and packages.
• Used SQL* Loader for Data Conversions and to load the flat files.

Confidential

PL/SQL Developer Oracle Developer

Responsibilities:

• Participated with Software Development Life cycle as an Oracle Developer/PL/SQL Developer, which includes Analysis, Development, Implementation and testing.
• Worked in Database Design and Development using Oracle 10g/11g, Web deployment using Oracle PL/SQL, Oracle SQL Loader
• Excellent skills in writing PL/SQL Stored Procedures, Functions, Triggers, Packages, Constraints, Views and Fine-Tuning them.
• Worked with Star schema, materialized views, dimension and fact tables, OLAP queries, data cubes, etc.
• Extensive knowledge in design and modeling database-using Oracle Designer
• Created Business Requirements, Functional Specs and User Interface Documentation.
• Extensive experience in developing UNIX Shell scripts.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.
• Extensively used SQL*PLUS, SQL Developer.
• Experience in using Exception handling to handle PL/SQL errors (error trapping).
• Experience in using Oraclein-built packages like UTL FILE, DBMS SQL etc.
• Enforced database integrity using primary keys and foreign keys.
• Created DDL scripts for implementing data modeling changes.
• Experienced in Dynamic SQL, PL/SQLCollections and Exception handling.
• Developed Stored Program Overloading, triggers for events and auditing
• Developed PL/SQL functions to facilitate business functions and calculations and did required modifications to the existing once.
• Performed performance tuning of the SQL queries by eliminating redundant joins, creating functional indexes, removing redundant code.

Confidential, NYC, NY

Informix DBA

Responsibilities:

• Manage replication for 2 participant informix serves manage dbspaces, add chunks to informix servers
• Created unix cron jobs, detecting informix servers down, replication out of sync, etc.
• Designed schema for databases, tables, and users.
• Created users, roles, and permissions.
• Worked with informix in unix and NT environments
• Daily backups with onbar tool in unix server
• Daily backups with ontape in NT servers
• Managed to adjust replication during business hours (it is easy at night you could shut down informix servers) if there were some transactions problems which could generate many tables to be off
• Wrote some tools for unix system crashes and informix servers not responding as well
• Scripts that check for space in rootdbs and other dbspaces wrote tons of scripts for tuning, detection of replication problems, etcManaged a apache web server and wrote reports in php
• Informix installation in unix and NT with ISA for administration purposes.

Tools: php pages, SQL editor, table editor, Visio schema design, ISA (informix server administrator), ISM (informix store manager), ipload, etc

Confidential, NYC, NY

Oracle Developer

Responsibilities:

• Reengineered the Diamond Dept. computer system.
• Created menu, forms, reports using Oracle Developer 2000.
• Created menu libraries, store procedures, Packages, and Triggers.
• Created PL/SQL scripts for application tuning.
• Extensive use of built-in PL/SQL packages.
• Handled security features at the Application level and Database level.
• Maintained Pro C reports.
• Built some applications using Visual Basic.
• Created HTML Oracle reports

Tools: SQL plus 8, Oracle 8, Oracle Developer 2000, Oracle Forms 6.0, Oracle Reports 3.0, PL/SQL, TOAD, Pro C, Unix System 5, Visual Basic 6

Confidential, Union, NJ

Oracle Developer

Responsibilities:

• Developed software applications (personnel, payroll, etc.) for school districts in the area of NJ.
• Have extensive experience in the design and development of database systems using Oracle.
• Experience includes Full Project Life Cycle, Analysis, Design, etc.
• Created Tables in 3rd Normal Form, Relationships (1 - 1, 1-M, M-N), Fields, Indexes, etc.
• Enforced Referential Integrity (updates, deletes).
• Created Reports using Report Builder 3.0 and Report Wizard, for example, Matrix, Tabular, Group Reports, etc.
• Created Report Templates, Report Parameters, and Report Triggers.
• Created PL/SQL libraries containing Data Structures and Object Oriented Packages.
• Created Triggers, Procedures, Functions, Cursors and Stored Procedures using PL/SQL.
• Designed complex Queries and Views involving nested SubQueries, and ie= UNION, INTERSECT, and MINUS, etc.
• Built security for the Database, ie= Users, Roles, and Privileges.

Tools: SQL plus 3.3, Oracle 8, Oracle Developer 2000, Oracle Forms 5.0, Oracle Reports 3.0, PL/SQL, TOAD 6, Pro C, E/R Model