Luxoft USA Inc

Oracle DBA

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: New York
  • Experience: NA
  • No. of Positions: 1
  • Primary Skills: Oracle DBA
  • Secondary Skills: See job description
  • Job Location: New York, New York
  • Posted Date: Posted today
Job Description
  • 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
Relevant Job Openings
Java Developer