Database Administrator (10-month Contract)
CAD 84K-108K (estimate) Mid-level Contract
Tasks
- Administer database security users roles and permissions
- Automate tasks with T SQL scripts SQL Agent jobs and PowerShell
- Configure and manage SQL Server AlwaysOn availability groups and failover clustering
- Develop and maintain SSIS packages and SSRS reports
- Install, configure and maintain SQL server instances
- Manage AWS IAM roles and permissions
- Manage and support SQL Server production QA and development environments
- Manage backup restore and point in time recovery
- Monitor OS metrics with Performance Monitor
- Monitor performance with CloudWatch and NewRelic
- Optimize database performance with query optimization index tuning and execution plan analysis
- Perform Windows Server administration and patching
- Troubleshoot connectivity network and DNS issues
Perks/Benefits
Skills/Tech-stack
AWS | AWS IAM | AWS Systems Manager | AWS systems | Amazon DynamoDB | Amazon EC2 | Amazon RDS | Amazon S3 | Backup/Restore | CloudWatch | DNS | Execution Plan | Failover Clustering | HAProxy | Index Tuning | New Relic | ODBC | PerfMon | Performance Monitor | Point In Time | Point-in-time recovery | Powershell | Query Optimization | SQL Server | SQL Server Agent | SQL Server AlwaysOn | SSIS | SSRS | Systems Manager | T-SQL | TCP/IP | Windows Firewall | Windows server
Education
N/A
Roles
Regions
Countries
States
Related jobs
-
Intermediate Data Analyst CAD 72K-90KC# | Data Architecture | Data Governance | Data Modeling | Data SecurityMid-level Full TimeDartmouth, NS, Canada1d ago
-
Snowflake Database Administrator USD 100K-125K3NF | AWS | AWS Cross Account Access | Access Control | Apache AirflowConference and course support | Health benefits | Mental health care program | Paid time off | Parental leaveSenior-level Full TimeCanada; United States R7d ago
-
Database Administrator - Assistant Vice President CAD 94K-141KAWS | Apache Iceberg | Autonomous Database | Backup and Recovery | Big DataExecutive-level Full Time5900 HURONTARIO STREET MISSISSAUGA, Canada9d ago
-
Access Control | Backup and Recovery | Data encryption | Database replication | Database securitySenior-level Full TimeMontreal, QC10d ago
-
AWS | Amazon Aurora | Amazon Aurora MySQL | Amazon Redshift | Aurora MySQLCertification programs | Health insurance | Mentorship | Professional development opportunities | Relocation programSenior-level Full TimeEdmonton, AB, Canada R15d ago
-
AWS | Amazon Aurora | Amazon Aurora MySQL | Amazon Redshift | Aurora MySQLHealth insurance | Professional development programs | Relocation program | Remote workSenior-level Full TimeCalgary, AB, Canada R15d ago
-
AWS | Alerting | Amazon Aurora | Amazon Aurora MySQL | Amazon RedshiftHealth insurance | Relocation program | Work from anywhereSenior-level Full TimeToronto, ON, Canada R15d ago
-
Advanced Database Engineer CAD 83K-138KBackup monitoring | Business Suite | Database Administration | Database Migration | Database PatchingMid-level Full TimeCA Canada (ResMed Halifax)28d ago
-
Virtualisation, Storage & Backup Administrator CAD 86K-108KAzure Backup | Backup | Commvault | Database | Disaster RecoveryAnnual paid vacation | Comprehensive group insurance plan | Defined benefit pension plan | Inclusive workplace culture | MentorshipMid-level Full TimeMontréal1mo ago
-
Virtualization, Storage & Backup Administrator CAD 86K-108KAutomation | Azure Backup | Change Management | Commvault | Disaster RecoveryAnnual paid vacation | Comprehensive group insurance plan | Defined benefit pension plan | Inclusive workplace culture | Limited travelMid-level Full TimeOttawa1mo ago