11902

Maarut; Toronto; On-site; CAD 120,000 - 150,000; Full time

Job summary

Maarut is seeking a Senior Database Administrator in Toronto to design and administer enterprise databases. You will optimize DBMS performance, plan capacity, and manage backups, migrations, and security across Oracle, SQL Server, PostgreSQL, and MySQL environments.

Experience with data warehousing and OBIEE is valued. You will collaborate with cross‑functional teams to maintain data integrity, support ERP and Case Management systems, and drive improvements in data architecture for large-scale

Qualifications

• Experience with major DBMS: Oracle, SQL Server, PostgreSQL, MySQL, IBM DB2.
• Proven ability to manage cloud or hybrid databases alongside on-premises systems.
• Experience with Agile methodologies and data modeling.
• Ability to design, implement and optimize data architectures for large public applications.
• Experience with Rest APIs, integrations, and on-prem/cloud connections.

Responsibilities

• Creates physical database designs and administers DBMS including optimization, capacity planning, installation and migration.
• Perform backup and recovery, performance tuning and security enforcement.
• Lead data warehouse data marts design and Oracle OBIEE implementation.
• Manage case management and ERP related database components and patches.
• Support cloud database administration, DevOps/DataOps, and automation tooling.
• Ensure compliance with data privacy and security mandates.

Skills

Operating systems

Database technologies

Programming languages

Query languages

Database rules

Incident/Change/Config Mgmt

Communication skills

Team collaboration

Distributed data systems

Middleware / gateways

Cyber security remediation

Emerging IT trends

CASE tools

Information Management basics

Tools

Oracle OBIEE

WebLogic

Oracle Data Guard

RMAN / FRA

SQL Server / PostgreSQL / MySQL

e-Business Suite R12.2

Job description

RQ11860 - Database Administrator - Senior

• Createsphysical database designs and operates and administers the databasemanagement system (DBMS) including database optimization, capacityplanning, installation and migration, database design, performance tuning,backup and recovery

General Skills

• Experiencewith one or more operating systems
• Experiencewith one or more database technologies
• Experiencein one or more programming languages
• Experiencein the use of information retrieval packages and proficiency with querylanguages
• Experiencein monitoring and enforcing database rules
• Experiencein Incident, Change and Configuration Management procedures
• Experiencewith one or more communications protocols
• Excellentanalytical, problem-solving and decision-making skills; verbal and writtencommunication skills; and interpersonal skills
• Ateam player with a track record for meeting deadlines
• Experiencewith distributed data systems
• Experiencewith middleware and gateways
• Experiencewith researching and implementing cyber security vulnerabilityremediations
• Awarenessof emerging IT trends and directions
• Experiencewith Computer Aided Software Engineering (CASE) tools
• Knowledgeand understanding of Information Management principles, concepts, policiesand practices

Additional Responsibilities/Skills for Data Warehouseincluding Oracle OBIEE

• Subjectmatter 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) andcloning

Additional Skills for Case Management and ERP

• Knowledgeand understanding of object-oriented analysis and design techniques.
• Knowledgeand understanding of Ontario Government Enterprise Architecture processesand practice
• Knowledgeand understanding of Information Management principles, concepts, policiesand practices
• Experiencein impact analysis, implementation planning and implementation oftechnology or suite specific patches, maintenance packs and releases, andtechnology stack patch sets and releases
• Experiencein technical design, planning and implementation of specific technology orsuite
• Experiencewith database administration and vendor support services

Additional Skills for Cloud Database Administrator

• Expertiseand 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/CouldEngineer

Additional Skills for Oracle Database Administrator

• Experiencein 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 GridControl
• Expertlevel knowledge of migrating Oracle technologies from Unix (Solaris) toOracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x
• Expertlevel knowledge of Advanced Compression, Data partitioning processes
• Highlevel knowledge of data masking using Oracle patches and database scripts
• Performancetuning of e-Business Suite R12.2/19c in multi-node RAC
• Developingdatabase 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 usingRMAN
• Knowledgeof Configuring Oracle E-Business Suite Release 12.2 using Logical Host
• Knowledgeof Online patching
• Knowledgeof UNIX OS (Operating System) and Linux OS, utilities, shell scripting

Requirements

Experience and Skill Set Requirements

Must Haves

• Experiencewith major database management systems (DBMS) such as Oracle, MicrosoftSQL Server, PostgreSQL, MySQL, and IBM DB2
• Experiencemanaging cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS,Google Cloud SQL) alongside legacy on-premises mainframes and enterpriseservers
• ExperienceCloud (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 Requirements

Technical Skills

• Experiencewith major database management systems (DBMS) such as Oracle, MicrosoftSQL Server, PostgreSQL, MySQL, and IBM DB2
• Experiencemanaging cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS,Google Cloud SQL) alongside legacy on-premises mainframes and enterpriseservers
• Experiencewith Agile methodologies
• Experiencewith conceptual, logical, and physical data modeling, schema design, andenterprise data architecture to support large-scale public applications
• Experiencewith onPrem and Cloud connections using Mulesoft or similar tools
• ExperienceCloud (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 Apps

Experience

• Experiencewith cloud platforms such as Azure, Dynamics 365, Power Platform
• ExperienceImplementing strict role-based access control (RBAC), data masking,row-level security, and transparent data encryption (TDE) at rest and intransit
• Ensuringadherence to provincial data privacy and security mandates
• Designing,testing, and executing enterprise backup strategies, point-in-timerecovery, geo-replication, and business continuity failover drills
• Experiencewith Agile methodologies including using kanban/task boards
• Hands-onexperience leading major database version upgrades, cross-platformmigrations, and consolidation projects without disrupting agency services
• Experiencewith SQL, PL/SQL, T-SQL, and shell scripting (Bash, PowerShell, Python)for automation, stored procedures, and triggers
• Experiencewith large government applications

Communication Skills

• Strongcommunication skills to prepare documentation, including but not limitedto; reports, reviews, assessments
• Abilityto present ideas and suggestions clearly and effectively and in a userfriendly manner; maintain a high level of customer service to bothinternal and external clients
• Abilityto communicate designs and development in clear and understandable manner