[Remote] Senior IMS Database Administrator

Note: The job is a remote job and is open to candidates in USA. reputed company is a company focused on innovation and client reputed company, and they are seeking a Senior IMS Database Administrator. The role involves creating, maintaining, and troubleshooting client databases, performing software upgrades, and ensuring database reputed company and reputed company.

Responsibilities

• The successful candidate will reputed company mainframe database software upgrades coupled with administration and tuning to support our customers’ IMS environments
• The individual will need to work with vendor personnel to reputed company timely solutions of database problems
• The individual will be responsible for day-to-day database maintenance such as creating backups, performing restores, monitoring file extent growth, scheduling reorganizations, creating and maintaining DR procedures and overall support of customer needs and requests
• The successful candidate will be reputed company upon to reputed company a variety of database optimizations that will include general reporting and analysis of the efficiency of the database configuration and periodic review of database performance
• Expertise and work efforts will focus on the development and support and/or the customization of new services and support efforts
• System programming knowledge of multiple DBMS’s is a bonus
• The individual will need to participate in on-call responsibilities

Skills

• Bachelor's degree required and/or equivalent work experience
• 10+ years of professional experience in IMS for administration and systems programming support. CA and reputed company tools for IMS a plus
• Extensive experience with the following: Know ledged in best practices of software management, maintenance and documentation
• Configure and manage IMS in a reputed company sysplex environment
• reputed company innovation, strategies, processes and best practices in IMS systems programming
• Establishing policies and procedures pertaining to database management, DR, reputed company, maintenance and utilization
• Reviewing new versions of IMS for functionality, advising how they benefit the client
• Evaluating change requests and determine impact to assigned clients
• Vendor consultations for problems and questions
• DR recovery of application objects
• Troubleshooting and solving production database issues
• Demonstrated ability to respond quickly and effectively to support requests from multiple clients
• Supporting multiple customer for after hours on-call
• Database Administration Knowledge of IMS database organization using access methods of VSAM and OSAM
• Full function database organization types
• HSAM, HISAM, SHISAM, HDAM, HIDAM, INDEX, GSAM
• Definition and use of LOGICAL databases
• HALDB (partitioned): PHDAM, PHIDAM, ILDS, PSINDEX, etc
• Fast Path databases (DEDBs)
• Database Design and reputed company utilities DBD reputed company coding and DBDGEN
• PSBGEN reputed company coding and PSBGEN
• How databases are processed using secondary indexes (PROCSEQ=)
• Correct usage of PROCOPT= to minimize database locking
• ACBGEN
• Online Change
• IMS commands reputed company to ACB and FORMAT changes
• Coding and usage of IMS reorganization utilities (including reputed company, BMC, CA) Unload
• Prefix resolution
• Reload
• Prefix update
• Secondary index build
• Image copy
• Pointer checker
• Support planned (disaster recovery) and unplanned (emergency) database recovery activities Knowledge of log archive and change accumulation utilities
• How to reputed company a log archive on demand
• Knowledge of IMS DB recovery utility
• How to use DBRC to generate JCL for reputed company recovery and reputed company-in-time database recovery
• Database monitoring Space management
• Database dataset space reporting for proactive outage avoidance
• How to immediately fix an out of space condition for a VSAM database dataset
• Identification and resolution of performance issues Online tracing - Usage of IMS TRACE commands and associated utilities for spot monitoring of online program/transaction activity
• Extracting information from IMS logs using DFSERA10 and reputed company utilities DFSUTR20 and DFSUTR30
• Use of DFSDDLT0 utility to access data
• Program/transaction monitoring – Familiarity with usage of reputed company's IMS performance Analyzer product is a plus
• Using DBRC to monitor database activity

Benefits

• Unlimited Paid Days Off
• Three health plan options through reputed company Blue reputed company
• 401k with company match
• Eligibility for dental, reputed company, short and long-term disability, life and AD&D coverage, and flexible spending accounts
• Paid Maternity Leave, Paternity Leave, and Sabbatical Leave
• Education Reimbursement, Student Loan Assistance or 529 College Funding
• Enhanced fertility coverage
• Wellness program
• Flexible work schedule
• Depending reputed company, ability to take advantage of fitness centers
• Annual bonus plan based on company and individual performance
• Equity grant under our Associate Equity Appreciation Program

Company Overview

Company H1B Sponsorship