Database Administrator

BNY Mellon

23d•Hybrid

About The Position

BNY is seeking a Database Administrator to join its Data and Analytics team in Boston, Massachusetts. The role supports hundreds of Oracle databases, helping maintain their availability, performance, security, and reliability. The administrator works with internal organizations to address client issues and support requests, improves database operations through tuning, architectural changes, standardization, and automation, and provides rotating on-call support. The posting also includes a separate position summary for a Vice President, Database Management, describing strategic oversight of database systems, cross-functional collaboration, policy development, and complex project management.

Requirements

Bachelor's degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and experience.
Typically 6–10 years of experience; the posting also states 10+ years of IT experience managing and administering Oracle databases in a Linux environment.
Experience designing and modifying structures in a relational database environment, such as Oracle Database or SQL Server.
Excellent problem-solving skills and ability to troubleshoot issues across multiple technical environments.
Good understanding of Oracle architecture and internals.
Strong database administration experience managing Oracle versions 12c and 19c.
Experience with Oracle database upgrades and patch management.
Strong knowledge of Oracle ASM administration.
Experience with backup and recovery solutions using RMAN.
Experience setting up and troubleshooting Oracle Data Guard.
Experience identifying and tuning SQL queries using Oracle technologies.
Experience with Oracle RAC clustering.
Experience managing databases using Oracle Enterprise Manager.
Experience automating database administration tasks using shell scripts and other programming languages.
Strong leadership and strategic-thinking skills in database management, as stated in the included position summary.
Ability to communicate complex technical concepts to diverse stakeholders, as stated in the included position summary.

Nice To Haves

Experience with Oracle Exadata Cloud at Customer.
Experience implementing and administering GoldenGate replication.
Experience with SQL Server administration.

Responsibilities

Provide day-to-day administration and support for Oracle databases, including monitoring, maintenance, patching, upgrades, and troubleshooting.
Work with internal organizations to respond to client issues and support requests.
Monitor database availability, space, and performance.
Perform database backups and restorations.
Improve database performance by tuning SQL statements, implementing architectural changes, and configuring database parameters.
Optimize environment management through standardization and automation.
Provide on-call support for database environments on a rotating schedule.
Evaluate new database features and functionality.
Set up and maintain Oracle GoldenGate services for client data replication.
Lead the design and implementation of database management solutions to support business needs, as described in the included position summary.
Establish monitoring and optimization protocols to support database performance, security, and reliability, as described in the included position summary.
Collaborate with cross-functional teams to align database strategies with organizational goals, as described in the included position summary.
Develop and enforce database policies and procedures that comply with industry standards and regulatory requirements, as described in the included position summary.
Support continuous improvement through innovative solutions and adoption of emerging database technologies, as described in the included position summary.
Oversee complex database projects, including timely delivery and resource management, as described in the included position summary.