Job description

Responsibilities • Manage and maintain SQL Server instances across various environments, ensuring high availability, security, and performance. • Implement and support geoclustering solutions to achieve disaster recovery and business continuity objectives. • Monitor database performance, tuning SQL queries, and optimizing database configurations for improved efficiency. • Develop and implement automation scripts using PowerShell, Python, or similar tools to automate routine DBA tasks, deployment processes, and monitoring. • Handle table locks and concurrency issues effectively, ensuring minimal impact on production environments. • Plan and execute database migrations and upgrades, including transitioning on-premises databases to Azure cloud services. • Implement and manage SQL Server AlwaysOn Availability Groups for high availability and disaster recovery. • Utilize performance monitoring tools such as SQL Server Management Studio (SSMS), Azure Monitor, or third-party tools to proactively monitor and analyze database performance. • Collaborate with cross-functional teams to troubleshoot database-related issues and implement solutions promptly. • Develop and maintain documentation related to database configurations, processes, automation scripts, and procedures. • Implement and enforce database security best practices, ensuring compliance with organizational standards and regulations. • Participate in on-call rotations and respond to database incidents in a timely manner. Qualifications • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience). • Proven experience as a SQL Server DBA in a large-scale production environment, with a strong emphasis on operational tasks. • In-depth knowledge of SQL Server internals, including geoclustering, table locks, and concurrency management. • Experience in designing and implementing database backup and recovery strategies. • Proficiency in performance tuning, query optimization, and index management. • Hands-on experience with database migration tools and methodologies, particularly to Azure SQL Database or Azure SQL Managed Instance. • Strong scripting skills with PowerShell, Python, or similar languages for automation of DBA tasks and deployments. • Experience with performance monitoring tools and techniques to identify and resolve database performance issues. • Strong understanding of database security principles and best practices. • Excellent troubleshooting skills and the ability to resolve database issues under pressure. • Effective communication skills and the ability to collaborate with diverse teams. • Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) would be a plus.

Requirements