Oracle Database Production Support

The Bank of New York Mellon•Lake Mary, FL

34d

About The Position

At BNY, our culture allows us to run our company better and enables employees' growth and success. As a leading global financial services company at the heart of the global financial system, we influence nearly 20% of the world's investible assets. Every day, our teams harness cutting-edge AI and breakthrough technologies to collaborate with clients, driving transformative solutions that redefine industries and uplift communities worldwide. Recognized as a top destination for innovators, BNY is where bold ideas meet advanced technology and exceptional talent. Together, we power the future of finance - and this is what #LifeAtBNY is all about. Join us and be part of something extraordinary. We're seeking a future team member for the role of Oracle Server Database Production Support to join our Technology Engineering Group team. This role is located in Lake Mary, Florida or Pittsburgh, Pennsylvania. In this role, you'll make an impact in the following ways:

Requirements

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.

Nice To Haves

Experience with other data platforms (PostgreSQL, Snowflake, MongoDB) and Cloud services such as Azure is a plus.
Additional experience with other database platforms is advantageous.

Responsibilities

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.
High Availability & Disaster Recovery: Manage Oracle RAC, ASM, Dataguard and Goldengate ensuring minimal replication lag, guiding secondary read-only usage, and handling planned/unplanned switchovers.
Security & Access Management: Configure privileges and roles to enforce least privilege access for applications and users.
Database Schema Change Management: Lead schema change processes using automation tools like GitLab and Liquibase, including rollback procedures.
Leverage AI/LLM Tools: Utilize Large Language Models (e.g., ChatGPT) to troubleshoot and manage complex Oracle issues.
Cross-Platform Experience: A working knowledge of Linux OS fundamentals and shell scripting is required.

Benefits

BNY offers highly competitive compensation, benefits, and wellbeing programs rooted in a strong culture of excellence and our pay-for-performance philosophy.
We provide access to flexible global resources and tools for your life's journey.
Focus on your health, foster your personal resilience, and reach your financial goals as a valued member of our team, along with generous paid leaves, including paid volunteer time, that can support you and your family through moments that matter.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume