Mainframe DB2 DBA

4 weeks ago

Kottayam, India Tata Consultancy Services Full time

Role - Mainframe DB2 System AdministratorExp- 6 to 12 yearsLocation: Chennai/Hyderabad/Bangalore/Mumbai/Pune/DelhiSummary of key responsibilitiesDefine and provide guidance for database creation, configuration, upgrade, patches and refresh requirementsRecommend operating system and database performance monitoring, tuning and configuration changesExperience with database physical and logical design, query analysis and optimizationProvide technical assistance and subject matter expertise to applications groupsProvide database storage management and capacity management recommendationsDefine and manage database security and access permissions in consultation with customerEnsure completion of authorized Service Requests, Changes, Problem ticketsManage escalations and track Service Delivery and ensure SLA compliance including with vendorsReview and update the SOP documents on regular basisSupport in all in-flight and upcoming project activitiesRecommend and perform customer-approved database replication proceduresYears of ExperienceL3 : 6+ Years of experience in Mainframe z/OS Db2 v13 Database AdministrationTechnical requirementsExperience in Mainframe Db2 v12/ v13 Database System-Administration on z/OSDB2 installation, upgrade, patching, configuration and operationsProficiency in DB2, VSAM Systems Performance Tuning and Capacity PlanningExperience in Data Sharing setup in Parallel Sysplex environmentKnowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9Experience in SMPE and ISV tools installation and migrationCreate and maintain database entities, including instances, databases, table spaces and tablesDatabase DR, Cloning, Backup/Recovery, HA and Point in Time Recovery (PITR) expertiseExperience with Database ISV Tools and Products like OmegaMon and AdminToolApplication related performance tuning; Write, modify, and debug database specific SQL queriesDBA related utilities like Unload, Load, DSNJU003, DSNJU004, Reorg, Runstats, image copyREXX, CLIST, JCL, JES and Assembler knowledge

  • Expert Mainframe System Specialist

    3 days ago

    kottayam, India beBeeMainframe Full time

    Lead Mainframe Systems ProgrammerWe are seeking an experienced Lead Mainframe Systems Programmer to lead our mainframe environment. Key responsibilities include installing, maintaining and upgrading z/OS systems as well as other critical infrastructure components such as JES2, RACF, CICS, DB2 and IMS.

  • Systems Mainframe Specialist

    5 days ago

    kottayam, India beBeeExpert Full time

    **Mainframe Systems Expert Wanted** We are seeking a highly skilled and experienced mainframe systems expert to lead technical initiatives and collaborate with cross-functional teams to support business and IT objectives. As a key member of our team, you will be responsible for ensuring the high availability and optimal performance of our z/OS and subsystems...

  • OMEGAMON Performance Specialist

    1 day ago

    kottayam, India beBeeMonitoring Full time

    Job OverviewAs a seasoned IT professional, you will play a pivotal role in ensuring the smooth operation of complex systems and services.Manage critical system data for clients and provide day-to-day solutions and security compliance.Oversight of a queue of assignments, working directly with technicians to prioritize tickets and deliver exceptional client...