RQ11159 - Sr. Database Administrator

RQ11159 - Sr. Database Administrator

1-year 10-month contract (447 business days) - possible extension

ONSITE 5 days - 222 Jarvis St., Toronto or 49 Place d'Armes, Kingston

Security Level: CRJMC

Must have

• 7–10+ years of experience in Database Administration, including design, implementation, operations, and optimization of enterprise‑scale database systems.
• Proven expertise administering cloud database platforms, with a strong focus on Azure PaaS and IaaS database services.
• Experience managing cloud data services for project delivery, including storage, repositories, virtual machines, disks, key vaults, Data Lake, Data Warehouse, and Data Lakehouse platforms
• Expertise in Azure SQL Database, Azure SQL Managed Instance, and SQL Server o n Azure Virtual Machines.
• Advanced performance tuning and troubleshooting, including:
• Query optimization and indexing strategies
• Azure SQL Query Store analysis
• Intelligent Performance & automatic tuning features
• Review of wait statistics and IO analysis
• TempDB optimization
• Understanding and mitigating Azure throttling limits

Responsibilities

• Designing and developing data pipelines from source to end user
• Optimizing data pipelines

· 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

AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations.

Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting.

INCORPORATED RATE RANGE (7.25 billable hours per day)

• $75.60/hr - $90.72/hr Inc.

T4 RATE RANGE (7.25 billable hours per day)

• $60.48/hr - $72.58/hr T4