Oracle Apps DBA

1 week ago

Gurugram, India NCR Voyix Full time

About Company:

NCR VOYIX Corporation (NYSE: VYX) is a leading global provider of digital commerce solutions for the retail, restaurant and banking industries. NCR VOYIX is headquartered in Atlanta, Georgia, with approximately 16,000 employees in 35 countries across the globe. For nearly 140 years, we have been the global leader in consumer transaction technologies, turning everyday consumer interactions into meaningful moments. Today, NCR VOYIX transforms the stores, restaurants and digital banking experiences with cloud-based, platform-led SaaS and services capabilities.


Role: Oracle Apps DBA

Work Location- Gurgaon

Grade : 12

Oracle APPS DBA (10+ Yrs of experience) Job description:

  • Installation, configuration and upgrading of Oracle EBS Application R12.1 and R12.2 and database from 12c to 19c.
  • Analyze performance issues in the application, concurrent manager and database tiers of E-Business Suite installations.
  • Manage resources to provide assistance to development teams with tuning database queries, reviewing and testing patches, configuration and code migrations. Develop purging, archiving, and cloning strategies
  • Single node & Multi Node cloning of EBS R12.2 and 19c database Instances in Normal and Shared Appltop Architecture.
  • Monitoring and bouncing the application related products like oacore, oafm, apache, weblogic, forms & Reports etc.
  • Starting, Stopping and troubleshooting the Oracle EBS application and databases. Administration of WebLogic Servers.
  • Applying Database patches using OPATCH, OPATCHAUTO utility in RAC environment, Application Patches using ADOP and Weblogic patches using BSU utility
  • Troubleshoot performance issues related to database and concurrent manager, using explain plan and TOP, VMSTAT, TKPROF, AWR, ADDM, FND Debug etc.
  • Carry out DBA work related to Backup, Recovery, Imports, Exports, Schema Refresh/Creation, Patching, Migration of Databases, EBS Application and Weblogic.
  • Good knowledge on AD Utilities and their usage database maintenance.
  • User Management of EBS R12.2, Creating responsibility, assigning responsibility to users.
  • Implement, enforce and adhere to Disaster Recovery plan for Database and EBS platforms
  • Setting up LBR for multi nodes.
  • Configuring TLS/SSL on all oracle products (DB and APP).
  • Rapid Cloning of EBS R12.2, Concurrent Manager Tuning, Tuning of Java Heap size, ADSPLICE, ADCTRL, ADMERGE etc.
  • Patching using ADOP (ONLINE, HOTPATCH, DOWNTIME Mode) Utility.
  • Purging the log of Concurrent Manager, Concurrent request, OHS, WebLogic etc.
  • Administration of Concurrent Managers and Concurrent Processing server.
  • Installation of Oracle EBS R12.2.0 and Upgradation of EBS R12.2.X
  • Multi-node handling of Oracle EBS application and RAC databases on exadata
  • Performing Cloning of Application, Online Patching, RDF compile, Form Compile, APPS Schema Compilation using ADADMIN, FNDCPASS, Password Management of APPS, DB, MIDDLEWARE, Performance ISSUE of Applications etc.
  • Upgrading database from 12c to 19c
  • Managing multiple databases in 24*7 environment.

L3 Apps DBAs (Roles and Responsibilities)

