IBM DB2 LUW Database Systems Administrator

2 days ago

Downey, United States Tech Providers Inc. Full time


Position : IBM DB2 LUW Database Systems Administrator
Location: Downey, CA 90242 (Hybrid)
Duration :12+ month contract with possibility of extension.
Skills Required:
The Technical Architect will possess knowledge and experience in analyses and development of conceptual designs and detail designs; developing JBOSS Messaging and connectivity with Spring-JMS connectivity; designing DB schema as per the requirements and in sync with the old system; implementing the daily and weekly jobs that interact with external interfaces; coordinating with business stakeholders to understand their requirements; communicate with cross-divisional personnel at both team and executive levels to understand performance measurement methodologies; and direct team members in compiling business requirements and executing project milestones.
 
Skills Preferred:
Ability to administer IBM DB2 LUW database systems; skilled to perform IBM DB2 LUW tuning including SQL tuning; ability to perform IBM DB2 database backup, restore, and disaster recovery design and deployments; able to automate routine daily IBM DB2 database system management tasks such as database deployments and refreshes.
Possess excellent communication skills to effectively interact with internal and external management teams, developers, network, and infrastructure teams.
Possess skills to install/upgrade IBM DB2 LUW databases from lower version to latest supported version such as 11.1.x and above.
Possess skills to install, maintain, support IBM DB2 LUW server software and related features including HADR with auto failover.
Possess skills to install, maintain, support IBM DB2 LUW Client on Linux and Windows platforms.
Possess skills to install, maintain, support IBM DB2 LUW monitoring software such as IBM DB2 Data Management Console and recommend improvements for operational efficiency, following best practices.
Ability to create project plans for major tasks assigned.
Ability to provide technical support and maintenance of the IBM DB2 LUW database systems to ensure their integrity, availability, and performance.
Ability to document and refine database upgrade procedures following best practices and store on the section's MS SharePoint site.
Possess skills to collaborate effectively with customer application groups and technical support groups to resolve performance and/or technical issues.
Possess skills to perform capacity planning, space management, and data maintenance tasks for IBM DB2 LUW database systems including management of data and log files.
Possess skills to perform database backup/recovery of IBM DB2 LUW databases utilizing enterprise class backup software such as CommVault.
Possess skills to prepare change management documents using an enterprise class change management tool such as Cherwell.
Possess skills to manage and maintain security to IBM DB2 LUW systems via authentication and authorization of access users following best practices.
Possess skills to support ADABAS/Natural database systems following the section's established processes and procedures.
Possess skills to provide 24x7x365 database systems support of IBM DB2 LUW and ADABAS/Natural database systems for troubleshooting and problem resolution, including after-hours and weekends, as needed to maintain maximum system uptime and minimize service disruptions.
Jenkins, Ansible, MS PowerShell for workflow automation; MS Azure SQL and related Azure technologies; MS SQL Server Always on clustering services on SQL Server 2016 and above.
 
Experience Required:
This classification must have a minimum of eight (8) years of experience in systems development, analysis, programming, or testing.
 
Experience Preferred:
10+ years’ experience in the following: IBM DB2 LUW database systems administration, including installing and upgrading to new versions and applying maintenance processes; install, configure, maintain, troubleshoot HADR auto failover. Developing automation scripts using WMI, PowerShell, Perl, Python, Jenkins, Ansible, or Unix/Linux shell scripts etc.
Using a DevOps GIT source code management tool.
Five+ years’ experience of the following:
Working with IBM DB2 LUW database systems in a RedHat Linux platform environment, installing new software releases, applying maintenance patches and fixes, and performing regular database administration support services including monitoring and troubleshooting.
Working with IBM Data Management Console, installing and configuring new releases, and setting up monitoring profiles.
Supporting, monitoring, and troubleshooting ADABAS/Natural database systems.
Utilizing DBeaver to monitor DB2 resources and usage. Supporting Linux RedHat database systems running in a VMware virtualized platform.
Managing systems in any Cloud platform such as Amazon Web Services, Microsoft Azure, Google Cloud Platform, or Oracle Cloud Infrastructure.
SQL Server installations, configurations, management and monitoring, and system administration tasks at the level of a SQL Server Database System Administrator.
Managing large MS SQL Server farms (300+ servers).
Developing scripts to automate routine manual database server functions using tools such as Jenkins, Ansible, or similar tools.
Migrating and upgrading SQL Server to the latest supported version; experience migrating SQL Servers on premise to MS Azure.
Building and managing Azure SQL Managed Instance services.
Building, configuring, and managing MS SQL Server Always On cluster services.
Working with Commvault Backup client as a tool to perform SQL Server database Backup and Restore including the experience managing SQL Server backup and restore in native SQL Server Management Studio.
Microsoft SQL Server experience on SQL Server 2016 and above.
 
