filter salaries All Filters (1)

Clear all

23 Performance Monitoring Jobs in Ahmedabad

DB2 Database Administrator

4-8 years

Ahmedabad

DB2 Database Administrator

IBM

posted 18d ago

Job Description

As a Database Administrator: RDBMS, you are responsible for developing application designs and providing regular support/guidance to project teams on complex coding, issue resolution, and execution.

Your primary responsibilities include:

1. Lead the design and construction of new mobile solutions using the latest technologies, always looking to add business value and meet user requirements.

2. Strive for continuous improvements by testing the build solution and working under an agile framework.

3. Discover and implement the latest technologies and trends to maximize and build creative solutions.

4. Run multiple production DB2 databases with High Availability (HA) and Disaster Recovery (DR) enabled across data centres.

5. Troubleshoot DB slowness and disk/Memory/CPU utilisation and suggest resolutions.

6. Troubleshoot CDC and SQL replication issues.

7. Participate in PagerDuty On-Call rotation.

8. Perform database patches and upgrades without downtime.

9. Linux Red Hat System Administration.

10. Ensure technical modifications do not adversely affect database integrity, stability, and availability.

11. Implement solutions for DB2 database backup and recovery infrastructure.

12. Monitor/maintain/upgrade the DB2 database and assist the application team with performance-tuning initiatives and builds.

13. Assisted in backup and recovery operations, including disaster recovery planning.

14. Ability to design, build and address Continuous Improvement Culture across the environment.

15. Perform database patches and upgrades, avoiding disruption of availability.

16. DBA On-Call: Respond to, diagnose, and resolve DBA pages, including but not limited to Replication failuresCDC and SQL replication (DPROP), disk space thresholds and shortages, system connectivity issues, system issues, DB crashes, DB performance issues, DB Lock issues, and other DB/System failures, i.e., DB2 backup.


Required education
Bachelor's Degree
Preferred education
Master's Degree
Required technical and professional expertise

1. Mandatory Skills: LUW/Unix DB2 DBA , Shell Scripting, Linux and AIX knowledge

2. Secondary Skills: Physical DB2 DBA skills, PL/SQL Knowledge and exposure

3. Expert knowledge of IBM DB2 V11.5 installations and configurations administration in Linux /AIX systems.

4. Expert-level knowledge in Database restores, including redirected restore backup concepts.

5. Excellent understanding of database performance monitoring techniques, fine-tuning and ability to perform performance checks query optimization

6. Proven experience in DB2 Database Administration.

7. Strong understanding of DB2 database architecture and design.

8. Experience with High Availability (HA) and Disaster Recovery (DR) solutions.

9. Proficiency in Linux Red Hat System Administration.

10. Strong problem-solving skills and ability to troubleshoot complex database issues.

11. Experience with CDC and SQL replication.

12. Ability to perform database patches and upgrades without downtime.

13. Experience with database backup and recovery infrastructure.

14. Strong communication skills and ability to work with application teams for performance tuning.


Preferred technical and professional experience

1. Good knowledge of utilities like import, load export under high volume conditions.

2. Ability to tune SQLs using db2advisor db2explain, as well as, ability to troubleshoot database issues using db2diag, db2pd, db2dart, db2top tec.

3. Ability to work in a Continuous Improvement Culture.

4. Strong issue resolution skills and ability to escalate and obtain necessary resources.

5. Experience acting as a resource for Application Support teams.



Employment Type: Full Time, Permanent

Read full job description

Prepare for DB2 Database Administrator roles with real interview advice

What people at IBM are saying

4.5
 Rating based on 23 DB2 Database Administrator reviews

Likes

Good with all infrastructure and worl culture

  • Salary - Good
  • +6 more
Dislikes

None according to me , as I don't

Read 23 DB2 Database Administrator reviews

DB2 Database Administrator salary at IBM

reported by 175 employees with 2-10 years exp.
Lock Unlock
₹9.3 L/yr - ₹23 L/yr
53% more than the average DB2 Database Administrator Salary in India
View more details

