"The world of legacy data management is undergoing a resurgence as companies modernize their critical systems. Expertise in IDMS and DB2 is in high demand, especially for hybrid roles that blend on\u2011site consulting with remote analysis. This contract position offers a chance to leverage over a decade of experience to drive performance and migration projects for top-tier clients.\n\n# Job Summary\nWe are seeking an experienced IDMS DBA/DB2 Administrator to consult with clients, resolve complex database issues, and document solutions. The role focuses on IDMS application and database usage, including ADSO, performance tuning of Db2/SQL, data migration, and related mainframe technologies. You will work in a hybrid setting in Albany, NY, delivering expert guidance and ensuring optimal system performance.\n\n# Top 3 Critical Skills Table\n| Skill | Why it's critical | Mastery Level |\n|-------|-------------------|--------------|\n| IDMS DBA | Core platform; ensures data integrity & availability | Senior |\n| Db2/SQL performance tuning | Optimizes query speed, reduces costs | Senior |\n| Data Migration / ADSO | Enables seamless transition between systems | Mid |\n\n# Interview Preparation\n1. **Explain how you would approach performance tuning for a Db2/SQL workload that interacts with IDMS data.**\n *What the interviewer is looking for:* Understanding of query optimization, indexing strategies, and cross\u2011system considerations.\n2. **Describe the steps you would take to migrate data from an ADSO environment to a modern DB2 schema.**\n *What the interviewer is looking for:* Knowledge of migration planning, data mapping, validation, and downtime minimization.\n3. **How do you troubleshoot and resolve an IDMS application error that impacts VSAM file access?**\n *What the interviewer is looking for:* Problem\u2011solving methodology, familiarity with VSAM, and documentation practices.\n4. **What is the role of Assembler/Macro language in maintaining legacy IDMS systems, and how have you used it?**\n *What the interviewer is looking for:* Practical experience with low\u2011level code and its impact on database operations.\n5. **Can you discuss a time you had to communicate a complex technical issue to a non\u2011technical client?**\n *What the interviewer is looking for:* Communication skills and ability to translate technical concepts into business impact.\n\n# Resume Optimization\n- IDMS DBA\n- DB2\n- SQL performance tuning\n- ADSO\n- Data Migration\n- Assembler\n- Macro language\n- IMS-DB/DC\n- VSAM\n- Documentation\n\n# Application Strategy\nWhen reaching out to the recruiter, send a concise email that begins with a friendly greeting, attach your updated resume, and clearly highlight your top skills. Make sure to mention related skills you possess, such as IDMS administration, DB2 performance tuning, and data migration experience. Reference specific projects where you applied these skills and demonstrate how they align with the responsibilities listed in the job description.\n\n# Career Roadmap\n| Current Role | Typical Experience | Core Focus | Next Position |\n|--------------|-------------------|------------|---------------|\n| IDMS DBA/DB2 Administrator | 11+ years IDMS & DB2 | System performance, migration, client consulting | Senior IDMS DBA Lead |\n| Senior IDMS DBA Lead | 3\u20115 years leading projects | Architecture, team mentorship | IDMS/DB2 Solutions Architect |\n| IDMS/DB2 Solutions Architect | 5+ years strategic design | Enterprise data strategy, multi\u2011system integration | Director of Data Engineering |\n"