About the Job 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. Your Career · Manage and optimize Azure SQL Server environments, ensuring high performance, availability, and security. · Develop and maintain T-SQL scripts, including stored procedures, functions, and queries, to support various business needs. · Review and optimize code written by other team members to ensure best practices and performance standards. · Design and implement data pipelines using Azure Data Factory or Azure Synapse Analytics, with a focus on automating database tasks and data integration. · Utilize SQLPackage (dacpac / Data-tier applications) for database deployment and management. · Develop and maintain PowerShell scripts for automation, including Azure modules and error handling. · Ensure compliance with internal standards, security concepts, and operational requirements. · Collaborate with cross-functional teams to design and implement data solutions that meet business requirements. · Provide mentorship and guidance to junior team members, fostering a culture of continuous improvement and excellence. · Stay up-to-date with the latest Azure and SQL Server technologies and best practices, advising on their implementation. Our Requirements · Strong understanding of low-level SQL permissions based on SQL roles, including schema-level permissions assigned to roles. · Proficient in T-SQL, with experience in writing stored procedures, querying system tables, and conducting code reviews. · Experience with SQLPackage (dacpac / Data-tier applications) for database deployment and management. · Hands-on experience with Azure Data Factory or Azure Synapse Analytics, including designing pipelines and automating database tasks. · Proficient in PowerShell scripting, including general scripting, Azure modules, and error handling. · Proven experience in managing and optimizing Azure SQL Server environments. · Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field. · Strong analytical and problem-solving skills. · Excellent communication and teamwork abilities. · Ability to work in a fast-paced, dynamic environment. Nice to Have · Experience with Azure Dedicated SQL Pool and understanding of its limitations versus Azure SQL databases. · Experience with GitHub and GitHub actions/workflows. Technology Stack · Azure Synapse Analytics & Dedicated SQL Pools · Azure · PowerShell · Azure Data Factory · Entra Join our team at Allianz and play a key role in developing and maintaining high-quality data solutions that drive our business forward. Apply today and take the next step in your career! About Allianz Technology Allianz Technology is the global IT service provider for Allianz and delivers IT solutions that drive the digitalization of the Group. With more than 13,000 employees located in 22 countries around the globe, Allianz Technology works together with other Allianz entities in pioneering the digitalization of the financial services industry. We oversee the full digitalization spectrum – from one of the industry’s largest IT infrastructure projects that includes data centers, networking, and security, to application platforms that span from workplace services to digital interaction. In short, we deliver full-scale, end-to-end IT solutions for Allianz in the digital age. D&I statement Allianz Technology is proud to be an equal opportunity employer encouraging diversity in the working environment. We are interested in your strengths and experience. We welcome all applications from all people regardless of gender identity and/or expression, sexual orientation, race or ethnicity, age, nationality, religion, disability, or philosophy of life. Join us. Let´s care for tomorrow. 57567 | IT & Tech Engineering | Professional | Non-Executive | Allianz Technology | Full-Time | Permanent