IT
Job DescriptionRole: Mainframe DB2 systems programmer
Location: Frisco, TX
Duration: Fulltime
BGV will be done for the selected candidates.
Qualification
Minimum 10 to 20 Years of Experience.
Scope of Work
The scope of effort includes all items identified below. The candidate needs to have a good level working knowledge of the Mainframe Database (DB2) identified within.
In support of the task, the candidate shall perform the activities such as those described within.
Work Experience Knowledge Skills & Abilities:
Drive architecture roadmap, reference architecture and standard efforts. Provide leadership in all technical aspects of assigned projects, programs and portfolios
Architect complex end-to-end solutions across distributed, host and business intelligence environments
Functional experience is required with the following technologies:
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 etc.
Online utilities -CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc.
Please respond with your word resume and requested details:
Full Name :
Work Authorization:
Contact Number :
Email ID :
Skype ID:
Current location:
Willing to relocate :
Salary :
All your information will be kept confidential according to EEO guidelines.
Skills Required
- Minimum 10 to 20 Years of Experience
- Expertise in DB2 administration on z/OS
- Strong knowledge of database performance tuning
What We Do
Infoways specializes in providing comprehensive consulting, implementation, migration, upgrade, solution development, customizations, functional testing, user training, interface development, and support services for Infor solutions. Our expertise extends to Extensibility, ION, and Report Designer, enabling us to tailor solutions precisely to your requirements. We pride ourselves on our client-centric approach, ensuring that your needs are at the forefront of everything we do. Our services include functional and technical support, admin support, system availability management, incident support, trend analysis, and ticket reduction, among others, all aimed at enhancing your experience and maximizing the value of your Infor investments. Furthermore, our software development capability is at the forefront of innovation. For instance, we are currently enhancing applications in the Financial Services sector using Blockchain technology, showcasing our commitment to leveraging the latest technologies to drive meaningful change for our clients. Infoways offers flexible engagement models and has cultivated a robust talent pool of global resources with expertise in various technologies, including BaaN/LN, M3, Lawson S3, and more. Our team is well-versed in Agile methodology and SDLC best practices, ensuring that projects are delivered on time and within budget. If you are interested in knowing more about how Infoways can support your business and enhance your Infor experience, please let us know. We would be delighted to schedule a meeting with our team at your convenience to discuss Let's Connect We believe in the power of collaboration. Whether you're a client, partner, or future team member, let's embark on this journey together. 📧 [email protected] ☎ 609-718-0720 Join us at Infoways as we navigate the digital landscape, create meaningful solutions, and build a future where innovation knows no bounds.
