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 on 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