DB2 Mainframe Architect

[ { "Remote_Job" : false, "Posting_Title" : "DB2 Mainframe Architect", "Is_Locked":false,"City": "Mumbai", "Role": "Development", "Industry": "IT Services", "Job_Opening_ID": "SA-22918-JOB", "Job_Description": "

**Give us an opportunity to find the next career move for you.

**SA Technologies Inc. is hiring for DB2 Mainframe Architect in PAN India

**Requirement/Description:

Role Summary:

We are looking for an experienced DB2 Data Architect with deep expertise in DB2 Data Modeling, Mainframe Database Design, and SQL Optimization. The ideal candidate will be responsible for designing scalable and high-performing database architectures, defining data models, and optimizing enterprise data environments supporting critical mainframe applications.

Key Responsibilities

• Design and maintain enterprise-wide DB2 database architectures for mainframe applications.

• Develop conceptual, logical, and physical data models aligned with business and application requirements.

• Define database standards, data governance practices, and design guidelines.

• Lead database design reviews and recommend best practices for scalability, performance, and maintainability.

• Analyze and optimize complex SQL queries, database access paths, and data retrieval processes.

• Collaborate with Solution Architects, Application Developers, and Business stakeholders to deliver robust data solutions.

• Support performance tuning, capacity planning, data integrity, and database modernization initiatives.

• Provide technical leadership and mentorship on DB2 database design and optimization.

Required Qualifications

• 10+ years of experience in DB2 database architecture and design.

• Strong expertise in DB2 Data Modeling and Mainframe Database Design.

• Advanced knowledge of SQL development, query optimization, and performance tuning.

• Experience working with large-scale transactional and enterprise data environments.

• Strong understanding of data architecture principles, normalization, and database design best practices.

• Excellent analytical, problem-solving, and stakeholder management skills.

Preferred Qualifications

• Experience with Mainframe technologies including COBOL, CICS, JCL, and VSAM.

• Exposure to database modernization and cloud integration initiatives.

• Knowledge of data governance, metadata management, and data quality frameworks.

• Experience in Healthcare, Banking, Insurance, or other large-scale enterprise domains.

Key Skills

DB2 Data Architecture | Data Modeling | Mainframe Database Design | SQL Optimization | Database Performance Tuning | Data Governance | Physical & Logical Data Modeling | Data Migration | Mainframe Technologies | Technical Leadership Ideal Candidate A seasoned DB2 Data Architect with strong expertise in data modeling, database design, and SQL optimization, capable of architecting high-performance data solutions and providing technical leadership across large enterprise mainframe ecosystems.

Location: -

• Mumbai
• Pune******

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.