SUMMARY:

A seasoned Oracle Database Administrator and PL/SQL Developer with over 25 years experience managing Oracle databases and developing PL/SQL scripts and procedures. Adept at logical and physical data modeling for OLTP relational models and data warehouse dimensional (star schema) models. Highly skilled in database and application performance tuning. Experienced in all the phases of the SDLC. Experience also includes financial and investment systems, telecommunications, healthcare, utilities, and human resource management systems.

WORK EXPERIENCE:

Confidential, Lawrenceville, NJ

Sr Applications Developer

Responsibilities:

• Write/test PL/SQL packages, procedures, functions, and unix shell scripts for the Confidential Wealth Reporting (AWR) application, a wealth management product used by various financial institutions, advisors, and investors, using advanced pl/sql, analytic functions, bulk collections, and global temporary tables for report generation, batch processing, and provision data to front - end java application
• Write application design and program specifications
• Manage/lead release development with on-shore and off-shore team
• Manage and perform code reviews
• Interact with various teams to resolve development issues
• Perform SQL analysis and tuning
• Support client on-boarding/implementation
• Troubleshoot, analyze, and fix application issues
• Support data warehouse data loading (ETL) using informatica monitor
• Render production support on a rotation basis

Confidential, Lawrenceville, NJ

Oracle Developer

Responsibilities:

• Write/test PL/SQL packages, procedures, and functions for the Confidential Wealth Reporting (AWR) application, a wealth management product used by various financial institutions, advisors, and investors. Used advanced pl/sql, analytic functions, bulk collections, and global temporary tables for generating reports and online applications.
• Write DDL and DML statements for creating database objects and managing privileges.
• Write shell scripts as interface for running database jobs
• Resolve database/application issues and tickets

Confidential, Roseland, NJ

Database Administrator/PLSQL Developer

Responsibilities:

• Install oracle software and create databases in RAC and non-RAC environments on Windows and Linux/Unix environments
• Improve database performance by evaluating AWR reports and OEM data
• Optimize application (SQL) queries using explain plan
• Gather data requirements and developed logical and physical data models using TOAD Data Modeler
• Create the database objects in the database as per data models
• Extract/load data into databases using sql*loader, export/import utilities
• Write PL/SQL scripts, procedures and triggers
• Write automated jobs using dos and shell scripts

Confidential, Princeton, NJ

Sr. Database Administrator

Responsibilities:

• Install and configure Oracle softwares and upgrades
• Install, configure, and manage Oracle Real Appication Cluster (RAC) databases and Oracle single-instance databases in Oracle 10g and 11g
• Create physical database and database objects (tables, indexes, views, etc) as per database design
• Monitor and tune database performance using Oracle Enterprise Manager (OEM), AWR, and OS utilities
• Write unix shell scripts and database scripts
• Support application developers in their database requirements, such as, loading of test data, database refresh, writing and optimizing queries, etc.
• Optimize database application queries using tkprof, explain plan, and toad
• Gather data volume projections and plan for data growth
• Implement and plan the back-up and recovery strategies for the different databases using Oracle Recovery Manager (RMAN)
• Plan and Implement database archiving for fault tolerance
• Ensure database availability and performance
• Attend to all database and database-related problems
• Write Oracle PL/SQL scripts, stored procedures and packages using TOAD and SQLDeveloper
• Write stored functions to implement FGAC using VPD dbms procedures
• Write scripts for promoting database changes from one environment to another

Confidential, Philippines

Sr. Oracle DBA/Developer

Responsibilities:

• Install and configure Oracle softwares and upgrades
• Install, configure, and manage Oracle 10g Real Application Cluster (RAC) databases and Oracle single-instance databases
• Design logical and physical data models
• Create physical database and database objects (tables, indexes, views, etc) as per database design
• Improve database performance using Oracle Enterprise Manager (OEM) Database Control and Grid Control for RAC, Statspack, and OS utilities
• Manage users and user resources in RAC
• Write unix shell scripts and PL/SQL scripts/stored procedures

Confidential, Pasig City, Philippines

Datawarehouse DBA/Developer

Responsibilities:

• Identified initial data volume and growth rate to determine data storage requirements.
• Prepared and Implemented physical database design for the datawarehouse
• Created database and corresponding storage and memory structures, e.g., tablespaces, rollback segments, redo logs, etc.
• Created tables, partitions, indexes, synonyms, etc.
• Wrote shell scripts for running the ETL process.
• Manage the ETL process and validate the results.
• Monitor and Fine-tune the database and the application SQLs.
• Perform regular database backups.
• Wrote ETL jobs using Ascential DataStage ETL tool.
• Wrote stored procedures/scripts to capture data changes using PL/SQL and Oracle Streams.
• Wrote stored procedures, packages for ETL process using Oracle PL/SQL; also wrote shell scripts.
• Wrote programs using Cognos Impromptu, Transformer, and Powerplay.

Confidential, Warren, NJ

Sr. Database Administrator / Developer

Responsibilities:

• Gathered and documented requirements from the users/analysts.
• Developed database designs and program specifications.
• Installed and configured Confidential ERP application software.
• Installed and configured Oracle 8/8i RDBMS.
• Developed physical designs for database implementations.
• Created database and database objects.
• Monitored and tuned the application and database.
• Configured and sized database and database objects, e.g., tablespaces, tables, and indexes
• Wrote database backup and recovery plan
• Wrote stored procedures/packages, PL/SQL scripts, shell scripts, and perl scripts.
• Wrote report programs using Crystal Reports.
• Led and mentored junior DBA’s

Confidential, New York, New York

Database Administrator

Responsibilities:

• planned and created the physical database and database objects. created test database, loaded test data, and did test database refreshes using export/import and SQL*Loader. fine-tuned application SQL statements using explain plan, tkprof, and Platinum’s Plan Analyzer. monitored and fine-tuned database performance using Oracle Enterprise Manager, Platinum SQL-Station, and Oracle’s utlbstat/estat utility. created users and managed user privileges and resources. performed logical and physical database back-ups using export/import and unix back-up utilities. apply upgrades to the CARS application software. attend to all database related problems.
• Wrote stored procedures/packages, PL/SQL scripts, and shell scripts.

Confidential, Edison, New Jersey

Database Administrator

Responsibilities:

• installed Oracle softwares and software upgrades.
• Installed and worked on sql and database performance tools such as Platinum DBVision/ Server Vision/ Wire Tap, Quest’s SQL*Lab.
• Performed SQL tuning and database performance monitoring/tuning, designed physical database schemas, created database and database objects (tables, indexes, etc.).
• Performed database back-up and management of user and user resources. developed a number of online programs and reports using ORACLE Developer 2000 Forms Designer and Reports Designer for the Data Management Group (DMG) of BMP.
• Wrote database triggers, PL/SQL scripts, stored procedures, and shell scripts, and Pro*C programs.

Confidential, Pasig City, Philippines

Systems Designer

Responsibilities:

• Enhancements to the General Ledger and Accounts Receivable system
• Insurance Sales Analysis System
• Insurance Billing (Invoicing/Refund Premium) System
• Policy Master System
• Insurance Claims System