Database Administrator

Roles and responsibilities

• Managing and administering organization databases which includes: availability, performance optimization, security, backup & restore and auditing
• Responsible for user security on DB and business applications levels
• Installation of server-side DB software
• Troubleshooting Database and Application server issues.
• Prepares testing/ development environment for Application team
• Shall be responsible and compliance with ABA IT Division's security policies; protection of ABA IT Division's information assets from unauthorized access, disclosure, modification, destruction and/or interference thereby ensuring the confidentiality, integrity and availability of information; and the reporting of security events, potential incidents and/or other threats.
• Manages business applications user accounts in terms of creating, modifying and disabling
• Quarterly validates user accounts and information and communicates to management
• Interacting with application team to deploy new developments and handling version control
• Interacting with System team to verify Database and applications backups are done successfully
• Provides application users with customized reports when requested
• Works in unpredictable IT situational environment
• Takes action for routine trouble shooting, however complex situations like critical business service failures are escalated
• back office support job which works within defined guidelines and policies set by the group and primarily interfacing with IT team.

• Database Design and Architecture

• Database Setup and Installation: Install and configure database management software and set up new databases for various business applications.
• Database Design: Design database structures that are scalable, efficient, and suitable for the organization's needs, ensuring that data is organized logically for easy retrieval.
• Schema Management: Define and manage the database schema, including tables, indexes, views, stored procedures, and triggers.
• Normalization: Apply normalization techniques to reduce data redundancy and improve data integrity.

Desired candidate profile

• Database Administrator (OCA or OCP certified)
• Bachelor degree of computer science / Computer Engineering
• OCA or OCP certificate is a must
• With experience in Techno Functional ERP support
• Arabic / English communications
• Minimum 4 years of experience in database administration and in Techno Functional ERP support.
  

Solid Knowledge Of The Following

• Database design
• Data Security
• Backup and Recovery
• Performance optimization
• Unix-based operating systems
• Oracle Application Server
• SQL and PL/SQL scripting

• Database Performance and Tuning

• Performance Monitoring: Continuously monitor database performance and address any performance bottlenecks or issues, such as slow queries or inefficient indexing.
• Query Optimization: Work to improve the performance of queries by rewriting SQL queries, indexing tables, and applying other optimization techniques.
• Resource Management: Ensure that database resources (e.g., CPU, memory, disk space) are utilized efficiently and optimize resource allocation to ensure high performance.