Database Developer

---

Are you a seasoned IT professional and project leader with a background in Microsoft SQL Server technology? If so, then consider this opportunity with the Education Quality and Accountability Office (EQAO) where you will lead the design, development and implementation of technical solutions.

---

About the job

You will:

• define, evaluate and recommend solutions for information and database architecture requirements
• use secure database development methods to create well-performing T-SQL statements, T-SQL objects, MDX statements and programming code for in-house applications
• create technical specifications and perform gap analysis, hands-on integration and testing of acquired solutions

---

What you bring to the team

Technical knowledge:

You have knowledge of:
• hands-on database, business intelligence and reporting development using Microsoft SQL Server technology
• T-SQL development, including stored procedures, views, triggers and functions
• design and development of OLAP solutions including the creation of MDX statements and SQL Server Analysis Services (SSAS) cubes and dimensions
• Extract, Transform and Load (ETL) experience using SQL Server Integration Services (SSIS)
• experience with reporting using SQL Server Reporting Services (SSRS)
• code control, code and system change management, team development tools, agile development methods and tools, database scripting, automated code builds, and automated deployment

Systems and data analysis:

• You have knowledge of systems analysis, methods and technology solutions to advise clients on general and specific technology products, contribute to the development of I&IT strategic and operational business plans, and support the preparation of IT business cases.
• You have experience gathering requirements, conducting analysis of vendor solutions.
• You can work with large datasets containing millions of data points.
• You stay abreast of current and emerging technology solutions and industry trends for application development and maintenance, desktop computer systems, network communications and inter-connectivity to advise clients on technology products.

Stakeholder management and communication skills:

• You have communication skills to prepare submissions and planning documents, reports, briefing materials and correspondence.
• You can provide advice and guidance to support agency business area management in I&IT operational and strategic matters and foster effective relationships with stakeholders and vendors.
• You have negotiation and persuasion skills to encourage client understanding/acceptance of technology concepts and generate commitment to projects.
• You can prepare and present information, explanations, options and recommendations for diverse audiences.

Administrative and project management skills:

• You can acquire knowledge of policy, procurement, and decision-making processes to provide information and advice, support business case development, and prepare submissions to facilitate senior-level decision-making.
• You have knowledge of IT project management policies and procedures, including budgeting and financial administration to lead projects and ensure compliance.

---

Additional information:

Note:

• T-EU-106435/17

---

Language requirements and assessment:
All external Ontario Public Service (OPS) job ads are posted in English and French. Check the "position(s) language" section at the top of each job ad for the language requirements. For all roles, candidates are assessed in English, the business language of the OPS. If the position is bilingual (English/French), you'll also need to pass a French-language proficiency test.

Exigences en matière de langue et évaluation:
Toutes les offres d'emploi externes de la fonction publique de l'Ontario (FPO) sont affichées en français et en anglais. Consultez la section « Langue du ou des postes » en haut de chaque offre d'emploi pour connaître les exigences linguistiques. Pour tous les postes, les candidats sont évalués en anglais, la langue d'affaires de la FPO. Si le poste est bilingue (anglais/français), vous devrez également passer un test de compétences linguistiques en français.