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.