Mainframe DB2 System programmer
Job ID : 25733
Job Title : Mainframe DB2 System programmer
Location : Frisco, TX
Comapny Name : QData
Job Type : contract
Industry : Information Technology
Salary : $55 - $60 per hour
Work Authorization : ["OPT","H4","Have H1 Visa","TN Permit Holder","Green Card Holder","Canadian Citizen","US Citizen"]
No. of Positions : 1
Posted on : 05-05-2020
Required Skills : Mainframe DB2 System programmer
Benefits : None of These
Job Description :
Responsibilities:-
- Upgrade/Migrate DB2 Versions to newer versions
- Regularly applying PTFS/APARS if required.
- Manage DB2 IVS Products and upgrade to supported versions if required.
- Managing system catalogs
- Manage application data and database environments, performing reorganizations when required to optimize performance
- Offline utilities - DSNJLOGF, DSNJU004, DSNJU003 etc.
- Database and related object security – manage user ids, rights and privileges
- DB2 administration on z/OS, SQL creation, DB2 command line creation and execution, DB2 performance tuning,
- Physical database definition (DDL) and understanding of logical database design
- Implement DBDC (CICS, DB2, or IMS) base software installs and upgrades
- Implement DBDC (CICS, DB2, or IMS) related product installs and upgrades
- Implement DBDC (CICS, DB2, or IMS) security compliance corrections
- Monitoring – threads, table space and index spaces.
- Monitoring instances for events and resolution/escalations
- Performance tuning – Database and SQL tuning
- DB2 recycle
- DB2 Image copy (full/incremental)
- Database creation
- Grant/revoke of authorities
- DB2 archive logs
- Having experience of DR setup through various synch methods
- Build and maintenance of database and related objects like table space, tables, indexes, views, triggers
- Online utilities -CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc.
Years of Experience:-
- Total : Above 8+ Years of experience.
- Relevant : Minimum of 8 yrs in DB2 UDB on z/OS.
Company Details :
Company Information hidden please Login to view details
Program Manager
Comapny Name :Twelve Labs
Job Location :New York, NY
Job Description:
Responsibilities: Drive risk management review for business demands, identify privacy/security risks and find viable risk mitigation measures, ensure timely deliv
View Job
Quality Data Analyst
Comapny Name :Matal
Job Location :Austin, TX
Job Description:
Responsibilities: Provide input to Quality, Manufacturing and Engineering teams for new product development and product improvement programs. Review an
View Job
Sr Data Analyst
Comapny Name :wipros
Job Location :San Antonio, TX
Job Description:
Responsibilities: Establish reporting standards and best practices. Architect and implement a reporting framework. Develop programs, methodo
View Job