Oracle DBA

Luxoft USA Inc
New york city, NY
02 May 2024

Vacancy expired!

  • Project Description:Our client is looking to a comprehensive real-time trade blotter to satisfy our SEC reporting requirements. The client will be sourcing Orders, Fills from 14 trading systems (currently in use) on a real-time basis and will normalize the events, save them into an s3 bucket and a relational database. The Normalized Fills are aggregated into Trades and reported to Bloomberg AIM.
  • Responsibilities:• Install, configure and maintain Oracle 19/12c software on Red Hat Linux platform• Install, configure and maintain Oracle 19/12c Data Guard software on Red Hat Linux platform• Install configure and maintain Oracle Data Guard in Single Instance• Manage database space using BRTOOLS file system on Red Hat Linux platform• Tune database parameters for optimal system performance.• Ensure proper setting of system memory and semaphore system parameters in consultation with system administrators.• Create and maintain Oracle 12c/19c databases with optimal file layout for data file, rollback, and redo objects.• Assist developers and logical DBAs in detecting performance problems including analysis of SQL, PL/SQL, and JDBC code.• Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the Oracle 19/12c environments using Oracle Diagnostic and Tuning packs• Provide backup and restore functions for Oracle 19/12c databases.• Implement Database failover technologies using clustering technologies in Linux• Participate in On Call weekly shift supporting off hours and weekend activity. This is rotating assignment shared with other members of the team as necessary• Follow ITIL processes for incident management, change management and problem management• Compliance with ISO 20000 and ISO 27001 standard processes.• Understanding of HIPAA and SOX Oracle compliance and controls
  • Mandatory Skills Description:Educational Qualifications and Experience:• Minimum education requirement of Bachelor's in Computer Science, IT, or STEM field• 5 - 7 years relevant experience as a DBA in Oracle 11g/12c/18c/19c

    Certification Requirements:• One of Oracle 11g/12c/18/19c certification is required. Relevant experience in remote management of Production database system Required Skills/Abilities:• Extensive experience in Oracle backup and Recovery using SAP Brtools• Experience in operating Oracle in SAP ERP environment• Relevant experience with RMAN for backup and recovery• Unix Shell Scripting experience is required• Experience in Oracle Transparent Data Encryption• Relevant experience in use of ITIL processes• Relevant experience for SOX/CIS compliance of critical financial systems
  • ID: #40053275
  • State: New York New york city 10001 New york city USA
  • City: New york city
  • Salary: Depends on Experience
  • Job type: Permanent
  • Showed: 2022-05-02
  • Deadline: 2022-06-26
  • Category: Software/QA/DBA/etc