Database Administrator (10-month Contract)
Vancouver, British Columbia, Canada
CAD 84K-109K (estimate) Mid-level Contract
Tasks
- Administer Windows Server and manage patching
- Administer database security users roles and permissions
- Automate tasks using T SQL scripts and SQL Agent jobs
- Conduct root cause analysis for outages and performance issues
- Configure ODBC clients and HAProxy
- Configure SQL Server AlwaysOn availability groups and failover clustering
- Develop and maintain SSIS packages and SSRS reports
- Install, configure and maintain SQL server instances
- Manage SQL Server environments in production QA and development
- Manage Windows Firewall rules and VPN access
- Manage backup restore and point in time recovery
- Monitor OS metrics using Perfmon
- Monitor and rightsize infrastructure using CloudWatch and NewRelic
- Optimize database performance using query optimization index tuning and execution plan analysis
- Perform capacity planning forecasting and performance tuning
- Troubleshoot connectivity and network issues including TCP IP DNS and hostname
- Use PowerShell scripting for automation
Perks/Benefits
Skills/Tech-stack
AWS IAM | AWS RDS | AlwaysOn Availability | AlwaysOn availability groups | Amazon DynamoDB | Amazon EC2 | Amazon S3 | Availability Groups | CloudWatch | DNS | Failover Clustering | HAProxy | NewRelic | ODBC | PerfMon | Performance Monitor | Powershell | SQL Agent | SQL Server | SSIS | SSM RunCommand | SSRS | T-SQL | TCP/IP | VPN | Windows Firewall | Windows server
Education
N/A
Regions
Countries
States
Related jobs
-
Database Administrator (10-month Contract) CAD 84K-108KAWS | AWS IAM | AWS Systems Manager | AWS systems | Amazon DynamoDBRemote interview for first stageMid-level ContractVancouver, British Columbia, Canada4d ago
-
Active Directory | Agile | Artificial Intelligence | Data Integrity | Hardware TroubleshootingHealth, dental, vision benefits | Pension plan | Tuition waiver program | VacationEntry-level Full TimeMain Campus (Employees), Canada9d ago
-
Advanced Database Engineer CAD 83K-138KBackup monitoring | Business Suite | Database Administration | Database Migration | Database PatchingMid-level Full TimeCA Canada (ResMed Halifax)9d ago
-
Manager, Relational Databases CAD 90K-140KAWS RDS | Agile methodology | Capacity Planning | Database Administration | Development Life CycleHybrid work model | Inclusive culture | Pension plan | Professional development | Savings planMid-level Full TimeSun Life Toronto Atria, Canada11d ago
-
Manager, Relational Databases CAD 90K-140KAWS RDS | Agile methodologies | Capacity Planning | Cloud Computing | Database AdministrationHybrid work model | Pension | Professional development | Savings programs | Stock programsMid-level Full TimeSun Life Toronto Atria, Canada11d ago
-
Virtiualisation, Storage & Backup Administrator CAD 86K-108KAzure Backup | Backup and Recovery | Commvault | Database Administration | Disaster RecoveryAnnual paid vacation | Comprehensive group insurance plan | Defined benefit pension plan | Inclusive workplace culture | Training and mentorshipMid-level Full TimeMontréal17d ago
-
Ansible | Azure Backup | Azure CLI | Azure SQL | BackupAnnual paid vacation | Defined benefit pension plan | Group insurance plan | Inclusive workplace culture | Standby and call back paySenior-level Full TimeMontréal17d 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éal17d ago
-
Ansible | Automation | Azure Backup | Azure CLI | Azure SQLAnnual paid vacation | Defined benefit pension plan | Group insurance plan | Training and mentorshipSenior-level Full TimeOttawa17d 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 TimeOttawa17d ago
-
Manager, Data Architecture & Application Services CAD 122K-153KBI Publisher | Change Management | Commvault | Crystal Reports | Data GovernanceComprehensive health benefits | Compressed work week | Employee assistance program | Employee discounts | Flexible work arrangementsSenior-level Full TimeTown Hall, Canada21d ago
-
Technical Services Engineer, Named Accounts CAD 115K-160KActive Directory | Alerting | Amazon Web Services | Application Performance Analysis | Application performanceSenior-level Full TimeVancouver1mo ago
-
Database Administrator CAD 80K-100KAutomation frameworks | Database normalization | ETL | Indexing | MariaDBBenefits package | Flexible work schedule | Performance bonusMid-level Full TimeToronto, Ontario, Canada (Hybrid) R1mo ago
-
Cloud Database Administrator CAD 99K-136KAWS RDS | Backup and Recovery | Cloud Database | Cloud Database Management | Database ManagementHealth benefits | Paid time offSenior-level Full TimeToronto, Canada1mo ago