Prorsum Technologies - New York, NY

posted 3 months ago

Full-time
New York, NY
Professional, Scientific, and Technical Services

About the position

The Oracle Exadata DBA position is a long-term opportunity based in New York, NY, specifically designed for local candidates. This role is crucial for managing and optimizing Oracle databases, particularly focusing on Oracle Exadata and Exalogic systems. The successful candidate will be responsible for the installation, administration, and tuning of Oracle databases, ensuring high availability and performance across various platforms including Linux, Unix, and Windows. In this role, you will work extensively with Oracle Database 19c, utilizing multitenant concepts such as Container Databases (CDBs) and Pluggable Databases (PDBs). You will also leverage Oracle OEM Cloud Control for monitoring and managing database environments. A significant part of your responsibilities will include implementing Oracle Zero Data Loss Recovery Appliance (ZDLRA) for efficient database backups and restores, ensuring data integrity and availability. The position requires a deep understanding of database tuning and optimization, where you will be expected to enhance database performance through effective query optimization and coaching developers on best practices. Additionally, you will be involved in the installation and configuration of Oracle DataGuard and GoldenGate, which are essential for disaster recovery and data replication. This role is hybrid, allowing for a mix of remote and on-site work, providing flexibility while maintaining close collaboration with the team.

Responsibilities

  • Install, configure, and administer Oracle databases on Linux, Unix, and Windows platforms.
  • Manage and optimize Oracle Exadata and Exalogic systems.
  • Utilize Oracle Database 19c and multitenant concepts (CDBs and PDBs).
  • Implement and manage Oracle OEM Cloud Control for database monitoring.
  • Utilize Oracle ZDLRA for database backups and restores.
  • Tune and optimize Oracle databases for performance across various platforms.
  • Install and configure Oracle DataGuard and GoldenGate for data protection and replication.
  • Coach developers on SQL query optimization and best practices.

Requirements

  • At least 10 years of experience as an Oracle Database Administrator (DBA).
  • Proven experience with Oracle Exadata and Exalogic systems.
  • Strong knowledge of Oracle Databases 19c and multitenant concepts (CDBs and PDBs).
  • Experience with Oracle OEM Cloud Control for database management.
  • Familiarity with Oracle ZDLRA for database backups and restores.
  • Proficient in installing and administering Oracle databases on Linux, Unix, and Windows.
  • Experience in tuning and optimizing Oracle databases on various platforms.
  • Knowledge of installing and configuring Oracle DataGuard and GoldenGate.
  • Strong skills in SQL, PL/SQL (Oracle 11+), database functions, and stored procedures.
  • Experience in tuning and optimizing database queries.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service