Technical Lead - Database Admin SQL,DB2 _2942-
Pune, MH, IN
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 projects
- Maintenance 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 Environment
- Experience 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 Degree
- Prior Experience in Databases Administration
- Datacentre migration & support related roles
- Working in L3 Roles in a global delivery team model
- Microsoft DB2 and SQL certifications
Key Competencies
4.1 Technical (Must Have)
- Extensive knowledge on the following technologies:
- Microsoft SQL
- Always on SQL
- Cloud Knowledge (AWS)
- DB2
- Performance Tuning of applications from a database perspective
- Windows Knowledge desirable
- Powershell scripting
- Ability to troubleshoot third party applications
- Assists others in resolving complex technical problems and investigating the root cause of problems and recommends smart (specific, measurable, achievable, realistic, timely) solutions
- Provides 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 driven
- Good Market Insight & contribute towards driving change & Innovation
- Fostering Relationships with stakeholders, customers & peers
- Excellent 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.
