Database Design and Implementation:
1. Design, develop, and implement database structures based on organizational requirements.
2. Create and maintain data models, schemas, and indexing strategies.
Database Management:
3. Design, create, and maintain databases across multiple platforms (e.g., SQL Server, Oracle, MySQL) to meet application and business requirements.
4. Perform database installations, configurations, upgrades, and migrations as needed.
Database Security:
5. Implement and enforce data security measures, including user access controls, encryption, and authentication.
6. Monitor and audit database systems for security vulnerabilities and breaches.
7. Apply database security patched regularly.
Database Maintenance:
8. Perform regular backups and disaster recovery planning to ensure data availability and integrity.
9. Apply patches and updates to database management systems (DBMS).
10. Generate Report daily for database backups and send to head of Database Administration.
Performance Tuning:
11. Monitor and optimize database performance by analyzing query execution plans and indexing strategies.
12. Identify and resolve bottlenecks and performance issues.
Data Migration and ETL:
13. Manage data migration between systems and perform Extract, Transform, Load (ETL) processes.
14. Ensure data consistency and accuracy during migration.
Capacity Planning:
15. Forecast database growth and plan for hardware and software scalability.
16. Allocate resources as needed to maintain optimal performance.
Backup and Recovery:
17. Develop and maintain backup and recovery plans to minimize data loss in case of system failures or disasters.
18. Test and document recovery procedures.
Database Monitoring and Troubleshooting:
19. Monitor database systems for anomalies, errors, and performance issues.
20. Troubleshoot and resolve database-related problems.
Documentation and Reporting:
21. Maintain documentation of database configurations, procedures, and best practices.
22. Generate reports on database performance and usage.
Collaboration:
23. Collaborate with developers, system administrators, and other IT professionals to support application development and integration.
24. Ensure correct adoption of policies and procedures to guarantee that QNB ALAHLI business is conducted in compliance with Local Laws, Internal rules and regulations, as well as, International Standards.
25. Ensure the correct functioning and implementation of Permanent Supervision system, compliance,
operational risk & workplace success guidelines whenever & wherever possible.
