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 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.

Not only are we the leader in the market segments we serve and the technology we deliver, but we create exceptional consumer experiences in partnership with the world\xe2\x80\x99s leading retailers, restaurants and financial institutions. We leverage our expertise, R&D capabilities and unique platform to help navigate, simplify and run our customers\xe2\x80\x99 technology systems.

Our customers are at the center of everything we do. Our mission is to enable stores, restaurants and financial institutions to exceed their goals \xe2\x80\x93 from customer satisfaction to revenue growth, to operational excellence, to reduced costs and profit growth. Our solutions empower our customers to succeed in today\xe2\x80\x99s competitive landscape.

Our unique perspective brings innovative, industry-leading tech to all the moving parts of business across industries. NCR VOYIX has earned the trust of businesses large and small \xe2\x80\x94 from the best-known brands around the world to your local favorite around the corner.

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.

Offers of employment are conditional upon passage of screening criteria applicable to the job

EEO Statement
Integrated into our shared values is NCR Voyix\xe2\x80\x99s commitment to diversity and equal employment opportunity. All qualified applicants will receive consideration for employment without regard to sex, age, race, color, creed, religion, national origin, disability, sexual orientation, gender identity, veteran status, military service, genetic information, or any other characteristic or conduct protected by law. NCR Voyix is committed to being a globally inclusive company where all people are treated fairly, recognized for their individuality, promoted based on performance and encouraged to strive to reach their full potential. We believe in understanding and respecting differences among all people. Every individual at NCR Voyix has an ongoing responsibility to respect and support a globally diverse environment.

Statement to Third Party Agencies
To ALL recruitment agencies: NCR Voyix only accepts resumes from agencies on the preferred supplier list. Please do not forward resumes to our applicant tracking system, NCR Voyix employees, or any NCR Voyix facility. NCR Voyix is not responsible for any fees or charges associated with unsolicited resumes

\xe2\x80\x9cWhen applying for a job, please make sure to only open emails that you will receive during your application process that come from a @ncrvoyix.com email domain.\xe2\x80\x9d