Lead Teradata Database Administrator / Remote
Posted Today by DATAMAXIS, Inc
Negotiable
Undetermined
Remote
Remote or Springfield, Illinois
Summary: The Lead Teradata Database Administrator is responsible for overseeing database administration tasks, leading major upgrades, and ensuring optimal performance of Teradata systems. This role requires extensive experience in database management, SQL, and data warehousing, along with strong leadership and communication skills. The position can be performed remotely or from Springfield, Illinois, and involves collaboration with various teams to meet business requirements. The ideal candidate will have a proven track record in managing large databases and resolving customer-related issues effectively.
Key Responsibilities:
- Lead and manage Teradata database administration tasks and upgrades.
- Develop detailed database specifications and analyze project requirements.
- Write complex SQL and perform data extraction, loading, and transformation.
- Conduct performance tuning and resolve customer-facing database issues.
- Collaborate with technical teams to strategize solutions for business needs.
- Mentor team members and ensure adherence to best practices in database management.
Key Skills:
- Bachelor's degree or equivalent work experience.
- 5+ years of experience as a primary/lead DBA with strong leadership skills.
- 7+ years of experience as a Teradata DBA on Version 15+ (preferably 17+).
- Experience with Teradata 6800/1800 system or IntelliFlex.
- 5+ years of experience writing complex SQL using SQL Assistant/Teradata Studio.
- Experience with Teradata Utilities in a Unix/Linux environment.
- Performance tuning experience in large database environments.
- Excellent verbal/written communication and team collaboration skills.
- Strong culture fit demonstrating integrity and innovation.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Required Qualifications
- Bachelor's degree or equivalent work experience
- Proven experience of at least 5+ years as primary/lead DBA with strong leadership and presentation skills.
- 7+ years of experience as a Teradata DBA on Version 15+ (preferably 17+) and 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, mentoring skills, and strong work ethics.
- Demonstrates strong culture fit through integrity, compassion, inclusion, relationships,
innovation, and performance.
Preferred Qualifications:
- Experience with State Medicaid / Medicare / Healthcare applications
- Experience working in large Design Development and Implementation (DDI) projects.
- Knowledge/experience with Cloud databases such as Snowflake and migration from on Prem to Cloud project
- 5+ years logical and physical data modeling experience
- 5+ years with Erwin or other data modeling software
- 3+ years maintaining and creating models using OpenText BI-Query
- 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
- 3+ years working with end users/customers to understand requirements for technical solutions to meet business needs
- 3+ years collaborating with technical developers to strategize solutions to align with business requirements
- 3+ years defining standards and best practices and conducting code reviews
- 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 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 and GitHub will be a plus.