Oracle Apps DBA

Talent Groups; Sunnyvale (CA); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical insurance

Job summary

A staffing and recruiting company is looking for an Oracle Application Database Administrator to manage Oracle ERP and RDBMS. The role demands proficiency in MSSQL and RPA tools, along with database performance tuning. Responsibilities include applying patches, monitoring database performance, and providing 24/7 on-call support. Candidates must possess thorough knowledge of Oracle technologies, and good understanding of networking and scripting is preferred. This full-time role is a great opportunity for a mid-senior level professional.

Qualifications

• Thorough knowledge of Oracle ERP and Oracle RDBMS.
• MSSQL and RPA experience is mandatory.
• Experience in database performance tuning and optimization.

Responsibilities

• Apply patches and updates to Oracle EBS.
• Backup and restore Oracle databases using RMAN or other tools.
• Monitor database performance and propose enhancements.
• Provide 24x7 on-call support for production incidents.

Skills

Oracle ERP

Oracle RDBMS

MSSQL

RPA (Automation Anywhere)

Database performance tuning

Oracle WebLogic Server

TLS/OAG certificate renewals

Network topology

Unix/Linux basic support

Shell scripting

Job description

Oracle Application Database Administrator

Seniority level: Mid-Senior level

Employment type: Full-time

Job function: Information Technology

Industries: Staffing and Recruiting

Benefits: Medical insurance

Responsibilities

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