Vacancy expired!
Clover Consulting has a direct client in Springfield, IL in need of a Teradata DBA for a multi-year project. Our client does require the candidates to RELOCATE TO SPRINGFIELD, IL prior to the role starting. This is an ON-SITE position. The job details are below. Qualified candidates please provide resume. Thank you!
Senior Teradata Database Administrator (DBA)Primary Responsibilities:- Manage, monitor, and maintain OnPrem Teradata hardware/software including patches, replacements, and upgrades with support from Teradata.
- 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 and 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 of pro-active 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 make 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 communicate 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.
- Bachelor’s degree or equivalent work experience
- Proven experience of at least 7+ years as primary/lead Teradata DBA
- 7+ years of experience as a Teradata DBA on Version 15+
- Previous experience leading Teradata major upgrade/floor sweep
- 3+ years of experience with Teradata 6800/1800 system or IntelliFlex
- 5+ years of experience writing complex SQL using SQL Assistant/Teradata Studio
- 3+ years of experience extracting, loading, and transforming structured/unstructured data using Teradata Utilities (FastLoad, Multiload, FastExport, BTEQ, TPT) in a Unix/Linux environment
- 3+ years of experience performance tuning in a large database (>5TB) or data warehouse environment, using advanced SQL, DBQL and Explain plans
- 3+ years of experience analyzing project requirements and developing detailed database specifications, tasks, dependencies, and estimates
- 3+ years of experience identifying and initiating resolutions to customer facing problems and concerns associated with a query or database related business need
- Data warehouse or equivalent system experience
- Excellent verbal/written communication, end client facing, team collaboration, and mentoring skills
- Location required is Springfield, IL area
- Teradata Vantage Certified Master
- Experience upgrading to Teradata Intelliflex
- 3+ years identifying and initiating resolutions to customer problems and concerns associated with a Data Warehouse or equivalent system
- 5+ years logical and physical data modeling experience
- 5+ years with Erwin or other data modeling software
- 3+ years working with end users/customers to understand requirements for technical solutions to meet business needs
- 3+ years working with technical developers to strategize solutions to align with business requirements
- 3+ years defining standards and best practices and conducting code reviews
- 3+ years maintaining and creating models using OpenText BI-Query
- Experience working with project teams in metadata management, data/IT governance, business continuity plan, data security
- Experience in Application Server Hardware/Software Administration (Windows/Linux)
- Experience with State Medicaid / Medicare / Healthcare applications
- Experience working in matrix organization as an effective team player
- Experience working in agile environment such as Scrum framework and iterative/incremental delivery/release. Experience in tools like DevOps, GitHub will be a plus.
- Experience working in large Design Development and Implementation (DDI) projects.
- ID: #46430064
- State: Illinois Springfield 62701 Springfield USA
- City: Springfield
- Salary: Depends on Experience
- Job type: Contract
- Showed: 2022-10-13
- Deadline: 2022-12-01
- Category: Et cetera