Oracle DBA

Apply Now

Company: Avani Technology Solutions, Inc.

Location: Tarrytown, NY 10591

Description:

Key Responsibilities:
  • Works as part of the team to provide technical support for applications that have database requirements, including requirements gathering, through installation, configuration, testing and other production.
  • Expertise on database versions 11g,12c,18c including upgrades.
  • Expertise with automating repetitive tasks using shell/python scripts.
  • Expertise with configuring and maintaining RAC clusters and Dataguard configurations.
  • Experience with SQL and PL/SQL tuning, including in-depth tuning analysis with highly complex and vendor supplied code
  • Experience working in a Linux/Unix environment, with equivalent experience writing, maintaining, and/or debugging operating system shell scripts
  • Experience with database Backups, including RMAN, RMAN in a Data Guard Environment, classic export/import, and Oracle data pump.
  • Experience working with traditional Data Warehousing databases, including Database Design and implementation skills, tuning and troubleshooting,
  • Design, Installation, configuration, patching and upgrading of database server software and related products.
  • Establish and maintain sound recovery and backup policies and procedures
  • Implement and maintain database security (create and maintain users and roles, assign privileges).
  • Ensuring data integrity and availability
  • Establish and execute periodic disaster recovery testing
  • Performance management, and tuning
  • Database management, monitoring, and maintenance
  • Capacity planning, Database licensing, Database security and encryption
  • Evaluation of database features and database related products
  • Provide Database compliance for Sarbanes Oxley (SOX)
  • Responsible for database installations, backup & recovery, upgrades, migrations and day to day monitoring using OEM.
  • Responsible for documenting the system in compliance with FDA regulations relating to computerized systems. This includes creating and following SOP, maintaining log books and following system change control procedures.
  • Works closely with the internal customers to ensure the software is configured and service level agreements are created and maintained for new database installs.
  • Works closely with Quality group to ensure Information Systems are developed and implemented according to system development life cycle approach.
  • Develop and support procedures for database security.
  • Implement and support database software upgrade and patch management procedures.
  • Develop processes, procedures and guidelines for troubleshooting database events and performing tasks.
  • Evaluate and seek solutions to production issues as wells as new projects.
  • Work closely with application developers and project managers in solving production issues.
  • Help define appropriate metrics/measures to proactively monitor systems for failures.
  • Work with Oracle support services to resolve customer open issues.
  • Manage and monitor more than 100 Oracle databases in various environments such as Dev, QA, and UAT, pre-prod and prod environments.
  • Database administration for Oracle on premise and in cloud.

Similar Jobs