Technical Lead - Database Admin SQL,DB2 _2942-

About This Job

Allianz Commercial

Location: Pune, Maharashtra, India

Work Mode: On-site

Employment Type: Full Time

Industry: Insurance

Job Description

This job is with Allianz Commercial, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.

Job Description - Database L3 Expert

Overall Objectives of Job: (If multiple sections, accord weightage to each section)

The candidate would be responsible for technical deliveries, which include environment build, maintain the environment in operation condition. You define the architecture evolution of DB2 /SQL servers Databases.

Duties and Responsibilities

Work closely with project managers and technical teams for planned system upgrades, server roll out, application upgrades, changes, releases and run the business tasks.Provide specialist assistance and input to various key technical projectsMaintenance and proactive monitoring of DB2 and SQL Databases across environments. Ensure Implementation processes and procedures are developed, implemented and followed for various activities with respect to Middleware Infrastructure Projects.Proper documentation of various implementation procedures for system and application upgrades before handing over the systems to the Operations team.Work with the business and development teams to plan, manage and implement various changes in the pre-production Middleware EnvironmentExperience with interacting with customers, senior managers, and customers, to handle service inquiries and problems.Develop automation tools by writing/modifying scripts for deployment, maintenance and system monitoring using Linux shell scripts, Python, Perl, and other scripting languages.Plan, document, review and maintain system administrations guidelines and policies.Experience in backend solution, day to day system admin and monitoring, file system management and disk management and creation of shell scripts for the automation of tasks and the extraction of logs.Update operations and maintenance documentation for 24/7/365 personnel. Support operations across multiple geographic locations.Develop solutions to complex technical issues.Provide follow-up reports (technical findings, feedback, resolution steps taken) for Root Cause analysis, engineering technical assessment and process improvement initiatives

Qualification, Experience, Technical And Functional Skills

Bachelor's DegreePrior Experience in Databases AdministrationDatacentre migration & support related rolesWorking in L3 Roles in a global delivery team modelMicrosoft DB2 and SQL certifications

Key Competencies

4.1 Technical (Must Have)

Extensive Knowledge On The Following Technologies

Microsoft SQLAlways on SQL Cloud Knowledge (AWS) DB2Performance Tuning of applications from a database perspectiveWindows Knowledge desirablePowershell scripting Ability to troubleshoot third party applicationsAssists others in resolving complex technical problems and investigating the root cause of problems and recommends smart (specific, measurable, achievable, realistic, timely) solutionsProvides deep specialist consultancy, guidance and support in their specific specialism. Works with other Technical Specialists/analysts as required and ensures any solution within their specific specialism fits with strategic and technical direction

Technical Skills (Desirable)PostgreSQL

Soft Skills

Result Oriented & customer focus drivenGood Market Insight & contribute towards driving change & InnovationFostering Relationships with stakeholders, customers & peersExcellent communication skills (Verbal & Written)Excellent Team player, flexible and adaptable

Allianz Group is one of the most trusted insurance and asset management companies in the world. Caring for our employees, their ambitions, dreams and challenges is what makes us a unique employer. We are united by a shared commitment: to put our customers first and at the center of everything we do. Their needs inspire our thinking and guide our actions. Together, we can build an environment where everyone feels empowered and confident to explore, grow and shape a better future - for our customers and for the world around us.

At Allianz, we stand for unity: we believe that a united world is a more prosperous world, and we are dedicated to consistently advocating for equal opportunities for all. The foundation for this is our inclusive workplace, where people and performance both matter, and where integrity, fairness, inclusion and trust are at the heart of our culture. We therefore welcome applications regardless of race, ethnicity or cultural background, age, gender, nationality, religion, social class, disability or sexual orientation, or any other characteristics protected under applicable local laws and regulations.

Join us. Let's care for tomorrow.

Note: Having different strengths, experiences, perspectives and approaches is an integral part of Allianz' company culture. One means to achieve this is a regular rotation of Allianz employees across functions, Allianz entities and geographies. Therefore, Allianz expects from its employees a general openness and a high motivation to regularly change positions and collect experiences across Allianz Group.