Oracle Database Production Support

Oracle Platform Management: Oversee administration of Oracle (Oracle 19) multitenant databases across all business lines, including installation, configuration, patching, upgrades, backup and recovery, database cloning, space management and routine maintenance activities. Performance Tuning & Query Optimization: Collaborate with application teams to analyze query performance. Work on strategies for improving SQL performance including analyzing execution plans and creating indexing strategies. Advise on partitioning strategies for large data sets. Manage Oracle RAC, ASM, Dataguard and Goldengate ensuring minimal replication lag, guiding secondary read-only usage, and handling planned/unplanned switchovers. Experience with other data platforms (PostgreSQL, Snowflake, MongoDB) and Cloud services such as Azure is a plus. Bachelor’s degree in computer science or a related discipline, or equivalent work experience required; advanced degree preferred. 8 – 10 years of related infrastructure experience required; experience in the securities or financial services industry is a plus. Minimum 5 years managing Oracle platforms, with responsibility for 100 database servers and very large (over 10 TB) databases. Experience managing Oracle Exadata, RAC, ASM, Dataguard and Goldengate. Possess strong troubleshooting and SQL/PLSQL coding skills. Familiarity with AI/LLM tools for database management. Additional experience with other database platforms is advantageous.

BNY Mellon