11902 (Toronto)

11902 (Toronto)

19 Nov
|
Maarut
|
Toronto

19 Nov

Maarut

Toronto

RQ11860 - Database Administrator - SeniorCreatesphysical database designs and operates and administers the databasemanagement system (DBMS) including database optimization, capacityplanning, installation and migration, database design, performance tuning,backup and recoveryGeneral SkillsExperiencewith one or more operating systemsExperiencewith one or more database technologiesExperiencein one or more programming languagesExperiencein the use of information retrieval packages and proficiency with querylanguagesExperiencein monitoring and enforcing database rulesExperiencein Incident, Change and Configuration Management proceduresExperiencewith one or more communications protocolsExcellentanalytical, problem-solving and decision-making skills; verbal and writtencommunication skills; and interpersonal skillsAteam player with a track record for meeting deadlinesExperiencewith distributed data systemsExperiencewith middleware and gatewaysExperiencewith researching and implementing cyber security vulnerabilityremediationsAwarenessof emerging IT trends and directionsExperiencewith Computer Aided Software Engineering (CASE) toolsKnowledgeand understanding of Information Management principles, concepts, policiesand practicesAdditional Responsibilities/Skills for Data Warehouseincluding Oracle OBIEESubjectmatter expert in database design of the data warehouse or data marts.Skills:Experienceand expert knowledge in technology and/or application required includinginstallation, configuration, maintenance, upgrade (technology stack) andcloningAdditional Skills for Case Management and ERPKnowledgeand understanding of object-oriented analysis and design techniques.Knowledgeand understanding of Ontario Government Enterprise Architecture processesand practiceKnowledgeand understanding of Information Management principles, concepts, policiesand practicesExperiencein impact analysis, implementation planning and implementation oftechnology or suite specific patches, maintenance packs and releases, andtechnology stack patch sets and releasesExperiencein technical design,



planning and implementation of specific technology orsuiteExperiencewith database administration and vendor support servicesAdditional Skills for Cloud Database AdministratorExpertiseand experience in Cloud DB Administration, Data Development(DevOps/DataOps) & Operations, Data Integration, Automation tools andtechnologies. Further research suggested on a potential need for a role ofa Senior DevOps/Cloud DBA at a rate similar to a Senior DevOps/CouldEngineerAdditional Skills for Oracle Database AdministratorExperiencein e-Business Suite Applications R12.2 and Oracle Data Guard application(installation, configuration, maintenance, patching, upgrade, and cloning)Knowledgeand experience in configuring the latest version of WebLogic, OEM GridControlExpertlevel knowledge of migrating Oracle technologies from Unix (Solaris) toOracle Enterprise Linux / Red Hat Enterprise Linux 5.X/6.X/7.XExpertlevel knowledge of Advanced Compression, Data partitioning processesHighlevel knowledge of data masking using Oracle patches and database scriptsPerformancetuning of e-Business Suite R12.2/19c in multi-node RACDevelopingdatabase backup and restore strategy utilizing Flash Recovery Area (FRA)for RMAN and ASM.Expertlevel knowledge of Oracle 12c/19c database administration, maintenance,security implementation, upgrade and patching, database performancetuning, sizing and capacity planning, database backup and recovery usingRMANKnowledgeof Configuring Oracle E-Business Suite Release 12.2 using Logical HostKnowledgeof Online patchingKnowledgeof UNIX OS (Operating System) and Linux OS, utilities, shell scriptingRequirementsExperience and Skill Set RequirementsMust HavesExperiencewith major database management systems (DBMS) such as Oracle, MicrosoftSQL Server, PostgreSQL, MySQL, and IBM DB2Experiencemanaging cloud-hosted or hybrid databases (e.G., Azure SQL, Amazon RDS,Google Cloud SQL) alongside legacy on-premises mainframes and enterpriseserversExperienceCloud (Azure or AWS), Cyber Security, Enterprise and SolutionArchitecture, Java,



Microsoft .Net,Experiencewith SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQLMI, Azure Blob, Cosmos DB etc.)Skill Set RequirementsTechnical SkillsExperiencewith major database management systems (DBMS) such as Oracle, MicrosoftSQL Server, PostgreSQL, MySQL, and IBM DB2Experiencemanaging cloud-hosted or hybrid databases (e.G., Azure SQL, Amazon RDS,Google Cloud SQL) alongside legacy on-premises mainframes and enterpriseserversExperiencewith Agile methodologiesExperiencewith conceptual, logical, and physical data modeling, schema design, andenterprise data architecture to support large-scale public applicationsExperiencewith onPrem and Cloud connections using Mulesoft or similar toolsExperienceCloud (Azure or AWS), Cyber Security, Enterprise and SolutionArchitecture, Java, Microsoft .Net,Experiencewith SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQLMI, Azure Blob, Cosmos DB etc.)Experiencewith Rest APIs & Integrations, Web/Lite AppsExperienceExperiencewith cloud platforms such as Azure, Dynamics 365, Power PlatformExperienceImplementing strict role-based access control (RBAC), data masking,row-level security, and transparent data encryption (TDE) at rest and intransitEnsuringadherence to provincial data privacy and security mandatesDesigning,testing, and executing enterprise backup strategies, point-in-timerecovery, geo-replication, and business continuity failover drillsExperiencewith Agile methodologies including using kanban/task boardsHands-onexperience leading major database version upgrades, cross-platformmigrations, and consolidation projects without disrupting agency servicesExperiencewith SQL, PL/SQL, T-SQL, and shell scripting (Bash, PowerShell, Python)for automation, stored procedures, and triggersExperiencewith large government applicationsCommunication SkillsStrongcommunication skills to prepare documentation, including but not limitedto; reports, reviews, assessmentsAbilityto present ideas and suggestions clearly and effectively and in a userfriendly manner; maintain a high level of customer service to bothinternal and external clientsAbilityto communicate designs and development in transparent and understandable manner

📌 11902 (Toronto)
🏢 Maarut
📍 Toronto

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: 11902 (toronto) / toronto

Subscribe to this job alert:

Get the latest job offers by email for: 11902 (toronto) / toronto