Teradata DBA - Technology Services Lead

Bank of America; Jacksonville (FL); On-site; USD 110,000 - 140,000; Full time

Job summary

Bank of America is seeking an experienced Teradata DBA with 10+ years of experience, including Teradata V17.20 or higher, to manage day-to-day database operations across development, UAT, and production environments.

The role involves database design changes, automation of DBA processes, and ensuring disaster recovery and storage management align with corporate standards. On-site responsibilities support enterprise warehouse activities.

Qualifications

• 10+ years experience as a Teradata DBA.
• Advanced working knowledge of Teradata RDBMS at physical and logical levels.
• In-depth familiarity with Teradata tools: Teradata Studio, TDWM, BTEQ, ARCMAIN, FASTLOAD, MLOAD, TPUMP, TPT, DBQL, PDCR.
• Experience with Mainframe interfaces and execution: TDP, JCL, TSO, ISPF, FICON, NDM.
• Working knowledge of Unix/Linux scripting (KSH, BASH, PERL).

Responsibilities

• Manages and prioritizes multiple tasks and assignments for the team, tracking tickets and ensuring SLAs.
• Provides escalation point for incidents and triage for high-priority issues.
• Performs all responsibilities of team members from applicable teams.
• Ensures alerts, dashboards, and processes are in place for new projects.
• Participates in resource interviews and onboarding processes.
• Performs access reviews and compliance activities; acts as delegate for admin processes.
• Creates on-call rotation and ensures coverage for off-hours and releases.

Skills

Collaborative

Influence

Production Support

Risk Management

Solution Design

Analytical Thinking

Architecture

Innovative Thinking

Result Orientation

Stakeholder Management

Adaptability

Automation

DevOps Practices

Project Management

Solution Delivery Process

Tools

Teradata Studio

TDWM

BTEQ

ARCMAIN

FASTLOAD

MLOAD

TPUMP

TPT

DBQL

PDCR

Job description

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. We do this by driving Responsible Growth and delivering for our clients, teammates, communities and shareholders every day.

Being a Great Place to Work and providing a culture of caring is core to how we drive Responsible Growth. We are intentional about fostering an inclusive workplace where every teammate has the opportunity to succeed, build a career and contribute to our shared success. This includes attracting and developing exceptional talent, recognizing and rewarding performance, and supporting our teammates’ physical, emotional, and financial wellness through affordable, competitive and flexible benefits.

We value the unique perspectives individuals bring from all backgrounds and career paths - whether shaped by military service, community college education, or a wide range of work and life experiences. These journeys foster resilience, leadership and innovation, strengthening our workforce and positively impact the communities we serve.

Bank of America is committed to an in-office culture that supports collaboration, engagement, and career development. Our approach includes clear in-office expectations, while providing an appropriate level of flexibility based on role-specific responsibilities and business needs.

At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!

Position Summary:

We are seeking a Teradata DBA with more than 10 years experience including some experience with Teradata V17.20 or higher.

Key Responsibilities:

• Support Application DBA functions including DDL creation, SQL scripting, problem research, change deployments, on call rotation support, etc.


• Assist with design, development, implementation, documentation, and support of automated DBA processes using Teradata and Unix/Linux scripting.


• Support multiple Teradata systems including development/UAT, disaster recovery, and the enterprise warehouse production environments.


• Implement and administer access policies in conjunction with corporate standards.


• Support some Mainframe administrative functions including archive processing and job scheduling.


• Manage, design, support, and consult on practices of storage management, archive, restore, and disaster recovery.


• Work closely with Application projects teams on implementation of database changes to support large project initiatives and BAU work.


• Complete any assigned training courses and attend any required team meetings/calls to learn about and stay up to date on internal DBA team processes and tools. Provide high level weekly written status report to manager.


• Work independently with minimal supervision, with general guidance from more seasoned DBA team members or managers.

Required Qualifications:

• 10+ years experience as a Teradata DBA including some experience with Teradata V17.20 or higher.


• Advanced working knowledge of Teradata RDBMS at both physical and logical levels.


• Advanced working knowledge of Teradata suite of tools: Teradata Studio, TDWM, BTEQ, ARCMAIN, FASTOAD, MLOAD, TPUMP, TPT, DBQL, PDCR.


• Working knowledge of Mainframe interfaces and execution; TDP, JCL, TSO, ISPF, FICON, NDM.


• Working knowledge of Viewpoint, Teradata Data Mover, Teradata BAR technology.


• Working knowledge of Unix/Linux scripting (KSH, BASH, PERL).

Desired Qualifications

• Familiar with Teradata Systems setup, GDO, DBSControl, Multitool, etc.


• Working knowledge of QueryGrid, DSA, Taraserver, NPARC, TASM


• Working knowledge of job schedulers: CA-7, AutoSys, etc. Replication technologies, Golden Gate.


• Familiar with REXX scripting.


• Familiar with Hadoop and Cloud concepts and technologies


• Familiar with project and change management solutions and automation software, such as Agile, Remedy, Ansible.

Job Description:
This job is responsible for managing the day-to-day activities and functions for the assigned team. Key responsibilities include delegating work to team members, supervising work processes, providing informal leadership of sub teams or technology silos, managing on call and support schedules, and providing leadership, mentorship, and direction to team members. Job expectations include solving complex technical and analytical issues and effectively communicating results to senior management and Line of Business partners.

Responsibilities:

• Manages and prioritizes multiple tasks and assignments for the team including tracking tasks and tickets in system(s) of record, ensuring enterprise service level agreements are met, and participating in defect, incident, problem, and change review meetings and release activities


• Provides point of escalation for team members, peers, and partner teams, and shares the leadership Point of Contact for triage of high priority incidents or consulting engagements


• Performs all responsibilities of team members from applicable teams


• Works with appropriate teams to ensure alerts, monitoring, dashboards, and processes are established appropriately for new projects and initiatives


• Participates and helps with resource interviews and onboarding processes


• Performs access reviews, conducts compliance activities, and serves as a delegate for administrative processes


• Creates the on call rotation schedule and ensures support for off hours, weekends, and release windows

Skills:

• Collaboration


• Influence


• Production Support


• Risk Management


• Solution Design


• Analytical Thinking


• Architecture


• Innovative Thinking


• Result Orientation


• Stakeholder Management


• Adaptability


• Automation


• DevOps Practices


• Project Management


• Solution Delivery Process

Shift:

1st shift (United States of America)

Hours Per Week:

40