Teradata Operational DBA

Bank of America•Jacksonville, FL

11d•Onsite

About The Position

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 is core to how we drive Responsible Growth. This includes our commitment to being an inclusive workplace, attracting and developing exceptional talent, supporting our teammates’ physical, emotional, and financial wellness, recognizing and rewarding performance, and how we make an impact in the communities we serve. Bank of America is committed to an in-office culture with specific requirements for office-based attendance and which allows for an appropriate level of flexibility for our teammates and businesses based on role-specific considerations. At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us! Position Summary: The individual will be part of the DBA team that supports all Teradata databases for multiple Applicationss across all lines of business on the Teradata Data Warehouse. Responsible for working with Teradata technology stakeholders and technical partners to design/implement changes and provide ongoing support for Teradata application database environments. Provide consulting services, support change implementations, and fulfill work requests from application and operational support teams. Provide on call support for Teradata production environments. Create and maintain internal team documentation related to our processes, tools, and problem resolution techniques. 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, document, 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. Work independently with minimal supervision, with general guidance from more seasoned DBA team members or managers. 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.

Requirements

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).
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

Nice To Haves

Familiar with Teradata Systems setup, GDO, DBS Control, 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.
Familiar with Teradata Native object Storage (NOS)

Responsibilities

Responsible for working with Teradata technology stakeholders and technical partners to design/implement changes and provide ongoing support for Teradata application database environments.
Provide consulting services, support change implementations, and fulfill work requests from application and operational support teams.
Provide on call support for Teradata production environments.
Create and maintain internal team documentation related to our processes, tools, and problem resolution techniques.
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, document, 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.
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