SQL Engineer

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