Title: Teradata DBA Database Administrator
Location: REMOTE
Type: Contract
Duration: 1 years with high probability of multi-year extensions
Primary Responsibilities:
- Creating, maintaining, and supporting Teradata architectural environment
- Working with creation of databases, tables, views, users, and granting them access
- Working with the development teams with design, implementation, and performance tuning of new and existing applications
- Performing database backup and recovery operations
- Developing of pro-active processes for monitoring capacity and performance tuning
- Supporting the application development teams for database needs and guidance
- 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
- Supporting Teradata patch and upgrades collaborating with Teradata team and interfacing with the application sub vendors
- Supporting backup and restore/retrieval process – using the BAR DSA and NetBackup. Create, implement, and maintain BAR strategy for the Teradata (TD) application and system databases
- Maintaining rules set in 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, 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 audit
- Coordinating with Teradata to perform Teradata system hardening and delivery 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
- Creating Teradata incident on issues, tracking using TAYS, setting appropriate priorities, monitoring and controlling, and work with Teradata to resolve the issues promptly
- Performing additional duties that are normally associated with this position, as assigned
Required Qualifications:
- Bachelor’s degree or equivalent work experience
- 5+ years of experience as a Teradata DBA on Version 14+
- 5+ years of SQL experience
- 3+ years ETL using Teradata Utilities in a Unix/Linux environment
- 3+ years performance tuning in a large database (>5TB) or data warehouse environment, using advanced SQL, DBQL and Explain plans
- 3+ years analyzing project requirements and developing detailed database specifications
- 3+ years identifying and initiating resolutions to customer problems and concerns associated with a
- Data Warehouse or equivalent system
Preferred Qualifications:
- 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
- Experience in Application Server Hardware/Software Administration (Windows/Linux)
- Experience in SharePoint
- Knowledge in ETL process, Unix, and Windows Scripting
- Knowledge/Experience in Agile
- Excellent verbal/written communication, end client facing, team collaboration, and mentoring skills
- Ability to proactively learn and support overall system administration, support hardware/software maintenance, and leading data management activities
- Training developers in how best to design queries for a specific database
- Working with lead / management, business users, SMEs/BA, developers, application administrators, architect/modelers, and coordinating with hardware / software sub vendors
- Installing, configuring and administering Microsoft SQL Server on Windows Server
- Performing application servers backups and recovery using Veritas Backup Exec 2012/above
- Analyzing IBM Tivoli logs and responds to alerts and errors
- Monitoring of SAN storage with the knowledge and ability to react to alerts and errors
- Configuring and managing HP MSA Storage arrays
- Installing, configuring and administering Windows Server 2008 R2 or higher platforms on HP DLT