19 Nov
|
Talent OJ
|
Bengaluru
19 Nov
Talent OJ
Bengaluru
– Db2 Database Administrator
Job Title: Database Administrator – Db2
Experience: 5–7 Years
Role: Database Administration
Job Summary
We are looking for an experienced Db2 Database Administrator with 5–7 years of hands-on experience in managing and supporting IBM Db2 databases. The candidate will be responsible for end-to-end database administration, performance optimization, high availability, backup and recovery, and production database support.
The role also involves supporting other database technologies, including PostgreSQL, Oracle, MS SQL, NoSQL and cloud-based database services across AWS and Azure environments.
Key Responsibilities
- Handle end-to-end IBM Db2 database administration and production support.
- Perform database installation, configuration, upgrades, patching and maintenance.
- Manage database architecture, design, schemas, partitioning and data modelling.
- Perform database performance tuning, parameter tuning and query optimization.
- Manage storage, capacity planning and database maintenance activities.
- Implement and manage backup, recovery and disaster recovery strategies.
- Manage High Availability (HA), HADR and database clustering.
- Work with Db2 tools and features such as TSA, Db2 DPF, Federation and SQL Replication.
- Perform Linux administration and automation using Shell and Perl scripting.
- Provide secondary support for PostgreSQL, Oracle, MS SQL,
NoSQL and other open-source databases.
- Support AWS and Azure database services (DBaaS).
- Ensure database availability and reliability in a 24x7 production environment.
Required Skills & Qualifications
- 5–7 years of experience in Database Administration, with solid hands-on IBM Db2 DBA experience.
- Strong knowledge of Db2 installation, configuration, administration and maintenance.
- Experience in database architecture, modelling, partitioning and normalization.
- Hands-on experience in performance tuning, backup and recovery.
- Good understanding of HADR, TSA, Db2 DPF, Federation and SQL Replication.
- Working knowledge of Linux operating systems.
- Experience with Shell and Perl scripting.
- Knowledge of AWS and Azure database environments.
- Exposure to PostgreSQL, Oracle, MS SQL and NoSQL databases.
Positive to Have
- Experience with ER/Studio.
- Knowledge of Spectrum Scale File System.
- Experience with IBM InfoSphere Replication Server.
- Experience supporting business-critical 24x7 database environments.
Key Competencies
- Strong analytical and troubleshooting skills.
- Good communication and interpersonal skills.
- Ability to work independently and take initiative.
- Strong production support and problem-solving capabilities.
Pay: ₹1,000,000.00 - ₹2,000,000.00 per year
Work Location: In person
📌 Db2 – Database administrator (Bengaluru)
🏢 Talent OJ
📍 Bengaluru