Database Admin Professional-Oracle DBA

Date:  Nov 5, 2024
Location: 

Bangalore, India, 560052

Company:  Teva Pharmaceuticals
Job Id:  58566

Who we are

Together, we’re on a mission to make good health more affordable and accessible, to help millions around the world enjoy healthier lives. It’s a mission that bonds our people across nearly 60 countries and a rich, diverse variety of nationalities and backgrounds. Working here means working with the world’s leading manufacturer of generic medicines, and the proud producer of many of the products on the World Health Organization’s Essential Medicines List. Today, at least 200 million people around the world take one of our medicines every single day. An amazing number, but we’re always looking for new ways to continue making a difference, and new people to make a difference with.

The opportunity

As a Lead Database Administrator (DBA), responsible for Oracle, SQL, MY_SQL and PostgreSQL database administration, including code migration, patch analysis, and implementation of data models and designs. Ensure performance optimization, capacity management, and security of databases in a 24x7 production environment. Collaborate with cross-functional teams, support development projects, and participate in on-call rotations. Experience with automation and backup strategies is required, alongside managing complex infrastructure and ensuring compliance with change control procedures.

How you’ll spend your day

Provide 24x7 support for Oracle (10g, 11g, 12c, 19c, 23c) and PostgreSQL databases.
Maintain security and ensure overall reliability of database platforms.
Install, configure, upgrade, and migrate database systems.
Perform performance tuning, monitoring, and capacity planning.
Apply patches, fix bugs, and ensure compliance with change control procedures.
Manage backup, recovery, and disaster recovery strategies.
Clone Oracle databases for development and testing purposes.
Work with internal teams to resolve infrastructure-related issues.
Perform automation using UNIX shell scripting, Ansible, and Python.
Document processes and provide knowledge-sharing across teams.
Participate in on-call rotations and support global team operations

Your experience and qualifications

12+ years of Oracle Database administration experience (L3).
Min 3+ years of SQL Database Administrator experience is required.
Any cloud DBA administration experience is an added benefit.
Experience in automating DBA activities using Ansible and Python.
PostgreSQL & My-SQL Database administration experience is an advantage.
Friday and Saturday will be the week-off.

Oracle Database: Experience with Oracle 10g, 11g, 12c, 19c & 23c is required.
PostgreSQL: Experience with PostgreSQL 10, 11 is preferred.
Database Tools: Proficiency with Oracle Enterprise Manager (OEM 11g, 12c, 13c) is required.
Backup & Restore: Extensive experience with RMAN, Data Pump, and backup/restore processes.
High Availability & DR: Expertise in Disaster Recovery and Data Guard & Goldengate.
Performance Tuning: Advanced experience with performance optimization and tuning.
Automation: Strong skills in automation using Ansible and scripting (UNIX, Python).
Cloud & Infrastructure: Familiarity with Oracle Database administration in the cloud is a plus.
Operating Systems: Knowledge of IBM AIX, Linux, and Windows environments.

Reports To

Associate Director IT Business Application

Already Working @TEVA?

If you are a current Teva employee, please apply using the internal career site available on "Employee Central". By doing so, your application will be treated with priority. You will also be able to see opportunities that are open exclusively to Teva employees. Use the following link to search and apply: Internal Career Site

The internal career site is available from your home network as well. If you have trouble accessing your EC account, please contact your local HR/IT partner.

Teva’s Equal Employment Opportunity Commitment

Teva Pharmaceuticals is committed to equal opportunity in employment. It is Teva's global policy that equal employment opportunity be provided without regard to age, race, creed, color, religion, sex, disability, pregnancy, medical condition, sexual orientation, gender identity or expression, ancestry, veteran status, national or ethnic origin or any other legally recognized status entitled to protection under applicable laws. We are committed to a diverse and inclusive workplace for all. If you are contacted for a job opportunity, please advise us of any accommodations needed to support you throughout the recruitment and selection process. All accommodation information provided will be treated as confidential and used only for the purpose of providing an accessible candidate experience.