Job DescriptionDatabase AdministratorWe'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, MA.
In 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 GoldenGate 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 RAC
- Oracle Exadata
- Oracle Golden Gate
- Oracle Enterprise Manager
- Oracle ZFS
- Oracle ZDLRA
- SQL Server
- Linux
- Shell/Python/SQL/PLSQL Scripting
Work Information:
- Primary Work Shift: Mon-Fri 9:00AM - 5:00PM ET
- Alternating Work Shift: Mon-Fri 2:00PM - 10:00PM ET
- Weekend 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 work schedule. Require 20 days in-office over the past 90 days.
**POSITION SUMMARY:** The Vice President, Database Management plays a critical role within the Engineering division, focusing on the strategic oversight and enhancement of database systems to support BNY's commitment to operational excellence and innovation. This position is integral to advancing the organization's strategic pillars of resilience and client-centricity by ensuring the integrity, availability, and performance of data assets. The role aligns with BNY's principles by fostering a collaborative culture and driving continuous improvement in database technologies. **PRIMARY RESPONSIBILITIES:** - Lead the design and implementation of robust database management solutions by leveraging expertise in database technologies to support dynamic business needs. - Ensure database performance, security, and reliability by establishing comprehensive monitoring and optimization protocols. - Collaborate with cross-functional teams to align database strategies with organizational goals, demonstrating strong leadership and communication skills. - Develop and enforce database policies and procedures, ensuring compliance with industry standards and regulatory requirements. - Facilitate continuous improvement through innovative solutions and adopting emerging database technologies. - Oversee complex database projects, ensuring timely delivery and effective resource management. **EDUCATION/QUALIFICATIONS:** - 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 **SKILLS:** - Strong leadership and strategic thinking skills in database management. - Excellent problem-solving abilities with a focus on innovative solutions. - Proficient in communicating complex technical concepts to diverse stakeholders.
