Senior Lead Teradata Database Administrator (DBA) Job at Vergence, Springfield, IL

RG1CQXpUOWFvRXY2WXYxdVdsUG9BN2RudUE9PQ==
  • Vergence
  • Springfield, IL

Job Description

In this role you will:

• Manage, monitor, and maintain OnPrem Teradata hardware/software including patches,
replacements, and upgrades with support from Teradata.
• Support data governance, metadata management, and system administration
• Plan and execute tasks required to ensure the Teradata system is operational including
occasional evening and weekend support for Teradata maintenance.
• Provide direction to developers on Operational, Design, Development, and Implementation
projects to ensure best use of the Teradata system including review/approval of database
components (such as tables, views, SQL code, stored procedures).
• Performing database backup and recovery operations – using the BAR DSA and NetBackup.
• Developing proactive processes for monitoring capacity and performance tuning.
• Providing day-to-day support for the EDW users problems like job hands, slowdowns,
inconsistent rows, re-validating headers for tables with RI constraints, PPIs, and configuration.
• Maintaining rules set in the Teradata Active System Management (TASM) and supporting
workload management.
• Maintaining the Teradata Workload Manager with the proper partitions and workloads based
on Service Levels.
• Supporting the database system and application server support for the Disaster Recovery (DR)
build/test, annual drill, and quarterly maintenance as needed.
• Actively monitoring the health of the Teradata system and Teradata Managed Servers (TMS)
using Viewpoint and other tools and application servers and make preventive or corrective
actions as needed.
• Maintaining access rights, role rights, priority scheduling, and reporting using dynamic workload
manager, Database Query Log (DBQL), usage collections and reporting of ResUsage, AmpUsage,
and security administration etc.
• Coordinating with the team and customers in supporting database needs and making necessary
changes to meet the business, contractual, security, performance, and reporting needs.
• Supporting internal or external audit process and address vulnerabilities or risk proactively.
• Prepare and support IRS and internal audit.
• Coordinating with Teradata to perform Teradata system hardening and delivery of Safeguard
Computer Security Evaluation Matrix (SCSEM) Reports as needed, addressing issues in the
hardening and vulnerability scan report.
• Generating and maintaining capacity management, Space, and CPU reports on analyzing the
Spool, CPU, I/O, Usage, and Storage resources and proactive monitoring to meet performance
and growth requirements.
• Reviewing and resolving Teradata alerts and communicating any risk / issues or impact to the
management, team, and business users through appropriate communication strategy.
• Effectively reporting status, future roadmap, proactive process improvements, automation,
mitigation strategies, and compensating controls to the management and clients.
• Leading database or data related meetings and projects/activities delivering quality deliverables
with minimal supervision/direction.
• Sharing knowledge, coaching/mentoring other members in the team for backups.
• Performing additional duties that are normally associated with this position, as assigned.
• Responsible for front-end tool (OpenText Bi-Query) and model maintenance and administration

Job Tags

Afternoon shift

Similar Jobs

PLUMAS PINES GOLF RESORT & LONGBOARDS RESTAURANT

Longboards Bar & Grill Front of House Staff Job at PLUMAS PINES GOLF RESORT & LONGBOARDS RESTAURANT

 ...service regulations and enforce responsible drinking practices. Requirements Priorwork experience is required for certain entry-level positions; training will be provided. For more specialized roles, previous experience is preferred but not mandatory. Strong communication... 

Fitz on 4th

Bartender Job at Fitz on 4th

 ...Come and be a part of making a positive difference in Queen Village Philadelphia area. We are a full service vegan restaurant/cocktail bar. Looking for dynamic personable team members to present our vegan tapas to our community and introduce them to your exceptional customer... 

Sonepar

Delivery Driver-Non-CDL Job at Sonepar

 ...are, we trust their individual skills and qualities and give them everything they need to reach their full potential. Delivery Driver (Non-CDL) The Delivery Driver is responsible for transporting goods safely and efficiently to customers, ensuring accurate deliveries... 

BJC Healthcare

Regional Float RN Med/Surg/Tele Job at BJC Healthcare

 ...Tele RN that is excited to provide patient care throughout our system in a Regional Float...  ...Med/Surg/Tele experience, and willing to travel between BJC facilities, both MO & IL. Must...  ...Purpose A BJC Central Staffing Office nurse will be required to float to 12 BJC... 

Capgemini

Fraud Analyst Functional Job at Capgemini

 ...organizationsunlock the value of technology and build a more sustainable, more inclusive world. Location and Role Overview: The Fraud Strategy Analyst partners with the credit card business to shape portfoliolevel fraud strategy , focusing on trend analysis,...