Sr Oracle Developer Resume Irving, TX - Hire IT People

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.

We provide IT Staff Augmentation Services!

Sr Oracle Developer Resume

Irving, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship