Database Administrator
8 months ago
The Health Services I&IT Cluster, Emergency Health I&IT Solutions & Technology Management Branch is seeking a Database Administrator to provide strategic data resource management.
**OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism**: We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.
Visit the **OPS Anti-Racism Policy** and the **OPS Diversity and Inclusion Blueprint** pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.
We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's **Human Rights Code**. Refer to the "How to apply" section if you require a disability-related accommodation.
**What can I expect to do in this role?**: In this role, you will:
- provide strategic data resource management, assess Branch requirements and develop data management strategies and plans;
- co-ordinate the development, maintenance and control of the Branch's Databases and Data Warehouse and related documented processes and procedures;
- manage the development, maintenance and uninterrupted running of all interface processes feeding data to the Branch's Databases and Data Warehouse
- co-ordinate the development and provision of standard and ad hoc reports;
- monitor database performance, tuning the database environment, ensure best overall use of technology and optimum on-line systems performance;
- conduct capacity planning and system resource allocation;
- co-ordinate/provide technical support and resolve technical and operational problems;
- coordinate services with vendors and IT support specialists;
- provide expert advice on database, data warehousing and data management developments, technologies and methodologies;
- conduct cost/benefit analyses and feasibility studies, make recommendations and prepare business cases to support new or enhanced technologies
- conduct on-going liaison and consultation with clients, users and stakeholders regarding database and data warehouse needs, operations and changes.
**How do I qualify?**:
**Technical Knowledge and Skills**: You have knowledge of the following:
- PC-based and server-based systems technologies, networks, and data management tools such as Microsoft Power BI
- systems and relational database analysis such as SQL Server databases
- disk architecture and expertise in tuning the database for performance
- user environments, client support issues and client data access tools
**Leadership and Project Management Skills**:
- you have knowledge of project management methodologies and procurement policies and practices
- you have project management and technical leadership skills to advise on technical requirements of the databases and data warehouse and lead database development and change management projects.
**Analytical, Problem-Solving and Organizational Skills**:
- you have analytical skills in assessing the data management requirements of the Branch and clients
- you can lead the development of standards and processes for the databases and data warehouse
- you can analyze user needs in a multi-client environment and develop client access systems, processes and procedures that support user requirements while protecting the security of the system and integrity of data.
- you have analytical and problem-solving skills to ensure the smooth running of all aspects of the databases and Data Warehouse by monitoring performance, tuning the environment and providing timely technical support to resolve problems
- you have organization, co-ordination and administration skills to guide and manage database and data warehouse administration
**Communication and Interpersonal Skills**:
- you have oral communication skills to: liaise and consult extensively with clients regarding data management requirements in both technical and non-technical language, provide direction to staff and vendors, and provide training to clients
- you have written communication skills to: prepare reports, technical analyses, and recommendations for Branch management; develop business cases; prepare systems documentation; and prepare informational materials for clients.
- you have consultation, negotiation and interpersonal skills to consult extensively with clients and stakeholders and to negotiate contracts with vendors of services, equipment and hardware/software within established
parameters
**Other Essential Abilities and Knowledge**:
- you have the ability to learn the policies, standards and objectives relating to information technology, and emergency health services
- you have the ability to interpret policy and legislative requirements affecting data processing and freedom/privacy of information
- you have knowledge of training techniques to co-ordinate the developmen
-
Database Administrator
4 months ago
North York, Canada Ministry of Health Full timeThe Health Services I&IT Cluster, Emergency Health I&IT Solutions & Technology Management Branch is seeking a Database Administrator to provide strategic data resource management. **OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism**: We are committed to build a workforce that reflects the communities we serve and to promote a diverse,...
-
Database Administrator
6 months ago
North York, Canada Extend Financial Ltd. Full timeDurée de l'emploi: Permanent - Langue de travail: Anglais - Heures de travail: 40 hours per week - Education: - Expérience: **Education**: - Bachelor's degree **Work setting**: - Private company, corporation or industry **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Develop and implement a...
-
Analyst, Database
6 months ago
North York, Canada OSTIM LTD. Full timeEducation: - Expérience: **Education**: - Bachelor's degree **Work setting**: - Construction - Construction industry **Tasks**: - Develop and maintain computer databases - Document customers' requirements for projects - Design and develop database - Operate database management systems to analyze data - Develop and implement data administration policy,...
-
Database Analyst
6 months ago
North York, Canada Vyoma Global Inc. Full timeWork Term: Permanent - Work Language: English - Hours: 32 hours per week - Education: College/CEGEP - Experience: 1 year to less than 2 years - or equivalent experience **Work setting**: - Consulting firm **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Data Science - Develop and implement a strategic...
-
Database Manager
1 month ago
North York, Canada Ontario Society of Occupational Therapists Full timeDurée de l'emploi: Permanent - Langue de travail: Anglais - Heures de travail: 35 hours per week - Education: - Expérience: - **Education**: - Bachelor's degree - ** Work setting**: - Associations and non profit organizations - ** Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Develop and...
-
Analyst, Database
6 months ago
North York, Canada Ontario Association of Architects Full timeWork Term: Permanent - Work Language: English - Hours: 35 hours per week - Education: Bachelor's degree - Experience: 3 years to less than 5 years **Work setting**: - Associations and non profit organizations **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test...
-
SQL Server Database Administrator
3 months ago
North York, Canada Uncharted Talent Inc. Full time**Key Responsibilities**: - Maintain and support production SQL Server PaaS databases, ensuring high availability and performance. - Implement and manage database partitioning strategies for large tables in live environments. - Optimize and reduce the number of indexes on high I/O tables based on usage analysis. - Perform query plan analysis and maintenance...
-
SQL Server Database Administrator
4 weeks ago
North York, Canada Uncharted Talent Inc. Full time**Key Responsibilities**: - Maintain and support production SQL Server PaaS databases, ensuring high availability and performance. - Implement and manage database partitioning strategies for large tables in live environments. - Optimize and reduce the number of indexes on high I/O tables based on usage analysis. - Perform query plan analysis and maintenance...
-
Database Analyst
6 months ago
North York, Canada SunCan Communications Corporation Full timeWork Term: Permanent - Work Language: English - Hours: 35 hours per week - Education: Bachelor's degree - Experience: 3 years to less than 5 years **Work setting**: - Consulting firm - Information technology (IT) service provider **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Develop and maintain...
-
Application Database Administrator
5 months ago
North Bay, Canada Resonaite Full timeOur client in the social services industry is looking for a Database Admin/Management Location: Primarily remote, with occasional team meeting in North BayResponsibilitiesProvide in-depth operational support and participate in the architecture, deployment, and management of on premise and cloud-based databases, systems, and services in a geographically...
-
Application Database Administrator
5 months ago
North Bay, Canada Resonaite Full timeOur client in the social services industry is looking for a Database Admin/Management Location: Primarily remote, with occasional team meeting in North BayResponsibilitiesProvide in-depth operational support and participate in the architecture, deployment, and management of on premise and cloud-based databases, systems, and services in a geographically...
-
Application Database Administrator
5 months ago
North Bay, Canada Resonaite Full timeOur client in the social services industry is looking for a Database Admin/Management Location: Primarily remote, with occasional team meeting in North BayResponsibilitiesProvide in-depth operational support and participate in the architecture, deployment, and management of on premise and cloud-based databases, systems, and services in a geographically...
-
Dba (Database Administrator)
7 months ago
North Vancouver, Canada AVIS Full timeEducation: College/CEGEP - Experience: 2 years to less than 3 years **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Develop and implement data administration policy, standards and models - Research and document data requirements, data collection and administration policy,...
-
Professor Databases
6 months ago
North York, Canada Seneca Polytechnic Full time**Join the Renewed Seneca, The Next Seneca.**: Guided by _The Next - A Strategic Plan for Seneca Polytechnic_, we offer a working environment that is innovative, flexible and encourages risk-taking. Joining Seneca Polytechnic brings opportunities for professional development and career growth. We focus on health and wellbeing in all its forms to provide a...
-
Application Database Administrator
2 months ago
North Bay, Ontario, Nipissing region, Canada Resonaite Full timeOur client in the social services industry is looking for a Database Admin/Management Location: Primarily remote, with occasional team meeting in North BayResponsibilitiesProvide in-depth operational support and participate in the architecture, deployment, and management of on premise and cloud-based databases, systems, and services in a geographically...
-
Application Database Administrator
3 weeks ago
North Bay, ON, Canada Resonaite Full timeOur client in the social services industry is looking for a Database Admin/Management Location: Primarily remote, with occasional team meeting in North Bay Responsibilities Provide in-depth operational support and participate in the architecture, deployment, and management of on premise and cloud-based databases, systems, and services in a...
-
Application Database Administrator
3 weeks ago
North Bay, ON, Canada Resonaite Full timeOur client in the social services industry is looking for a Database Admin/Management Location: Primarily remote, with occasional team meeting in North Bay Responsibilities Provide in-depth operational support and participate in the architecture, deployment, and management of on premise and cloud-based databases, systems, and services in a...
-
Database Analyst
6 months ago
North Vancouver, Canada TEI Web Solutions Full timeEducation: College/CEGEP - Experience: 7 months to less than 1 year **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards...
-
Data Administrator
6 months ago
North York, Canada sio4 stone inc Full timeEducation: Bachelor's degree - Experience: 1 year to less than 2 years **Tasks**: - Develop and maintain computer databases - Document reporting needs, queries, logic, results and recommendations to other information systems professionals - Test data models and database management systems - Design and develop database - Operate database management systems...
-
Data Administrator
6 months ago
North York, Canada SparkLease Inc. Full timeEducation: - Expérience: **Education**: - Bachelor's degree **Tasks**: - Develop and maintain computer databases - Document reporting needs, queries, logic, results and recommendations to other information systems professionals - Test data models and database management systems - Design and develop database - Operate database management systems to...