Oracle pl sql developer • chandler az
Mainframe Db2 Database Administrator (DBA) .Chandler, Arizona; Plano, Texas; Charlotte, North Carolina; Jersey City, New Jersey.Hybrid – 3 days onsite and 2 days remote per week.We are seeking an ... Mostrar más
Role Overview: Mercor is looking for data analysts and spreadsheet specialists with 2-3 years of experience, or currently enrolled postgrad students in a quantitative field, to support a research p... Mostrar más
We are seeking a Network / System Engineer to perform Level two production support tasks.The role involves working within a global team, providing on-call support to triage problems, and coordinati... Mostrar más
Salesforce higher education implementations, consulting, and support.With a focus on delivering exceptional client experiences, IntraEdge helps organizations achieve their business objectives throu... Mostrar más
Relocation Authorized: National - Family.Telework Type: Full-Time Office/Project.Extraordinary teams building inspiring projects:.Since 1898, we have helped customers complete more than 25,000 proj... Mostrar más
Are you looking for a new challenge? Passionate about innovation? Want to work for a global company that values integrity, teamwork, and loyalty?.We’ve been in business for 70 years, family-owned f... Mostrar más
L45 - Delivery Senior Consultant, Maintenance Solutions Our Deloitte Enterprise Performance team is at the forefront of enterprise technology, working across finance, supply chain, and IT op... Mostrar más
United States (Relocate Anywhere—Willing).Contract / Contract to Hire / Full Time (W-2).US Citizen / Green Card Only (No sponsorship).You’ll collaborate with product owners and designers to build p... Mostrar más
Application Deadline: 12/24/2026 Address: 320 S Canal Street Job Family Group: Technology This is a great opportunity where you will learn about Risk Management while further enhancing your Sal... Mostrar más
We are looking for a hands-on full-stack Software Engineer who will focus primarily on security remediation.Your first priority will be owning the remediation of vulnerabilities identified through ... Mostrar más
The Production Manager provides leadership to the manufacturing, planning and materials teams at the Mesa AZ location.This position utilizes cross functional leadership, technical knowledge and com... Mostrar más
Senior Software Asset Management Specialist .The Boeing Company The Boeing Company is currently seeking a.Senior Software Asset Management Specialist.North Charleston, SC; Everett, WA; Seattle, W... Mostrar más
Central Christian Church is seeking a relationally driven, influential, and passionate leader who loves Jesus, loves people, and thrives on building healthy teams and vibrant communities.The Campus... Mostrar más
Oracle Cloud Inventory / Costing Functional </b>for one of its clients in <b>Remote w/ Travel</b></p> <p style="margin-bottom:11px"><b>Job Title: Oracl... Mostrar más
External Candidates: Please use the following URL to apply on Paycom:.CDF214108C880FA17A213F5B114EEDC/jobs/367506.Designs and/or develops software programs and tools.Works with vendors, the IT team... Mostrar más
MSR-FSR is looking for a Power BI Developer/Data Analyst to join our team with experience in working in a fast paced-high volume of documentation environments.Candidate will help properly structure... Mostrar más
Our AI & Engineering team helps transform technology platforms, drive innovation, and deliver meaningful impact for clients.In this role, you will work with professionals who are reimagining and re... Mostrar más
Technical Software Support Engineer Job Specification.The Technical Software Support Engineer is responsible for providing technical assistance and support to end-users related to i2 software appli... Mostrar más
Stefanini is looking for a IT Analyst II in Chandler, AZ 85226.Location: 6833 W Willis Rd Ste 5050, Chandler, AZ 85226.Lead IT deskside activities to support all employees at the Client Chandler pl... Mostrar más
Mainframe Db2 Database Administrator (DBA)
Duration: 6–12 Months(NO BENEFITS)
Work Locations: Chandler, Arizona; Plano, Texas; Charlotte, North Carolina; Jersey City, New Jersey
Work Arrangement: Hybrid – 3 days onsite and 2 days remote per week
Job Overview
We are seeking an experienced Mainframe Db2 Database Administrator (DBA) with strong hands-on expertise in IBM Db2 for z/OS to support large-scale, business-critical mainframe environments.
The ideal candidate will have extensive experience in database administration, performance tuning, maintenance, availability, backup and recovery, and production troubleshooting. This role involves close collaboration with application development, systems programming, infrastructure, security, and operations teams to ensure database reliability, performance, and data integrity.
Key Responsibilities Db2 Database Administration
Administer and support IBM Db2 for z/OS databases across development, testing, and production environments.
Create, maintain, and manage database objects, including databases, tablespaces, tables, indexes, views, and storage definitions.
Manage Db2 catalog objects, partitions, and database structures.
Monitor database health, capacity, performance, and space utilization.
Ensure database availability, integrity, and operational reliability.
Database Maintenance & Utilities
Execute and manage Db2 utilities, including REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, CHECK DATA, and REBUILD INDEX.
Perform database reorganization, statistics collection, data loading, integrity checking, and recovery operations.
Develop and maintain JCL for Db2 utilities and database maintenance processes.
Troubleshoot utility failures and implement appropriate corrective actions.
Performance Tuning & Optimization
Analyze and tune SQL statements and database performance.
Review Db2 access paths, indexing strategies, and query execution behavior.
Identify and resolve performance bottlenecks, locking issues, and concurrency problems.
Recommend improvements to SQL statements, indexes, and database design.
Optimize database objects to maintain performance and availability.
Backup, Recovery & Production Support
Support database backup, recovery, and disaster recovery activities.
Troubleshoot Db2 errors, SQL issues, performance degradation, and production incidents.
Participate in incident resolution, root cause analysis, and preventive action implementation.
Support database schema changes and application deployments through controlled implementation processes.
Assist with Db2 upgrades, maintenance, migrations, and modernization initiatives.
Documentation & Collaboration
Collaborate with application developers, systems programmers, infrastructure teams, and production operations.
Maintain technical documentation, database standards, operational procedures, and recovery plans.
Follow established change management and production deployment processes.
Support highly available enterprise mainframe environments.
Required Qualifications
Strong hands-on experience with IBM Db2 for z/OS.
Extensive knowledge of Db2 database administration and object management.
Strong understanding of tablespaces, tables, indexes, partitions, views, and the Db2 catalog.
Experience with SQL development support, query analysis, and performance tuning.
Hands-on experience with Db2 utilities, including REORG, RUNSTATS, COPY, RECOVER, LOAD, UNLOAD, CHECK DATA, and REBUILD INDEX.
Knowledge of database backup, recovery, and disaster recovery procedures.
Experience with database performance monitoring, locking, concurrency, and troubleshooting.
Knowledge of Db2 storage and space management.
Strong experience with JCL.
Good working knowledge of IBM z/OS.
Experience supporting large-scale, highly available production mainframe environments.
Experience with production incident management, problem resolution, and controlled change implementation.
Preferred Technical Skills
IBM Db2 Administration Tool
IBM OMEGAMON for Db2
Db2 Query Monitor or equivalent performance monitoring tools
IBM or third-party Db2 utility products
REXX scripting
TSO/ISPF
SDSF
Db2 data sharing and IBM Parallel Sysplex environments
