BEV123
Level 3 Database Administrator for a 1-year contract with three 1-year option periods.
Security & Work Conditions
-
Clearance: Reliability Status (minimum)
-
Location: NCR (Ottawa/Gatineau)
-
Typically, hybrid or onsite
Mandatory Profile
10+ years of DBA experience
-
Senior-level exposure to:
-
Enterprise IT environments
-
Mission-critical systems
Recent experience (within the past 5 years) working with Azure SQL databases.
Experience in designing and developing SQL databases.
Core Responsibilities
Database Administration & Maintenance
Install, configure, and maintain database systems
-
Manage:
-
Instances
-
Storage
-
Environments (dev/test/prod)
Performance Monitoring & Tuning
Monitor:
-
Database performance
-
Query execution
-
Resource usage
Perform:
-
Performance tuning
-
Index optimization
-
Query optimization
Backup, Recovery & Continuity
Implement and manage:
-
Backup strategies
-
Disaster recovery plans
Perform:
-
Data restoration
-
Failover testing
Security & Access Management
Manage:
-
User roles and permissions
-
Authentication and access controls
Ensure:
-
Compliance with federal security standards
-
Data protection and audit readiness
Application & Integration Support
Work with developers and analysts to:
-
Support database-related application issues
-
Optimize queries and data access
Support integration across:
-
Applications
-
APIs
-
Data pipelines
Troubleshooting & Issue Resolution
Diagnose:
-
Performance issues
-
Data inconsistencies
-
System failures
-
Provide timely resolution to minimize downtime
Collaboration with Data Modeler
Implement and maintain:
-
Data models
-
Database schemas
-
Ensure alignment between:
-
Logical design and physical implementation
