​

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

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.

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

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.

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

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
• 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
• 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.
• 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
• 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.
• 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
• 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