Lead Teradata Database Administrator

Leadership & Data Governance

Lead project work related to Teradata Database system administration and IT/data governance
Coordinate with teams business partners vendors and customers to meet business data
security audit and reporting needsfor contractual requirements.
Participate in agile development environments and large-scale Design Development and
Implementation (DDI) projects.
Lead the overall data management practice for the project.

System Administration & Maintenance
Manage and maintain on-prem Teradata systems and work with Teradata (as needed)
including patches upgrades configurations resolving/fixing vulnerabilities and hardware
replacements.
Use Viewpoint and additional tools to monitor system health including the Teradata Managed
Servers (TMS); carry out preventive and corrective measures.
Support Disaster Recovery (DR) planning testing quarterly maintenance annual drills and
updating/maintaining DR plans and DR drill results.
Coordinate with Teradata and subcontractors for Teradata system hardening ensuring the system
meets Computer Security Evaluation Matrix (SCSEM) requirements reviewing vulnerability scan
results and performing remediation.
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.

Database Operations & Optimization

Perform backup and recovery operations using BAR DSA and NetBackup.
Monitor and tune performance capacity and resource usage (CPU I/O Spool Storage) to meet
the performance and growth requirements.
Maintain workload management using Teradata Active System Management (TASM) and
Workload Manager partitions.
Administer access rights role rights priority scheduling and security reporting.
Deliver quality work products/deliverables to meet the project/customer needs.
Support logging requirements perform analysis/research and support colleagues/end users
with their technical issues/questions
Lead/maintain the Disaster Recovery (DR) plan annual DR drills deliver results and take
required action items.
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.
Providing product support during business and after business hours as neededto address
production issues/problem tickets promptly.
Coordinating with the team and customers in supporting database needs and making necessary
changes to meet the business contractual security performance and reporting needs.

Development Support & Governance

Gather requirements analyze design document and develop database components (scripts tables
views DataMarts SQL code stored procedures triggers etc.)
Peer review/test the work products before moving to higher environments. Seek required
approvals and maintain production install logs with required documentation for operations
guide and audit support.
As applicable perform run stats reorgs indexing partitioning and other methods to support
system performance data integrity quality reliability accessibility and availability.
Guide developers on design and implementation best practices; review/approve database
components.
Support EDW users with query optimization job handling and data integrity issues.
Maintain and administer OpenText BI-Query models and front-end tools.
Lead database-related meetings and deliverables with minimal supervision.

Reporting & Compliance
Report monthly Teradata operational reports including space and CPU utilization
Generate and maintain capacity and performance reports.
Support internal and IRS audits; address risks and vulnerabilities proactively.
Communicate work availability promptly to stakeholders be readily available/accessible and
respond to queries/email/messages more promptly.
Submit weekly status reporting on key outcomes progress and priorities.
Support/ensure compliance with SCSEM and other security evaluation frameworks.
Prepare/report future roadmap and plan for patches/upgrades including change controls and
following change management processes.
Reviewing reporting and resolving Teradata alerts and communicating any risk / issues or
impact to the management project team and business users through appropriate
communication strategy.
Travel to customer location on need basis (usually quarterly).
Live the Optum Code of Conduct and Culture Valuesproviding highest level of accountability
transparency and quality.

Required Qualifications:
Bachelors degree in IT/Computer Science or related field or equivalent experience.
Seven (7) plus years as a lead Teradata DBA (experience with Teradata Version 15 plus or higher)
with database application and system responsibilities.
Experience with on premises Teradata 6800/1800 or IntelliFlex systems or equivalent.
Expert in SQL skills and Teradata utilities (such as Teradata Studio/SQL Assistant FastLoad
Multiload FastExport BTEQ TPT).
Proven performance tuon-premisesning experience in large databases (>5TB).
Two (2) plus years of data governance experience and supporting metadata management.
Healthcare/Medicaid/Government or equivalent business domain experience.
System administration knowledge/experience (in addition to application DBA and SQL
expertise).
Lead experience with clear demonstration of leadership tasks like deliverables quality review
tasks assignment integration of work presentation to customers/leadership capacity planning
(such as processing space) and performance management.
Two (2) plus years of experience with large-scale Design Development and Implementation (DDI)
projects especially related to Enterprise Data Warehouse system.
Experience in database specification development testing and defect/issue resolution.
Excellent business communication client-facing and mentoring skills.

Preferred Qualifications:

Teradata Vantage Certified Master.
Data modeling experience (Erwin or similar).
Experience in agile environments (Scrum DevOps GitHub).
ETL development knowledge/experience or data analysis experience (such as Informatica tools)
Reports development knowledge/experience (such as Business Objects SAS Tableau Power BI
tools)
Cloud migration experience (especially related to Snowflake Azure)
No visa sponsorship required
Located within two hours of Springfield IL or based in the Central region

Functional Description:
The Senior DBA Lead is a lead role on our team responsible for the overall database application
management system administration data governance and data delivery of the Enterprise Data
Warehouse for the Medicaid agency including application and system tasks. It is a critical role involving
expertise in working with Medicaid data itself data governance security audits disaster recovery
supporting and maintaining Teradata hardware and software configuring Teradata setting up new
environments and ensuring the system achieves optimal performance and operational requirements.
For example the DBA is expected to provide a wide range of expertise including the ability to help a user
to fetch data (requiring business knowledge) and the technical ability to lead a major Teradata upgrade
and complete complex Teradata hardware/software system configurations/patches/upgrades in
partnership with Teradata.
Analyzes current business practices processes and procedures as well as identifies future business
opportunities for leveraging data storage and retrieval system capabilities. Manage relationships with
software and hardware vendors to understand the potential architectural impact of different vendor
strategies and data acquisition. May design schemas data models write SQL or other data markup
scripting and help to support the development of Analytics and Applications that build on top of data.

This position also identifies/selects develops and evaluates personnel to ensure the efficient operation of
the function and support DBA backup plans.