Especialista em Banco de Dados IDMS

Job description

**This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for an Especialista em Banco de Dados IDMS based in Brazil.** Join a technology-driven environment focused on delivering reliable, scalable, and high-performance enterprise database solutions. As a Database Specialist, you will be responsible for administering, maintaining, monitoring, and optimizing CA-IDMS databases within IBM z/OS mainframe environments. Your expertise will help ensure database availability, security, data integrity, and operational efficiency across critical business systems. You will collaborate with development and infrastructure teams to improve performance, troubleshoot complex issues, and support seamless integration between mainframe applications and database platforms. This role offers the opportunity to work with large-scale data environments and specialized legacy technologies that remain essential to enterprise operations. If you enjoy solving complex technical challenges and strengthening the performance and reliability of mission-critical systems, this opportunity is for you. ### Accountabilities - Administer, maintain, and provide technical support for CA-IDMS database management systems, ensuring availability, stability, security, and reliable operation within IBM z/OS mainframe environments. - Monitor database performance and analyze queries, routines, access patterns, and system behavior across development, testing, and production environments. - Identify performance bottlenecks and implement optimization strategies to improve database response times, resource utilization, and operational efficiency. - Develop and recommend data modeling and structural improvements to support database architecture, optimize physical data access, and enhance overall performance. - Manage database structures, schemas, subschemas, storage areas, and partitioning strategies to maintain data consistency and efficient access. - Support the integration of CA-IDMS databases with mainframe applications, collaborating with development teams working with CICS, Enterprise COBOL, JCL, and VSAM files. - Apply database administration practices involving DDL, DML, and DCL commands to support data definition, manipulation, access control, and operational requirements. - Support the management of large volumes of data, including database partitioning, normalization, integrity validation, and resource optimization. - Troubleshoot database incidents, investigate technical issues, and implement corrective and preventive measures to maintain service continuity. - Use mainframe monitoring, scheduling, version control, and diagnostic tools to support operational control, performance analysis, and job execution. - Contribute to database maintenance, reorganization, backup and recovery activities, and other procedures required to preserve data integrity and system reliability. - Collaborate with technical teams to evaluate database-related risks, recommend improvements, and ensure that solutions align with enterprise architecture and operational standards. ## Requirements - Bachelor's degree in Information Technology or a related field, or a degree in another discipline combined with a postgraduate qualification in Information Technology. - Strong practical and theoretical knowledge of CA-IDMS database management systems. - Experience with DDL, DML, and DCL commands and their application in database administration. - Solid experience in relational data modeling, database performance analysis, and optimization techniques. - Knowledge of database normalization, data consistency, table partitioning, and strategies for managing very large databases (VLDBs). - Familiarity with IBM z/OS mainframe environments and utilities such as JCL, TSO, IDCAMS, and Sort. - Experience integrating databases with CICS, Enterprise COBOL applications, and VSAM files. - Knowledge of mainframe database monitoring, support, and version control tools, such as Endevor, MainView, Strobe, Control-M, Abend-Aid, File-Aid, or equivalent solutions. - Strong analytical and troubleshooting skills, with the ability to investigate complex database issues and implement effective technical solutions. - Attention to detail and a commitment to database security, data integrity, system availability, and operational reliability. - Ability to collaborate effectively with development, infrastructure, and other technical teams. **Nice to Have** - Experience with CA-IDMS/DB administration, including schema and subschema management, storage areas, physical access optimization, and partitioning. - Familiarity with ADSO (Application Development System/Online) for developing and executing online transactions and interactive reports integrated with IDMS. - Experience with IBM CICS transaction processing and its integration with CA-IDMS. - Knowledge of Control-M for batch job scheduling and automation. - Experience with CA Database Management utilities for DB2/IDMS, including database reorganization, REORG operations, backup, and recovery. - Familiarity with DASS (Data Administration & Structuring Systems) tools for database volume reporting, pointer analysis, and IDMS network integrity checks. - Basic knowledge of statistics, predictive models, and probabilistic analysis. ## Benefits - **Healthcare coverage:** Access to a Bradesco national medical and dental insurance plan. - **Meal allowance:** Food and meal benefits provided through a Swile card. - **Transportation assistance:** Transportation allowance for eligible commuting expenses. - **Financial benefits:** Access to an exclusive banking credit package. - **Life insurance:** Fully employer-funded life insurance coverage. - **Professional development:** Exclusive discounts on courses, training programs, and educational institutions. - **Fitness and wellness:** Access to Wellhub (formerly Gympass) and participating fitness facilities. - **Technology-driven environment:** Opportunities to contribute to enterprise technology projects and work with specialized mainframe database systems. - **Career development:** Exposure to complex technical challenges and opportunities to strengthen expertise in database administration, performance optimization, and enterprise systems.