Mainframe DB2 DBA

4 weeks ago

Salem, United States OneAPPS Consulting Full time

OneAPPS is a Technology consulting firm based out of New York and offices across US. We are working on various projects involving diverse, multicultural teams with clients across the US. We are an invaluable partner and our teams have collaborated to support the growth of our clients. With more than 7 locations worldwide we help our clients to deliver their projects smoothly. We look forward to getting to know you and working with you.


Title: Mainframe DB2 DBA

Location: Salem, OR – REMOTE Full time - (6 months /1040 hrs)

Duration: 12 months contract


Our remote client is searching for an experienced senior DB2 database administrator to assist with the administration of the enterprise DB2 environment. This position will focus on providing expert consultation to management, DRM staff, technical, and business stakeholders.

The Key Person will participate in the Mainframe Modernization project by applying their skills and experience to manage both IBM DB2 databases for Unix and Mainframe operating systems.

The Key Person will perform data refreshes in development, test, and UAT environments, assist in the deprecation of legacy DB2 databases, and troubleshoot and resolve DB2 job and database issues. They will plan and implement DB2 upgrades and patches, support the export and load of production data, and provide support for batch jobs on zOS, including job scheduling, monitoring, and troubleshooting. The Key Person will also offer DBA support for applications running on AIX, zOS, and Linux platforms, support Java-based applications using JDBC and SQLJ, and create and manage JCL jobs to automate database and system tasks.

Additionally, the Key Person will design, create, implement, maintain, tune, and support DB2/UDB databases on AIX and z/OS platforms. They will manage tables and indexes, promote changes to various subsystems including production, and provide on-call coverage for OLTP applications on the zOS platform. The Key Person will develop and maintain UNIX shell scripts to monitor table space usage and buffer pool usage, work with ETL tools to extract DB2 data from zOS to staging tables on distributed platforms and develop ETL routines using DB2 load/unload utilities, DB2 Connect, and other data warehousing tools.

Finally, the Key Person will provide ongoing technical assistance and education to application developers and business analysts for DB2, COBOL, JCL, and SQL. They will conduct performance analysis and identify tuning opportunities to enhance database performance, implement and manage recovery strategies using RMAN, and provide schema development and system configuration support for application developers. The Key Person will also work with developers to diagnose and resolve database-related application issues, supporting schema maintenance and data distribution.

Specific DBMS Skills:

Extensive knowledge of DB2 on z/OS and AIX.

Knowledge of SQL construction and optimization.

Understanding of data base connectivity to DB2 z/OS from SQL-Server, WebSphere, Cold fusion, Business objects, LUW, MS-Access, Toad, Oracle, etc.

Extensive knowledge of z/OS, OMVS, CICS basics, utilities, RACF and dataset and Access Control.

AIX security, scripting and monitoring experience.


