Database Administrator 9634-1516

• 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.
• Providing technical leadership to development teams within the section in areas of database and Oracle-specific technologies specifically as they relate to application development efforts within the relevant systems. This requires keeping abreast of new developments in these areas; communicating new developments and technologies to programmers and analysts on a regular basis; looking for opportunities where development teams might take advantage of new functionality available through new versions; and mentoring programmers and analysts in these areas through the technical design and construction phases as systems are developed.
• 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.

• 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 a wide range of computer system technologies including server-based technologies as well as personal computer systems application and database management software (Oracle Oracle Enterprise Manager Toad ArcGIS DB) and database development methodology programming languages (SQLPL/SQL) and relational database concepts. This is required to coordinate the design and development of spatial and non-spatial databases and data management structures data dictionaries data storage and retrieval techniques and optimizing database performance.
• 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 clients 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 clusters information technology plans and strategies (short and long term) to: ensure development of databases and recommendations on acquisition of hardware/software promote and facilitate clusters information technology goals and plans

• 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 analyzing client requirements by: identifying parameters method and scope for review of data flow data management and decision-making processes; identifying options; conducting feasibility studies and cost-benefit analyses; and providing advice and guidance to clients on strategies for spatial and non-spatial applications data management including identifying opportunities for integration with other areas/programs use of new technology and techniques.
• 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 clients 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 evaluative skills to research and assess potential use of new information engineering and data management techniques methodologies software and hardware.
• Job requires verbal communication skills to; interview diverse clients about program operations decision-making processes goals and objectives and business plans/strategies; explain spatial and non-spatial database design/development process and review technical considerations with clients and project team; explain recommendations for hardware and software acquisition; present formal and informal training sessions to information system/database users; make presentations to senior management on potential application of new data management technologies.
• Job requires written communication skills to prepare systems documentation and manuals; draft database management policies and standards; prepare project reports; explain analyses/recommendations.
• Job requires interpersonal skills to discuss data management spatial and non-spatial requirements with clients and how particular techniques/technologies will help to improve operational efficiency service delivery and achievement of business goals; illustrate feasibility and advantages or disadvantages of various options with clients and both program branch and systems senior managers; negotiate contracts for services hardware and software with vendors within defined parameters.

Technical Knowledge 40%

• You have 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
• a wide range of computer system technologies including server-based technologies personal computer systems application and database management software (Oracle Oracle APEX Oracle Enterprise Manager Toad ArcGIS DB) and database development methodology programming languages (SQLPL/SQL) and relational database concepts
• commercial software such as Computer Aided Systems Engineering (CASE) knowledge of Use Cases and UML modelling
• You can interpret information technology policies directives guidelines plans and strategies

Analytical and Problem-Solving Skills 30%

• You can:
• coordinate analysis and development of data management systems
• analyze client requirements operations business goals and objectives
• develop project plans data management structures and overall database design requirements and standards
• coordinate design development and testing of databases
• research and assess potential use of new information engineering and data management techniques methodologies software and hardware

Communication and Interpersonal Skills 25%

• You have effective communication and interpersonal skills to:
• conduct interviews with clients and explain technical recommendations and requirements to technical and non-technical audience
• prepare systems documentation and manuals draft database management policies and standards project reports and recommendations
• lead and participate in teams and working groups
• present formal and informal training sessions to data users
• negotiate contracts for services hardware and software with vendors and convey information to senior management

Communication and Interpersonal Skills 5%

• You have previous working experience within Government environment.

• 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
• analyze client requirements operations business goals and objectives
• prepare systems documentation and manuals draft database management policies and standards project reports and recommendations
• present formal and informal training sessions to data users