Database Administrator
About The Position
BNY is seeking a Database Administrator to join its Data and Analytics team in Boston, Massachusetts. The role provides day-to-day administration and support for hundreds of Oracle databases, including monitoring, maintenance, patching, upgrades, and troubleshooting. The administrator works with internal organizations to address client issues and support requests, monitors database availability, capacity, and performance, and performs database backup and restoration. The role improves database performance through SQL tuning, architectural changes, and database parameter configuration; standardizes and automates environment management; evaluates new database features; and sets up and maintains Oracle GoldenGate services for client data replication. It includes rotating on-call support, including weekend coverage. The work schedule is hybrid, with a requirement to work in the office 20 days over a 90-day period. The posting also includes a separate position summary for a Vice President, Database Management, describing strategic oversight of database systems, database policy and project leadership, and cross-functional collaboration. The summary does not clearly identify that title as the role being recruited for; the posting's specific role heading and detailed duties identify the position as Database Administrator.
Requirements
- Bachelor’s degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and experience.
- The posting states typically 6–10 years of experience and separately specifies 10+ years of IT experience managing and administering Oracle databases in a Linux environment.
- Experience designing and modifying structures in relational database environments such as Oracle Database or SQL Server.
- Strong problem-solving skills and ability to troubleshoot across multiple technical environments.
- Good understanding of Oracle architecture and internals.
- Strong DBA 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 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 DBA tasks using shell scripts and other programming languages.
Nice To Haves
- Experience with Oracle Exadata Cloud at Customer.
- Experience implementing and administering GoldenGate replication.
- Experience with SQL Server administration.
Responsibilities
- Administer, monitor, maintain, patch, upgrade, and troubleshoot hundreds of Oracle databases.
- Work with internal organizations to respond to client issues and support requests.
- Monitor database availability, space, and performance.
- Perform database backups and restorations.
- Tune SQL statements, implement architectural changes, and configure database parameters to improve performance.
- Standardize and automate environment management.
- Provide on-call support for database environments on a rotating schedule, including weekend coverage.
- Evaluate new database features and functionality.
- Set up and maintain Oracle GoldenGate services for client data replication.
Benefits
- Competitive compensation and benefits.
- Wellbeing programs and flexible global resources and tools.
- Paid leaves, including paid volunteer time, vacation, and sick time, subject to eligibility and position.
- Eligible employees may enroll in a 401(k) plan.
- Eligible employees may participate in company-sponsored medical, dental, vision, and basic life insurance plans.
- Eligible employees may receive an annual discretionary incentive award.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
