Database Administrator 9634-1516

**Description**

**Responsibilities**:

- Ensuring that all production databases managed through MNR are operational and optimized to perform at acceptable levels. This requires working with analysts and business clients to establish operational requirements; analysis of these requirements, leading to working with relevant technical development teams to ensure solutions meet these requirements; and working with MGCS-IT Services personnel to implement the technical solutions to meet these needs.
- Managing the security mechanisms which are in place and designing and constructing new solutions, such that the relevant databases respect the security requirements placed on the data stored within, as defined by relevant policies at a provincial, cluster, or ministry level (e.g. FIPPA). This requires working with analysts, cluster security officers, and business clients to clearly establish requirements related to security of the data; leading the analysis, design, and construction of the required technical components to ensure these security rules are enforced; and working with LRC IT Services personnel to implement the technical solutions to meet these needs.
- Managing and upgrading the relevant corporate database schemas to support new data to be loaded into the respective database. This requires working closely with the data modelling team to convert logical data models to physical models, and into database schemas which can be integrated with the relevant corporate database schema. This also requires working with the related development teams to ensure any required data conversions are managed appropriately.
- Leading the development and implementation of guidelines, standards, and processes for database management across the related systems. This requires analyzing the technical and business methodologies for managing databases both within these systems and across the industry and promoting the use of appropriate database management practices to developers and analysts who might be either data providers or consumers, as well as implementing these within the related environments, and ensuring their compliance within.
- Ensuring that Provincial, Cluster, and Ministry database management policies, guidelines, and standards are known within the involved development teams, and that they are respected, and adhered to; representing MNR concerns through the bodies or groups which may create them. This requires regular communication with policy analysts and other staff who have a role in creation of data management policies, guidelines, and standards, as well as participating in working committees and standards groups as needed, to help define these.

**Knowledge**:

- Job requires knowledge of relational database management and administration, and information architecture theory, principles and techniques, techniques of data modeling using computer aided software, and use of information engineering tools to: analyze client data management requirements; assess options, conduct feasibility studies on hardware/software and data management standards; advise clients on short/long term strategies relating these to business plans; develop policies, standards, procedures for administration of database systems.
- Job requires knowledge of commercial software such as Computer Aided Systems Engineering (CASE), knowledge of Use Cases, and UML modelling, to develop/record data models and architectures, process engineering, word processors and graphics presentation software. This is required to lead a project team in: analysis and definition of client's business and information technology requirements; design, development, testing and implementation of systems solutions; review and preparation of technical documentation and technical support.
- Job requires knowledge of government/cluster/ministry information technology policies, directives and guidelines and cluster's information technology plans and strategies (short and long term) to: ensure development of databases and recommendations on acquisition of hardware/software, promote and facilitate cluster's information technology goals and plans

**Skills**:
Experience and Skill Set Requirements

**Skills**:

- Job requires reasoning and high-level problem-solving skills to coordinate analysis and development of data management systems which meet client requirements and facilitate improvement of operational efficiency and to troubleshoot complicated problems.
- Job requires analytical and evaluative skills to: develop project plans, data management structures and overall database design requirements and standards; coordinate design, development and testing of databases.
- Job requires analysis of client's operations and business goals and objectives (short and long term) to develop and recommend policies, standards and procedures for operating issues such as user access, security measures, data storage and retention, data manipulation and reporting capabilities.
- Job requires