DB Administrator (IMS-DB2 DBA)

Who are we?

Amdocs helps those who build the future to make it amazing. With our market-leading portfolio of software products and services, we unlock our customers’ innovative potential, empowering them to provide next-generation communication and media experiences for both the individual end user and enterprise customers. Our 30,000 employees around the globe are here to accelerate service providers’ migration to the cloud, enable them to differentiate in the 5G era, and digitalize and automate their operations. Listed on the NASDAQ Global Select Market, Amdocs had revenue of $4.3 billion in fiscal 2021. For more information, visit Amdocs at www.amdocs.com

In one sentence

The DB administrator is handling physical and applicative database administration activities supporting end-to-end life cycle of product from database perspective

What will your job look like?

** Preferred work locations can be in Dallas, Atlanta or St. Louis **

• You will support the following levels: IMS and DB2 ADBA – you will handle all application-related issues (e.g., Schema, DB objects, users, embedded SQL’s, performance etc.)
• Ensure database resources are sized accurately and a design strategy is developed to make sure that the database is maintained at a healthy size
• You will ensure availability and performance of multi database and application environments with very large volumes and sizes
• You will perform routine DBA tasks like database maintenance, backups, recovery, table space management, upgrades, etc
• You will execute periodic health checks for databases and recommend changes that should be executed in the production environment to ensure efficient performance
• You will interact and work with multiple infra and IT teams as part of environment setup, maintenance, and support
• You will work closely with developers, testers and assist them with database structure design as of business needs (e.g., indexes, constraints, integrity)
  

All you need is...

3-5 years’ experience as an IMS DBA and 2-3 years’ experience as a DB2 DBA on Z/OS

IMS DBA:

• IMS DB DBA support experience with version 13 onwards
• DB Objects: Experience in creating and modifying DBD, PSB, ACB, FMT
• Experience with administration of IMS Full Function, HALDB, Fastpath databases
• Good knowledge on DBRC, Restore, Reorg, Load IMS DB
• Experience in database initialization, forward recovery & building secondary index and pointer checker, checkpoint restart, Fast path, DEDB, etc.
• Strong Knowledge of Troubleshooting skills on IMS administration
• Usage of IMS utilities (including IBM, BMC)
• Working Knowledge of RACF as it relates to IMS
• Working Knowledge of IMS exit points and routines
• z/OS – TSO, ISPF, JCL
• Tools – File Manager
• Basic knowledge on VSAM, CICS, IMS DC
  

DB2 DBA on Mainframe(Z/OS):

• DB Objects – Experience in creating and modifying DB2 objects - Database, Storage Group, Tablespace, Tables, Views, Indexes, etc.
• Experience with DB2 commands: Stop/Start Databases, Display command, Cancel thread and Term & Display utility, others
• Hands on experience on DB2 utilities: Reorg and Runstat, Backup and Recovery of Table spaces (copy & recover), Repair, Load/Unload utilities
• Ability to bind/rebind the Plans/Packages and Granting required accesses to Packages/Plans/Collections
• Experience in Database Monitoring
• Experience in Database replication – IBM DB2 Data Propagator
• DB2 administration - Strong Troubleshooting skills and DB2 privileges and RACF
• z/OS – TSO, ISPF, JCL
• Tools – DB2 Admin tool, QMF, FileManager, Changeman, ESP
  

Even better if you have...

• REXX development experience
• COBOL code understanding
  

Why you will love this job:

• Drive growth by constantly looking for opportunities to bring more value to new and existing customers. Calling upon your superb communication skills and the ability to clearly translate business benefits that our service offerings provide.
• You will be a key member of a global, dynamic and highly collaborative team with various possibilities for personal and professional development
• Join us in our expanding organization, with ever growing opportunities for personal growth and one of the highest scores of employee engagement in Amdocs!
• We provide stellar benefits that range from health insurance to paid time off, sick leave, and parental leave!