Senior Teradata DBA

Teradata, DBA, Application DBA, BTEQ, Explain Plan, SQL Assistant
Contract Corp-To-Corp, Contract Independent, Contract W2, 1+ years
Telecommuting not available Travel not required

Job Description

Clover Consulting has a large, direct client in the Springfield, IL area in need of a Senior Teradata DBA for a long term contract assignment.


Job Requirements


  • 5+ years of Teradata Database Administration (Version 14/15) experience
  • 7+ years of SQL development including 3 Years SQL and Performance Tuning
  • 5+ years of Data Warehouse project experience
  • Excellent verbal/written communication skills,  end client facing skills, and team collaboration skills
  • Mentoring co-workers


Preferred Skills:


  • Experience in Application Server Administration in Windows/Linux environment
  • Experience in Hardware / Software Server Administration
  • Experience with State Medicaid / Medicare / Healthcare applications
  • Knowledge in ETL process, Unix, and Windows Scripting
  • Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives and make appropriate recommendations
  • Train developers in how best to design queries for a specific database
  • Working with the business users, SMEs, BA, developers, system administrators, modelers, and coordinating with hardware / software sub vendors
  • Experience in SharePoint
  • Experience working in Agile projects/environment and Agile tools
  • Installing, configuring and administering Microsoft SQL Server on Windows Server
  • Performing application servers backups and recovery using Veritas Backup Exec 2012 and or above
  • Analyzing IBM Tivoli logs and responds to alerts and errors
  • Monitoring of SAN storage with the knowledge and ability to react to alerts and errors
  • Configuring and managing HP MSA Storage arrays
  • Installing, configuring and administering Windows Server 2008 R2 or higher platforms on HP DLT Servers


Primary Job Responsibilities:


  • Developing and analyzing highly complex system standards, thresholds, and recommendations to maximize system performance 
  • Evaluating products and upgrades for appropriateness and lead the implementation and upgrade strategies.
  • Creating / Modifying the database tables, views, or other database objects to support the projects and change requests that impact the Data Warehouse
  • Support Teradata patch and upgrades collaborating with Teradata team and interfacing with the application sub vendors
  • Supporting backup and restore/retrieval process – using the BAR DSA and NetBackup. Create, implement, and maintain BAR strategy for the Teradata (TD) application and system databases.  
  • Maintaining rules set in TASM and supporting workload management. Set up / maintaining the Teradata Workload Manager with the proper partitions and workloads based on Service Levels.  
  • Set up / maintaining Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.
  • Supporting the database system and application server support for the Disaster Recovery (DR) build/test, annual drill, and quarterly maintenance as needed
  • Perform Teradata SQL troubleshooting and fine tuning of scripts
  • Support database or system issues reported by Helpdesk or business users
  • Actively monitor the health of the Teradata system and Teradata Managed Servers using Viewpoint and other tools and application servers and make preventive or corrective actions as needed
  • Maintenance of Access Rights and Role Rights, Priority Scheduling, Dynamic Workload Manager, Database Query Log (DBQL), Database Administrator, Partitioned Primary Index (PPI), Multi-Value Compression Analysis, Usage Collections and Reporting of ResUsage, AmpUsage, Security Administration Setup etc.
  • Support remote log process
  • Support data needs using QueryGrid 2.0
  • Coordinating with the team and customers in supporting database needs and make necessary changes to meet the business, contractual, security, performance, and reporting needs
  • Support internal or external audit process and address vulnerabilities or risk proactively. Prepare and support IRS audit 
  • Coordinate with Teradata to  perform Teradata system hardening and delivery SCSEM Reports as needed addressing issues in the hardening and vulnerability scan report
  • Generate and maintain 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
  • Review and resolve Teradata alerts and communicate any risk or impact to the team and business users through appropriate communication strategy
  • Create Teradata incident on issues, tracking, setting appropriate priorities, monitoring and controlling, and work with Teradata to resolve the issues promptly
  • Provide weekly status update and update the weekly status report with the summary of database related activities including maintenance and issues.
  • Analyzing project requirements and develop detailed specifications for new and existing data warehouse database related requirements
  • Reviewing and validating the database related test scenarios and results and incorporating extensive knowledge of the Agency’s business rules.
  • Developing or acquiring test data and initiate tests to determine the accuracy of database logic to produce desired results.
  • Communicating effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector. 
  • Meeting with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan. Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives and make appropriate recommendations.
  • Working with the team and data modelers, facilitate modification of the logical design to create a physical design most suited to the business needs of the customer. 
  • Working with Developers and Enterprise Data Warehouse (EDW) team to create and maintain database standards. 


Qualified candidates please apply with resume and contact details. NO CALLS PLEASE!!!


Dice Id : 10108584
Position Id : WG-TDARDBA
Have a Job? Post it