Job description

We are seeking an experienced SQL Server Database Administrator (DBA) who possesses a strong background in On-Premises SQL administration, PowerShell automation, Azure Infrastructure as a Service (IaaS), and cloud migration to join our team. As a Principal SQL Server DBA, you will play a crucial role in managing and maintaining our organization's SQL Server databases for our various products and services, ensuring their optimal performance, security, and availability. You will be a thought leader who will influence key stakeholders in adopting industry best practices, bring innovative ideas and be a subject matter expert.What you’ll be doing:Database Management: Install, configure, and upgrade SQL Server instances (on-premises and Azure IaaS); create and maintain database objects; monitor and optimize performance; implement security; perform backups and disaster recovery; troubleshoot issues; maintain documentation.Cloud Migration: Develop and execute cloud migration strategies; assess and determine migration approaches; plan and coordinate migration processes; ensure smooth migration with minimal downtime; validate and test migrated databases.Azure Integration: Deploy and manage SQL Server databases in Azure IaaS; utilize Azure features for data storage and integration; implement and manage Azure SQL Database features; monitor and optimize performance.Automation: Develop PowerShell scripts for database administration tasks; use PowerShell to interact with SQL Server and Azure resources; schedule PowerShell jobs for recurring tasks.Performance Optimization and Troubleshooting: Optimize query performance and server configuration; monitor and analyze database performance; resolve incidents; provide on-call support during critical windows.Technical Leadership: Mentor and coach team members; lead design and implementation of programs; represent the team in technical discussions; influence technical roadmap and strategy for SQL Server infrastructure.What we’ll want you to have:Proven experience (minimum 8+ years) as a SQL Server Database Administrator, with expertise in On-premises SQL, PowerShell automation, Azure IaaS, and cloud migration.Strong knowledge of SQL Server database administration, including installation, configuration, backup and recovery, security, and performance tuning.Experience with Azure SQL Database and Azure SQL Managed Instance in an Azure IaaS environment.Strong knowledge and understanding of SDLC, CI/CD practicesHighly proficient in Python, PowerShell or C# for automation and scripting tasksExtensive experience in T-SQL and SQLExperience in database engineering/ software engineering.Experience in technical leadership of small, focused teams to deliver projects.Experience using tools like SQL Sentry, Azure monitors etc. to monitor performance.Understanding of database performance monitoring and tuning techniques.Experience with Azure Infrastructure as a Service (IaaS) and managing SQL Server databases on Azure virtual machines.Proven track record of successful cloud migration projects, including assessing, planning, and executing migrations from on-premises to the cloud.Excellent problem-solving skills, big picture thinking and ability to troubleshoot complex database issues.Effective communication and collaboration skills to work effectively with cross-functional teams.Able to work flexible hours as required by business priorities Able to deliver work that meets quality, security and operability standards.

Requirements