Database Administrator, Principal

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 youll 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 well 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 practices
• Highly proficient in Python, PowerShell or C# for automation and scripting tasks
• Extensive experience in T-SQL and SQL
• Experience 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.