Database Administrator

WilsonHCG

  • Canada
  • Contract
  • Full-time
  • 2 months ago
Description and RequirementsWork Type: OnsitePosition Type: ContractLocation: Calgary, ABCompensation Range: $53 - $59 (Per Hour)Our client, a multinational technology company specializing in information technology services and consulting, is seeking a " Database Administrator"The position is responsible forResponsibilities:1. Ability to perform day to day database administration tasks with deep understanding of SQL Server internals e.g. Indexing, partitioning , filestream , Always-On , replication cctv and Mirroring technologies. 2. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.3. Expert in T-SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and Data Transform Services (DTS).4. Expert in Log shipping with SQL Server 2012/2008 R2.5. Expert in setting up Snapshot and Transactional Replication6. Experience in Power shell Scripting, Partitioning7. Experience in designing databases, creating tables, views, stored procedures and Triggers.8. Worked on disaster recovery plans and Developed backup and recovery strategies for production environment9. Knowledge in data encryption10. Knowledge of relational databases, T-SQL, query execution plans, solving concurrency issues and deadlocks11. Troubleshoot and provide advice on SQL Server performance issues and be able to work with application development teams and provide recommendations.12. Strong Knowledge of administrating Azure-SQL databases.13. Good communication skill and experience to handle P1/P2 outages.14. MSSQL DBA Certification will be added advantage.15. Knowledge on the Use of Azure Monitor, Log Analytics, and Azure Automation & Integration with PowerShell and Azure CLI will be an added advantageQualifications:Primary Skill Set
  • MSSQL Database Administrator
  • Performance tuning (e.g., indexing strategies, query optimization)
  • High availability and disaster recovery (e.g., Always On Availability Groups, log shipping)
  • T-SQL and scripting expert
  • Worked on Azure environment
Automation with SQL Server AgentSecondary Skill Set
  • Backup and recovery
  • Security and permissions
  • Monitoring and alerts
  • Database design and normalization
All interested applicants who meet the qualifications listed above are invited to submit a resume by clicking "Apply Now".The indicated pay range for this position is a good-faith estimate based on the qualifications necessary for the position, including experience, training, and other considerations permitted by law. Additionally, it is emphasized that the pay band mentioned herein is the one established by the client company. Factors that may be used when making an offer may include a candidate's skills, experience and geographic location, the expected quality and quantity of work. Most candidates will start at the bottom half of the pay range, with the upper end reserved for candidates with extensive experience and skills and who live in geographic markets commanding a higher starting pay. An employee's pay history will not be a contributing factor where prohibited by local law.This information is subject to change and serves as a general guideline for compensation discussions. Actual offers may vary based on specific circumstances and company policies.

WilsonHCG