16 Pragma Edge Software Services Jobs
6-12 years
Hyderabad / Secunderabad
Pragma Edge - IBM DB2 LUW Administrator - Unix/Cloud (6-12 yrs)
Pragma Edge Software Services
posted 26d ago
Flexible timing
Key skills for the job
We are hiring for IBM DB2 LUW Admin
Experience : 6 to 12 Years
Location : Hyderabad
Job Description :
As an IBM DB2 Database Administrator, you will be responsible for the management, optimization, and overall administration of IBM DB2 databases. You will ensure the availability, reliability, and performance of DB2 databases that support business-critical applications.
This position requires expertise in database configuration, tuning, security, backup, recovery, and troubleshooting within both distributed and mainframe environments.
Responsibilities :
- Install, configure, and maintain IBM DB2 databases on Linux, UNIX, IBM Could platforms.
- Perform database upgrades and patches to ensure the environment is up to date and secure.
- Manage database objects (tables, indexes, views, etc.) and ensure proper data integrity and normalization.
- Handle database partitioning, clustering, and replication tasks
- Monitor and analyze database performance, identifying bottlenecks and tuning SQL queries for optimal performance.
- Utilize tools such as IBM Data Studio, or third-party software for performance monitoring.
- Conduct regular database health checks and make recommendations for improvements.
- Design and implement robust backup strategies, including automated backups, point-in-time recovery, and disaster recovery planning.
- Perform DB2 database restores and recoveries, ensuring minimal downtime.
- Manage database log files and ensure recovery capabilities.
- Perform regular maintenance tasks, including reorganization, compression, and data archiving.
- Manage large volumes of transactional data and optimize database performance for OLTP and OLAP systems.
- Expertise on of cloud platforms (IBM Cloud, Google cloud) is critical.
- Troubleshoot and resolve database issues, including connectivity, performance, and corruption problems.
- Provide support to development teams for database design, query optimization, and performance tuning.
- Support high-availability environments and participate in on-call rotations for after-hours support.
Required Skills :
- Bachelor's degree in Computer Science, Information Technology, or a related field
- Strong experience in IBM DB2 from a production perspective
- Expertise in clustering and replication
- Proficiency in high availability (HA) and high availability disaster recovery (HADR)
- Experience with PTO
- Strong troubleshooting skills
Functional Areas: Software/Testing/Networking
Read full job descriptionPrepare for Unix Administrator roles with real interview advice
6-12 Yrs
Hyderabad / Secunderabad
5-9 Yrs
5-7 Yrs
Hyderabad / Secunderabad
5-7 Yrs
Hyderabad / Secunderabad