Database Administrator (Oracle) at Altron Bytes Systems Integration

Main Purpose of the Job

• The Database Administrator (DBA) requires specific technical knowledge about the administration and control of the data warehouse environment, including the database, operating systems and tools. The DBA will provide services to administer, maintain, and control the data warehouse including the database, operating systems, and tools. The Database Administrator may be the Lead Consultant on a project.

Key Areas of Responsibility

• Maintaining the database server and application tools
• Allocating system storage and planning future storage requirements for the database system
• Creating primary database storage structures (tablespaces) after application developers have designed an application
• Creating primary objects (tables, views, indexes) once application developers have designed an application
• Modifying the database structure, as necessary, from information given by application developers
• Enrolling users and maintaining system security
• Ensuring compliance with the license agreement
• Controlling and monitoring user access to the database
• Monitoring and optimizing the performance of the database
• Planning for backup and recovery of database information
• Maintaining archived data on tape
• Backing up and restoring the database
• Performing migration from Teradata Enterprise to Teradata Application

KPI's
Finance

• Achieve at least 90% billable utilizations measured over an agreed period of time
• Always aim to provide excellent, value-added service to customers that meet or exceed their expectations
• Internal Processes
• Demonstrate ability in performing the functions of your job specification as Application Consultant by accepting responbility and take personal accountability for all your actions and outputs to meet and exceed what is required
• Achieve individual objectives as per individual KPI's specified during performance appraisal
• Adherence to internal and customer processes
• Meet training and certification targets as defined during performance appraisal
• Lives company values - Professionalism, Ownership, Productivity, Reliability, Positive attitude, Pride in your work

Job Requirements
Qualification

• Matric
• Essential:IT Degree
• Essential
• DBA
• Teradata DBA
• Minimum Experience Required: 3 - 5 Years
• Minimum Education Required: Grade 12/Matric
• Qualifications Required: IT Degree/IT Diploma
• Advantageous:IT Diploma

Skills

• In depth knowledge of operations management and control.
• In depth knowledge of data warehousing.
• In depth knowledge of Teradata tools.
• In depth knowledge of security tools.
• In depth knowledge of system management.

Skill Category - Skill Mapping

• Databases
• Primary Skill
• Operations Skills
• Primary Skill
• Teradata Active Data Warehousing Knowledge
• Primary Skill
• Tools – Business Intelligence Knowledge
• Tools – Development Knowledge
• Tools – Enterprise Application Integration Knowledge
• Tools – ETL Secondary Skill
• Tools – Job Control and Scheduling Primary Skill
• Tools – Monitoring and Control Secondary Skill
• Tools – Operating Systems/Networking Primary Skill
• Tools – Security Primary Skill
• Tools – System Management Primary Skill
• Tools – Teradata Primary Skill

Job Related Experience Required Time Span Essential / Desirable

Database administration of major and complex IT solutions

• 2 years

Essential

• Database administration of end-to-end Data Warehouse systems
• Participation in data warehouse implementations
• 2 years

Desirable
Database administration of Teradata data warehouse solutions

• 2 years

Desirable

Extensive experience and expertise in developing robust policies and procedures related to the management, security, maintenance and use of the database management system

• 3 years

Essential

• Additional requirements for the job
• Flexible to work standby, attention to detail, adaptability, tenacity, show initiative, auality orientated, ability to work under pressure
• Drivers License

Competencies

• Adaptability
• Delegating Responsibility
• Developing Others
• Follow – up
• Initiative
• Innovation
• Managing Conflict
• Tenacity
• Time Management
• Johannesburg based
• Strong team player
• Building Customer Loyalty
• Building strategic working relationships
• Coaching
• Communication
• Continuous Learning
• Contributing to team success
• Customer Focus
• Decision Making
• Quality Orientation
• Stress Tolerance