Database Administrator

Assignment: RQ09634 - Database Administrator - Senior

Job Title: Database Administrator

Requisition (SS): RQ09634

Start Date: 2025-09-02

Client: Land & Resources Cluster

End Date: 2026-03-31

Office Location: 40 St Clair W, Toronto

Organization: Land & Resources Cluster

Ministry: Ministry of Public and Business Service Delivery and Procurement

# Business Days: 109.00

Hybrid - Candidate MUST work 3 days onsite and 2 days remote. Starting October 20, resources are expected to come into the office 4 days per week. Starting January 5, resources are expected to come into the office 5 days per week. This is subject to change based on manager discretion.

Must haves

• 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

Description

• To respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basis.
• Ensuring that all productio n 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.

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, Toad, ArcGIS DB), and database development methodology, programming languages (SQL,PL/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 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

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 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 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 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.

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.

Scoring:

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 (SQL,PL/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.