Job
Description
Project Role : Technology Architect Project Role Description : Design and deliver technology architecture for a platform, product, or engagement. Define solutions to meet performance, capability, and scalability needs. Must have skills : IBM Db2 Good to have skills : Database Architecture Minimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Application Tech Support Practitioner Project Role DescriptionAct as the ongoing interface between the client and the system or application. Dedicated to quality, using exceptional communication skills to keep our world class systems running. Can accurately define a client issue and can interpret and design a resolution based on deep product knowledge.Must to have skillsIBM Db2, SSI:NON SSI: Good to have skillsSSI:NON SSI:Job Requirements Job Title:DB2 for Mainframe Database AdministratorJob Summary :We are seeking a skilled DB2 for Mainframe Database Administrator to manage and maintain our enterprise-level DB2 databases on z/OS. The ideal candidate will be responsible for ensuring the performance, availability, and security of DB2 databases while also planning and implementing database solutions for the future.Key Responsibilities:Database Management:Administer and maintain DB2 databases on IBM z/OS mainframe environments, including installation, configuration, upgrades, and patching.Performance Tuning:Monitor and optimize the performance of DB2 databases, identifying bottlenecks, and implementing performance tuning strategies to ensure high availability and responsiveness.Backup & Recovery:Develop, implement, and manage backup and recovery procedures to safeguard critical data. Perform regular backups and ensure that recovery procedures are robust and well-documented.Security Management:Implement and manage database security, including user access controls, encryption, and auditing, ensuring compliance with industry standards and company policies.Problem Resolution:Troubleshoot and resolve issues related to DB2 database operations, including providing support for complex technical problems and developing root cause analysis.Data Integrity & Availability:Ensure data integrity and availability by managing replication, data migration, and data archiving processes.Documentation:Maintain comprehensive documentation of the database environment, including configurations, processes, and procedures.Collaboration:Work closely with application developers, system administrators, and other stakeholders to design and implement database solutions that meet business requirements.Disaster Recovery:Participate in the development and testing of disaster recovery plans to ensure data continuity in the event of a disaster.Compliance & Auditing:Ensure that database systems comply with regulatory requirements and participate in regular audits. Qualifications:Experience:Minimum of 5 years of experience as a DB2 Database Administrator in a mainframe environment.Technical Skills: Technical Proficiency:In-depth knowledge of DB2 for z/OS, SQL,SPUFI, IBM Data Studio, CA Tools For DB2 (RC Query, Migrator, Log Analyzer, etc.), BMC Utilities, CA Utilities, IBM Utilities, File Manager For DB2, InfoSphere CDCStrong knowledge of mainframe technologies and z/OS operating systemMainframe TechnologiesZ/OS, JCL, REXX, CLIST, ESP schedulerPerformance Monitoring ToolsIBM OMEGAMON, CA Thread Terminator, IBM Query Monitor, IBM Tivoli Enterprise Portal, Dynatrace, (other monitoring software is owned but not implemented at the moment ex Detector/Subsystem Analyzer)Version Control Systems.ChangemanSecurity ToolsRACFOperating SystemsZ/OSDB2 System Version:V12M510 & V13M100Scripting LanguagesREXX, JCL, CLISTExperience with database performance tuning and optimizationFamiliarity with backup and recovery tools and processesUnderstanding of database security best practicesExperience with disaster recovery planning and implementationSoft Skills: Strong analytical and problem-solving abilitiesExcellent communication and collaboration skillsAbility to work independently and as part of a teamAttention to detail and strong organizational skillsPreferred Qualifications:IBM Certified Database Administrator DB2 for z/OSExperience with data replication tools (e.g., Q Replication, InfoSphere)Knowledge of automation tools and scripting languages (e.g., REXX, JCL)Additional Information: The candidate should have a minimum of 3 years of experience in DB2 for Mainframe Database Administrator This position is based at our Pune office. A 15 years full-time education is required.
