Oracle Apps DBA

Oracle Application Database Administrator

Seniority level:
Mid-Senior level

Employment type:

Full-time

Job function:
Information Technology

Industries:
Staffing and Recruiting

Benefits:
Medical insurance

• Thorough and In-depth knowledge of Oracle ERP, architecture, Oracle RDBMS.
• MSSQL and RPA (Automation Anywhere (Blue prism tool) is Mandatory.
• Apply patches and updates to Oracle EBS, including functional and technical patches.
• Backup and restore Oracle databases using RMAN (Recovery Manager) or other tools.
• Perform database performance tuning, including query optimization and indexing.
• In-Depth Knowledge of Oracle Web Logic Server, OAM, and other Oracle technologies.
• Creates physical database objectives following established standards and processes employed by database team.
• Enforces database standards and follows up on inconsistencies.
• Performs routine reviews of databases and systems to ensure acceptable levels of performance.
• Reports on problem performance areas and recommendations for improvement.
• Follows up on recommendations and actively pushes for implementation as appropriate.
• Understands and apply database concepts such as database definitions, parameters, database components placement, reorganization, access methods and security definitions.
• Works with capacity planning, operations, application developers and other teams on database performance and access issues.
• Very well versed with TLS/OAG certificate renewals.
• Good understanding of Network topology, Proxies, SFTP, IPV4, IPV6 in the E-business portfolios.
• Very good exposure to various other and 3rd party tools - Getpaid, vertex, ETAL, MSSQL, RPA etc.
• Provide advice and support to development resources.
• Monitor database performance, propose and implement agreed performance enhancing changes.
• 24x7 On-call support for Production Incident resolution.
• OEM monitoring, identifying performance issues.
• Unix, Linux basic support, and shell scripting.
• Preferable to have knowledge in OCI.