System Specilaist _684

Job Level:  Professional
Location: 

Pune, MH, IN

Area of Expertise:  IT & Tech Engineering
Unit:  Allianz Technology
Employing Entity:  Allianz Technology SE India Branch
Job Type:  Full-Time
Remote Job:  Hybrid working
Employment Type:  Permanent
ID:  80529
Position Cluster:  Non-Executive

PART 2

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

 

 

A key role within the Allianz Business System (ABS) which deals with the Database Administration responsibilities starting from the basic database health check to the advanced level tasks like DB2 migrations, installations and support.

 

Responsibilities:

 

  • Database Object Management & Administration
  • Guiding the team in all technical blockers and timely coordination to achieve appropriate solutions
  • Execution of DML queries requested by Project team
  • Perform ABS Version migration on all environments
  • Analysis of failures in Batch jobs
  • Performance monitoring & fine tuning
  • Troubleshooting issues related to DB2,HADR
  • IBM DB2 version upgrade activities
  • Adhoc Restore and Cleanup activities
  • Golive & Major release support
  • Management of DB2 housekeeping scripts

100%

 

 

PART 3

Duties and Responsibilities

List in order of importance and state approximate weightage accorded to each.

 

 

Understanding the requirement from each Customers and setting up the database environment as per the design. Leading and coordinating the various Database Project Activities like – DB2 Database Build, Instance Creation, Database Object Creations and also providing guidance to the team

 

 

15%

 

Database Operational Activities like – Support to Data Migrations , ABS Version Migrations, Cleanups,DB2 Upgrades, Support for RHEL Migrations, Performance Tuning.

Setup of DB2 HA clusters and maintenance.

10%

 

Analyse/Troubleshoot issues which includes the Batch Job failures, DB connectivity/access errors and co-ordinate with other support teams for resolution.

 

15%

 

Setup of the various DB Monitoring Tools/Front End Databases.

10%

Study and Documentation of all the newly implemented technologies/changes (process/technical)

10%

Identify areas of improvement and implement those ideas. Ensure that knowledge is shared with peers for all new implementations. Act as SPOC for projects to share updates, be available for meetings understanding the requirements in details and support the team if required for new projects.

 

15%

Responsible for technically leading the team. Collating data and providing status updates to Team lead as and when required. Supporting TL in review or appraisal process. Be accountable for all technical issues and finding solutions for the same.

Technically guide team in RCA handling, Mentoring/training, Decision making on Technical level, Production Support, OE Onboarding.

15%

Follow all the ITIL practices applicable for the various processes involved.

5%

Information Security Responsibilities:

 

All employees are expected to adhere to the Information Security policies day in and day out.
• Report any ISMS events / incidents as per the reporting procedures.
• Shall be aware of all ISMS principles and guidelines

 

5%

 

 


 

PART 5

Qualification, Experience and Skills

 

 

Qualification : Any Bachelor Degree

Experience   : 6+ years

Skills             : DB2 database administration

                       Knowledge of SQL,

                       Bash scripting,

                      JCL,

                      Setup of DB2 HADR clusters

                      Performance tuning & query optimization

 

Key-Skills       

  • DB2     
  • Scripting - Shell/Perl     
  • Linux Intermediate knowledge   
  • JCL basics                   

 

Process Skills

  • DB setup/maintenance 
  • Production Support       
  • Incident handling & RCA           
  • Change handling          
  • Problem handling         
  • Version Upgrades                     

 

Application Expertise 

  • Eclipse 
  • Optim/DSM      
  • Service Now     
  • Rundeck          
  • Putty   
  • Jira      

 

Soft-Skills       

  • Communication Skill (Speaking, Email)  
  • Documentation Skills    
  • Technical Coordination 
  • Relationship Managemen
  • Having a basic understanding or exposure to AI tools would be a plus.Familiarity with basic AI tools is considered an advantage.Basic knowledge or experience with AI tools will be beneficial.Exposure to AI tools, even at a basic level, is a value-add.A fundamental grasp of AI tools will be an added benefit.

 

 

PART 6

Key Competencies

 

Repository : Subversion

Linux Tool : MobaXterm/Putty

DB2 Tool : Squirrel

IDE : Eclipse

Scripting Language : Shell, SQL, Perl

Monitoring Tool : IBM Optim/Data Server Manager

Request/Incident Tracking : Service Now, Jira

Documentation Tool : Wiki, Confluence

Automation Tool : Rundeck

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. Together we can build an environment where everyone feels empowered and has the confidence to explore, to grow and to shape a better future for our customers and the world around us. 
We at Allianz believe in a diverse and inclusive workforce and are proud to be an equal opportunity employer. We encourage you to bring your whole self to work, no matter where you are from, what you look like, who you love or what you believe in.
We therefore welcome applications regardless of ethnicity or cultural background, age, gender, nationality, religion, disability or sexual orientation.
Join us. Let's care for tomorrow.
Note: Diversity of minds is an integral part of Allianz’ company culture. One means to achieve diverse teams is a regular rotation of Allianz Executive employees across functions, Allianz entities and geographies. Therefore, the company encourages its employees to have motivation in gaining varied skills from different positions and to collect experiences from across Allianz Group.