10 Db2 Dba Jobs

You will be responsible for Database Object Creation and Maintenance, including creating and altering various DB2 objects such as Tablespaces, Tables, Stored procedures, Indexes, etc. Additionally, you will need to have knowledge and expertise on DB2 utility execution. Your role will involve Data load and migration tasks, such as understanding the data migration process from VSAM to DB2, unloading data from DB2 tables using UNLOAD utility, loading data from files to Tables using LOAD utility, unloading data from Image copy using UNLOAD or other utilities, and migrating data from one environment to another. Database backup and Recovery will be a crucial part of your responsibilities. This includes setting up and maintaining Image Copy and other DB2 housekeeping jobs, as well as being able to recover data from Image Copy using RECOVER utility. You will also manage Database access and security control by following security and audit control procedures to GRANT/REVOKE permissions on database objects, and providing Group level access on DB2 objects to RACF user groups. Supporting the Application team will be a key aspect of your role, which involves monitoring and troubleshooting batch job failures, handling and resolving all DB2 package related consistency token issues, and assisting the application team in resolving performance issues for the SQLs and/or Stored procedures. As part of Performance monitoring and tuning, you will be required to monitor current active and historical threads using DB2 monitoring tools, identify potential bottlenecks and lock contention in the active or historical threads, troubleshoot them, check overall Mainframe CPU utilization using SYSVIEW online panels, and perform SQL tuning by rewriting the SQLs or designing appropriate indexes. This is a Full-time position with benefits such as Paid time off, Provident Fund, and a Yearly bonus. The work schedule is Day shift, Monday to Friday, with the work location being in person at Noida.,

As a Mainframe DB2 Database Administrator, you will be responsible for installing, configuring, and upgrading DB2 database software and tools on mainframe systems. Your primary focus will be to ensure compatibility, performance, and security of the databases. You will create and manage DB2 databases, tablespaces, tables, indexes, and other database objects according to organizational standards and best practices. Your role will involve performing ongoing database maintenance activities such as backup and recovery, reorganization, space management, and health checks to uphold data integrity and availability. Monitoring database performance and resource utilization will be crucial, as you will proactively identify and resolve performance issues, tune SQL queries, and optimize database parameters. Database security will also be a key aspect of your responsibilities. You will implement and maintain database security policies, including roles and permissions, to ensure compliance with regulatory and data privacy standards. Planning and executing database migrations, upgrades, and patch installations in alignment with change management processes and business needs will be part of your duties. Collaboration with application developers, system administrators, and other stakeholders is essential to support database-related activities including development, testing, and production deployments. You will also be required to develop and maintain documentation, procedures, and standards for database administration tasks, including disaster recovery plans and high availability configurations. In addition, providing technical support and assistance to internal teams and users by troubleshooting and resolving DB2-related issues will be part of your daily tasks. It is important to stay current with emerging technologies, tools, and best practices in Mainframe DB2 administration, and actively contribute to knowledge sharing within the team. Required Experience: - Minimum of 5+ years of experience as a Mainframe DB2 DBA. Skills: - Mainframe - DB2 DBA - Backup Recovery - Performance and SQL Tuning - High Availability (HA) - Disaster Recovery (DR),

You are looking for a Mainframe Db2 DBA with 6-8 years of experience to join our team in Chennai, Pune, or Bangalore. As a Mainframe Application DBA / System Programmer, you will be responsible for maintaining the Mainframe Database architecture and concepts. You will work closely with vendors, application teams, and troubleshoot application issues. Your role will involve handling Mainframe Database offline & online Utilities, ISV tools like BMC and CA products, System Upgrades, Migration activities, SMP/e tools, and JCL concepts. Additionally, you will contribute to Performance monitoring, ITIL processes, and Disaster Recovery activities. Your must-have competencies include a strong understanding of Mainframe & Database Architecture, Mainframe Database concepts, JCL, and Performance monitoring tools. You should have experience in dealing with various vendors, application teams, and hold hands-on knowledge in Mainframe Database utilities. Being customer-facing, you should possess excellent communication skills and demonstrate a willingness to learn new technologies. Flexibility in shifts and strong communication skills are considered good-to-have qualities. Expectations from you include a stronghold on Application DBA and System Programmer activities, flexibility during crunch scenarios, and monthly on-call support during weekends. Your role will play a crucial part in maintaining the Mainframe Database systems and providing support as needed.,

Installing and/or customizing software products Mainframe DB2, working with large systems in data sharing SysPlex environment, Perform mainframe database software upgrades coupled with administration and tuning to support DB2 environments Required Candidate profile Perform performance data collection, analysis, and tuning of DB2 systems, Analyzing new versions of DB2 for functionality that can improve systems performance and reduce cost.

Warm Greetings from SP Staffing!! Role: Mainframe DB2 LUW Experience Required :6 to 10 yrs Work Location :Bangalore Required Skills, DB2 DBA/LUW Interested candidates can send resumes to nandhini.spstaffing@gmail.com

Administer z/OS systems, configure and manage DB2/CICS/IMS, optimize performance, manage storage systems, monitor capacity, and implement DR solutions. Required Candidate profile Experienced systems programmer/admin with deep z/OS, DB2, CICS, IMS, VSAM skills. Ability to manage Mainframe infra components and troubleshoot performance issues.

Mainframe DB2 DBA DB2 Database Administration Good articulation skills Ability to drive Incident Calls

Mainframe DB2 DBA DB2 DBA DB2 DBA Description: Database Administration skills on DB2. Attend meetings and interact regularly with management, team, and clients to continuously improve services. Participate in On-Call rotation schedule. Education and/or Experience: Bachelor s degree/technical certification in Computer Science or Systems Programming experience. Specific Requirements: Required: Maintaining DB2 Objects using Utilities Proactively provide Database structure, usability and performance improvements review query performance reports for inefficiencies and performance issues. DB2 Database Refresh and Grants Recovery of DB2 Objects, including via REDO SQLs Work with Data Architects and physical DBAs to request the implementation or modification of Databases in development, test, QA and production environments Provide consultation and advice on new queries and stored procedures. Review new queries and stored procedures, at application request on a regular basis. Senior level JCL Skills Pluses: DB2 System level Skills. REXX Skills TBC

Warm Greetings from SP Staffing Services Pvt Ltd!!!! Experience:6-10yrs Work Location :Chennai Job Description: Experience in Mainframe Db2 DBA 1. Should be stronghold on Mainframe & Database Architecture. 2. Should be expertise in Mainframe Database concepts 3. Should be dealing with various vendors & application team and troubleshoot the application Issues. 4. Should hold the hands-on knowledge in Mainframe Database offline & online Utilities. Hands-on experience in ISV tools like BMC and CA products Interested candidates, Kindly share your updated resume to gokul.priya@spstaffing.in or contact number (Whatsapp:9360311230) to proceed further.

Warm Greetings from SP Staffing!! Role: Mainframe DB2 DBA Experience Required :6 to 8 yrs Work Location :Pune/Chennai Required Skills, DB2 DBA SMP/e tools. Interested candidates can send resumes to nandhini.spstaffing@gmail.com