L3 Apps DBAs mainly work on high end issues like:

  • Installing Oracle EBS R12.2.0 and Upgrading to EBS R12.2.X
  • Installing and upgrading database from 12c to 19c.
  • Administering, Troubleshooting and Handling Alerts raised by alert monitoring system from Database and applications
  • Tablespace Reorg Activities to improve the performance/to reclaim the unused space
  • Schema Reorg Activities to improve the performance
  • Patch Analysis where there is a patch needs to be applied
  • Backups and issues related to them
  • Query response time and other Performance Issues
  • Work with Oracle Support by raising SRs on several issues
  • Monitoring Standby Databases and resolve respective issues
  • Importing data according to the user request and maintenance of oracle production, development and QA databases.
  • Administration of Concurrent Managers and Concurrent Processing server.
  • Compiling of Forms & Reports for Oracle Application.
  • Performed Application admin tasks using ADADMIN Utility.
  • Data Refresh Using RMAN, expdp/impdp, adpreclone.pl, adcfgclone.pl
  • Rapid Cloning of EBS R12.2 with multi node.
  • Patching AD and TXK Delta using ADOP (ONLINE, HOTPATCH, DOWNTIME Mode ) Utility.
  • Purging the log of Concurrent Manager, Concurrent request, OHS, WebLogic etc.
  • Issues related to space management, Locks, database hit ratios, Backup Failures and database related on call alerts.
  • Monitoring and reorganizing database objects to minimize fragmentation in the database.
  • User and security management by using auditing, Roles and Profiles.
  • Quarterly Password rotation and Applying PSU patches
  • Managing RAC database on Exadata.
  • Applying latest ETCC patches on EBS application and database.

  • Oracle Apps DBA

    1 week ago

    gurugram, India NCR Voyix Full time

    About Company: NCR VOYIX Corporation (NYSE: VYX) is a leading global provider of digital commerce solutions for the retail, restaurant and banking industries. NCR VOYIX is headquartered in Atlanta, Georgia, with approximately 16,000 employees in 35 countries across the globe. For nearly 140 years, we have been the global leader in consumer transaction...

  • Oracle Apps DBA

    1 week ago

    Gurugram, India NCR Voyix Full time

    About Company:NCR VOYIX Corporation (NYSE: VYX) is a leading global provider of digital commerce solutions for the retail, restaurant and banking industries. NCR VOYIX is headquartered in Atlanta, Georgia, with approximately 16,000 employees in 35 countries across the globe. For nearly 140 years, we have been the global leader in consumer transaction...

  • Oracle Apps Dba

    4 weeks ago

    Gurugram, Haryana, India NCR Full time

    About NCR VOYIX NCR VOYIX Corporation (NYSE: VYX) is a leading global provider of digital commerce solutions for the retail, restaurant and banking industries. NCR VOYIX is headquartered in Atlanta, Georgia, with approximately 16,000 employees in 35 countries across the globe. For nearly 140 years, we have been the global leader in consumer transaction...

  • Oracle Apps Dba

    1 day ago

    Gurugram, Haryana, India NCR Full time

    About NCR VOYIX NCR VOYIX Corporation (NYSE: VYX) is a leading global provider of digital commerce solutions for the retail, restaurant and banking industries. NCR VOYIX is headquartered in Atlanta, Georgia, with approximately 16,000 employees in 35 countries across the globe. For nearly 140 years, we have been the global leader in consumer transaction...

  • Oracle Apps DBA

    4 weeks ago

    Gurugram, India NCR Corporation Full time

    About NCR VOYIX NCR VOYIX Corporation (NYSE: VYX) is a leading global provider of digital commerce solutions for the retail, restaurant and banking industries. NCR VOYIX is headquartered in Atlanta, Georgia, with approximately 16,000 employees in 35 countries across the globe. For nearly 140 years, we have been the global leader in consumer transaction...

  • Oracle Apps DBA

    3 weeks ago

    Gurugram, India NCR Corporation Full time

    About NCR VOYIX NCR VOYIX Corporation (NYSE: VYX) is a leading global provider of digital commerce solutions for the retail, restaurant and banking industries. NCR VOYIX is headquartered in Atlanta, Georgia, with approximately 16,000 employees in 35 countries across the globe. For nearly 140 years, we have been the global leader in consumer transaction...

  • Oracle Apps DBA

    4 weeks ago

    gurugram, India NCR Corporation Full time

    About NCR VOYIX NCR VOYIX Corporation (NYSE: VYX) is a leading global provider of digital commerce solutions for the retail, restaurant and banking industries. NCR VOYIX is headquartered in Atlanta, Georgia, with approximately 16,000 employees in 35 countries across the globe. For nearly 140 years, we have been the global leader in consumer...

  • Oracle Apps DBA

    3 weeks ago

    gurugram, India NCR Corporation Full time

    About NCR VOYIX NCR VOYIX Corporation (NYSE: VYX) is a leading global provider of digital commerce solutions for the retail, restaurant and banking industries. NCR VOYIX is headquartered in Atlanta, Georgia, with approximately 16,000 employees in 35 countries across the globe. For nearly 140 years, we have been the global leader in consumer...

  • Oracle DBA

    5 days ago

    gurugram, India Oracle Full time

    Customer Success Services (CSS) is a unit within the Oracle’s Customer Service Organization that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project based one-time services. CSS services team sells from a broad IT-services portfolio both in fixed price and T&M basis. CSS services are...

  • Oracle DBA

    1 week ago

    Gurugram, India Oracle Full time

    Customer Success Services (CSS) is a unit within the Oracle’s Customer Service Organization that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project based one-time services. CSS services team sells from a broad IT-services portfolio both in fixed price and T&M basis. CSS services are...

  • Oracle DBA

    2 months ago

    Gurugram, India Oracle Full time

    As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our...

  • Oracle DBA

    3 weeks ago

    Gurugram, India Oracle Full time

    As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our...

  • Oracle DBA

    3 weeks ago

    gurugram, India Oracle Full time

    As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our...

  • Senior Oracle Apps Technical

    3 weeks ago

    gurugram, India Oracle Full time

    Apps Tech 1. Complete Understanding of Oracle Apps and E-Business Suite Architecture and underlying table structures and their usage to design efficient program Must have strong experience in RICE Develop/maintain oracle custom code and interfaces to oracle forms - based applications in accordance with business Develop PL/SQL packages, procedures, and...

  • Senior Oracle Apps Technical

    2 months ago

    gurugram, India Oracle Full time

    Apps Tech 1. Complete Understanding of Oracle Apps and E-Business Suite Architecture and underlying table structures and their usage to design efficient program Must have strong experience in RICE Develop/maintain oracle custom code and interfaces to oracle forms - based applications in accordance with business Develop PL/SQL packages, procedures, and...

  • Senior Oracle Apps Technical

    2 months ago

    Gurugram, India Oracle Full time

    Apps Tech 1. Complete Understanding of Oracle Apps and E-Business Suite Architecture and underlying table structures and their usage to design efficient program Must have strong experience in RICE Develop/maintain oracle custom code and interfaces to oracle forms - based applications in accordance with business Develop PL/SQL packages, procedures, and...

  • Senior Oracle Apps Technical

    3 weeks ago

    Gurugram, India Oracle Full time

    Apps Tech 1. Complete Understanding of Oracle Apps and E-Business Suite Architecture and underlying table structures and their usage to design efficient program Must have strong experience in RICE Develop/maintain oracle custom code and interfaces to oracle forms - based applications in accordance with business Develop PL/SQL packages, procedures, and...

  • Oracle DBA

    2 days ago

    Gurugram, India Alphanext Technology Solutions Full time

    AboutUs: Alphanext TechnologySolutions is a leading provider of innovative technology solutions.We specialize in delivering robust scalable and efficient ITsolutions to a diverse range of industries. Our commitment toexcellence and innovation drives us to seek top talent to join ourteam. JobOverview: We are seeking anexperienced Oracle DBA with Cloud...

  • Oracle DBA

    2 hours ago

    gurugram, India Alphanext Technology Solutions Full time

    AboutUs: Alphanext TechnologySolutions is a leading provider of innovative technology solutions.We specialize in delivering robust scalable and efficient ITsolutions to a diverse range of industries. Our commitment toexcellence and innovation drives us to seek top talent to join ourteam. JobOverview: We are seeking anexperienced Oracle DBA with Cloud...

  • Sr Oracle Apps DBA

    1 day ago

    gurugram, India Kiash Solutions LLP Full time

    Considering candidates taht can join in 7 days only Oracle Apps Database Administrator Experience: 10+Years ctc - upto 30 lpa Location: Gurgaon/Chennai/Hyderabad/Bangalore Np: Immediate to 7 Days Job Description : Has extensive knowledge in R12.1.3 to R12.2.10 upgrade. Ability to lead and guide team on R12.2 upgrade, prepare playbook for upgrade...