Database Administrator – DB2 LUW UDB

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.

TSG is building next generation scalable, efficient data center as a service using the latest innovation infrastructure. Building on top of the cloud deployments in BNY Mellon, we are aggressively automating and bridging the green field cloud with the existing virtual computing environments.

The Database Administration team is seeking a DB2 LUW UDB Database Administrator who will be responsible for Database Administration in a fast-paced environment supporting business critical applications using analytical and transactional databases on DB2 LUW. We are a deep and talented resource pool of database professionals with a mission to establish robust data governance and database management practices, with a focus to build strong partnerships within all areas of the company requiring database support. Database Administration’s strategy is to provide highly reliable, scalable and supportable database environments through the use of consistent, effective processes and best practices.

Responsibilities Include:

• Install, configure, monitor, upgrade and maintain DB2 LUW databases in production and non-production environments.
• Interact with Storage and Deployment teams with AIX, Linux, and Windows operating systems.
• Support a High Availability Disaster Recovery (HADR) environment.
• Participate in Database Maintenance and DR activities.
• Provide database deployment support for production and non-production environments.
• Perform space management activities such as table space creation, modification, etc.
• Perform DB2 LUW maintenance activities.
• Troubleshoot database production problems and database connectivity issues.
• Implement Business Continuity Solutions such as Database refresh, cloning, Database Backups, etc.
• Write database maintenance and automation scripts.
• Monitor the database environment on a regular basis for performance and other issues.
• Perform database maintenance activities using security and access control tools.
• Implement DR solutions.
• Configure and maintain database high availability.

Qualifications

• Bachelor’s degree in computer science or a related discipline, or equivalent work experience.
• 8-10 years of experience in design and administration of logical and relational databases or systems analysis.
• Solid understanding of Database technology – DB2 LUW.
• Good understanding of Linux/VM, AIX, Linux/Unix and Windows operating system platforms.
• Good understanding of HA, DR Databases and storage technologies such as Data Replication, SRDF/non-SRDF.
• Experience with Unix Shell scripting and automation.
• Database performance tuning experience.
• Experience in the securities or financial services industry.
• Ability to work well as a team and as an individual with minimal supervision.

Qualifications

For over 230 years, the people of BNY Mellon have been at the forefront of finance, expanding the financial markets while supporting investors throughout the investment lifecycle. BNY Mellon can act as a single point of contact for clients looking to create, trade, hold, manage, service, distribute or restructure investments & safeguards nearly one-fifth of the world’s financial assets. BNY Mellon remains one of the safest, most trusted and admired companies. Every day our employees make their mark by helping clients better manage and service their financial assets around the world. Whether providing financial services for institutions, corporations or individual investors, clients count on the people of BNY Mellon across time zones and in 35 countries and more than 100 markets. It’s the collective ambition, innovative thinking and exceptionally focused client service paired with a commitment to doing what is right that continues to set us apart. Make your mark: bnymellon.com/careers.

Client Technology Solutions provides our business partners with client-focused, technology-based solutions. These enhance their ability to be successful through world-class software solutions and leading-edge infrastructure. Client Technology Solutions provides employees with the tools and resources to enhance their professional qualifications and careers.

BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer.

Minorities/Females/Individuals With Disabilities/Protected Veterans.

Primary Location: United States-Pennsylvania-Pittsburgh

Internal Jobcode: 45152

Job: Information Technology

Organization: Technology Services Group-HR06725

Requisition Number: 1701897