Job Specification

Purpose of Position :

To develop SQL script, execute and operational maintenance of databases and database administration activities in support of the Ministry of Natural Resources application portfolio. Work with project team and take part in development database design. Monitor the health of databases and address issues as they arise as well as "incidents" raise by client. Work with team to improve delivery of service and introduce operational efficiencies.

Duties / Responsibilities :

Ensuring that all databases managed through LRC are operational and optimized to perform at acceptable levels.

Work with project team and establish good operational requirements. Working with all IT partners and implement solutions as designed providing leadership and guidance to project team; determining database structure and system operating issues such as levels of user access, security measures, data storage and retention, response times, reporting requirements, etc; participate in design and development process; and liaising /negotiating with vendors of services, hardware and software.

Work within individual/team environment, designing data base structures by analysing users requirements and technology and consulting with clients as necessary, developers, programmers; developing physical data models based from conceptual or logical data models; analysing or modifying existing physical models and recommend/implement performance measure, while adherence to LRC/OPS standards; Share information with project team and with section team members on new technology/data management methods.

Monitoring and/or executing, on an ongoing basis, data base and information system administration procedures (back-up, recovery, tuning, upgrades, migration, etc); identifying and resolving user problems and ensuring their compliance with standards and systems use; developing data management guidelines for use/maintenance of data bases that ensure information security, accessibility, data base integrity and which comply with corporate/ministry standards, policies and guidelines.

Developing standards and procedures for user access methods, security measures, etc, using data base management system; providing authorized access to Ministry staff and other users, and monitoring data bases consistency and integrity.

Providing technical support and advice to users on data base management systems and data administration tools, techniques and methodologies.

Staffing and Licensing :

N/A

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 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), and database development methodology, programming languages (SQL PL/SQL), and relational database concepts. This is required to coordinate the design and development of databases and data management structures, data dictionaries, data storage and retrieval techniques, and optimizing database performance.

Job requires knowledge of commercial software such as 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 :

Job requires analytical and evaluative skills to: design data bases, analyse & develop project plans, data management structures and overall data base operation efficiencies, requirements and standards; identifying user problems, system and information bottlenecks and feasible solutions, developing security levels and security procedures; determining specific approaches and most cost effective solutions, applying and/or adapting precedents to solve problems, and designing the data base; analysing requirements and trade-offs between flexibility, complexity, processing, communications, and specific features to determine modifications to existing applications.

Job requires analysis of client's operations and business goals and objectives to develop and recommend 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 ministry use of new information engineering and data management techniques, methodologies, software and hardware.

Job requires oral communication skills to: exchange information during development and operation of data bases; to obtain information from other staff and advise on technical requirements, and to collaborate to achieve efficient operation explain data.

Freedom of Action :

Job requires working within Land and Resources Cluster/government directives, policies and guidelines for the acquisition and use of information technology, within recognized systems/database design and development practices, data management techniques and methods.

Job requires latitude for decision-making in: determining adjustments to database design specifications; recommending opportunities for productivity improvement and database optimization; determining how best to define and characterize client needs. Work is reviewed at key critical stages only of project by manager, for accomplishment of goals and objectives and completion of deliverables.

Job requires determining parameters and scope of review/analysis of client operations and data management requirements in preparation for feasibility studies; determining and recommending data management strategy to client and recommending related policies, standards and procedures for operation and administration (e.g. levels of user access, security measures, data manipulation and storage capabilities); identifying opportunities for data sharing and integration across projects/programs; determining testing and implementation plans.

Job refers to supervisor/manager problems/issues such as insufficient resources, acquisition of hardware or software to carry out design and development of database and consults on sharing of technology or integration of data among different clients/programs. Job requires awareness of new and upcoming technologies such as new management tools and software versions.