Database Administrator

Job-:
Database Management

Location:

Boston, MA, United States;
Pittsburgh, PA, United States

Schedule:

Full time, Day Posted:
Base Salary Min: 69000

Base Salary Max: 185000

Database Administrator 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 Database Administrator to join our Data and Analytics team. This role is located in Boston,  this role, you’ll make an impact in the following ways:
Provide day-to-day administration and support functions(monitoring, maintenance, patching, upgrades, troubleshooting) for hundreds of Oracle databases.

Work closely with internal organizations to respond to client issues and support requests.

Monitor database availability, space and performance.

Perform backup and restoration of databases.

Improve database performance by tuning individual SQL statements, implementing architectural changes or configuring database parameters. Optimize environment management through standardization and automation.

Provide on-call support for database environments on a rotating schedule.

Evaluate new features and functionality.

Setup and maintain Oracle Golden Gate services for client data replication.

To be successful in this role, we’re seeking the following:
Bachelor's degree in Computer Science, Information Technology, or a related field or the equivalent combination of education and experience required.
*
* EXPERIENCE:

** Typically 6-10 years of experience
10+ years of IT experience in managing and administrating Oracle databases in Linux environment.

Experience with the design and modification of structures in a relational database environment such as Oracle Database or SQL Server.

Excellent problem-solving skills and skilled at troubleshooting issues over multiple technical environments.

Good understanding of Oracle Architecture and Internals.

Strong database DBA experience in managing Oracle versions 12c/19c.Experienced in Oracle database Upgrades and Patch management.

Strong knowledge of Oracle ASM administration.

Experience with backup/recovery solutions using RMAN.Experience in setting up and troubleshooting Oracle Data Guard.

Experience with identifying and tuning SQL queries using Oracle Technologies.

Experience with Oracle RAC clustering.

Experience with managing databases using Oracle Enterprise Manager.

Experience in Automating DBA tasks using shell script and other programming languages.

Experience with Oracle Exadata cloud at Customer (a plus)
Experienced in implementing and administering Goldengate replication (a plus).

Experience with SQL Server administration (a plus).Key Technologies:

Oracle RDBMS/Grid Infrastructure(Versions 19c and up)
Oracle RACOracle Exadata Oracle Golden Gate Oracle Enterprise Manager Oracle ZFSOracle ZDLRASQL Server Linux Shell /Python/SQL/PLSQL Scripting Work Information:

Primary

Work Shift:

Mon-Fri 9:00AM - 5:00PM ETAlternating

Work Shift:

Mon-Fri 2:00PM - 10:00PM ETWeekend on-call duties on a rotating basis with the rest of the team.  
Sat: 9:00AM - 9:00PM for scheduled work and as needed for emergency coverage.

Sun:
As needed for emergency coverage.

Hybrid in-office…