Job Description Position Summary The Logical DB2 Mainframe Engineer plays a key role in designing, modeling, and optimizing DB2 databases on the IBM z/OS platform. This position focuses on logical data architecture, schema governance, and collaboration with application development teams to ensure high quality, scalable, and efficient database solutions. The engineer will help shape enterprise data structures, enforce standards, and support mission critical applications across the organization. Key Responsibilities Logical Data Modeling & Architecture • Develop, maintain, and enhance logical data models for DB2 on z/OS. • Translate business and application requirements into well structured database schemas. • Define and manage tables, indexes, views, relationships, and referential integrity rules. • Ensure logical designs align with enterprise data architecture and modeling standards. Schema Governance & Standards • Establish and enforce naming conventions, modeling guidelines, and metadata practices. • Review and approve database design changes proposed by development teams. • Maintain documentation for logical structures, data flows, and data lineage. SQL & Performance Optimization • Analyze SQL statements and access paths to identify logical design improvements. • Recommend schema adjustments to enhance performance and reduce resource consumption. • Collaborate with developers to promote efficient SQL coding and DB2 best practices. Collaboration & Support • Partner with application teams to design new features and support ongoing development. • Work closely with system DBAs to ensure logical designs translate effectively into physical implementations. • Participate in project planning, impact analysis, and release management activities. Data Quality & Integrity • Ensure logical models support data accuracy, consistency, and compliance requirements. • Implement and maintain referential integrity, normalization, and data validation rules. • Support audits, data governance initiatives, and regulatory reporting needs. Required Qualifications • 5+ years of experience with DB2 for z/OS, with emphasis on logical database design. • Proficiency in SQL, access path analysis, and query tuning. • Hands on experience with data modeling tools (ERwin, IBM Data Architect, IDz Data Studio, etc.). • Solid understanding of mainframe concepts, JCL, and application development workflows. • Ability to communicate complex database concepts to technical and non technical audiences. Preferred Qualifications • Experience with performance monitoring tools (OMEGAMON, Query Monitor, BMC, CA). • Familiarity with DevOps pipelines for mainframe environments. • Exposure to modernization initiatives such as APIs, data virtualization, or cloud integration. • Knowledge of enterprise data governance frameworks. We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/. Skills and Requirements Position Summary The Logical DB2 Mainframe Engineer plays a key role in designing, modeling, and optimizing DB2 databases on the IBM z/OS platform. This position focuses on logical data architecture, schema governance, and collaboration with application development teams to ensure high quality, scalable, and efficient database solutions. The engineer will help shape enterprise data structures, enforce standards, and support mission critical applications across the organization. Key Responsibilities Logical Data Modeling & Architecture • Develop, maintain, and enhance logical data models for DB2 on z/OS. • Translate business and application requirements into well structured database schemas. • Define and manage tables, indexes, views, relationships, and referential integrity rules. • Ensure logical designs align with enterprise data architecture and modeling standards. Schema Governance & Standards • Establish and enforce naming conventions, modeling guidelines, and metadata practices. • Review and approve database design changes proposed by development teams. • Maintain documentation for logical structures, data flows, and data lineage. SQL & Performance Optimization • Analyze SQL statements and access paths to identify logical design improvements. • Recommend schema adjustments to enhance performance and reduce resource consumption. • Collaborate with developers to promote efficient SQL coding and DB2 best practices. Collaboration & Support • Partner with application teams to design new features and support ongoing development. • Work closely with system DBAs to ensure logical designs translate effectively into physical implementations. • Participate in project planning, impact analysis, and release management activities. Data Quality & Integrity • Ensure logical models support data accuracy, consistency, and compliance requirements. • Implement and maintain referential integrity, normalization, and data validation rules. • Support audits, data governance initiatives, and regulatory reporting needs. Required Qualifications • 5+ years of experience with DB2 for z/OS, with emphasis on logical database design. • Proficiency in SQL, access path analysis, and query tuning. • Hands on experience with data modeling tools (ERwin, IBM Data Architect, IDz Data Studio, etc.). • Solid understanding of mainframe concepts, JCL, and application development workflows. • Ability to communicate complex database concepts to technical and non technical audiences. Preferred Qualifications • Experience with performance monitoring tools (OMEGAMON, Query Monitor, BMC, CA). • Familiarity with DevOps pipelines for mainframe environments. • Exposure to modernization initiatives such as APIs, data virtualization, or cloud integration. • Knowledge of enterprise data governance frameworks.