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 transparent and understandable manner

#J-18808-Ljbffr

📌 11902 (Ontario)
🏢 Maarut
📍 Ontario