Teradata DBA

at  DATAMAXIS

REQUIRED QUALIFICATIONS:

• Bachelor’s degree or equivalent work experience
• Proven experience of at least 7+ years as primary/lead on-premises Teradata DBA including:
• 7+ years of experience as a Teradata DBA on Version 15+ and
• 5+ years of experience writing complex SQL using SQL Assistant/Teradata Studio and
• 3+ years of experience with Teradata IntelliFlex and
• 3+ years of experience extracting, loading, and transforming structured/unstructured data using Teradata Utilities (FastLoad, Multiload, FastExport, BTEQ, TPT) in a Unix/Linux environment and
• 3+ years of experience performance tuning in a large database (>5TB) or data warehouse environment, using advanced SQL, DBQL and Explain plans or
• 3+ years of experience analyzing project requirements and developing detailed database specifications, tasks, dependencies, and estimates or
• 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

PREFERRED QUALIFICATIONS:

• 5+ years logical and physical data modeling experience using ERWIN or other data modeling tool
• 2+ Years of Snowflake Application Database Administration
• 3+ Years of experience as ETL/Informatica Development
• 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
• 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

• 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 includingoccasional evening and weekend support for Teradata maintenance.
• Provide direction to developers on Operational and Design, Development, and Implementationprojects to ensure best use of the Teradata system including review/approval of databasecomponents (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 supportingworkload management.
• Maintaining the Teradata Workload Manager with the proper partitions and workloads basedon 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 correctiveactions as needed.
• Maintaining access rights, role rights, priority scheduling, and reporting using dynamic workloadmanager, 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 necessarychanges 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 including 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 theSpool, CPU, I/O, Usage, and Storage resources and proactive monitoring to meet performanceand growth requirements.
• Reviewing and resolving Teradata alerts and communicate any risk / issues or impact to themanagement, 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 deliverableswith 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.