Mainframe DB2

Job Description - Key Responsibilities: - Application Development and Support: - Develop, implement, and maintain DB2-based applications on the mainframe, ensuring they meet business requirements and performance standards. - Collaborate with business analysts to gather and translate functional requirements into technical specifications for DB2 applications. - Develop SQL queries, stored procedures, triggers, and views to support application functionality. - Code and test new application modules and enhancements, ensuring compliance with organizational development standards. - Database Design & Optimization: - Design, implement, and optimize DB2 database structures (tables, indexes, and views) to ensure data integrity, accuracy, and performance. - Optimize SQL queries for performance and scalability, minimizing resource consumption and improving response times. - Conduct DB2 database tuning and performance analysis to identify and resolve issues, such as slow query performance or inefficient indexing. - System Integration & Testing: - Work with integration teams to ensure smooth interaction between DB2 databases and other systems (including legacy and cloud-based systems). - Develop unit tests, integration tests, and system testing procedures for DB2 applications. - Participate in the debugging and issue resolution of application errors, ensuring timely fixes and minimal downtime. - Maintenance and Upgrades: - Perform regular system maintenance tasks, including backups, security patches, and database upgrades to ensure optimal database health and performance. - Ensure the integrity and security of the DB2 database by implementing appropriate access controls and data protection measures. - Participate in the migration and upgrade of DB2 databases to newer versions, ensuring compatibility with existing systems. - Collaboration & Documentation: - Collaborate with cross-functional teams, including developers, QA engineers, and system administrators, to deliver end-to-end solutions for DB2 applications. - Create and maintain technical documentation, including design documents, database schema, and user manuals, ensuring that they are up-to-date and comprehensive. - Provide guidance and mentorship to junior developers on best practices, debugging techniques, and DB2-related technologies. - Incident Management & Troubleshooting: - Investigate, diagnose, and resolve database-related issues and incidents in a timely manner to minimize business impact. - Provide on-call support for DB2-related incidents, performing root-cause analysis and implementing corrective actions. - Monitor DB2 databases for availability, performance, and capacity, proactively addressing any potential issues before they escalate. - Compliance & Security: - Ensure that all DB2 applications comply with organizational security policies and industry regulations (e.g., GDPR, HIPAA). - Implement database encryption, access control policies, and audit trails to ensure sensitive data is protected and regulatory compliance is maintained. - Continuous Improvement: - Stay current with the latest Mainframe DB2 technologies, trends, and best practices in database management and application development. - Suggest improvements to existing systems and processes, driving automation, efficiency, and cost reduction. - Contribute to the development of strategies for scalability and performance optimization across DB2-based applications. - Required Qualifications: - Bachelor's degree in Computer Science, Information Technology, or related field. - 3+ years of experience in Mainframe DB2 application development or similar roles, including working with COBOL, JCL, and DB2 databases. - Strong experience in DB2 database administration, SQL query optimization, and database design on the mainframe platform. - Proficiency in COBOL programming, including integration with DB2 for data access and manipulation. - Strong understanding of relational database management systems (RDBMS) and concepts such as normalization, indexes, joins, and ACID properties. - Experience with database performance tuning, query optimization, and database indexing for large-scale enterprise applications. - Familiarity with mainframe tools such as Endevor, Zowe, or ISPF. - Knowledge of JCL (Job Control Language) and its integration with DB2 and other mainframe applications. - Experience with version control systems (e.g., Git, SCCS) and change management tools.