Bank Of America Assistant Vice President/ President Infrastructure 

Singapore 

506188259

• Believes diversity makes us stronger so we can reflect, connect and meet the diverse needs of our clients and employees around the world.
• Is committed to building a workplace where every employee is welcomed and given the support and resources to perform their jobs successfully.
• Wants to be a great place for people to work and strives to create an environment where all employees have the opportunity to achieve their goals.
• Provides continuous training and development opportunities to help employees achieve their career goals, whatever their background or experience.
• Is committed to advancing our tools, technology, and ways of working to better serve our clients and their evolving business needs.
• Believes in responsible growth and is dedicated to supporting our communities by connecting them to the lending, investing and giving them what they need to remain vibrant and vital.

Job Description:

This role is responsible for providing support/maintain the DB2 connect Infrastructure components on the z/OS mainframe and the DB2 connect gateway servers on the zLinux platform. This role will include programming to automate tasks and enhance our DB2 Connect Infrastructure support processes.

Business needs require DB2 Connect Infrastructure support on z/OS projects across both infrastructure and application DBA support; consistent volume and throughput growth as well as complexity of support requirements across our business partners are driving.

Responsibilities:

• Responsibilities include full life cycle management of DB2 Connect infrastructure components and mainframe databases from analysis through decommission. Additionally, the Individual will be involved in DB2 related z/Os Database software upgrades, including DB2 Database, BMC and Shadow products.

  Day to day activities would include:

• Provision of technical consultation to application teams during the design of database solutions regarding approach, resources, availability, and recoverability.
• Translation of business requirements into a physical model for implementation with a focus on a clear understanding of processing requirements (peak times, # trans etc), performance, availability, recoverability, and data access methods
• Consulting with the application teams on both RACF managed database security to ensure appropriate access is provisioned for data access.
• Defining and implementing application specific backup and recovery strategies for the production environment.
• Implement, change, remove database owned components ensuring adherence to Enterprise and database standards.
• Support of product upgrades related to DB2 providing a focal communication point for development teams as well as completing owned DBA remediation activities, executing internal verification processes, conducting assessments of new feature/function, and providing recommendations for use.
• Performance tuning support and recommendations for database calls, in cooperation with the application development team.
• Monitoring and addressing items on exception reports to ensure a stable production environment.
• Supplying database technical expertise to application developers by assisting in development debugging efforts related to database and providing information on the various database utilities and facilities.
• Support DBA production on call rotation including 24X7 SEV1 test support.
• Conduct information sharing meetings with the application teams when requested.
• Support of Self-Identified Audits, Control assessments, Database Audits and SOX reviews, ensuring deliverables are complete and correct, and all milestone deliverables dates are met.

Required Skills:

• DB2DBA on z/OS position in Singapore to support DB2 Applications and DB2 Infrastructure support for Consumer, Card, Global wealth management business, using mainframe database administration skills.
• Position requires in-depth Mainframe DB2 DBA and DB2 Connect infrastructure knowledge with a focus on performance and DB2.
• Individual should have minimum of 5 years of DB2 DBA experience on z/OS and DB2 connect.
• Job stability is a key requirement.
• In depth working knowledge of DB2 Utilities including IBM and BMC
• Working knowledge of BMC tools including change manager, catalog manager, Mainvew, and SQL performance.
• Solid understanding of DB2 recovery options
• In-depth understanding of DB2 Explain and ability to identify less than optimal access paths.
• Broad understanding of RACF2 managed security for DB2 Access.
• REXX scripting
• Working knowledge of Endevor
• Working knowledge of ITSM Processes and tools including BMC Remedy
• Understanding of Data Dictionaries including Brownstone.
• Background in database design for 24x7 availability.

Desired Skills:

• DB2 Performance skills a big plus
• Shell scripting is a plus
• Programming background a plus
• SAS skills is a plus.
• Python, VB script & MS Access skill is a plus