Database Administrator

About the role

Database Administrator position within the Data and Analytics team at BNY, located in Boston, MA. Hybrid in-office work schedule requiring 20 days in-office over the past 90 days.

Responsibilities

• 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

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field or the equivalent combination of education and experience required
• 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

Schedule

• 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
• Saturday: 9:00AM - 9:00PM for scheduled work and as needed for emergency coverage
• Sunday: As needed for emergency coverage
• Hybrid in-office work schedule requiring 20 days in-office over the past 90 days

Benefits