Education Required:
This classification requires the possession of a bachelor’s degree in an IT-related or Engineering field.
Additional qualifying experience may be substituted for the required education on a year-for-year basis.
 
Education Preferred:
IBM DB2 Database Administrator Certification
 
Additional Information:
Local to Southern California.
A hybrid work schedule (onsite plus remote) will be discussed in the interview.

  • DB2/ Coolgen systems programmer/Storage Administrator

    2 weeks ago

    Downey, United States CodeForce Full time

    Position Description: A Mainframe Systems Programmer/DBA is responsible for leading and/or supporting the most complex database upgrade projects, modification, installation, testing, implementation, maintenance and enhancements of new or existing system software products. This classification must plan, install, configure, test, implement and manage core...

  • DB2/IMS Systems programmer/DBA

    3 weeks ago

    Downey, United States US Tech Solutions Full time

    Position Description A Mainframe Systems Programmer/DBA is responsible for leading and/or supporting the most complex database upgrade projects, modification, installation, testing, implementation, maintenance and enhancements of new or existing system software products. This classification must plan, install, configure, test, implement and manage core...

  • DB2/IMS Systems programmer/DBA

    2 weeks ago

    Downey, United States Russell Tobin & Associates Full time

    What are we looking for in our DB2/IMS Systems programmer/DBA? Russell Tobin's client, An entertainment, manufacturing, and international trade capital of the U.S. is hiring a COBOL/Mainframe Programmer to work in Downey, CA (Initial Onsite then Remote) Apply Now! Employment Type: Contract/Initial Onsite then Remote Location:...

  • Mainframe System Programmer

    2 weeks ago

    Downey, United States JRD Systems Full time

    Job title: Mainframe Systems ProgrammerLocation: Downey, CA (Hybrid)Duration: Long term*W2 Only*Description:A Mainframe Systems Programmer/DBA is responsible for leading and/or supporting the most complex database upgrade projects, modification, installation, testing, implementation, maintenance and enhancements of new or existing system software products....

  • Mainframe Systems Programmer

    1 week ago

    Downey, California, United States JRD Systems Full time

    Mainframe Systems Programmer/DBA Job DescriptionJRD Systems is seeking a highly skilled Mainframe Systems Programmer/DBA to lead and/or support complex database upgrade projects, modification, installation, testing, implementation, maintenance, and enhancements of new or existing system software products.Key Responsibilities:Plan, install, configure, test,...

  • Mainframe Systems Administrator

    3 weeks ago

    Downey, California, United States JRD Systems Full time

    Mainframe Operator Job DescriptionJob Summary: JRD Systems is seeking a highly skilled Mainframe Operator to join our team. As a Mainframe Operator, you will be responsible for managing all aspects of work for the IBM mainframe systems, ensuring the health and normal operation of the systems.Key Responsibilities:Start and stop system tasks, monitor system...

  • Senior Mainframe Systems Programmer

    4 weeks ago

    Downey, California, United States JRD Systems Full time

    Essential SkillsThe Mainframe Database Systems Specialist at JRD Systems oversees various database types, including Hierarchical (IMS), relational (DB2), and file-based (ADABAS).Accountable for the strategic planning and enhancement of database environments as per organizational standards.Ensures the integrity and performance of all database systems.Provides...

  • Lead Mainframe Systems Engineer

    4 weeks ago

    Downey, California, United States JRD Systems Full time

    Position OverviewJRD Systems is seeking a skilled Mainframe Systems Programmer/DBA to oversee and manage various database environments. This role is essential for ensuring the stability and performance of our legacy systems.Key ResponsibilitiesManage diverse database types, including Hierarchical (IMS), relational (DB2), and file-based (ADABAS).Plan and...

  • Mainframe Systems Programmer/DBA

    1 week ago

    Downey, California, United States CodeForce Full time

    Job Summary:CodeForce is seeking a highly skilled Mainframe Systems Programmer/DBA to lead and/or support complex database upgrade projects, modification, installation, testing, implementation, maintenance, and enhancements of new or existing system software products. The ideal candidate will have a strong background in database administration, with...

  • Mainframe Systems Programmer

    7 days ago

    Downey, California, United States West Advanced Technologies Full time

    Mainframe Systems Programmer/DBA Job DescriptionWe are seeking a highly skilled Mainframe Systems Programmer/DBA to join our team at West Advanced Technologies, Inc. The ideal candidate will have a strong background in mainframe systems programming and database administration, with a minimum of 7 years of experience in a lead role.Key Responsibilities:Lead...

  • Senior Mainframe Systems Engineer

    1 month ago

    Downey, California, United States West Advanced Technologies Full time

    Job Title: Senior Mainframe Systems Engineer Position Overview: The Senior Mainframe Systems Engineer is tasked with overseeing and facilitating intricate database upgrade initiatives, along with the modification, installation, testing, implementation, maintenance, and enhancement of both new and existing system software solutions. This role necessitates the...

  • Senior Mainframe Systems Engineer

    1 month ago

    Downey, California, United States West Advanced Technologies Full time

    Job Title: Senior Mainframe Systems Engineer Position Overview: A Senior Mainframe Systems Engineer is tasked with overseeing and/or facilitating intricate database upgrade initiatives, including modification, installation, testing, implementation, maintenance, and enhancement of both new and existing system software solutions. This role requires planning,...

  • IMS/ADABAS Systems programmer

    2 months ago

    Downey, United States Tech Providers Inc. Full time

    Position:  Mainframe Database Systems ProgrammerLocation: Los Angeles, CA 90012 (Hybrid - Onsite once a week)Duration: 06+ months Contract with the possibility of extension Skills Required: The Mainframe Systems Programmer/DBA for Legacy Systems manages different types of databases, such as hierarchical (IMS), relational (DB2), and file-based (ADABAS), and...

  • IMS/ADABAS Systems programmer

    2 months ago

    Downey, United States US Tech Solutions Full time

    Duration: 06 Months Contract Job Description:A Mainframe Systems Programmer/DBA is responsible for leading and/or supporting the most complex database upgrade projects, modification, installation, testing, implementation, maintenance and enhancements of new or existing system software products.This classification must plan, install, configure, test,...

  • IMS/ADABAS Systems programmer

    2 months ago

    Downey, United States US Tech Solutions Full time

    Duration: 06 Months Contract Job Description:A Mainframe Systems Programmer/DBA is responsible for leading and/or supporting the most complex database upgrade projects, modification, installation, testing, implementation, maintenance and enhancements of new or existing system software products.This classification must plan, install, configure, test,...

  • Mainframe Systems Programmer

    1 week ago

    Downey, California, United States Varite Full time

    Job Title: Mainframe Systems ProgrammerVARITE is seeking a highly skilled Mainframe Systems Programmer to join our team. As a Mainframe Systems Programmer, you will be responsible for managing different types of databases, including hierarchical (IMS), relational (DB2), and file-based (ADABAS), and planning and upgrading the database environments on a...

  • Mainframe System Programmer

    3 weeks ago

    Downey, United States VARITE INC Full time

    VARITE is looking for a qualified for one of its clients located in .WHAT THE CLIENT DOES?It’s one of the largest County Clients in USAWHAT WE DO?Established in the Year 2000, VARITE is an award-winning minority business enterprise providing global consulting & staffing services to Fortune 1000 companies and government agencies. With 850+ global...

  • Mainframe System Programmer

    3 weeks ago

    Downey, United States VARITE INC Full time

    VARITE is looking for a qualified for one of its clients located in .WHAT THE CLIENT DOES?It’s one of the largest County Clients in USAWHAT WE DO?Established in the Year 2000, VARITE is an award-winning minority business enterprise providing global consulting & staffing services to Fortune 1000 companies and government agencies. With 850+ global...

  • Senior IMS/ADABAS Systems Engineer

    1 month ago

    Downey, California, United States TalentBurst, an Inc 5000 company Full time

    Position: IMS/ADABAS Systems ProgrammerContract Duration: 6 Months with potential for extensionWork Arrangement: Initially Onsite, transitioning to HybridCompensation: W2 AcceptableRole Overview:This position is focused on mainframe database system programming rather than application development.A Mainframe Systems Programmer/DBA plays a critical role in...

  • Mainframe Systems Programmer

    2 weeks ago

    Downey, California, United States JRD Systems Full time

    Mainframe Systems Programmer Job DescriptionJRD Systems is seeking a highly skilled Mainframe Systems Programmer to join our team.Job Summary:We are looking for a seasoned Mainframe Systems Programmer with expertise in DB2, IMS, and Z/OS to lead and/or support complex database upgrade projects, modification, installation, testing, implementation,...