Mainframe DB2 DBA - Core Technology Infrastructure at Bank of America (Charlotte, NC)

| Charlotte, NC
Sorry, this job was removed at 9:19 a.m. (CST) on Thursday, May 26, 2022
Find out who's hiring in Charlotte, NC.
See all Data + Analytics jobs in Charlotte, NC
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Job Description:
The Mainframe DB2 Database Architect will be a key stakeholder in Mainframe processes.
Summary of Role:
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.
Responsibilities:
  • Position requires Mainframe DB2 DBA (DB2 on z/OS) knowledge with a focus on replication.
  • Individual should have minimum of 2-4 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.
  • - Background in database design for 24x7 availability.
  • Supports senior personnel and project managers on technical projects
  • Assists and helps train junior analysts - includes guiding and providing technical peer reviews.
  • Works on complex problems where analysis of situation or data requires an in-depth evaluation of various factors; exercises judgment within broadly defined practices and policies in selecting methods, techniques, and evaluation criterion for obtaining results.
  • Will participate in 7x24 on call rotation.
  • Familiar with fundamental problem and dump analysis utilizing diagnostic tools.
  • Proficient in MS Office Tools - Excel, PowerPoint, Word.
  • Able to communicate effectively with peers, management and other technical support associates in a diverse global environment.
  • Must be a highly motivated self starter able to work with minimal supervision.

Desired Job Skills:
  • Project management skills
  • Assembler, CLIST, and REXX knowledge
  • Conceptual understanding of Mainframe Operations

Bank of America's Global Banking and Markets 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.

LOB Job Profile:
Leads and/or participates in the design, development, and implementation of complex system engineering activities involving cross-functional technical support, systems programming and data center capabilities. Responsible for components of highly complex engineering and/or analytical tasks and activities. Establishes input/output processes and working parameters for hardware/software compatibility, coordination of subsystems design, and integration of total system. Viewed as a technology subject matter expert; able to provide and communicate complex technology solutions across differing audiences including technical, managerial, business executives, and/or vendors. Will have responsibility for multiple, complex projects; will direct activities of teams related to special initiatives or operations and may have direct reports. Leads the resolution process for complex problems where analysis of situations or data requires an in-depth evaluation of various factors. Exercises judgment within broadly defined practices and policies in selecting methods, techniques, and evaluation criterion for obtaining results. Information Technology degree and/or technology certifications preferred or substantial equivalent experience. Typically 7-10 years of IT experience.
Shift:
1st shift (United States of America)
Hours Per Week:
40
Learn more about this role
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • C++Languages
    • GolangLanguages
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PerlLanguages
    • PythonLanguages
    • RLanguages
    • RubyLanguages
    • ScalaLanguages
    • SqlLanguages
    • SwiftLanguages
    • TypeScriptLanguages
    • D3JSLibraries
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • ReduxLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • DjangoFrameworks
    • Ember.jsFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • Google CloudFrameworks
    • AccessDatabases
    • DB2Databases
    • HBaseDatabases
    • HiveDatabases
    • InformixDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • Neo4jDatabases
    • OracleDatabases
    • TeradataDatabases
    • Google AnalyticsAnalytics
    • TableauAnalytics
    • InVisionDesign
    • SketchDesign
    • ConfluenceManagement
    • JIRAManagement
    • Microsoft ProjectManagement
    • WordpressCMS
    • LinkedIn SalesNavigatorCRM
    • SalesforceCRM
    • Salesforce CPQCRM
    • Salesforce PardotCRM

What are Bank of America Perks + Benefits

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Documented equal pay policy
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Unconscious bias training
Diversity manifesto
Mean gender pay gap below 10%
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Remote Work Program
Family Medical Leave
Adoption Assistance
Restricted work hours
Return-to-work program post parental leave
Company sponsored family events
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Sabbatical
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Parking
Recreational Clubs
Relocation Assistance
Fitness Subsidies
Home Office Stipend for Remote Employees
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Continuing Education stipend
Time allotted for learning
Online course subscriptions available
Customized development tracks
Paid industry certifications

More Jobs at Bank of America

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Bank of America's full profileSee more Bank of America jobs