Especialista em Banco de Dados IDMS

<h3>Accountabilities</h3><li>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.</li><li>Monitor database performance and analyze queries, routines, access patterns, and system behavior across development, testing, and production environments.</li><li>Identify performance bottlenecks and implement optimization strategies to improve database response times, resource utilization, and operational efficiency.</li><li>Develop and recommend data modeling and structural improvements to support database architecture, optimize physical data access, and enhance overall performance.</li><li>Manage database structures, schemas, subschemas, storage areas, and partitioning strategies to maintain data consistency and efficient access.</li><li>Support the integration of CA-IDMS databases with mainframe applications, collaborating with development teams working with CICS, Enterprise COBOL, JCL, and VSAM files.</li><li>Apply database administration practices involving DDL, DML, and DCL commands to support data definition, manipulation, access control, and operational requirements.</li><li>Support the management of large volumes of data, including database partitioning, normalization, integrity validation, and resource optimization.</li><li>Troubleshoot database incidents, investigate technical issues, and implement corrective and preventive measures to maintain service continuity.</li><li>Use mainframe monitoring, scheduling, version control, and diagnostic tools to support operational control, performance analysis, and job execution.</li><li>Contribute to database maintenance, reorganization, backup and recovery activities, and other procedures required to preserve data integrity and system reliability.</li><li>Collaborate with technical teams to evaluate database-related risks, recommend improvements, and ensure that solutions align with enterprise architecture and operational standards.</li><h2>Requirements</h2><li>Bachelor's degree in Information Technology or a related field, or a degree in another discipline combined with a postgraduate qualification in Information Technology.</li><li>Strong practical and theoretical knowledge of CA-IDMS database management systems.</li><li>Experience with DDL, DML, and DCL commands and their application in database administration.</li><li>Solid experience in relational data modeling, database performance analysis, and optimization techniques.</li><li>Knowledge of database normalization, data consistency, table partitioning, and strategies for managing very large databases (VLDBs).</li><li>Familiarity with IBM z/OS mainframe environments and utilities such as JCL, TSO, IDCAMS, and Sort.</li><li>Experience integrating databases with CICS, Enterprise COBOL applications, and VSAM files.</li><li>Knowledge of mainframe database monitoring, support, and version control tools, such as Endevor, MainView, Strobe, Control-M, Abend-Aid, File-Aid, or equivalent solutions.</li><li>Strong analytical and troubleshooting skills, with the ability to investigate complex database issues and implement effective technical solutions.</li><li>Attention to detail and a commitment to database security, data integrity, system availability, and operational reliability.</li><li>Ability to collaborate effectively with development, infrastructure, and other technical teams.</li><h2>Nice to Have</h2><li>Experience with CA-IDMS/DB administration, including schema and subschema management, storage areas, physical access optimization, and partitioning.</li><li>Familiarity with ADSO (Application Development System/Online) for developing and executing online transactions and interactive reports integrated with IDMS.</li><li>Experience with IBM CICS transaction processing and its integration with CA-IDMS.</li><li>Knowledge of Control-M for batch job scheduling and automation.</li><li>Experience with CA Database Management utilities for DB2/IDMS, including database reorganization, REORG operations, backup, and recovery.</li><li>Familiarity with DASS (Data Administration &amp; Structuring Systems) tools for database volume reporting, pointer analysis, and IDMS network integrity checks.</li><li>Basic knowledge of statistics, predictive models, and probabilistic analysis.</li><h2>Benefits</h2><li>
<strong>Healthcare coverage:</strong>Access to a Bradesco national medical and dental insurance plan.</li><li>
<strong>Meal allowance:</strong>Food and meal benefits provided through a Swile card.</li><li>
<strong>Transportation assistance:</strong>Transportation allowance for eligible commuting expenses.</li><li>
<strong>Financial benefits:</strong>Access to an exclusive banking credit package.</li><li>
<strong>Life insurance:</strong>Fully employer-funded life insurance coverage.</li><li>
<strong>Professional development:</strong>Exclusive discounts on courses, training programs, and educational institutions.</li><li>
<strong>Fitness and wellness:</strong>Access to Wellhub (formerly Gympass) and participating fitness facilities.</li><li>
<strong>Technology-driven environment:</strong>Opportunities to contribute to enterprise technology projects and work with specialized mainframe database systems.</li><li>
<strong>Career development:</strong>Exposure to complex technical challenges and opportunities to strengthen expertise in database administration, performance optimization, and enterprise systems.</li>