Oracle Database Administrator

**Your team responsibilities**
- Administration and maintenance of DB Systems and related MS Azure Cloud VMs.
- Planning and execution of On-Prem to Cloud database migration.
- Monitoring database performance across the production, beta and development services.
- Shell scripting and automation of DBA tasks and critical project deliveries.
- Handling of database backups, restore and recovery scenarios
- In-depth performance analysis using OEM, AWR, ASH, TKPOF, internal tracing etc.
- Troubleshoot P1/MI incidents and find the RCA, permanent resolution to ensure maximum uptime and database performance stability.
- Proactively manage and maintain security standards and controls.
- Proactive database review to optimize and simplify architecture and performance.
- Database Operation support and handling of database request tickets and alerts.
- Capacity planning and space management.
- Planning and execution of database migration and upgrade from 12c to 19c.
- Implement and fine tune disaster recovery solutions - standby/Active Dataguard.
- Create a reliable backup strategies. Ensure database backups are appropriately executed and periodic restorations are exercised to ensure backup quality.
- Determine and document DB policies, procedures and standards.
- Ensure Change process and required scripts and run books for the executions.
- Performance testing and evaluation to ensure data security, privacy and integrity. Identification of bottle necks and deadlock issues.
- Work on automation and scripting for time consuming DBA tasks/projects and ensure optimum and quality deliveries.
- Work on OEM alerts fine tuning and also ensure effective monitoring dashboards and customized database alerts.
- Periodic Patching of Database and Cloud VM instances.
- Support for table partitioning and effective index designs
- Recommend/implement stable stats gathering policies and other Oracle recommended standards suitable to MSCI environment.
- Database Encryption, Compression, Edition and Transportable tablespace
- Active support for database operations, projects and Engineering deliveries.
- Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
- Readiness to learn No-SQL (Cassandra/Mongo DB, Neo4J ) and start with L1/L2 support.

**What we will offer you**:

- At MSCI, we provide competitive benefits programs in every region in which we do business. While our benefits plans vary in availability in our different locations, we offer a broad range of benefits that are part of the value you receive as a MSCI employee. Wherever you are with us, you will find benefits that can help ensure your health and well-being and contribute to your financial security.

**Your key responsibilities**
- Administration and maintenance of DB Systems and related MS Azure Cloud VMs.
- Planning and execution of On-Prem to Cloud database migration.
- Monitoring database performance across the production, beta and development services.
- Shell scripting and automation of DBA tasks and critical project deliveries.
- Handling of database backups, restore and recovery scenarios
- In-depth performance analysis using OEM, AWR, ASH, TKPOF, internal tracing etc.
- Troubleshoot P1/MI incidents and find the RCA, permanent resolution to ensure maximum uptime and database performance stability.
- Proactively manage and maintain security standards and controls.
- Proactive database review to optimize and simplify architecture and performance.
- Database Operation support and handling of database request tickets and alerts.
- Capacity planning and space management.
- Planning and execution of database migration and upgrade from 12c to 19c.
- Implement and fine tune disaster recovery solutions - standby/Active Dataguard.
- Create a reliable backup strategies. Ensure database backups are appropriately executed and periodic restorations are exercised to ensure backup quality.
- Determine and document DB policies, procedures and standards.
- Ensure Change process and required scripts and run books for the executions.
- Performance testing and evaluation to ensure data security, privacy and integrity. Identification of bottle necks and deadlock issues.
- Work on automation and scripting for time consuming DBA tasks/projects and ensure optimum and quality deliveries.
- Work on OEM alerts fine tuning and also ensure effective monitoring dashboards and customized database alerts.
- Periodic Patching of Database and Cloud VM instances.
- Support for table partitioning and effective index designs
- Recommend/implement stable stats gathering policies and other Oracle recommended standards suitable to MSCI environment.
- Database Encryption, Compression, Edition and Transportable tablespace
- Active support for database operations, projects and Engineering deliveries.
- Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incid