We provide IT Staff Augmentation Services!

Senior Database Developer Resume

SUMMARY

  • Twenty years in Data processing including sixteen years of extensive experience in design, development, and implementation of ORACLE based DSS and OLTP business systems.
  • Extensive experience high - performance PL/SQL code development and SQL performance tuning. Strong skills in ETL development and Data Warehousing. Strong experience with Oracle Report Builder. Strong experience with Java, JDBC, C/C++, Pro*C, Unix shell scripts.
  • Self starter with ability to work either independently or as part of a team. Proven problem solving abilities.

TECHNICAL SKILLS

Operating Systems: UNIX (SunOS, Sparc Solaris, IBM AIX, HP-UX, DG/UX), LINUX, VMS, Windows NT/XP, and RSX11M.

RDBMS: ORACLE 11g (SQL, PL/SQL, SQL*Plus, Pro*C/C++, Java, JDBC, SQLJ, Oracle Reports Builder 10.1.2, Oracle WebDB) ORACLE Utilities (SQL*Loader, Export, Import).

Database Tools: (TOAD, SQL Navigator, MS Visual SourceSafe, SourceGear Vault, Clearcase).

ORACLE Performance Diagnostic Tools: (Explain Plan, Trace facility, Hints, V$ Views).

ETL: SQL*Loader, External tables, Pipelined functions, UNIX Korn Shell.

OLAP: Cognos 10.2.1, Business Objects.

Languages: PL/SQL, JAVA2, C/C++, Oracle Pro*C, C/UNIX, UNIX Shell, SQL, HTML, XML, UML, Design Patterns, COBOL, Macro Assembler.

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Developer

Responsibilities:

  • Designed, developed, documented, performance tuned, and tested various Oracle PL/SQL programs for supporting educational services.
  • Created various UNIX shell scripts for automate process of loading data files from customers to Oracle database using SQL*Loader.
  • Created various reports using Cognos 10.2.1.
  • Pre-Summarized data for purpose of multidimensional analysis along a combination of “dimensions” and “hierarchies” from detail levels and populated it into data warehouse tables.
  • Sql performance tuning. Created tables, indexes, constraints, views, types, sequences, materialized views.
  • Created various PLSQL packages implemented front end API.

Senior Oracle Database Developer

Confidential

Responsibilities:

  • Designed, develop, and tested (using Agile methodology) complex set of Oracle programs to report differences between new generated Ratings/Outlooks/CreditWatch and existing for Primary and Secondary Markets for various business scenarios.
  • Designed, develop, and tested complex set of Oracle programs for Non-Rating Score Master database. Non-Rating Score Master database is designed to store the various types and values of scores and their supporting components (components, factors, sub-factors) that are assessed for various types of analytical entities.
  • Created various UNIX shell scripts for automate process of loading data files from customers to Oracle database using SQL*Loader.
  • Designed, develop, and tested complex set of Oracle programs to populate primary Participant Evaluation Group tables from staging tables.
  • Designed, develop, and tested complex set of Oracle programs for Dependent Rating Notification services.
  • Developed various Oracle PL/SQL programs for rating services to help investors perform efficient credit risk-driven investment analysis.
  • Performance tuning complex views and PLSQL programs.

Confidential

Oracle Developer

Responsibilities:

  • Designed, developed, documented, performance tuned, and tested various Oracle PL/SQL and Java programs for supporting visits maintenance system.
  • Pre-Summarized data for purpose of multidimensional analysis along a combination of “dimensions” and “hierarchies” from detail levels and populated it into data warehouse tables.
  • Implement various API for Account Manager front-end application.
  • Created various visit maintenance reports using Oracle Reports Builder 10.1.2.
  • Created various UNIX shell scripts for automate process of loading data files from customers to Oracle database using SQL*Loader.
  • Sql performance tuning. Created tables, indexes, constraints, views, types, sequences.
  • Designed, develop, tested PL/SQL programs to implement API for front-end application to allow Home Health Agencies’ non-programmer workers create, update, delete export templates for custom visit maintenance export file in various formats (txt, csv, xml), and generated export files using templates. This functionality included tracking history changes, statistics, handling concurrency, and security.

Hire Now