If this role sounds like you, we invite you to apply. Thanks.

  • Mainframe DB2 DBA

    3 weeks ago

    Salem, United States OneAPPS Consulting Full time

    OneAPPS is a Technology consulting firm based out of New York and offices across US. We are working on various projects involving diverse, multicultural teams with clients across the US. We are an invaluable partner and our teams have collaborated to support the growth of our clients. With more than 7 locations worldwide we help our clients to deliver their...

  • Mainframe DB2 DBA

    4 weeks ago

    Salem, United States OneAPPS Consulting Full time

    OneAPPS is a Technology consulting firm based out of New York and offices across US. We are working on various projects involving diverse, multicultural teams with clients across the US. We are an invaluable partner and our teams have collaborated to support the growth of our clients. With more than 7 locations worldwide we help our clients to deliver their...

  • Sr. DB2 Database Administrator

    1 week ago

    Salem, United States Mavensoft Technologies Full time

    Job Title: Sr. DB2 Database Administrator Duration: 6 Months (contract on W2) Location: Salem, OR (Remote) Description: Seeking a highly experienced Senior DB2 Database Administrator for a part-time role. Client provides critical technology systems and services to over 18,000 agency staff across the state, supporting essential functions such as client...

  • DB2 Database Administrator

    4 weeks ago

    Salem, United States InnovitUSA Full time

    Job DescriptionJob DescriptionDB2 Database Administrator Salem, Oregon RemoteTax Terms: C2C,W2 And 1099. Scope of Work:As part of the Office of Information Services (OIS), Technology Platform Data Resources Management Team (DRM) is searching for an experienced senior DB2 database administrator to assist with the administration of the enterprise DB2...

  • DB2 Database Administrator IV

    4 weeks ago

    Salem, United States Ark Solutions Full time

    Ark Solutions Inc is looking for DB2 Database Administrator IV (Part-time)!Position: DB2 Database Administrator IV (Part-time) Location: REMOTE Duration: 12 Months and possibility of extension Description: As part of the Technology Platform - Data Resources Management Team (DRM) is searching for an experienced senior DB2 database administrator to assist with...

  • Database Administrator

    4 weeks ago

    Salem, United States BayOne Solutions Full time

    Title: Database Administrator (DB2)Specific DBMS Skills:· Extensive knowledge of DB2 on z/OS and AIX.· Knowledge of SQL construction and optimization.· Understanding of data base connectivity to DB2 z/OS from SQL-Server, WebSphere, Cold fusion, Business objects, LUW, MS-Access, Toad, Oracle, etc.· Extensive knowledge of z/OS, OMVS, CICS basics,...

  • Database Administrator

    4 weeks ago

    Salem, United States BayOne Solutions Full time

    Title: Database Administrator (DB2)Specific DBMS Skills:· Extensive knowledge of DB2 on z/OS and AIX.· Knowledge of SQL construction and optimization.· Understanding of data base connectivity to DB2 z/OS from SQL-Server, WebSphere, Cold fusion, Business objects, LUW, MS-Access, Toad, Oracle, etc.· Extensive knowledge of z/OS, OMVS, CICS basics,...

  • Mainframe Software Developer

    3 weeks ago

    Salem, United States nLeague Full time

    Mainframe Software Development Location: Salem OR Duration: 12 Months Client: ODOT Job Id: B36991W109 100% Remote job Computer systems specialists provide technical guidance for the development and troubleshooting of computer systems. They identify system data, hardware or software components required to meet user needs. They also develop guidelines for...

  • Mainframe Software Developer

    3 weeks ago

    Salem, United States nLeague Full time

    Job DescriptionJob DescriptionMainframe Software DevelopmentLocation: Salem ORDuration: 12+ MonthsClient: ODOTJob Id: B36991W109100% Remote jobComputer systems specialists provide technical guidance for the development and troubleshooting of computer systems. They identify system data, hardware or software components required to meet user needs. They also...

  • Sr. Mainframe Developer

    2 weeks ago

    Salem, United States Jsvvsols Full time

    Job DescriptionJob DescriptionRole: Sr. Mainframe DeveloperLocation: Salem, OR - RemoteResponsibilities:Provide C# software development efforts related to CCAD initiatives.Provide COBOL software development efforts related to CCAD initiatives.Provide JCL development related to mainframe work.Provide CICS development related to mainframe work.Provide coding...

  • .NET & Mainframe (COBOL) Developer

    2 weeks ago

    Salem, United States Smart IMS Full time

    .NET & Mainframe (COBOL) Developer Remote Role Computer systems specialists provide technical guidance for the development and troubleshooting of computer systems. They identify system data, hardware or software components required to meet user needs. They also develop guidelines for implementing secure systems to customers or installation teams. May require...

  • Senior System Analyst

    11 hours ago

    Salem, Oregon, United States ASR Tech Group Inc. Full time

    About the RoleASR Tech Group Inc. is seeking a highly skilled Senior System Analyst to join our team in mainframe software development. As a key member of our team, you will be responsible for providing technical guidance and expertise in the development and troubleshooting of computer systems.Key ResponsibilitiesTechnical Guidance: Provide technical...

  • Database Administrator IV

    4 weeks ago

    Salem, United States InnovitUSA Full time

    Job DescriptionJob DescriptionDatabase Administrator IVSalem, Oregon RemoteTax Terms: C2C,W2 And 1099. Scope of Work:As part of the Office of Information Services (OIS), Technology Platform Data Resources Management Team (DRM) is searching for an experienced senior DB2 database administrator to assist with the administration of the enterprise DB2...

  • Database Administrator

    4 weeks ago

    Salem, United States Software Technology Inc. Full time

    Title: DB2 Database Administrator IVLocation: Salem OR(Remote)Duration: 12+ Months***Please note that this is a part-time role lasting for a full year. 4 hrs a Day from 8 AM to 12 PM PST***Scope of Work:As part of the Office of Information Services (OIS), Technology Platform – Data Resources Management Team (DRM) is searching for an experienced senior DB2...

  • System Specialist

    2 weeks ago

    Salem, United States United Software Group Inc Full time

    Job Title: System SpecialistSalem ORLong term ContractRole Overview:We are seeking a System Specialist to support ODOT’s Commerce & Compliance Application Development (CCAD) team. This role involves mainframe software development, including C# and COBOL, as well as JCL, CICS, and DB2/SQL Server DBMS integration.Key Responsibilities:Develop and maintain C#...

  • Senior Systems Analyst

    1 week ago

    Salem, Oregon, United States Integrated Resources Full time

    Job Title: Senior Systems Analyst Location: Remote Duration: 6+ MonthsJob Overview:As a key contributor, the Senior Systems Analyst will offer expert technical support for the design and resolution of computer systems. The role involves determining the necessary system data, hardware, or software components to fulfill user requirements. Additionally, the...

  • System Specialist IV

    3 months ago

    Salem, United States Integrated Resources Full time

    Job Title: System Specialist IV Location: Salem, OR (100% Remote) Duration: 6+ MonthsJob Description: Computer systems specialists provide technical guidance for the development and troubleshooting of computer systems. They identify system data, hardware or software components required to meet user needs. They also develop guidelines for implementing secure...

  • System Specialist IV

    2 weeks ago

    Salem, United States Integrated Resources Full time

    Job Title: Systems Specialist/Mainframe Developer Duration: 6+ Months. Location: Salem, Oregon, 97301 (Remote)Job Description: Computer systems specialists provide technical guidance for the development and troubleshooting of computer systems. They identify system data, hardware or software components required to meet user needs. They also develop guidelines...

  • System Specialist

    7 days ago

    Salem, United States Apex Informatics Full time

    Computer systems specialists provide technical guidance for the development and troubleshooting of computer systems. They identify system data, hardware or software components required to meet user needs. They also develop guidelines for implementing secure systems to customers or installation teams. May require a bachelor's degree in a related area with at...

  • System Specialist IV

    3 months ago

    Salem, United States Global Pharma Tek Full time

    Job Title: System Specialist IV Job Location: Salem OR Duration: 12 Months, Remote Job Description Computer systems specialists provide technical guidance for the development and troubleshooting of computer systems. They identify system data, hardware or software components required to meet user needs. They also develop guidelines for implementing secure...