Oracle DBA | Performance Tuning, DR & Automation

Robotic Technologies Automation; Sunnyvale (CA); Vor Ort; USD 120.000 - 170.000; Vollzeit

Zusammenfassung

Robotic Technologies Automation is seeking an experienced Database Administrator/Engineer to guide the Application team and lead installation, upgrade, and tuning of DBMS solutions. You will write SQL patches, develop database programs, and help design scalable databases to support growing data and user loads.

You will continuously monitor systems, write support scripts to deploy and scale storage, and troubleshoot performance issues across platforms.

Qualifikationen

• Experience installing, upgrading, patching Oracle components including RAC, Data Guard, RMAN, OEM, ASM.
• Strong replication experience with GoldenGate or HVR and failover handling.
• Ensure uptime with backup, recovery, refresh, performance tuning, and security.
• Ability to cleanse data, enforce integrity, and implement access controls.
• Handle schema deployment, auditing, and database maintenance tasks.
• Recovery planning for log full events and system crashes; disaster recovery knowledge.

Aufgaben

• Provide guidance and support to the Application team.
• Install, tune, implement and upgrade DBMS installations.
• Write and deploy SQL patches.
• Develop and maintain database programs for traffic and storage needs.
• Design new databases based on needs and user load.
• Monitor databases and related systems for peak functionality.
• Create scripts to deploy, operate, scale storage, and fix DB issues.
• Troubleshoot performance and platform-specific problems.
• Review and debug database scripts and programs.
• Analyze daily/weekly/monthly reports to spot problems and optimize.
• Process work accurately and on time.
• Maintain attention to detail and urgency in tasks.
• Propose system improvements proactively and regularly.
• Collate and present statistical information for internal/external use.

Kenntnisse

Oracle RAC

Data Guard

RMAN

Oracle Enterprise Manager

ASM

Partitioning

GoldenGate

HVR

Backup and Recovery

Performance Tuning

Schema Management

Disaster Recovery

Tools

Oracle GoldenGate

HVR

Oracle Enterprise Manager

RMAN Scripts

Jobbeschreibung

Robotic Technologies Automation is seeking an experienced Database Administrator/Engineer to guide the Application team and lead installation, upgrade, and tuning of DBMS solutions. You will write SQL patches, develop database programs, and help design scalable databases to support growing data and user loads.

You will continuously monitor systems, write support scripts to deploy and scale storage, and troubleshoot performance issues across platforms.