02 Oct
|
KPMG
|
Bengaluru
OneDayHire Job
Top Hiring Companies
IMS/DB2 Database Administrator (DBA) on z/OS typically has a wide range of technical responsibilities revolving around managing and optimizing IMS and DB2 databases on IBM's mainframe operating system. Here are some typical roles and responsibilities:
Database Design and Architecture: Collaborate with architects, application developers, and stakeholders to design and implement scalable, high-performance database solutions that meet business requirements and align with organizational goals.
Database Administration: Manage all aspects of the DB2/IMS database setting on the z/OS platform, including database creation, configuration, monitoring, tuning, backup, recovery, and maintenance.
Database Performance Tuning: Monitoring database performance using tools like CA Sysview or IBM OMEGAMON, identifying bottlenecks, and implementing performance tuning measures such as index optimization, SQL tuning, and understanding of buffer pool sizing.
Capacity Planning:
Forecasting database growth and resource utilization to ensure that sufficient resources (storage, CPU, memory) are available to support current and future database workloads.
Database Security: Implementing and maintaining security measures to protect sensitive data stored in IMS and DB2 databases, including user authentication, access control, and encryption.
Backup and Recovery: Developing and maintaining backup and recovery procedures to ensure data integrity and minimize downtime in the event of hardware failures, data corruption, or other disasters.
High Availability and Disaster Recovery: Designing and implementing high availability and disaster recovery solutions for IMS and DB2 databases, such as clustering, data replication, and failover mechanisms.
Patch Management and Upgrades: Knowledge or participation in Applying patches, fixes, and upgrades to IMS and DB2 software to address security vulnerabilities, bugs, and performance enhancements.
Data
📌 System Engineer (Bengaluru)
🏢 KPMG
📍 Bengaluru