Oracle DBA — Performance Tuning & High Availability

Robotics Technologies LLC; Weehawken (NJ); In loco; USD 90.000 - 131.000; Tempo pieno

Descrizione del lavoro

Robotics Technologies LLC is seeking an Oracle Database Administrator to manage and optimize Oracle database environments across development, test, staging, and production. The role focuses on availability, security, performance, and reliability of mission-critical applications in a US-based setting.

Responsibilities include installation, maintenance, tuning, backup and recovery, DR planning, change management, and collaboration with developers and operations teams.

Competenze

• Minimum 3 years of experience as an Oracle Database Administrator.
• Strong experience with Oracle Database administration in enterprise environments.
• Proven experience identifying, analyzing, and resolving database performance issues.

Mansioni

• Install, configure, upgrade, and maintain Oracle databases across development, test, stage, and production environments.
• Monitor database health, availability, security, storage utilization, and backup/recovery processes.
• Support application deployments and collaborate with developers to ensure efficient database design and operation.
• Implement and maintain backup, recovery, disaster recovery, and high-availability solutions.
• Troubleshoot and resolve database incidents, outages, and data-related issues.
• Develop and maintain SOPs, operational procedures, and technical documentation.
• Participate in change management, system upgrades, and Agile project activities.
• Proactively monitor and analyze database performance to identify bottlenecks and optimization opportunities.
• Perform SQL and PL/SQL tuning using execution plans, AWR, ASH, Statspack, and Oracle performance diagnostic tools.
• Analyze and optimize database queries, indexes, partitions, and schema designs to improve performance.
• Monitor and optimize CPU, memory, I/O, and network utilization.
• Partner with application teams to diagnose and resolve performance issues across the database and application stack.
• Establish performance baselines and implement proactive monitoring and alerting strategies.

Conoscenze

Oracle DBA

Performance Tuning

SQL Optimization

PL/SQL

Execution Plans

Oracle RAC

Data Guard

RMAN

Backup & Recovery

Security

Capacity Planning

Documentation

Agile

Strumenti

RMAN

Data Pump

Descrizione del lavoro

Robotics Technologies LLC is seeking an Oracle Database Administrator to manage and optimize Oracle database environments across development, test, staging, and production. The role focuses on availability, security, performance, and reliability of mission-critical applications in a US-based setting.

Responsibilities include installation, maintenance, tuning, backup and recovery, DR planning, change management, and collaboration with developers and operations teams.