Compare IBM with

Oracle

3.7
Compare

TCS

3.7
Compare

Cognizant

3.7
Compare

Accenture

3.8
Compare

Infosys

3.6
Compare

Capgemini

3.7
Compare

Wipro

3.7
Compare

Deloitte

3.8
Compare

Google

4.4
Compare

Amazon

4.1
Compare

Amdocs

3.7
Compare

SAP

4.2
Compare

Microsoft Corporation

4.0
Compare

Tech Mahindra

3.5
Compare

PwC

3.4
Compare

Ernst & Young

3.4
Compare

Nagarro

4.0
Compare

NetApp

3.9
Compare

Salesforce

4.0
Compare

SAS

4.4
Compare

Similar Jobs for you

DB2 Database Administrator at Infosys Limited

Hyderabad / Secunderabad

3-5 Yrs

₹ 5-7 LPA

DB2 Database Administrator at Capgemini Technology Services India Limited

Bangalore / Bengaluru

6-11 Yrs

₹ 8-14 LPA

Application Database Administrator at IBM India Pvt. Limited

Bangalore / Bengaluru

3-6 Yrs

₹ 5-9 LPA

Technical Support Professional at IBM India Pvt. Limited

Pune

2-7 Yrs

₹ 4-7 LPA

Support Professional at IBM India Pvt. Limited

Pune

4-7 Yrs

₹ 6-10 LPA

Database Administrator DBA at Datatex

Bangalore / Bengaluru

5-10 Yrs

₹ 8-12 LPA

Application Database Administrator at IBM India Pvt. Limited

Bangalore / Bengaluru

3-6 Yrs

₹ 5-9 LPA

Database Admin at Accenture Solutions Pvt Ltd

Indore

3-8 Yrs

₹ 5-10 LPA

Database Admin at Accenture Solutions Pvt Ltd

Gurgaon / Gurugram

5-10 Yrs

₹ 7-12 LPA

SQL Database Administrator at Dexian India Technologies

Chennai

3-8 Yrs

₹ 5-10 LPA

4-8 Yrs

Ahmedabad

18d ago·via naukri.com

Assistant Manager

SP Capital IQ (India) Pvt. Ltd

2-3 Yrs

Ahmedabad

27d ago·via naukri.com

Site QA / QC Engineer

L&T Integrated Engineering Services

1-5 Yrs

Jamnagar, Ahmedabad, Rajkot +2 more

8d ago·via naukri.com

2-4 Yrs

Jamnagar, Ahmedabad, Rajkot +2 more

8d ago·via naukri.com

Warehouse Manager

PON PURE CHEMICAL INDIA PRIVATE LIMITED

3-5 Yrs

Ahmedabad

13hr ago·via naukri.com

S2RL Consultant

Infosys Technologies ltd

2-5 Yrs

Ahmedabad

1mon ago·via naukri.com

15-21 Yrs

Ahmedabad

13d ago·via naukri.com

5-10 Yrs

Ahmedabad

14d ago·via naukri.com

4-7 Yrs

Ahmedabad

28d ago·via naukri.com

Dot Net FS React, Azure React Lead

Harman Connected Services Corporation India Pvt.

5-9 Yrs

Hyderabad / Secunderabad, Ahmedabad, Bangalore / Bengaluru

3mon ago·via naukri.com
How was your last interview experience?

Recently Viewed

JOBS

Dalmia Cement East

No Jobs

JOBS

PNC Infratech

No Jobs

JOBS

Schneider Electric

No Jobs

JOBS

PNC Infratech

No Jobs

REVIEWS

Aarvee Associates

No Reviews

REVIEWS

Aarvee Associates

No Reviews

REVIEWS

Aarvee Associates

No Reviews

JOBS

IIFL Finance

No Jobs

JOBS

Silicon Stack

No Jobs

How was your last interview experience?
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent