IMS Database Administrator

2 weeks ago

Dallas, United States Wise Skulls llc Full time
Job DescriptionJob Description

Job Title: IMS Database Administrator
Location: Dallas, TX or Charlotte, NC Only Local
Duration: Long Term

Interview : F2F
Implementation Partner: Mphasis
End Client: TBD

The IMS Database Administrator creates, maintains, designs, monitors and troubleshoots client databases. They use specific relational database management systems, develop and implement database recovery mechanisms and procedures. And coordinate security measures to safeguard database integrity.
Key Areas of Focus for this Role
  • The successful candidate will perform mainframe database software upgrades coupled with administration and tuning to support IMS environments.
  • 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 called upon to perform 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.
Required Qualifications
  • Bachelor's degree required and/or equivalent work experience.
  • 5+ years of professional experience in IMS for administration and systems programming support. CA and IBM tools for IMS a plus
  • Knowledgeable in best practices of software management, maintenance and documentation
  • Configure and manage IMS in a parallel sysplex environment
  • Develop innovation, strategies, processes and best practices in IMS systems programming
  • Establishing policies and procedures pertaining to database management, DR, security, 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
Other Qualifications
  • 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 related utilities
  • DBD source coding and DBDGEN
  • PSBGEN source coding and PSBGEN
  • How databases are processed using secondary indexes (PROCSEQ=)
  • Correct usage of PROCOPT= to minimize database locking
  • ACBGEN
  • Online Change
  • IMS commands related to ACB and FORMAT changes
  • Coding and usage of IMS reorganization utilities (including IBM, BMC, CA), including: unload, prefix resolution, reload, prefix update, secondary index build, image copy, and pointer checker
  • Support planned (disaster recovery) and unplanned (emergency) database recovery activities
  • Knowledge of log archive and change accumulation utilities
  • How to perform a log archive on demand
  • Knowledge of IMS DB recovery utility
  • How to use DBRC to generate JCL for forward recovery and point-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 related utilities DFSUTR20 and DFSUTR30
  • Use of DFSDDLT0 utility to access data
  • Program/transaction monitoring Familiarity with usage of IBM's IMS performance Analyzer product is a plus
  • Using DBRC to monitor database activity

  • IMS Database Administrator and System programming knowledge

    Found in: Appcast Linkedin GBL C2 - 3 days ago

    Dallas, United States Smart IT Frame LLC Full time

    Experience Level: 10 YearsKey Areas of Focus for this Role· The successful candidate will perform mainframe database software upgrades coupled with administration and tuning to support IMS environments.· The individual will be responsible for day-to-day database maintenance such as creating backups, performing restores, monitoring file extent growth,...

  • IMS Database Administrator and System programming knowledge

    3 days ago

    Dallas, United States Smart IT Frame LLC Full time

    Experience Level: 10 YearsKey Areas of Focus for this Role· The successful candidate will perform mainframe database software upgrades coupled with administration and tuning to support IMS environments.· The individual will be responsible for day-to-day database maintenance such as creating backups, performing restores, monitoring file extent growth,...

  • IMS Database Administrator and System programming knowledge

    Found in: Appcast US C2 - 3 days ago

    Dallas, United States Smart IT Frame LLC Full time

    Experience Level: 10 YearsKey Areas of Focus for this Role· The successful candidate will perform mainframe database software upgrades coupled with administration and tuning to support IMS environments.· The individual will be responsible for day-to-day database maintenance such as creating backups, performing restores, monitoring file extent growth,...

  • IBM IMS DBA

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago

    Dallas, United States Ampstek Full time

    The IMS Database Administrator creates, maintains, designs, monitors and troubleshoots client databases. They use specific relational database management systems, develop and implement database recovery mechanisms and procedures. And coordinate security measures to safeguard database integrity.Required Qualifications• Bachelor’s degree required and/or...

  • IBM IMS DBA

    1 week ago

    Dallas, United States Ampstek Full time

    The IMS Database Administrator creates, maintains, designs, monitors and troubleshoots client databases. They use specific relational database management systems, develop and implement database recovery mechanisms and procedures. And coordinate security measures to safeguard database integrity. Required Qualifications Bachelors degree required and/or...

  • IBM IMS DBA

    Found in: Appcast US C2 - 2 weeks ago

    Dallas, United States Ampstek Full time

    The IMS Database Administrator creates, maintains, designs, monitors and troubleshoots client databases. They use specific relational database management systems, develop and implement database recovery mechanisms and procedures. And coordinate security measures to safeguard database integrity.Required Qualifications• Bachelor’s degree required and/or...

  • IBM IMS DBA

    Found in: Lensa US P 2 C2 - 3 hours ago

    Dallas, United States Ampstek Full time

    The IMS Database Administrator creates, maintains, designs, monitors and troubleshoots client databases. They use specific relational database management systems, develop and implement database recovery mechanisms and procedures. And coordinate security measures to safeguard database integrity.Required Qualifications Bachelor's degree required and/or...

  • IBM IMS DBA

    1 week ago

    Dallas, United States Ampstek Full time

    The IMS Database Administrator creates, maintains, designs, monitors and troubleshoots client databases. They use specific relational database management systems, develop and implement database recovery mechanisms and procedures. And coordinate security measures to safeguard database integrity. Please make an application promptly if you are a good match for...

  • Database Administrator

    2 weeks ago

    Dallas, United States Uvation Full time

    About the Database Administrator position We are looking for a professional database administrator (DBA) who will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users. You should be capable of productive...

  • Database Administrator

    3 days ago

    Dallas, United States Siri InfoSolutions Inc Full time

    Job DescriptionJob DescriptionDatabase Administrator Contract Duration: 6-12months, contract to hireLocation: Onsite Hybrid (Tues, Wed, Thurs) in Plano, TXJob Highlights: Database Administrator experience Manage automation scripts for rehydration of servers in AWSManage solution for SQL Server in AWS environment AWS technology experience SQL/DevOps...

  • SQL Database Administrator

    Found in: Appcast Linkedin GBL C2 - 1 week ago

    Dallas, United States CDW Full time

    CDW is seeking a SQL Database Administrator for a long-term contract opportunity in the Dallas, TX area.Job Type: Long-term contract that will continue to renew annually Location: 70% remote, 30% onsite in Dallas, TXStart: ASAPPay Rate: Open, based on experienceJob Description:We are seeking a skilled SQL Database Administrator. The ideal candidate will have...

  • SQL Database Administrator

    1 week ago

    Dallas, United States CDW Full time

    CDW is seeking a SQL Database Administrator for a long-term contract opportunity in the Dallas, TX area.Job Type: Long-term contract that will continue to renew annually Location: 70% remote, 30% onsite in Dallas, TXStart: ASAPPay Rate: Open, based on experienceJob Description:We are seeking a skilled SQL Database Administrator. The ideal candidate will have...

  • SQL Database Administrator

    Found in: Appcast US C2 - 1 week ago

    Dallas, United States CDW Full time

    CDW is seeking a SQL Database Administrator for a long-term contract opportunity in the Dallas, TX area.Job Type: Long-term contract that will continue to renew annually Location: 70% remote, 30% onsite in Dallas, TXStart: ASAPPay Rate: Open, based on experienceJob Description:We are seeking a skilled SQL Database Administrator. The ideal candidate will have...

  • Senior Database Administrator

    Found in: Appcast Linkedin GBL C2 - 3 weeks ago

    Dallas, United States Tucker Parker Smith Group (TPS Group) Full time

    Aurora Postgres Database Administrator Location: California (remote)Pay Rate: $87.59/hr.6-month assignment (potential to extend)Our leading ride share client is looking for a Postgres database administrator that will ensure reliability, scalability, security, and cost-effectiveness of Aurora Postgres databases running on AWS...

  • Senior Database Administrator

    Found in: Appcast US C2 - 3 weeks ago

    Dallas, United States Tucker Parker Smith Group (TPS Group) Full time

    Aurora Postgres Database Administrator Location: California (remote)Pay Rate: $87.59/hr.6-month assignment (potential to extend)Our leading ride share client is looking for a Postgres database administrator that will ensure reliability, scalability, security, and cost-effectiveness of Aurora Postgres databases running on AWS...

  • Oracle Database Administrator

    Found in: Appcast US C2 - 1 week ago

    Dallas, United States Themesoft Inc. Full time

    Enterprise Database Management is the CoE for database management within Client. This position provides senior level capabilities relative to database administration for the company. The person filling this position must be able to: • Develop operational policies, procedures, controls and standards • Develop, implement and maintain automation...

  • Oracle Database Administrator

    Found in: Appcast Linkedin GBL C2 - 1 week ago

    Dallas, United States Themesoft Inc. Full time

    Enterprise Database Management is the CoE for database management within Client. This position provides senior level capabilities relative to database administration for the company. The person filling this position must be able to: • Develop operational policies, procedures, controls and standards • Develop, implement and maintain automation...

  • Oracle Database Administrator

    1 week ago

    Dallas, United States Mastech Digital Full time

    Role: Database AdministratorLocation: WLK, TX/ Durham, NC/ MMK, NH/ Boston, MA or Smithfield/RIJob Type: Full time/ Permanent role Must Have Skills10+ years of IT database experienceAWS SkillsNeo4JDB expertiseResponsibilitiesRequires in depth knowledge on supporting and troubleshooting Databases like Cockroach, DB , Neo4j, Azure, SQLMI, Azure MySQLBuild,...

  • Oracle Database Administrator

    Found in: Lensa US P 2 C2 - 41 minutes ago

    Dallas, United States Mastech Digital Full time

    Role: Database AdministratorLocation: WLK, TX/ Durham, NC/ MMK, NH/ Boston, MA or Smithfield/RIJob Type: Full time/ Permanent roleMust Have Skills10+ years of IT database experienceAWS SkillsNeo4JDB expertiseResponsibilitiesRequires in depth knowledge on supporting and troubleshooting Databases like Cockroach, DB , Neo4j, Azure, SQLMI, Azure MySQLBuild,...

  • Oracle DBA L3 Database Administrator Support

    Found in: Lensa US P 2 C2 - 47 minutes ago

    Dallas, United States Diverse Lynx Full time

    Job Title Oracle DBA L3 Database Administrator Support Relevant Experience (in Yrs) 7-10 Years Technical/Functional Skills We are looking for a core technical person, who has hands-on Database administration experience on UNIX/Linux and/or worked as L3 level support engineer and/or having equivalent knowledge. They should possess the following...