DB2 Mainframe Architect

SA Technologies; Mumbai; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

SATechnologies Inc. in India is seeking an experienced DB2 Data Architect to design scalable, high-performing database architectures for mainframe applications. The role requires expertise in DB2 data modeling and mainframe design, with responsibilities spanning standards, governance, and optimization.

Lead data modeling efforts, mentor teams, and collaborate with architects, developers, and stakeholders to deliver robust data solutions and modernization initiatives. Location: Pune.

Qualifications

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

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.

Skills

DB2 Data Architecture

Data Modeling

Mainframe Database Design

SQL Optimization

Performance Tuning

Data Governance

Physical Data Modeling

Logical Data Modeling

Data Migration

Mainframe Technologies

Technical Leadership

Education

BE/B.Tech/MCA/MSc

Tools

Cobol

CICS

JCL

VSAM

Job description

Giveus an opportunity to find the next career move foryou.

SATechnologies Inc. is hiring for DB2 Mainframe Architectin PAN India

Requirement/Description:

RoleSummary:

We arelooking for an experienced DB2 Data Architect with deep expertise in DB2 DataModeling, Mainframe Database Design, and SQL Optimization. The ideal candidatewill be responsible for designing scalable and high-performing databasearchitectures, defining data models, and optimizing enterprise dataenvironments supporting critical mainframe applications.

KeyResponsibilities

• Design andmaintain enterprise-wide DB2 database architectures for mainframe applications.
• Developconceptual, logical, and physical data models aligned with business andapplication requirements.
• Definedatabase standards, data governance practices, and design guidelines.
• Leaddatabase design reviews and recommend best practices for scalability,performance, and maintainability.
• Analyzeand optimize complex SQL queries, database access paths, and data retrievalprocesses.
• Collaborate with Solution Architects, Application Developers, and Businessstakeholders to deliver robust data solutions.
• Supportperformance tuning, capacity planning, data integrity, and databasemodernization initiatives.
• Providetechnical leadership and mentorship on DB2 database design and optimization.

RequiredQualifications

• 10+ yearsof experience in DB2 database architecture and design.
• Strongexpertise in DB2 Data Modeling and Mainframe Database Design.
• Advancedknowledge of SQL development, query optimization, and performance tuning.
• Experienceworking with large-scale transactional and enterprise data environments.
• Strongunderstanding of data architecture principles, normalization, and databasedesign best practices.
• Excellentanalytical, problem-solving, and stakeholder management skills.

PreferredQualifications

• Experiencewith Mainframe technologies including COBOL, CICS, JCL, and VSAM.
• Exposureto database modernization and cloud integration initiatives.
• Knowledgeof data governance, metadata management, and data quality frameworks.
• Experiencein Healthcare, Banking, Insurance, or other large-scale enterprise domains.

Key Skills

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

Location: -

• Pune

EducationalQualifications: - BE/B.Tech/MCA/M.Sc

Skills: -

MandatoryTechnical skills

• DB2
• Cobol

Good to haveskills: -

• CICS
• VSAM
• JCL

SATechnologies specializes in offering IT consulting and Developmentsolutions for our global customers. From 20 years wehave been helping our customers achieve operational excellence andcompliance on the cloud. Our expertise lies indelivering quality services, cross-platform skills & supportingyou to achieve operational excellence & empower you to become atechnology-driven enterprise.

We are Microsoft Gold Partner, GooglePartner,andGreat Place to work certified company.