5-7 years of experience with major DBMS like Oracle, SQL Server, PostgreSQL, MySQL, and IBM DB2
Proficient in managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS)
Strong background in Cyber Security and Enterprise Architecture
Experience with SQL, PL/SQL, T-SQL, and shell scripting for automation
Familiarity with Agile methodologies and data modeling techniques
Excellent communication skills for documentation and client interaction
Experience with large-scale public applications and government projects
Responsibilities
Create and manage physical database designs and optimize DBMS performance
Administer database systems including installation, migration, and backup
Monitor and enforce database rules and compliance
Develop automated data distribution mechanisms
Lead database version upgrades and cross-platform migrations
Implement strict role-based access control and data security measures
Collaborate with teams to ensure adherence to data privacy mandates
Benefits
Flexible work arrangements
Professional development opportunities
Access to cutting-edge technology and tools
Collaborative team environment
Health and wellness programs
Full Job Description
Job Description Responsibilities:
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
Desirable Skills:
Experiencewith distributed data systems
Experiencewith middleware and gateways
Experiencewith researching and implementing cyber security vulnerabilityremediations
Experiencein designing/developing an automated data distribution mechanism
Knowledgeand understanding of object-oriented analysis and design techniques.
Experiencein developing enterprise architecture deliverables (e.g. models) based
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 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
