Vice President, Oracle Database Administrator

BNY Mellon; Town of Florida (NY); On-site; USD 140,000 - 210,000; Full time

Job summary

BNY Mellon in Lake Mary, Florida seeks a Vice President, Production Services Infrastructure Support to lead the administration and ongoing reliability of mission-critical Oracle Database environments. You will manage RAC, Data Guard, and Multitenant architectures across production and non-production systems, driving automation and partnering with cross-functional teams.

You will guide Oracle GoldenGate implementations, including cloud replication to Snowflake, perform upgrades, tuning, and DR

Qualifications

• Bachelor's degree or equivalent work experience.
• 8+ years of Oracle Database Administration experience in large-scale environments.
• 3+ years of Oracle GoldenGate administration and upgrades.
• Experience supporting 24x7 mission-critical production systems.
• Strong performance tuning, SQL optimization, capacity planning, and RCA.
• Experience with GoldenGate replication to cloud platforms including Snowflake is desirable.
• Experience with Exadata, OCI, Azure, and GoldenGate Microservices Architecture preferred.
• Proficiency in SQL, PL/SQL, Shell scripting, and automation best practices.
• Strong communication and stakeholder management; ability to participate in on-call rotations.

Responsibilities

• Administer and support Oracle Database environments ensuring high availability and security.
• Manage Oracle RAC, ASM, Data Guard, and Multitenant architecture across prod and non-prod.
• Install, configure, and support GoldenGate replication including cloud targets like Snowflake.
• Monitor, troubleshoot, and resolve incidents per SLAs; lead upgrades and migrations.
• Develop automation using Shell, SQL, and PL/SQL to improve efficiency.
• Collaborate with development, infrastructure, cloud, and engineering teams to deliver resilient solutions.
• Provide technical leadership and mentor junior DBAs; contribute to operational excellence.

Skills

SQL

PL/SQL

Shell scripting

Automation

Performance tuning

Root cause analysis

On-call incident response

Stakeholder management

Communication

Education

Bachelor's degree in Computer Science/Information Technology/Engineering

Tools

Oracle Database 19c

Oracle RAC

Oracle ASM

Data Guard

Multitenant (CDB/PDB)

GoldenGate

Exadata

Snowflake

OCI / Azure

Job description

We're seeking a Vice President, Production Services Infrastructure Support to join our Production Services Infrastructure Support team in Lake Mary, Florida.

In this role, you'll make an impact in the following ways:

• Administer and support mission-critical Oracle Database environments, ensuring high availability, performance, security, and operational stability.
• Manage Oracle RAC, ASM, Data Guard, Multitenant (CDB/PDB), and Exadata platforms across production and non-production environments.
• Install, configure, administer, and support Oracle GoldenGate replication solutions, including heterogeneous replication to cloud platforms such as Snowflake.
• Monitor and troubleshoot database and replication issues, ensuring timely resolution of incidents and adherence to SLAs.
• Lead database upgrades, patching, migrations, cloning, and modernization initiatives.
• Perform performance analysis and tuning using AWR, ASH, ADDM, SQL Monitor, and Oracle Enterprise Manager.
• Support disaster recovery planning, testing, switchover, failover, and failback activities for business-critical applications.
• Develop automation solutions using Shell scripting, SQL, and PL/SQL to improve operational efficiency and reduce manual effort.
• Collaborate with application development, infrastructure, cloud, and engineering teams to deliver resilient database solutions.
• Provide technical leadership, mentor junior DBAs, and contribute to operational excellence initiatives.

To be successful in this role, we're seeking the following:

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent work experience.
• 8+ years of Oracle Database Administration experience supporting large-scale enterprise environments.
• Strong hands-on experience with Oracle Database 19c and related technologies, including RAC, ASM, Data Guard, RMAN, and Multitenant architecture.
• Minimum 3+ years of Oracle GoldenGate administration experience, including implementation, monitoring, troubleshooting, and upgrade activities.
• Demonstrated experience supporting high-volume, mission-critical production systems in a 24x7 environment.
• Strong expertise in database performance tuning, SQL optimization, capacity planning, and root cause analysis.
• Experience with GoldenGate replication to cloud platforms, including Snowflake, is highly desirable.
• Experience with Oracle Exadata, Oracle Cloud Infrastructure (OCI), Azure, and GoldenGate Microservices Architecture is preferred.
• Proficiency in SQL, PL/SQL, Shell scripting, and automation best practices.
• Strong analytical, problem-solving, communication, and stakeholder management skills.
• Ability to participate in on-call support rotations and lead critical incident response activities.
• Oracle certifications (OCP and/or GoldenGate Certification) are preferred.