DB2 Database Administrator

4 weeks ago

Salem, United States InnovitUSA Full time
Job DescriptionJob Description

DB2 Database Administrator

Salem, Oregon

Remote

Tax 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 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.

Tasks:

Data Operations:

Diagnoses and resolves complex problems for critical state systems, often requiring high-level coordination with IS staff and multiple vendors, including conflict resolution.

Provides expertise to other IS staff, assisting with major system crashes and establishing procedures for problem diagnosis and resolution.

Communicates effectively with customers in both oral and written forms, and coordinates training for assigned infrastructure functions within a diverse and dynamic system environment.

Required Skills:

Theories, principles and practices of Information Systems Technology.

Project administration methods, principles, techniques and practices.

Information systems architecture.

Methods and procedures for designing, developing, monitoring and maintaining databases.

Tools for constructing database structures.

Automation products that support a variety of data management environments.

General Knowledge:

Business systems and organizational structures.

Trends, technological changes and developments in IS.

Operations and business of the organization.

Skills:

Administering and managing comprehensive, multi-system projects including directing and motivating internal staff, contractors and other participants.

Identifying the scope and complexity of a project and assigning segments of that project to others.

Assigning and reviewing the work of others to determine accuracy and adequacy of identified conditions, criteria, recommendations and supporting materials.

Developing long and short-range plans to meet established goals.

Developing policies and procedures.

Analyzing organizational needs and implementing cost-effective solutions.

Determining efficient design of data structures and software applications.

Assessing new technology developments.

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.

  • 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...

  • 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,...

  • 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 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...

  • 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...

  • 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...

  • 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...

  • Database Administrator IV

    4 weeks ago

    Salem, United States V R Della Infotech Inc Full time

    Job DescriptionJob Description***Please note that this is a part-time role lasting for a full year.The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and the Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 18,000 OHA and ODHS agency...

  • Database Administrator IV

    4 weeks ago

    Salem, United States Buzzclan Full time

    Job DescriptionJob Description***Please note that this is a part-time role lasting for a full year.The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and the Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 18,000 OHA and ODHS agency...

  • Database Administrator IV

    4 weeks ago

    Salem, United States Software Technology Inc Full time

    Job DescriptionJob Description***Please note that this is a part-time role lasting for a full year.The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and the Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 18,000 OHA and ODHS agency...

  • Database Administrator IV at OR

    4 weeks ago

    Salem, United States Elite WorkForce Inc Full time

    Job DescriptionJob DescriptionPosition: Database Administrator IV Location: Salem, OR 97302 Duration: 12+ Months Job Type: Part-Time Interview: Video Local Candidate OnlyRequired Skills:Extensive experience with IBM DB2 on z/OS and AIX, including performance tuning and optimization.Proficiency in SQL construction and optimization, with a strong understanding...

  • Database Administrator IV

    4 weeks ago

    Salem, United States Amtex Systems Inc Full time

    Job DescriptionJob DescriptionData Operations: Diagnoses and resolves complex problems for critical state systems, often requiring high-level coordination with IS staff and multiple vendors, including conflict resolution. Provides expertise to other IS staff, assisting with major system crashes and establishing procedures for problem diagnosis and...

  • Database Developer

    2 weeks ago

    Winston-Salem, United States Spear Staffing Full time

    Job DescriptionJob DescriptionThis is a contract to hire (must have some exposure to Java along with the other skills, not expert level, just exposure and it needs ot be on their resume**NOTE: No relocation, candidates must be within 100 miles or so of the client. Title: Database DeveloperClient: TCHLocation: Winston-Salem, NCVisa: No H1Bs/CPT2nd and final...

  • Database Developer

    7 days ago

    Winston-Salem, United States JS Consulting Full time

    Job DescriptionJob DescriptionJob Title: SQL Developer Location: Winston-Salem, NC(2-3 days onsite in a week)Duration: Contract Interview: Webex & InpersonJob Description-:Must have some Java experience, not an expert level and this is not a Java development position but some recent exposure.8+ Years of MS SQL experience.Must understand programming - 4 years...

  • Database Developer

    1 month ago

    Winston-Salem, United States Russell Tobin Full time

    Job DescriptionJob DescriptionLocation: Winston-Salem, NC or New York, NY (Hybrid, 2 days onsite)Pay Range: $105K - $115K, depending upon experienceType: FTEThe Information Technology team at Russell Tobin & Associates is supporting a top banking association and payments company that has an opening for a Database Developer.Position summary:This is an...

  • 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#...

  • Database Developer

    4 weeks ago

    Winston-Salem, United States Techtriad Team Inc Full time

    Job DescriptionJob DescriptionThis database development position supports transaction processing and analytics for high-volume payment products (Wire, ACH, etc.). Primary responsibilities include the design, development, and modernization of core database applications. The position requires significant experience developing high-performing applications on...

  • Senior Application Systems Analyst/Programmer

    1 week ago

    Salem, Oregon, United States Generis Tek Inc Full time

    Contact Information: For inquiries regarding this exceptional opportunity, please reach out to our Talent Acquisition Specialist.We are currently seeking a Contract position for a Senior Application Systems Analyst/Programmer. This role involves collaboration with various stakeholders to enhance and maintain Legacy Applications.Position Overview:The...