Teradata Warehouse administrator

Teradata Warehouse administrator

Local candidates ONLY. Candidates must be located in Michigan within 1 hour of Lansing, MI at time of submission.

Phone/Skype Hire. Onsite from day 1

Location: Lansing, MI

Duration: 12+ months

This position will serve as a platform administrator, consisting of 3 distinct platforms (Production, Development/Disaster Recovery, and Test). The client provides enterprise data warehousing services to executive branch department. A total of 7 departments are supported, with a user base of over 10,000 and 40 Terabytes of data. This position researches and coordinates long term strategies with all current and potential users, management and vendor personnel. This position defines the technical planning, implementation plan, and delivery of the platform services and supporting technologies to meet the business requirements and objectives. This includes vendor communication, trouble reporting, escalated troubleshooting, and release/patch management. This position is responsible for providing operating system guidance along with security expertise for the systems as well as advising the Agencies on disaster recovery planning strategies related to and their business applications. The position is also responsible for platform performance monitoring and resolving performance issues. This position provides direct technical expertise to department DBAs and specialists across the enterprise.

Responsibilities

The client maintains an enterprise data warehouse built on the Teradata ecosystem. Below is a list of services; however, this list is not exhaustive.

8+ years required for the following:

• Teradata database
• Upgrades, provisioning, software maintenance, scripting BASH, Perl, Python, Glink
• Teradata ecosystem health monitoring
• Teradata node management
• Teradata Viewpoint administration
• Teradata Tools and Utilities (TTU)
• PSIM (Platform Service Intelligent Monitoring) administration
• Teradata vendor upgrades
• Teradata workload management
• Teradata backup & recovery
• Performance tuning and resource optimization
• Extract Transform Load (ETL)
• Unix/Linux knowledge
• Cloud computing fundamentals, resource allocation, networking, preferably MS Azure
• Statistics
• Audits & security plans
• Federal requirements NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc.

Skills Needed

- Teradata database

- Teradata Tools and Utilities (TTU)

- Teradata backup & recovery

- Performance tuning and resource optimization

- Extract Transform Load (ETL)