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
-
Active Directory | Citrix | Dynamics GP | ITIL | LinuxMid-level ContractToronto, Canada4h ago
-
Always On | Azure | Azure Data | Azure Data Lake | Azure SQLSenior-level ContractToronto, Canada4h ago
-
Desktop Administrator CAD 39K-49KActive Directory | App Volumes | Application packaging | Change Management | Desktop deploymentEmployer sponsored pension | Flexible work options | Health and dental coverage | Paid vacation | Professional learning and developmentMid-level Full TimeEdmonton, AB, CA1d ago
-
Always On | Azure | Azure Data | Azure Data Lake | Azure Dedicated SQL PoolPossible extension | Up to 5 days onsiteSenior-level Full TimeToronto, ON, Canada1d ago
-
Azure Administrator CAD 70K-80KAzure Backup | Azure CLI | Azure ExpressRoute | Azure Key Vault | Azure MonitorCommunity Day volunteering | Competitive vacation package | Corporate discounts | Defined contribution pension plan | Employee and family assistance programMid-level Full TimeBurnaby, British Columbia, Canada2d ago
-
Senior Systems Administrator CAD 103K-132KActive Directory | Ansible | Apache | Backup and Recovery | BashSenior-level Full TimeToronto, ON, CA2d ago
-
Change Management | Disaster Recovery | ITIL | Incident Management | MainframeRotational onsite workMid-level Full TimeToronto, ON, Canada3d ago
-
Senior Linux Administrator (DNS) CAD 101K-130KAWS | Alerting | Ansible | Anycast | BGP24/7 on-call rotation | Remote and in-office flexibilitySenior-level Full TimeOttawa, Ontario, Canada (Hybrid) R6d ago
-
Active Directory | Azure | Backup and Restore | Cybersecurity | DHCPAnti stress account | Career advancement | Cellphone provided | Dental insurance | DiscountsSenior-level Full TimeBoucherville, QC, Canada6d ago
-
NOC Operations Administrator I CAD 65K-92KAWS | Apache | Azure | Blackberry | DNSDental insurance | Disability insurance | Employee share purchase program | Life insurance | Medical insuranceMid-level Full TimeWaterloo, Ontario, Canada7d ago
-
Administrateur système et réseaux, TI CAD 65K-109KAccess Management | Backup and Restore | Backup solutions | Change Management | DevSecOpsCellphone allowance | Company provided cellphone | Electric vehicle charging | Employee assistance program | Employee recognition programMid-level Full TimeLongueuil, Québec, Canada7d ago
-
Technicien Administrateur Réseau CAD 82K-136KCisco | DHCP | DNS | Dell | FortinetEmployee stock purchase plan | Health insurance | On call availability allowance | Retirement plan contributions | Two days telework per weekSenior-level Full TimeMONTREAL-MARQUEZ TRANSTECH LTEE(CAN), MONTREAL, Canada8d ago
-
Systems Administrator III CAD 85K-113KAWS | Active Directory | Ansible | Azure | BackupRemote flexibility | Rotational on-callSenior-level Full TimeToronto Office, Canada8d ago
-
Sr. Systems Administrator CAD 89K-149KAnsible | Automation | Azure Stack | Azure Stack HCI | Best practicesSenior-level Full TimeMississauga, ON, CAN - 2300 Meadowvale …9d ago
-
Automation | Azure Database | Azure Database for PostgreSQL | Azure SQL | Backup and RecoveryEmployee assistance program | Health insurance | Paid Holidays | Paid sick days | Paid vacationSenior-level Full TimeHôpital général juif11d ago
-
Power BI and Network Systems Administrator CAD 54K-72KAD Group Policy | Active Directory | Azure AD | Azure AD Group Policy | Azure Active DirectoryEFAP | Medical and dental benefits | RRSP matchingMid-level Full TimeLeduc, AB, T9E 0C3, CA11d ago
-
Access Management | Ansible | Azure AD | Bash | Configuration ManagementHealth insurance | Hybrid work | Paid time off | REER Retirement Plan | Wellness programsSenior-level Full TimeMontréal, Québec, Canada12d ago
-
Access Management | Cloud Migration | Cloud Security | Hybrid Cloud | ISO27001Mid-level Full TimeRive-Sud de Montréal, Canada12d ago
-
Active Directory | Apache | Backup and Recovery | CDN | DFSHealth benefits | Hybrid work | Paid vacationMid-level Full TimeToronto, ON, Canada12d ago
-
Mid-level Full TimeMontreal, QC, Canada12d ago
-
Administrateur ou administratrice de systèmes CAD 65K-109KAmazon Web Services | CI/CD | Configuration Management | Docker | GitLabInclusive workplace | On-call rotation compensationMid-level Full TimeMontreal, QC, Canada12d ago
-
Senior System Administrator CAD 90K-103KActive Directory | Ansible | Azure Monitor | Bash | Centralized LoggingBonus | Career development | Dental insurance | Flexible work schedule | Health insuranceSenior-level Full TimeMississauga, ON, Canada12d ago
-
System Administrator CAD 71K-86KAccess Management | Active Directory | Alerting | Ansible | AutomationCareer development | Dental insurance | Flexible schedule | Health insurance | Paid time offMid-level Full TimeMississauga, ON, Canada12d ago
-
Sr. Device Administrator CAD 73K-100KAndroid | Bash | C# | Cloud Migration | Dell Deployment ToolkitCareer growth | Comprehensive rewards program | Donation matching | Health and wellness benefits | On-site work flexibilitySenior-level Full TimeToronto, Canada12d ago
-
Sr. Database Administrator - Oracle CAD 66K-85KAnsible | Database Administration | Database migrations | Database performance | Database performance tuningDefined benefit pension plan | Employee recognition program | Employee share purchase plan | Paid time off for professional growth | Vacation offeringSenior-level Full TimeToronto-81 Bay, 16th Floor, Canada12d ago