Job Description:
At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.
One of the keys to driving Responsible Growth is being a great place to work for our teammates around the world. Were devoted to being a diverse and inclusive workplace for everyone. We hire individuals with a broad range of backgrounds and experiences and invest heavily in our teammates and their families by offering competitive benefits to support their physical, emotional, and financial well-being.
Bank of America believes both in the importance of working together and offering flexibility to our employees. We use a multi-faceted approach for flexibility, depending on the various roles in our organization.
Working at Bank of America will give you a great career with opportunities to learn, grow and make an impact, along with the power to make a difference. Join us!
The Chief Technology Organization:
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.
DB2DBA support crosses all regions, interfaces with vendors, and has multiple LOB impact implications. We support infrastructure and applications needs across 150 AIT DB2 applications & with each supporting multiple application.
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 DB
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
