What are the responsibilities and job description for the Lead Teradata Database Administrator / Remote position at DATAMAXIS, Inc?
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.