DBA & JD Professional
Zensar Technologies · Pune · onsite · Posted 44d ago
Undisclosed8–13 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
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.
- 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.
- Analyze source data structures (DB2 z/OS, VSAM, GDGs, flat 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.
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.
Sourced from naukri
Skills
DevopsDB2CI/CD Pipelinesdbaamazon web servicesamazon s3etl developmentDatabase AdministratorAWS RDSDatabase SchemaBankingCI/CD IntegrationData StructuresdeploymentData MigrationcloudData ConversionETLData Modeling
About Zensar Technologies
Zensar Technologies
IT Services & Consulting
10.0k+
employees
2001
25 years old
Pune, Maharashtra
India
About
Zensar is a global organization that conceptualizes, builds, and manages digital products through experience design, data engineering, and advanced analytics for leading companies.
Industries
IT Services & Consulting
Employee ratings
2,994 reviews
3.7/ 5
Culture
3.5
Career growth
3.0
Work-life
3.8
Employees rate it well for
Work Life Balance442Work Culture366Senior Management300Salary295Job Security229
Find them on