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, P

📌 11902 (Toronto)
🏢 Maarut
📍 Toronto