Job Description

:

Your background

• Bachelor's degree or equivalent work experience. At least 7 years of professional experience with Db2 database and performance tuning.
• Position requires in-dpeth Mainframe DB2 DBA (DB2 on z/OS) knowledge with a focus on performance and DB2 internals.
• Individual should have minimum of 7-9 years of DB2 DBA experience on z/OS at a single large financial institution.
• In depth working knowledge of DB2 Utilities including IBM and BMC
• Working knowledge of BMC tools including change manager, catalog manager, Mainview, 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 ACF2 and RACF2 managed security for DB2 Access.
• Working knowledge of Endevor
• Working knowledge of ITSM Processes and tools including BMC Remedy
• Understanding of Data Dictionaries including Brownstone.
• Experience with database design for 24x7 availability

What you can expect

The Mainframe optimization and DB2 DBA performance and stability team provides support for database administration, performance tuning, mainframe optimization and stability of the database environment. The task includes reviewing various reports, identify the poor performing SQL, batch jobs and OLTP transactions and provide recommendations to DBAs and application developers.

Shift Patterns

• Shift B: 2 pm to 11pm, including 1 hour meal break

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.

What you will do

• Responsibilities include full life cycle management of DB2 mainframe databases from analysis through decommission. Additionally, the Individual will be involved in DB2 related z/Os Database software upgrades, including DB2 Database, DB2 Connect, BMC and Shadow products.
• Day to day activities would include:
• Provision of technical consultation to application teams during the design of database solutions in regard to 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 ACF2 and 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.

About Bank of America

Our purpose as a firm is to make financial lives better, through the power of every connection. Across the world, we partner with leading corporate and institutional investors through our offices in more than 35 countries. In the U.S. alone, we serve almost all of the Fortune 500 companies and approximately 67 million consumer and small-business clients. We provide a full suite of financial products and services, from banking and investments to asset and risk management. We cover a broad range of asset classes, making us a global leader in corporate and investment banking, sales and trading.

Connecting Asia Pacific to the world

Our Asia Pacific team is spread across 19 cities in 12 markets. We are focused on connecting Asia to the world and the world to Asia, using our global expertise to ensure success is shared between us, our clients and our communities. Our regional footprint covers 12 currencies, more than a dozen languages and five time zones, placing us firmly among the region's leading financial services companies.