Database Administrator

at  Ministry of Health

The Health Services I&IT Cluster, Emergency Health I&IT Solutions & Technology Management Branch is seeking a Database Administrator to provide strategic data resource management.

TECHNICAL KNOWLEDGE AND SKILLS

You have knowledge of the following:

• current and emerging technologies, methodologies and tools associated with databases, data management, data warehousing, data modelling and design, the full systems life cycle, IT security, Internet applications and IT connectivity
• PC-based and server-based systems technologies, networks, and data management tools such as Microsoft Power BI
• systems and relational database analysis such as SQL Server databases
• disk architecture and expertise in tuning the database for performance
• user environments, client support issues and client data access tools

LEADERSHIP AND PROJECT MANAGEMENT SKILLS

• you have knowledge of project management methodologies and procurement policies and practices
• you have project management and technical leadership skills to advise on technical requirements of the databases and data warehouse and lead database development and change management projects.

ANALYTICAL, PROBLEM-SOLVING AND ORGANIZATIONAL SKILLS

• you have analytical skills in assessing the data management requirements of the Branch and clients
• you can lead the development of standards and processes for the databases and data warehouse
• you can analyze user needs in a multi-client environment and develop client access systems, processes and procedures that support user requirements while protecting the security of the system and integrity of data.
• you have analytical and problem-solving skills to ensure the smooth running of all aspects of the databases and Data Warehouse by monitoring performance, tuning the environment and providing timely technical support to resolve problems
• you can provide advice and identify new technologies and tools on data management strategies and standards to branch management and applications developers
• you have organization, co-ordination and administration skills to guide and manage database and data warehouse administration

COMMUNICATION AND INTERPERSONAL SKILLS

• you have oral communication skills to: liaise and consult extensively with clients regarding data management requirements in both technical and non-technical language, provide direction to staff and vendors, and provide training to clients
• you have written communication skills to: prepare reports, technical analyses, and recommendations for Branch management; develop business cases; prepare systems documentation; and prepare informational materials for clients.
• you have consultation, negotiation and interpersonal skills to consult extensively with clients and stakeholders and to negotiate contracts with vendors of services, equipment and hardware/software within established
  parameters

OTHER ESSENTIAL ABILITIES AND KNOWLEDGE:

• you have the ability to learn the policies, standards and objectives relating to information technology, and emergency health services
• you have the ability to interpret policy and legislative requirements affecting data processing and freedom/privacy of information
• you have knowledge of training techniques to co-ordinate the development and delivery of training for Branch staff and clients.

In this role, you will:

• provide strategic data resource management, assess Branch requirements and develop data management strategies and plans;
• co-ordinate the development, maintenance and control of the Branch’s Databases and Data Warehouse and related documented processes and procedures;
• ensure appropriate integration and connectivity of a number of emergency health systems and applications with the Branch’s Databases and Data Warehouse;
• manage the development, maintenance and uninterrupted running of all interface processes feeding data to the Branch’s Databases and Data Warehouse
• co-ordinate the development and provision of standard and ad hoc reports;
• monitor database performance, tuning the database environment, ensure best overall use of technology and optimum on-line systems performance;
• conduct capacity planning and system resource allocation;
• co-ordinate/provide technical support and resolve technical and operational problems;
• coordinate services with vendors and IT support specialists;
• provide expert advice on database, data warehousing and data management developments, technologies and methodologies;
• advise applications specialists/contractors regarding database design and data management issues;
• conduct cost/benefit analyses and feasibility studies, make recommendations and prepare business cases to support new or enhanced technologies
• lead projects for database design and development or to manage changes to hardware, software, applications or linkages; and
• conduct on-going liaison and consultation with clients, users and stakeholders regarding database and data warehouse needs, operations and changes.