Job Specification
Position Title:
Database Administrator
Job Code:
17162 - Systems Officer 6
Purpose of Position :
To provide technical support for the design and development of current and future IT Cluster database systems. To provide direction in technical design, programming concepts and optimization training, assuring compliance with standards, backup and integrity needs. To research data center operating systems and database software. To monitor the operations of database systems and ensure their operational efficiency.
Duties / Responsibilities :
Applying senior technical expertise in designing, developing and implementing all IT Cluster databases and data structures and providing group leadership and technical direction, consultation, and instruction to the application developers to ensure the benefits of database technology are achieved.
Providing technical direction and expert advice to the application development teams and monitoring, identifying and resolving the IT Cluster production systems to ensure their integrity and performance through database recovery, purge and reorganization operations, reviewing database performance, transaction and space utilization etc. and through validating designs against government and IT Cluster policy and standards.
Providing senior level expertise in the design, development and implementation of technology solutions researching, evaluating and selecting hardware and software tools and their impact on the various applications, communicating and coordinating with IT Cluster management and clients.
Providing leadership, planning and analysis expertise in technology uses for managing information and relationships to IT Cluster databases, operational systems and providing training to systems staff in best practices for data and database structures
and design. Reviewing proposals from subordinates and peers for feasibility, quality and effectiveness.
Establishing and maintaining the methods, techniques, guidelines and monitoring practices for the design and development of database systems, to minimize operational costs, to ensure service levels are maintained with clients and to comply with I&IT policy
Staffing and Licensing :
N/A
Knowledge :
Job requires expert knowledge of database management technologies and database design methods and techniques to design and maintain IT Cluster databases. Job requires knowledge of technical performance software to ensure database integrity and
performance standards are met, and knowledge of database utility software for mainframe, mid-range and desktop database management technologies to perform database recovery, purge and reorganization operations. Job requires knowledge of
research and project management methods to lead a multi-disciplinary project team, including business analysts, technical staff, knowledge workers and stakeholders in: identification and evaluation of information technology options for clients; development of
new systems or systems modifications; evaluation and recommendations for acquisition of applications, hardware/software, information technology services. Job requires knowledge of theory and principles of business design, systems analysis, design and development, and related methods, techniques, practices and standards, in order to lead a team in: initiating projects, establishing scope, objectives, requirements and analysis and definition of clients business and information technology requirements; design, development, testing and implementation of systems solutions; ensuring preparation of technical documentation and technical support; preparation of training and implementation plans for all aspects of the technical system. Job requires knowledge of IT Cluster/government administrative policies and directives to ensure compliance of recommendations on acquisition of technology and services. Job requires knowledge of the Clusters' IT plan, project planning methodology, and clients' business, processes, and requirements to recommend systems development solutions which promote the Cluster's IT strategies and goals while also meeting business needs/priorities of client. Job requires understanding of operational disciplines and processes. Job requires skills in negotiation, conflict and problems resolution and team leadership.
Skills :
Job requires senior level expertise in design, development and implementation of IT Cluster databases. Analytical and problem solving skills are required to assess sometimes competing clients' information/systems needs and lead development of information technology solutions which are cost effective and improve client program/service delivery. Job evaluates and determines new database design techniques, software and technology for acquisition by IT Cluster. Job evaluates design alternatives through feasibility studies and directs business and systems design, staff on technology approach, standards, costs, time constraints, and future development considerations. Job leads systems analysis and design: designs and develops data requirements with stakeholders both in the technology and user areas; leads the design process and data modelling for client branches/programs. Job performs analysis and definition of client information requirements, including assessment of short and long term business goals and objectives. Job analyses and advises clients on development of their information/data technology priorities in order to reflect their business needs/requirements/plans, program/service delivery requirements and resource limitations. Job requires expert technical problem analysis and resolution for production issues during regular business hours and after hour support. Job requires verbal communication skills to: discuss and confirm client requirements; lead discussion of systems development options and technical processes among project team; and discuss systems development recommendations with clients, making a variety of technical analyses, limitations and considerations clear in non-technical terms while also communicating advantages and disadvantages of various options and their impact on client's program/service delivery. Job requires writing skills to: prepare project reports; explain analyses/recommendations; develop data models and their descriptions, recommend approach to database acquisition of technology/services; prepare systems documentation and manuals. Job requires interpersonal skill to: explain/illustrate alternate solutions to client's systems development requirements; discuss and develop clients' support for recommended approach, by outlining analyses of costs/benefits, impact on client's service delivery and achievement of business goals.
Freedom of Action :
Job requires working within: IT Cluster policies and guidelines for delivery of information management systems, consulting services; and IT Cluster and government policies and directives for information technology development and acquisition. Job exercises latitude in decision-making by: determining how best to define and characterize client needs; identifying options and deciding on database structures and overall data design, recommending information technology approach for project; developing project plan, schedule and budget; determining necessary adjustments to development process during course of project to ensure quality of product, and that timeliness and sometimes changing client requirements are met. This senior level work is performed and rarely reviewed, approvals only at major milestones by management and clients; general updates on project status and achievement of objectives are provided to management. Job refers to management/executive only when significant issues require attention such as: major business changes, need for organizational enhancements; and significant