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 team15%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 DegreeExperience : 6+ yearsSkills : DB2 database administrationKnowledge of SQL,Bash scripting,JCL,Setup of DB2 HADR clustersPerformance 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 : SubversionLinux Tool : MobaXterm/PuttyDB2 Tool : SquirrelIDE : EclipseScripting Language : Shell, SQL, PerlMonitoring Tool : IBM Optim/Data Server ManagerRequest/Incident Tracking : Service Now, JiraDocumentation Tool : Wiki, ConfluenceAutomation Tool : RundeckAllianz 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.
