RQ11860 - Database Administrator - Senior

Responsibilities:

• Creates

physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery

General Skills:

• Experience

with one or more operating systems

• Experience

with one or more database technologies

• Experience

in one or more programming languages

• Experience

in the use of information retrieval packages and proficiency with query languages

• Experience

in monitoring and enforcing database rules

• Experience

in Incident, Change and Configuration Management procedures

• Experience

with one or more communications protocols

• Excellent

analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills

• A

team player with a track record for meeting deadlines

Desirable Skills:

• Experience

with distributed data systems

• Experience

with middleware and gateways

• Experience

with researching and implementing cyber security vulnerability remediations

• Awareness

of emerging IT trends and directions

• Experience

with Computer Aided Software Engineering (CASE) tools

• Knowledge

and understanding of Information Management principles, concepts, policies and practices

• Experience

in Database Administration, Maintenance Optimization

Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEE:

• Subject

matter expert in database design of the data warehouse or data marts.

• Skills:

• Experience

and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning

Additional Skills for Case Management and ERP:

• Experience

in designing/developing an automated data distribution mechanism

• Knowledge

and understanding of object-oriented analysis and design techniques.

• Experience

in developing enterprise architecture deliverables (e.g. models) based

• Knowledge

and understanding of Ontario Government Enterprise Architecture processes and practice

• Knowledge

and understanding of Information Management principles, concepts, policies and practices

• Experience

in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases

• Experience

in technical design, planning and implementation of specific technology or suite

• Experience

with database administration and vendor support services

Additional Skills for Cloud Database Administrator:

• Expertise

and experience in Cloud DB Administration, Data Development (DevOps/DataOps) & Operations, Data Integration, Automation tools and technologies. Further research suggested on a potential need for a role of a Senior DevOps/Cloud DBA at a rate similar to a Senior DevOps/Could Engineer

Additional Skills for Oracle Database Administrator:

• Experience

in e-Business Suite Applications R12.2 and Oracle Data Guard application (installation, configuration, maintenance, patching, upgrade, and cloning)

• Knowledge

and experience in configuring the latest version of WebLogic, OEM Grid Control

• Expert

level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x

• Expert

level knowledge of Advanced Compression, Data partitioning processes

• High

level knowledge of data masking using Oracle patches and database scripts

• Performance

tuning of e-Business Suite R12.2/19c in multi-node RAC

• Developing

database backup and restore strategy utilizing Flash Recovery Area (FRA) for RMAN and ASM.

• Expert

level knowledge of Oracle 12c/19c database administration, maintenance, security implementation, upgrade and patching, database performance tuning, sizing and capacity planning, database backup and recovery using RMAN

• Knowledge

of Configuring Oracle E-Business Suite Release 12.2 using Logical Host

• Knowledge

of Online patching

• Knowledge

of UNIX OS (Operating System) and Linux OS, utilities, shell scripting

Requirements

Experience and Skill Set Requirements:

Must Haves:

• Experience

with major database management systems (DBMS) such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2

• Experience

managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS, Google Cloud SQL) alongside legacy on-premises mainframes and enterprise servers

• Experience

Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, Microsoft .Net,

• Experience

with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB etc.)

Skill Set Requirements:

Technical Skills:

• Experience

with major database management systems (DBMS) such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2

• Experience

managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS, Google Cloud SQL) alongside legacy on-premises mainframes and enterprise servers

• Experience

with Agile methodologies

• Experience

with conceptual, logical, and physical data modeling, schema design, and enterprise data architecture to support large-scale public applications

• Experience

with onPrem and Cloud connections using Mulesoft or similar tools

• Experience

Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, Microsoft .Net,

• Experience

with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB etc.)

• Experience

with Rest APIs & Integrations, Web/Lite Apps

Experience:

• Experience

with cloud platforms such as Azure, Dynamics 365, Power Platform

• Experience

Implementing strict role-based access control (RBAC), data masking, row-level security, and transparent data encryption (TDE) at rest and in transit

• Ensuring

adherence to provincial data privacy and security mandates

• Designing,

testing, and executing enterprise backup strategies, point-in-time recovery, geo-replication, and business continuity failover drills

• Experience

with Agile methodologies including using kanban/task boards

• Hands-on

experience leading major database version upgrades, cross-platform migrations, and consolidation projects without disrupting agency services

• Experience

with SQL, PL/SQL, T-SQL, and shell scripting (Bash, PowerShell, Python) for automation, stored procedures, and triggers

• Experience

with large government applications

Communication Skills:

• Strong

communication skills to prepare documentation, including but not limited to; reports, reviews, assessments

• Ability

to present ideas and suggestions clearly and effectively and in a user friendly manner; maintain a high level of customer service to both internal and external clients

• Ability

to communicate designs and development in clear and understandable manner