Business Intelligence Specialist

NTT DATA BUSINESS SOLUTIONS; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

NTT DATA BUSINESS SOLUTIONS in Hyderabad is seeking a seasoned Business Intelligence Specialist to administer DB2 databases on z/OS and manage DB2 objects in production and development. The role requires expert tuning, backups, security and high availability, plus capacity planning and monitoring.

The candidate will support DB2 upgrades, migrations, and DR activities, performing DBA tasks with independence.

Qualifications

• Proven expertise in administering DB2 databases on z/OS.
• Experience with creating and managing DB2 objects (Databases, Tablespace, Tables, Indexes) in Production and Development regions.
• Experience with data maintenance utilities and DBA tools, scheduling tools.
• Experience in Performance tuning, backup/recovery procedures, security, and high availability.
• Experience in capacity planning, Space/memory Management and Monitoring.
• Experience in optimization of DB2 objects, queries, buffer pools, and system resources for maximum efficiency.
• Provide 24/7 On-call support for production system on rotation basis to handle DB2 job abends and issues.
• Support for DB2 upgrade, migration activities and DR and perform checkouts from DBA end
• Exceptional problem-solving abilities with a proven capacity to work independently.
• Strong communication and collaboration skills for effective teamwork.
• Knowledge of best practices in database management.
• Good to have experience/knowledge on Microsoft SSIS, SQL Server and Azure Cloud exposure.

Skills

DB2 on z/OS

Database administration

Performance tuning

Backup & recovery

Capacity planning

On-call production support

SQL/DB2 utilities

Teamwork & communication

Tools

SSIS

SQL Server

Azure Cloud

Job description

Job Summary

We are currently seeking a Business Intelligence Specialist to join our team in Hyderabad.

Requirements

• Proven expertise in administering DB2 databases on z/OS.
• Experience in creating and managing DB2 objects like Databases Tablespace Tables and Indexes, resizing, right buffer pool assignments and lock size modifications in Production and Development regions.
• Experience with data maintenance utilities and DBA tools, scheduling tools.
• Experience in Performance tuning, backup/recovery procedures, security, and high availability.
• Experience in capacity planning, Space/memory Management and Monitoring.
• Experience in optimization of DB2 objects, queries, buffer pools, and system resources etc for maximum efficiency.
• Provide 24/7 On-call support for production system on rotation basis to handle DB2 job abends and issues.
• Support for DB2 upgrade, migration activities and DR and perform checkouts from DBA end
• Exceptional problem-solving abilities with a proven capacity to work independently.
• Strong communication and collaboration skills for effective teamwork.
• Knowledge of best practices in database management.
• Good to have experience/knowledge on Microsoft SSIS, SQL Server and Azure Cloud exposure.