The role holder will ensure performance monitoring and management of database, data warehouse components, Infrastructure, and general ICT systems through setting up of optimal performance benchmarks and the use of modern best practice and appropriate tools to meet business performance growth demands, ensure system security, business continuity and competitiveness in product and service development.
Database Administrator Job Responsibilities
Monitor performance and manage parameters to provide fast query responses to front-end users ensuring performance of production core and data warehouse databases including systems logs, events and event correlation and maintaining performance statistics and setting baseline statistics.
Monitor and manage the high availability components including RAC, Dataguard, RMAN based backups and automatic storage management structures for key databases and related components as well as ensure best practice in the installation of database management systems (RDBMS); ensure compliance with RDBMS license agreements and maintain upgrades and critical patches.
Develop, manage and test back-up and recovery plans and ensure that storage, archiving, back-up and recovery procedures are functioning properly and ensure 24/7 available support for the data warehouse and related systems.
Take lead role in the various I.T. audits in providing necessary information and enforcing closure of audit, change management and compliance issues in the data warehouse environment and also manage key I.T. risks for data warehouse database systems and ensure proper mitigation; Business Continuity Planning (BCP) and disaster recovery preparedness through periodic testing as scheduled and update of disaster recovery procedures and sharing the results with management.
Team up with analytics applications support, development and infrastructure team in the development, implementation, management applications, infrastructure, and monitor system health in order to proactively identify weaknesses and address them.
Perform data modelling tasks such as business models, logical models and dimensional models to effectively convert business requirements to technical requirements in conjunction with data warehouse developers.
Establish the needs of users and monitoring user access and security, control data warehouse access permissions and privileges, consider both back-end organization of data and front-end accessibility for end-users and further refine the physical design to meet system storage requirements.
Create and maintain core and data warehouse database documentation, including data standards, procedures and definitions for the data dictionary (metadata) as well as maintaining all technical documentation relating to data warehouse maintenance, management and configuration.
Communicate regularly with technical, applications and operational staff to ensure data integrity and security and continually monitor security events in the network, take corrective actions and generate reports for management.
Attend to system failure and resolve/coordinate resolution of the problem and handle queries from analytics application support, resolve problems in a timely manner and advice accordingly.
Establish and maintain business relationships with vendors, consultants and other outside entities providing services to the bank. Monitor performance of the SLAs to ensure that the database gets maximum value from the services.
Qualifications for the Database Administrator Job
Bachelor’s degree in Software Engineering, Computer Science, Information Technology, or related discipline, or equivalent.
3 -5 years in database technology with experience deploying data warehousing technologies (e.g., High Availability, Data Warehousing, Backup, Partitioning, Online Data replication) in production environments.
Oracle RDBMS 11g/12c OCP certification as well as strong SQL and PLSQL skills including data warehouse objects such as partitions and materialized views.
Skills in Data Integration, Data Warehousing, Business Intelligence, OLAP, and Data mining as well Familiarity with ICT standards such as ITIL, COBIT, and Proficiency in various operating systems like AIX, Solaris, Linux & windows.
Thorough knowledge on data profiling, data modeling and data validation and associated tools; Skills in Database Sizing, Storage, Performance, and Security Considerations
Strong analytical skills; ability to analyze and correlate complex data and excellent knowledge on the Oracle Technology stack as well as excellent knowledge of ICT system architectures, platforms and Infrastructure .
Ability to effectively communicate complex technical issues and exhibit a wide degree of creativity and latitude coupled with the ability to lead and direct the work of others without the benefit of a direct reporting relationship as well as the ability to utilize independent judgment and to support senior managers on operational criticality.
General awareness of the banking industry ICT operations and security procedures.