Create databases with data modeling and development teams, replicate data across environments, and manage physical database structures.
Tune SQL and database performance; manage Teradata workloads, capacity, security, access privileges, and backup and recovery strategies.
Configure and maintain DBMS software and coordinate server configuration and complex database creation with system engineers.
Implement monitoring procedures to support system availability, performance, and service targets.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Experience
5–7 years of experience as a Teradata database administrator (preferred)
Experience leading projects or teams in a large, 24x7 environment (preferred)
Experience managing a large enterprise user base in a multi-terabyte, multi-application Teradata database system (preferred)
Ability to lead development and management of database design standards (preferred)
Experience with database, client tool, and hardware upgrades (preferred)
Experience setting up ViewPoint portlets for space and system health monitoring (preferred)
Experience with Teradata Manager and PDCR monitoring and tuning tools (preferred)
Experience with SUSE Linux 10 or higher and shell scripting (preferred)
Proven ability to lead projects across multi-departmental teams (preferred)
Skills
Skill with Teradata database commands and utilities, including Manager, Administrator, SQL Assistant, TSET, TPT, Visual Explain, Arcmain, and TASM (preferred)
Advanced knowledge of database administration, Database Console utilities, security, workload management, TDatamover, and BAR tools including NetBackup and TaraGui (preferred)
Ability to write, debug, and tune SQL, macros, and procedures, and implement multi-value compression (preferred)
Ability to present to audiences at various levels of management (preferred)
Your match
Sign in and add your resume to see which of this job's requirements it shows.
Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.
Full job description
From Atria Group LLC’s careers site
Company Description
Job Description
Show full descriptionShow less
The Teradata Operations DBA is a member of the Information Stores team that manages the physical data stores for the enterprise. This includes working with data modeling and development teams to create new databases, replicate data across environments, monitor and manage databases, perform SQL tuning and analysis, provide capacity planning, grant data level access privileges and provide consultation to application development teams on design issues. The Teradata DBA has knowledge about database platforms and independently leads the implementation for high priority and complex enterprise databases. Coordinate and lead the definition of database backup/recovery and security strategies. Responsible for mentoring and training other database administrators, managing task assignments for junior database administrators, reviewing work and providing input to performance reviews.
MAJOR TASKS, RESPONSIBILITIES AND KEY ACCOUNTABILITIES
Review physical database structures using complex technical skills based on physical design for development, test, and production environments.
Responsible for complex database performance tuning, security, backup/recovery strategy, and implementing monitoring procedures to maximize system availability.
Active in security design, including designing and implementing roles, profiles and accounts.
Managing and tuning Teradata Workload Management - designing and creating workload groups, priorities, throttles, etc.
Mentoring and training other associate database administrators, managing task assignments, reviewing work and providing input to Management.
Implementing monitoring procedures to maximize system availability and performance, to meet defined service targets.
Coordination with system engineers to configure servers for DBMS product installation and complex database creation.
Configure and maintain DBMS product software on complex database and application servers.
PREFERRED QUALIFICATIONS
Position Requirements:
High degree of skill with database commands and Teradata utilities such as Manager, Administrator, SQL Assistant, TSET,TPT, Visual Explain, Arcmain, TASM, etc.
Strong verbal and written communication skills.
Ability to present to audiences to include various levels of management.
Proven ability to lead projects across multi-departmental teams.
Advanced knowledge of database administration tasks such as Database Console utilities, security, work-load management (TASM), TDatamover, BAR including NetBackup and TaraGui.
Previous experience with issues around database, client tool, and hardware upgrades.
Setup ViewPoint portlets for monitoring space and system health.
Ability to write, debug and tune SQL, macros, procedures, implementation of multi-value compression, etc.
Experience with database monitoring and tuning tools such as Teradata Manager and PDCR.
Experience with the SUSE 10 or higher Linux operating system and command set as well as competence with shell scripting
Experience:
Five to seven years as Teradata database administrator.
Experience leading projects/teams in a large, 24x7 environment.
Experience managing a large enterprise user base in a multi-terabyte, multi-application Teradata database system.
Ability to lead the development and management of database design standards.
In-depth experience in security administration using roles and profiles.