TECHNOLOGY SERVICES GROUP (TSG) is the central infrastructure services group with a proven track record of innovating to help BNY Mellon and its customers have most reliable, nimble and cost-effective solutions in the financial services market place. BNY Mellon BXP technology is leading edge with industry first PasS/IaaS fully integrated solution, combined with enterprise standards for developers.
This is a 2nd shift position in Pittsburgh, PA, for a special group.
Oracle Database Administrator (DBA) maintains all enterprise databases to ensure integrity, performance, availability, and recoverability of data. This administrator conducts end-to-end plan design, production support, and implements and monitors database systems. The primary focus for this individual will be to provide production support, database design, install, monitors, patch Oracle database environments. Must be willing to participate in weekly rotations to provide on-site DBA support during evenings and weekends.
Primary Job Responsibilities Include:
Proactively monitor database performance and take necessary actions to improve throughput and stability of the database platform.
Plan and execute database upgrades and patches.
Troubleshoot production issues and clearly communicate the resolution to the stakeholders.
Work with Data and Business Architects to come up with optimal logical and physical database design.
Work with application development teams to rollout DB changes in all environments.
Ensure that the development and test databases are functioning properly and work the developers to make sure that the enterprise database conventions and security standards are being followed.
Participate in weekly rotation to provide DBA support evenings and weekends on premises.
Sr. Specialist Database Analyst->> Designs, implements, and supports database management structures, as well as database back-up, recovery, security, archiving and conversion strategies. Collaborates with application development teams on various database issues and takes a lead role in problem resolution. Collaborates and consults with application development teams to determine database/system platform selection, efficient database design, and access. Provides technical assistance and mentoring to staff in all areas of database support. Designs, implements, and maintains physical database structures and associated network and system configurations. Manages data, maintaining data integrity, using effective utility and disk management procedures. Monitors database and replication servers for resource utilization. Uses knowledge and expertise of existing database environments to make recommendations for opportunities to share data and/or reduce data redundancies. Assists database team in providing problem identification and resolution support through analysis and research. Designs and administers database security strategies. Installs and configures database management system and related distributed system software as needed. Contributes to the achievement of area objectives.
Bachelor's degree in computer science or a related discipline, or equivalent work experience required.
8-10 years of experience in design and administration of logical and relational databases or systems analysis required.
Extensive Oracle database administration skills.
Strong understanding of all aspects of Oracle 11g and 12c.
Experience with Exadata administration, installation, configuration and patching is a plus.
Ability to troubleshoot production problems and performance tuning.
3+ years of Unix Shell Scripting experience, working with Linux and Solaris operating systems preferred.
Effective interpersonal and time management skills – able to build consensus/trust driven relationships. The ability to articulate issues and work in a team oriented environment toward their resolution is critical to the success of this position.
Should be motivated and work well under pressure.
Good verbal and written communication skills are key as are project and time management skills.
Experience in the securities or financial services industry is a plus.
WE ARE BNY MELLON! BNY Mellon is a global investments company dedicated to helping its clients manage and service their financial assets throughout the investment lifecycle. Whether providing financial services for institutions, corporations or individual investors, BNY Mellon delivers informed investment management and investment services in 35 countries and more than 100 markets. As of June 30,... 2014, BNY Mellon had $28.5 trillion in assets under custody and/or administration, and $1.6 trillion in assets under management. BNY Mellon can act as a single point of contact for clients looking to create trade, hold, manage, service, distribute or restructure investments. BNY Mellon is the corporate brand of The Bank of New York Mellon Corporation (NYSE: BK). Additional information is available on www.bnymellon.com or, follow us on Twitter @BNYMellon.