What are the responsibilities and job description for the Senior IT Database Developer position at Allianz?
Contribute to the managing of SQL database servers, data integration and data related systems taking into account access, storage, performance and maintenance needs for current and future solutions. Must understand database management systems, and their underlying technology.
What you do
- Strong proficiency in T-SQL, including stored procedures, triggers, indexing, and query optimization.
- Experience with database design principles, normalization, and unit testing.
- Familiarity with DevOps practices, including CI / CD pipelines for database deployment.
- Design, develop, and optimize complex SQL queries, stored procedures, and database scripts for high-volume transactional systems.
- Collaborate with web developers, data analysts, and IT teams to ensure database solutions meet business requirements.
- Ensure data integrity, security, and high availability across on-premise and cloud-based systems.
- Troubleshoot and resolve database performance and security issues.
- Senior SQL DBA who supports all aspects of Microsoft SQL Server including tools, processes, and servers.
- Candidate will be responsible for building new SQL Servers as well as perform routine patching.
- He / she will also be a key contributor in recommending, designing and implementing new / complementing technologies.
- Utilizing his / her knowledge for troubleshooting high visibility issues as well as recommending improvements within the environment.
- Will work with project and agile teams to upgrade / enhance the SQL environment according to their needs. Supports SQL Server, SSIS, and Power BI.
- Maintain understanding of the data operating system environment, system utilities, debugging tools and monitoring tools. Also understand the underlying technology architecture and how it affects database code.
- Evaluate and recommend database software and tools for potential acquisition.
- Improve and advocate for adherence to corporate database standards, procedures, and policies for all database platforms.
- Understand current database technologies, strategic database technologies and data management principles and techniques.
- Work with other business areas to actively solve issues and recommend solutions.
What you bring
Locations
What we offer
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 12,000 employees located in 51 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. You.IT
Nearest Major Market : Minneapolis
Salary : $120,000 - $160,000
