What are the responsibilities and job description for the Mainframe Database Administrator position at SCIGON?
Key Responsibilities
Administer and maintain DB2 for z/OS databases, including installation, upgrades, backups, and performance tuning.
Develop and optimize database designs to meet application requirements, ensuring scalability and reliability.
Monitor and troubleshoot database performance, addressing issues proactively to minimize downtime.
Support disaster recovery planning, implementation, and testing.
Collaborate with application developers to optimize queries and database structures.
Utilize tools like CA DB2, JCL, and TSO/ISPF for database and job management.
Execute security protocols and ensure database compliance with organizational standards.
Provide 24/7 support for critical database systems on a rotational basis.
Required Skills and Qualifications
5 years in DB2 z/OS administration, with expertise in database tuning and optimization.
Proficiency in COBOL, SQL, JCL, and CICS in mainframe environments.
Hands-on experience with IMS database administration and tools.
Familiarity with Agile project management methodologies.
Technical Proficiency:
DB2 utilities, IMS commands, and synchronization tools like CA DB2.
Mainframe job control and diagnostic utilities (e.g., SDSF, ISPF).
Performance monitoring tools and disaster recovery solutions.
Preferred Qualifications
Knowledge of modern data modeling tools (e.g., ER/Studio) and their application in mainframe environments.
Experience integrating mainframe databases with external systems via middleware solutions.
