Previous Job
Previous
PL/SQL Developer
Ref No.: 18-00480
Location: East Hanover, New Jersey
Start Date: 05/10/2018
  • Database administration and migration experience for Oracle 11g and 12c
  • Troubleshooting core bottleneck issues, performance tuning after upgrade/migration
  • Analyze process failures and come up with alternative strategy and design to handle data validations, develop & enable automated error handling. 
  • Enhance all PLSQL Procedures/Packages to design & implement database-wide error management process that enables continuity with Boomi job/schedules and allows for improved operational debugging.
  • Use of Oracle Enterprise Manager (OEM) 11g and 12C for database monitoring/performance/diagnostics
  • Post-production database assessment to maximize the availability and performance
  • Schemas changes and design reviews with development teams helping them to optimize schema design
  • Coordination with Dell Boomi and IRMA Migration teams team for error resolution and rectification of issues
  • Assisting in the Performance Benchmarking testing activities (i.e. pre & post metrics, monitoring, troubleshooting)
  • Alignment of activities with the larger integrated project plan
  • Proper IGM & Lifecycle Documentation for all the installations as applicable