Previous Job
R12 Upgrade DBA - Milwaukee, WI, USA
Ref No.: 17-03338
Location: Milwaukee, Wisconsin
  1. Role: R12 Upgrade DBA - Milwaukee, WI, USA
    Skill Set required:
  2. Must have executed a minimum of 2 R12.2 Upgrade cycles in past.
  3. Should have hands-on experience of database upgrade to 12c
  4. Must have hands-on experience of platform migration from AIX to LINUX
  5. Must have hands-on experience of Vertex Upgrade process
  6. Preferred hands-on experience of NavTeq tool upgrade
  7. Must have hands-on experience of RMAN, Backup Management and different Recovery techniques
  8. Should have design experience of EBS multi-tier architecture for multi-node Application and RAC in DB tier
  9. Hands-on experience of the underlying operating system and storage, Network systems
  10. Good knowledge of the physical database design
  11. Ability to perform both Oracle and operating system performance tuning and monitoring
  12. A good knowledge of Oracle security management like OAM, SSO, OID etc.
  13. Production level exposure to 3rd party integrations to EBS systems and Support experience
  14. Experience in tool / manual based code migration, database change management and data management through the various stages of the development life cycle
  15. A sound knowledge of both database and system performance tuning
  16. Architecture tuning as part of Upgrade iterations
  17. A DBA should have sound communication skills with management, development teams, vendors and systems administrators
    Scope & Responsibilities:
  18. Should own end to end process of Oracle EBS R12 upgrade to R12.2.5, Database upgrade to 12c, Platform Migration from AIX to Linux RHEL 7 and Vertex Upgrade.
  19. Planning and execution of MLS patches on EBS Application
  20. Will be responsible for Patch Analysis and impact assessment, patching process documentation
  21. Will be responsible for Cutover Downtime reduction thru process improvements in each Upgrade iteration, documentation of Upgrade execution times
  22. Cutover Document preparation from DBA perspective for Go Live activities
  23. Responsible for Oracle 12c Grid Installation and ASM setup and maintenance
  24. Responsible for schedule and execution of EBS Cloning, preparation of consolidated cloning process document
  25. Responsible for Post Upgrade task (Additional Node and Configuration Setting)
  26. Responsible for maintaining latest patch set levels of Oracle EBS w.r.t. modules tech stack, security etc.
  27. Ensuring LDAP, database and other supporting services required in working condition
  28. Responsible for System Transition training and handover of documents for Steady State Support
  29. Coordination with Oracle on issue resolution for SR or with other Application/Product DBAs in case of any need of support / assistance
  30. Responsible for giving the latest Upgrade progress status and Defect updates to PMO / Project Manager on periodic / milestone basis as required.
  31. Responsible for System Health Check and maintenance
  32. Assistance in queries tuning
  33. Will be responsible for End to End successful execution of Mock and Go Live Activities which will be in 24x7 model.
  34. Will be responsible to work in harmony with other legacy application teams for Integration connectivity for SIT and UAT testing.
  35. Will be actively participating in Change Management and Governance meetings and provide valuable inputs for program execution
  36. Infosys Candidate fitment:
  37. Oracle Apps DBA with 12+ years' experience, preferably Lead DBA.
  38. Assumptions:
  39. Upgrade DBA's will have Metalink access to work with Vendor on any issue.