JOB ROLE/ PURPOSE:

To oversee the operation, maintenance, and optimization of URA’s database infrastructure to ensure reliable, secure, and efficient data management that supports the organization’s IT strategy and business objectives, enabling seamless access to critical data for operational and decision-making purposes.

PRINCIPAL ACCOUNTABILITIES

1. Manage the operation and performance of URA’s database infrastructure

• Monitor database performance metrics, such as response times and throughput, to ensure optimal functionality and availability
• Implement and manage database backup and recovery strategies to prevent data loss and ensure business continuity
• Troubleshoot and resolve database performance issues, including bottlenecks and system downtimes, in a timely manner.
• Coordinate with IT teams to ensure database infrastructure aligns with enterprise architecture and application requirements.
• Participates in design reviews as required to ensure database design meets application requirements.
• Generate and analyze performance reports to provide insights and recommendations for improving database operations

2. Plan database architecture and structures

• Plan for the installation of Database management systems in the organization.
• Document, design and implement requirements for database availability, accessibility, security, backup and recovery for both Oracle and MS SQL Server databases.
• Implement database configurations and database resource plan to improve database performance and resources utilization.
• Work with IT stakeholders to evaluate the hardware and software requirements for Database management system installation.
• Maintains up-to date inventory documentation of Database designs and architecture.

3. Lead the maintenance, tuning and optimization of databases for performance

• Perform regular database maintenance tasks, such as indexing, partitioning, and updating statistics, to optimize performance.
• Plan and execute database upgrades, patches, and migrations to ensure systems remain current and efficient
• Optimize database schemas and queries to improve data retrieval and processing speeds for business applications
• Conduct capacity planning to ensure database infrastructure can handle current and future data growth.
• Document database configurations, maintenance procedures, and optimization strategies for knowledge sharing and compliance

4. Ensure database security and compliance

• Implement and enforce database security policies, including access controls, encryption, and user authentication mechanisms.
• Support regular security audits to identify and mitigate vulnerabilities in the database infrastructure.
• Ensure compliance with URA’s data governance policies and the Data Protection Act
• Monitor and respond to security incidents, ensuring rapid resolution and documentation for audit purposes
• Collaborate with data governance teams to align database security practices with organizational standards.

5. Coordinate database change management processes

• Develop and implement change management plans for database updates, schema changes, or system migrations
• Assess the impact of proposed database changes on business applications and coordinate with stakeholders to mitigate risks
• Obtain, test and implement database system patches and bug fixes.
• Maintain a change management log to document all database modifications for audit and compliance purposes
• Communicate change plans and potential impacts to stakeholders to ensure minimal disruption to operations
• Conduct post-implementation reviews to evaluate change outcomes and recommend improvements for future processes

6. Plan and manage the performance and development of staff under supervision so as to improve their productivity

• Provide leadership and operational management to the team so that the service delivered is efficient and can adapt to changing circumstances
• Develop performance agreements with all the staff under supervision
• Assess the training and development needs of staff under supervision and recommend appropriate interventions.
• Provide coaching to staff under supervision
• Initiate and implement activities/programs intended to create and harness teamwork in the business Unit

PERSON SPECIFICATIONS

Essential Requirements

• An Honor’s Bachelor’s degree in either; Computer Science, Engineering, Information Technology, Statistics (Computing Option), Business Computing, Applied Mathematics from a recognized academic institution
• At least three (03) years’ work experience as a Database Administrator attained in a reputable organization.
• Oracle Certified Professional (OCP).
• Certification in Service Management ITILv4
• An impeccable record of integrity.

Desirable Requirements

• Certifications in Relational Database Management such as Microsoft Certified Systems Data Base Administrator (MCSDBA), Oracle, SQL Server, MySQL) or IT infrastructure from a reputable institution
• Experience in installing, building, upgrading and supporting Oracle RAC environment, ASM, Grid/Cluster.
• Proficiency in database management tools and scripting languages (e.g., SQL, PL/SQL, PowerShell, awk)
• Experience of using an IT Service Management system to manage, allocate and monitor support tasks.

Knowledge

• Knowledge of application programming and scripting
• Intimate knowledge of URA’s computing systems
• Knowledge of system design and analysis
• Knowledge of backup procedures, recovery of databases and SQL.

SPECIFIC SKILLS & ATTRIBUTES

The incumbent should be able to demonstrate;

• The ability to develop, communicate the vision, motivate and influence a team of professionals towards the realization of a team’s mandate
• The ability to assimilate new support tasks, while retaining and developing established ones
• The ability to work within a changing business and technical environment
• The ability to deal with confidential and sensitive information with tact and discretion
• The ability to explain complex ideas to those with limited IT and systems knowledge
• The ability to work with staff at all levels in a manner which does not bring disrupt to the rest of the team
• The ability to coach, mentor and guide the professional growth of staff under supervision
• Excellent interpersonal and communication skills.
• Strong conceptual, problem diagnosis and decision making skills
• Excellent analytical ability and attention to detail
• Creativity and innovation capability
• Excellent systems analysis as well as knowledge and interest in emerging technologies
• Technical competence and proven troubleshooting skills
• Listening ability and patience
• Customer service and relationship management

• Manage the operation and performance of URA’s database infrastructure
• Plan database architecture and structures
• Lead the maintenance, tuning and optimization of databases for performance
• Ensure database security and compliance
• Coordinate database change management processes
• Plan and manage the performance and development of staff under supervision so as to improve their productivity

• Ability to develop, communicate the vision, motivate and influence a team of professionals towards the realization of a team’s mandate
• Ability to assimilate new support tasks, while retaining and developing established ones
• Ability to work within a changing business and technical environment
• Ability to deal with confidential and sensitive information with tact and discretion
• Ability to explain complex ideas to those with limited IT and systems knowledge
• Ability to work with staff at all levels in a manner which does not bring disrupt to the rest of the team
• Ability to coach, mentor and guide the professional growth of staff under supervision
• Excellent interpersonal and communication skills
• Strong conceptual, problem diagnosis and decision making skills
• Excellent analytical ability and attention to detail
• Creativity and innovation capability
• Excellent systems analysis as well as knowledge and interest in emerging technologies
• Technical competence and proven troubleshooting skills
• Listening ability and patience
• Customer service and relationship management
• Proficiency in database management tools and scripting languages (e.g., SQL, PL/SQL, PowerShell, awk)

• An Honor’s Bachelor’s degree in either; Computer Science, Engineering, Information Technology, Statistics (Computing Option), Business Computing, Applied Mathematics from a recognized academic institution
• At least three (03) years’ work experience as a Database Administrator attained in a reputable organization.
• Oracle Certified Professional (OCP).
• Certification in Service Management ITILv4
• An impeccable record of integrity.
• Certifications in Relational Database Management such as Microsoft Certified Systems Data Base Administrator (MCSDBA), Oracle, SQL Server, MySQL) or IT infrastructure from a reputable institution
• Experience in installing, building, upgrading and supporting Oracle RAC environment, ASM, Grid/Cluster.
• Knowledge of application programming and scripting
• Intimate knowledge of URA’s computing systems
• Knowledge of system design and analysis
• Knowledge of backup procedures, recovery of databases and SQL.