Add office photos
All Filters
34 Sourced Group Jobs
DB Administrator - IMS / DB2
Sourced Group
posted 27d ago
Job Role Insights
Key skills for the job
Job Description
The DB administrator is handling physical and applicative database administration activities supporting end 2 end life cycle of product from database perspective
What will your job look like
- You will support the following levels: Physical - responsible for the physical and technical oriented aspects e.g. storage, security, networking and more; Application - you will handle all application-related issues (e.g. queries, users, embedded SQL s 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, assist them with database structure design as of business needs (e.g. indexes, constraints, integrity)
All you need is...
- IMS DBA experience:
IMS DB 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 - FileManager, ADBUS
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
DB2 privileges and RACF
z/OS - TSO, ISPF, JCL.
Tools - DB2 Admin tool, QMF, FileManager, Changeman, ESP.
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
DB2 privileges and RACF
z/OS - TSO, ISPF, JCL.
Tools - DB2 Admin tool, QMF, FileManager, Changeman, ESP.
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!
Employment Type: Full Time, Permanent
Read full job descriptionCompare Sourced Group with
TCS
Compare
Accenture
Compare
Wipro
Compare
Cognizant
Compare
Capgemini
Compare
HDFC Bank
Compare
ICICI Bank
Compare
Infosys
Compare
HCLTech
Compare
Tech Mahindra
Compare
Genpact
Compare
Teleperformance
Compare
Concentrix Corporation
Compare
Axis Bank
Compare
Amazon
Compare
Jio
Compare
Reliance Retail
Compare
IBM
Compare
iEnergizer
Compare
LTIMindtree
Compare
Similar Jobs for you
Share an Interview