Job 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.

Job Tags

Similar Jobs