Oracle Apps DBA

Oracle Apps DBA

Sunnyvale, CA (Onsite 3days/week) Full-Time

Technical Skills:

• Thorough and in-depth knowledge of oracle ERP, architecture, Oracle RDBMS.
• Excellent trouble-shooting skills - mandatory.
• 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.

Leadership Skills:

• Engage team members to take, follow-up and resolve issues effectively.
• Able to make decisions quickly to address the issues effectively.
• Manage multiple stakeholders effectively without conflict(s).
• Motivate team members to take up new challenges across all severity issues.
• Understand/adhere to the business process during PST hours.
• Effective shift management and resource management.
• Availability during crisis, major-incidents.