Mainframe DB2 Administration

Viraaj HR Solutions Private Limited

6 years

0 Lacs

Mumbai Metropolitan Region

Posted:5 days ago| Platform:

Apply

Skills Required

database tuning optimization installation configuration backup data integrity software design planning security audits checks maintenance support training technology provisioning sql query documentation troubleshooting monitoring communication automation collaboration

Work Mode

On-site

Job Type

Full Time

Job Description

Role Responsibilities Manage and maintain DB2 database environments for optimal functionality. Implement and streamline DB2 on Mainframe administrative processes. Conduct performance tuning and optimization of mainframe databases. Facilitate the installation and configuration of new DB2 versions and patches. Perform regular backup and recovery operations to safeguard data integrity. Monitor database performance and troubleshoot issues as they arise. Collaborate with software developers to design and enhance database systems. Develop, document, and enforce database policies and procedures. Assist in capacity planning and resource allocation for databases. Design and implement data models according to business requirements. Conduct security audits and manage user access rights for DB2 databases. Perform routine health checks and maintenance on database systems. Support disaster recovery planning and execution. Participate in cross-functional teams to deliver integrated solutions. Provide training and support to junior team members on DB2 administration best practices. Qualifications Bachelor's degree in Computer Science, Information Technology, or a related field. 6+ years of experience in Mainframe DB2 database administration. Hands-on experience with DB2 database provisioning and configuration. Proficient in SQL and query optimization. Strong knowledge of backup and recovery procedures for DB2 systems. Experience with data modeling and schema design. Familiarity with performance tuning techniques for DB2. Ability to troubleshoot database issues effectively. Good understanding of mainframe operating systems. Excellent analytical skills and attention to detail. Strong documentation skills for database procedures. Previously involved in troubleshooting and performance monitoring. Effective communication skills and team-oriented mindset. Experience with automation tools for database processes. Willingness to learn and adapt to new technologies. Skills: data modeling,backup and recovery procedures,db2 database administration,mainframe operating systems,query optimization,documentation,team collaboration,mainframe,sql proficiency,performance tuning,schema design,sql,automation tools,troubleshooting,database,adminstration,analytical thinking Show more Show less