Createsphysicaldatabasedesignsandoperatesandadministersthedatabasemanagementsystem(DBMS)includingdatabaseoptimization,capacityplanning,installationandmigration,databasedesign,...CA$26.00 hourlyFull-timeExperienced with TIBCO EBX master data management application, specifically the design and implementation of current dataspaces, data mode...Description :Responsibilities:Creates physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recoveryGeneral Skills:Experience with one or more operating systems Experience with one or more database technologies Experience in one or more programming languages Experience in the use of information retrieval packages and proficiency with query languages Experience in monitoring and enforcing database rules Experience in Incident, Change and Configuration Management procedures Experience with one or more communications protocols Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills A team player with a track record for meeting deadlines Desirable Skills: Experience with distributed data systems Experience with middleware and gateways Experience with researching and implementing cyber security vulnerability remediations Awareness of emerging IT trends and directions Experience with Computer Aided Software Engineering (CASE) tools Knowledge and understanding of Information Management principles, concepts, policies and practices Experience in Database Administration,



Maintenance Optimization Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEE Subject matter expert in database design of the data warehouse or data marts.Skills:Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning Additional Skills for Case Management and ERP Experience in designing/developing an automated data distribution mechanism Knowledge and understanding of object-oriented analysis and design techniques. Experience in developing enterprise architecture deliverables (e.G. models) based Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice Knowledge and understanding of Information Management principles, concepts, policies and practices Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases Experience in technical design, planning and implementation of specific technology or suite Experience with database administration and vendor support servicesExperience and Skill Set RequirementsExperience And SkillSet Requirements 60%Creates database designs, operates and administers the Oracle database and MS SQL server solution, including:Maintaining Oracle and MS SQL servers and backupsProvisioning of databasesSecuring data and access to the Oracle and MS SQL Servers and databasesTuning,



capacity management and monitoring of the databasesWrite database scripts and create tables, stored procedures, views, etc.Maintain documentation for operationsDR support, restoration and configuration of DR SQL servers and DBsGeneral Skills 25%:Experience with Windows Server and Red Hat Linux operating systemsExperience with both Oracle and Microsoft SQL Server and SQL Server Reporting ServiceExperience in the use of information retrieval packages and proficiency with querylanguagesExperience in monitoring and enforcing database rulesExperience in Incident, Change and Configuration Management proceduresExcellent analytical, problem-solving and decision-making skills; verbal and writtencommunication skills; and interpersonal skillsA team player with a track record for meeting deadlinesExperience with distributed data systemsExperience with middleware and gatewaysExperience with researching and implementing cyber security vulnerabilityremediationsAwareness of emerging IT trends and directionsKnowledge and understanding of Information Management principles, concepts,policies and practicesMust haves:Creates database designs, operates and administers the Oracle database and MS SQL server solution, including:Maintaining Oracle and MS SQL servers and backupsProvisioning of databasesSecuring data and access to the Oracle and MS SQL Servers and databasesTuning, capacity management and monitoring of the databasesWrite database scripts and create tables, stored procedures, views, etc.Maintain documentation for operationsDR support, restoration and configuration of DR SQL servers and DBsExperience with Windows Server and Red Hat Linux operating systems

📌 System Application Analyst (Oshawa)
🏢 Rodan Energy Solutions
📍 Oshawa