Oracle DBA
Avani Technology Solutions, Tarrytown, NY, United States
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.
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.