The successful candidate will leverage their technical knowledge across Oracle database and related technologies and best practices to support databases in Watson Health. The candidate will own the responsibility of design, availability and maintenance of databases that support various critical applications.
Key Responsibilities:
Administer, maintain , tune, and troubleshoot Oracle databases to provide high availability and reliability to the databases and applications running on them.
Administer databases running on RAC in Exadata environments.
Work with application teams, product teams and onshore DBA team to design, provision, maintain and tune Oracle databases .
Adopt and learn new cloud technologies for use in Watson Health solutions.
Automate Manual Tasks and d ocumentation of work.
Primary Skills Required:
7 -10 years of relevant experience and in-depth knowledge o f Oracle Database Architecture.
Experience in working with RAC databases.
Experience in working with multi-tenant database s.
Experience with performance tuning.
Experience with database backup, restoration, refresh using Recovery Manager (RMAN)
Experience with database, schema, table level refresh using datapump .
Experience with software Installation and Creation of 12c 19c Databases on RAC and Non-RAC environments.
Experience with database upgrades.
Experience with cross-platform database migrations.
Experience in working with Exadata machines and databases running on them.
Experience working with ASM storage.
Experience with Oracle Enterprise Manager 13c.
Experience in applying database , grid patches as per the organization policies.
Experience with design, set up and maintenance of data guard environments.
Experience in writing shell script s will be an added advantage .
Experience working with Postgres Databases. Installation, upgrades, tuning and troubleshooting expertise is highly required.
Experience with OCI Cloud Implementation and Management
Good knowledge of ITIL processes .
Preferred Skills :
DB2 administration
Oracle Apps administration
MySQL administration
Oracle ZFS Storage
Experience with databases on Azure
Experience with GitHub
Experience with Service Now
Knowledge of general cloud concepts
Knowledge of Linux Operating system
Knowledge of networking concepts
Knowledge of Python programming language
Experience:
7 -10 years in Oracle database administration
Education Requirements:
Bachelors / Master s degree in computer science , system analysis , or equivalent experience.