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)
