D_Senior Azure MS SQL Server DBA / Senior Azure MS SQL Developer

<p><span><span><span><b><span><span><span>About the Job</span></span></span></b></span></span></span></p> <p><span><span><span><span><span><span>We are seeking a highly skilled and motivated Senior Azure MS SQL Server DBA or Senior Azure MS SQL Developer to join our team at Allianz. This role is essential for maintaining and optimizing our Azure SQL Server environments and developing robust data solutions. The successful candidate will have a strong background in SQL Server administration and development, with a focus on leveraging Azure technologies to enhance our data capabilities.</span></span></span></span></span></span></p> <p><span><span><span><b><span><span><span>Your Career</span></span></span></b></span></span></span></p> <ul> <li><span><span><span><span><span><span>Manage and optimize Azure SQL Server environments, ensuring high performance, availability, and security.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Develop and maintain T-SQL scripts, including stored procedures, functions, and queries, to support various business needs.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Review and optimize code written by other team members to ensure best practices and performance standards.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Design and implement data pipelines using Azure Data Factory or Azure Synapse Analytics, with a focus on automating database tasks and data integration.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Utilize SQLPackage (dacpac / Data-tier applications) for database deployment and management.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Develop and maintain PowerShell scripts for automation, including Azure modules and error handling.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Ensure compliance with internal standards, security concepts, and operational requirements.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Collaborate with cross-functional teams to design and implement data solutions that meet business requirements.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Provide mentorship and guidance to junior team members, fostering a culture of continuous improvement and excellence.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Stay up-to-date with the latest Azure and SQL Server technologies and best practices, advising on their implementation.</span></span></span></span></span></span></li> </ul> <p><span><span><span><b><span><span><span>Our Requirements</span></span></span></b></span></span></span></p> <ul> <li><span><span><span><span><span><span>Strong understanding of low-level SQL permissions based on SQL roles, including schema-level permissions assigned to roles.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Proficient in T-SQL, with experience in writing stored procedures, querying system tables, and conducting code reviews.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Experience with SQLPackage (dacpac / Data-tier applications) for database deployment and management.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Hands-on experience with Azure Data Factory or Azure Synapse Analytics, including designing pipelines and automating database tasks.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Proficient in PowerShell scripting, including general scripting, Azure modules, and error handling.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Proven experience in managing and optimizing Azure SQL Server environments.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Strong analytical and problem-solving skills.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Excellent communication and teamwork abilities.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Ability to work in a fast-paced, dynamic environment.</span></span></span></span></span></span></li> </ul> <p><span><span><span><b><span><span><span>Nice to Have</span></span></span></b></span></span></span></p> <ul> <li><span><span><span><span><span><span>Experience with Azure Dedicated SQL Pool and understanding of its limitations versus Azure SQL databases.</span></span></span></span></span></span></li> <li><span><span><span><span><span><span>Experience with GitHub