We provide IT Staff Augmentation Services!

Sr Oracle Developer Resume

Irving, TX

PROFESSIONAL SUMMARY:

  • Over 20 years of development, batch automation and administration experience.
  • ETL development utilizing Oracle SQL*Loader scripting, SQL and PL/SQL.
  • Experience with Sun Solaris, HP - UX, AIX UNIX and various Linux operating systems.
  • Experience working with UNIX scripting languages Korn, C shell and Perl.
  • Production support experience with Oracle in various ETL, data warehousing and application environments.
  • Business Objects development, administration and support.

TECHNICAL SUMMARY:

RDBMS: Oracle 7, 8, 9i, 10g, RAC, 11g, 11g on AWS and 12c.

RDBMS Access: SQL*Plus, TOAD, SQL Developer and SQL Navigator.

Languages: Oracle PL/SQL, Korn, Bash, C shell scripting and Perl.

Operating systems: UNIX and Linux.

Batch Automation: Autosys 4.5, R11.x, DBMS SCHEDULER and crontab.

BI Applications: Business Objects.

Other: SQL*Loader, Perl DBI, NDM Connect Direct, FTP, SFTP, CA WCC, Net Backup and CVS/SVN version control software.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr Oracle Developer

Environment: Oracle 11g, PL/SQL

Responsibilities:

  • Sr. Oracle Developer for Operational Risk Management (ORM) group
  • Converted existing batch operations on the back-end to real-time processing using PL/SQL packages.
  • Performance tuning for queries used in reporting and the ORM application.
  • Provided Level III support for the Operations Team.
  • Performed Database design and code reviews.

Confidential, Irving, TX

Sr Oracle Developer

Environment: Oracle 11g, PL/SQL

Responsibilities:

  • Sr. Oracle Developer for Operational Risk Management (ORM) group
  • Converted existing batch operations on the back-end to real-time processing using PL/SQL packages.
  • Performance tuning for queries used in reporting and the ORM application.
  • Provided Level III support for the Operations Team.
  • Performed Database design and code reviews.

Confidential, Jacksonville, FL

Application Programmer

Environment: Oracle 12c, PL/SQL, Autosys R11, Korn shell scripting

Responsibilities:

  • Sr. Oracle Developer for the Confidential group.
  • Wrote Linux Korn shell scripts that were used as wrapper processes for file trasfers, file polling and Oracle SQL*Plus required for batch automation.
  • Wrote SQL*Loader control scripts used to import data into the database.
  • Automated testing process using Autosys and Korn shell scripting.
  • Perl scripting utilizing the DBI and Threads modules to create parallel processing used in creating database extracts.

Confidential

Sr. Database Developer / DBA

Environment: SQL Server, SSIS, Powershell, sqlcmd utility

Responsibilities:

  • Provided SQL Server DBA support for databases related to warehouse picking and business intelligence.
  • Maintained SSIS packages that were used as ETL processes to provide data to the BI database.
  • Used the sqlcmd utility and Powershell to create a scripts and a subset of data from production that the developers used in local unit testing.

Confidential, Addison, TX

Oracle Developer / DBA

Environment: Oracle 11g, PL/SQL, DBMS SCHEDULER, *NIX

Responsibilities:

  • Provided Oracle 11g database development.
  • Troubleshoot issues in the existing PL/SQL packages.
  • Query and process performance tuning of SQL and PL/SQL code used by application.
  • Automation of procedures using DBMS SCHEDULER.

Confidential, Pennington, NJ and Plano, TX

Sr. Oracle Developer

Environment: Oracle 11g, PL/SQL, Autosys R11, *NIX, Korn Shell

Responsibilities:

  • Provided application setup and configuration and assisted in troubleshooting defects.
  • Provided assistance of the initial batch automation using Autosys and Korn shell scripting.
  • Application support of the Teradata Aprimo Marketing application.

Confidential, Beaverton, OR

Application Engineer

Environment: Oracle 11g, PL/SQL, DBMS SCHEDULER, Autosys R11, *NIX

Responsibilities:

  • Provided Oracle 11g database development.
  • Troubleshoot issues in the existing PL/SQL packages as well as provided new development according to STM and Functional Specifications
  • Query and process performance tuning of SQL and PL/SQL code.
  • Automation of Oracle processes using DBMS SCHEDULER.
  • Management of batch in Production, Production Support (PS ) and Release environment (RLS) using Autosys.

Confidential, Portland, OR

DBA/ PL/SQL Developer

Environment: Oracle 11g on Amazon Web Services ( AWS ), PL/SQL, DBMS SCHEDULER

Responsibilities:

  • Provided DBA support for Oracle on AWS for various production and development databases.
  • Query and process performance tuning of SQL and PL/SQL code used by enterprise application.
  • Automation of weekly production processing through the use of DBMS SCHEDULER.
  • Researched and resolved issues with database performance at the system and application level.

Confidential, Beaverton, OR

HR Batch Coordinator

Technologies Summary: Autosys R11.

Responsibilities:

  • Management of batch in Production, Production Support (PS ) and Release environment (RLS)
  • Coordinating outages, upgrades, and releases.
  • Attending meetings and communicating information out to HRIT.
  • Review all batch changes and approve them.

Hire Now