Pros
Benefits are good, free coffee, fruit, juice, vacation days, and discounts on several restaurants. You can take some of the Oracle courses for free (no charge to your org/division), and if you want to take any paid course usually management approve it. Flexibility to work from home when required. Also, at least for my department, we used to install/upgrade latest RDBMS versions which is very challenging and learn the new things faster
Cons
Salary hikes are very difficult, you can spend 3-4 years with no hikes, so better to join the company with a very good salary if you want to be for a long time there. And if you get one it usually won’t be a substantial one. Heard of cases that is better to leave the company and a year later be rehired to get a better salary.