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
-
Virtual Infrastructure & Storage Administrator USD 80K-128KBatch scripting | Cisco ACI | Cisco HyperFlex | Cisco Nexus | Cisco UCSSenior-level Full TimeAPO, AE, United States2d 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, CA13d 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, Canada14d ago
-
Technical Services Engineer, Named Accounts CAD 115K-160KActive Directory | Alerting | Amazon Web Services | Application Performance Analysis | Application performanceSenior-level Full TimeVancouver14d ago
-
Cloud Database Administrator (DBA) CAD 114K-143KAnsible | Bash | CI/CD | Data Migration | Database monitoringEmployee assistance program | Employee discounts home auto gym | Extended health/dental coverage | Holiday pay | Hybrid workSenior-level Full TimeOttawa 20 Colonnade, Canada22d ago
-
Senior DataOps Developer USD 150K-250KAWS RDS | Data Migration | Database performance | Database performance tuning | Database replicationMedical/Dental/Vision insurance | Paid parental leave | Paid time off | Professional growth opportunities | Retirement planSenior-level Full TimeCanada (Remote) R23d ago
-
Database Administrator CAD 80K-100KAutomation frameworks | Database normalization | ETL | Indexing | MariaDBBenefits package | Flexible work schedule | Performance bonusMid-level Full TimeToronto, Ontario, Canada (Hybrid) R29d 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
-
Senior Database Administrator MSSQL CAD 91K-136K2016 | 2017 | 2019 | Active Directory | AutomationBonuses | Community programs | Diversity and inclusion | Flexible vacation | Upskilling opportunitiesSenior-level Full TimeToronto, ON, CA, M5V2T31mo ago