Teradata Operations DBA

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.

Please, send your resume with rate.

Apply today!