DBA And JD

Zensar Technologies; Pune District; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Zensar Technologies Limited is seeking a senior Database Administrator with deep mainframe expertise to drive the migration of DB2 for z/OS, VSAM, GDGs and flat-file assets to AWS cloud services.

The role encompasses data assessment, schema design, ETL development, Flyway-based deployment, performance tuning and production cut-over, working closely with mainframe SMEs, cloud engineers and DevOps teams.

Qualifications

• 8+ years of DBA experience with mainframe data migration projects.
• Strong knowledge of IBM DB2 for z/OS, VSAM (KSDS, ESDS, RRDS), GDGs and JCL.
• Proficiency in DB2 LUW, SQL development, data modeling and performance tuning.
• Hands-on experience with AWS RDS DB2 LUW, Amazon S3, AWS DMS, Glue and DataSync.
• Expertise in Flyway, database schema versioning and CI/CD integration.

Responsibilities

• Analyze source structures (DB2 z/OS, VSAM, GDGs, flat files) and map to target schemas.
• Design and implement DB2 LUW schemas, indexes, constraints and naming standards.
• Develop Flyway migrations and integrate into CI/CD pipelines.
• Create ETL processes including EBCDIC-to-ASCII conversion and datatype transformations.
• Perform bulk and incremental loads into AWS RDS DB2 LUW and S3; support cut-overs.
• Tune DB2 LUW performance and optimize load utilities and query plans.
• Collaborate with mainframe SMEs, cloud engineers, Rocket Server teams and QA.

Skills

DB2 for z/OS

VSAM

JCL

AWS RDS DB2 LUW

Data modeling

SQL development

CI/CD integration

ETL development

Tools

Flyway

Informatica

Talend

Precisely

Syncsort

Job description

Job Description:

Zensar Technologies Limited is seeking a senior Database Administrator with deep mainframe expertise to drive the migration of DB2 for z/OS, VSAM, GDGs and flat‑file assets to AWS cloud services. The role encompasses data assessment, schema design, ETL development, Flyway‑based deployment, performance tuning and production cut‑over, working closely with mainframe SMEs, cloud engineers and DevOps teams.

Responsibilities

• Analyze source data structures (DB2 z/OS, VSAM, GDGs, flat files) and create source‑to‑target mapping specifications.
• Design and implement DB2 LUW schemas, indexes, constraints and naming standards.
• Develop and maintain Flyway migration scripts and integrate them into CI/CD pipelines.
• Build and execute ETL processes, including EBCDIC‑to‑ASCII conversion and legacy datatype transformations.
• Perform bulk and incremental loads into AWS RDS DB2 LUW and Amazon S3, supporting rehearsals and production cut‑overs.
• Conduct record‑count, field‑level and business‑level reconciliation and produce audit reports.
• Tune DB2 LUW performance, optimize load utilities and query execution plans.
• Collaborate with mainframe SMEs, application architects, Rocket Enterprise Server specialists, cloud engineers and testing teams.
• Support capacity planning, performance testing and rollback procedures.

Qualifications

• 8+ years of DBA experience with mainframe data migration projects.
• Strong knowledge of IBM DB2 for z/OS, VSAM (KSDS, ESDS, RRDS), GDGs and JCL.
• Proficiency in DB2 LUW, SQL development, data modeling and performance tuning.
• Hands‑on experience with AWS RDS DB2 LUW, Amazon S3, AWS DMS, Glue and DataSync.
• Expertise in Flyway, database schema versioning and CI/CD integration.
• Demonstrated ability to develop ETL processes and perform data conversion (EBCDIC‑to‑ASCII, packed decimal).
• Experience with migration tools such as Informatica, Talend, Precisely or Syncsort.
• Background in banking, financial services or insurance domains is preferred.
• Familiarity with Rocket Enterprise Server environments and cloud‑replatforming initiatives.

At Zensar, we’re "experience-led everything". We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: "Together, we shape experiences for better futures". Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.