SQL DBA

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