14 Aug
|
HCLTech
|
Alberta
Job Description: SQL Database Administrator (L3 – Cloud Focus)
Experience Level: Senior / Expert (L3)
Position Summary
We are seeking an L3-level SQL Database Administrator with advanced expertise in cloud database platforms. This role will architect, optimize, and lead SQL Server environments across Azure and AWS, driving cloud-first strategies, automation, and innovation. The ideal candidate will serve as the technical authority for cloud database solutions, guiding migrations, performance engineering, and advanced troubleshooting, while mentoring junior DBAs and collaborating with cross-functional teams.
Key Responsibilities
Architect and optimize cloud-based SQL Server deployments (Azure SQL Database, Managed Instances, AWS RDS) for scalability, reliability, and security.
Lead cloud migration projects: assessment, planning, execution, and post-migration optimization.
Design and implement advanced high-availability and disaster recovery solutions using cloud-native features (e.g., Azure Geo-Replication, AWS Multi-AZ).
Drive automation for provisioning, patching, monitoring, and backup in cloud environments using PowerShell, T-SQL, and cloud-native tools.
Evaluate and implement current cloud database technologies, services, and cost optimization strategies.
Act as the highest-level escalation for complex cloud database incidents, root cause analysis, and performance challenges.
Collaborate with architects, application owners, and infrastructure teams to align cloud database solutions with business goals.
Mentor and train L1/L2 DBAs on cloud database best practices and troubleshooting.
Ensure compliance with cloud security, audit, and regulatory requirements.
Set and maintain database standards
Performance tuning of database systems
Diagnose and troubleshoot database errors
Recommend and implement emerging database technologies
Create automation for repeating database tasks
Familiarity with SSAS, SSIS, SSRS
Be available for on-call support as needed.
Excellent written and verbal communication skills
Own documentation of cloud architectures, standards, and advanced troubleshooting guides.
Install, upgrade, and manage database, Instance ( SQL Server 2008,2012,2014,2016,2017)
Advanced knowledge of database security, backup and recovery, and performance monitoring standards
Good hand on Experience in establishing High Availability configurations including SQL Mirroring, SQL Clustering, Always-On Failover Clustering, Always-On Availability Groups, and log-shipping
Advantage if having experience in PowerShell scripting
Hands on experience on Azure / AWS related database service
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
Required Skills & Qualifications
10+ years of enterprise SQL DBA experience, with at least 3 years focused on cloud database platforms (Azure SQL, Managed Instances, AWS RDS).
Deep expertise in cloud database architecture, migration, automation, and performance engineering.
Strong experience with cloud-native backup, monitoring, and disaster recovery solutions.
Advanced proficiency in PowerShell, T-SQL, and cloud automation frameworks.
Proven track record in large-scale cloud migrations and optimization.
Excellent communication, leadership, and mentoring skills.
Preferred Certifications
Microsoft Certified: Azure Solutions Architect Expert
AWS Certified Database – Specialty
MCSA: SQL Server (2016 or later)
#J-18808-Ljbffr
📌 SQL Database Administrator (Alberta)
🏢 HCLTech
📍 Alberta