US
0 suggestions are available, use up and down arrow to navigate them
What job do you want?

Mainframe DB2 DBA job in Brookfield at Nesco Resource

Create Job Alert.

Get similar jobs sent to your email

List of Jobs

Apply to this job.
Think you're the perfect candidate?
Apply Now
Mainframe DB2 DBA at Nesco Resource

Mainframe DB2 DBA

Nesco Resource Brookfield, WI Full-Time
$115,000 - $130,000/Year
Apply Now
Mainframe DB2 DBA

The core of these services runs on multiple IBM Parallel Sysplex environments utilizing IBM's DB2 z/OS in a high-performance, highly-available data-sharing configuration. This DB2 DBA role is responsible for the maintenance, administration and availability of the DB2 database objects, application performance monitoring and tunings to support the demands of the fast-paced, time-critical financial trading industry.

Essential Responsibilities

  • Lead DB2 Structure Changes to support application design and development efforts. Participate in logical and physical database design and provide best possible solution.

  • Responsible for DB2 availability and recovery strategies and procedures.

  • Proficient with DB2 REORGs and other database utilities.

  • Experience with Data migration and movement between multiple environments.

  • Performance analysis and tuning of application SQLs.

  • Knowledge of third part DB2 tools like CA Platinum, Migrator, Log Analyzer, Detector, Mainview, SPUFI etc.

  • Perform problem analysis and resolution, both technical and application related.

  • Performance and capacity tuning of system parameters and resources, utilizing various monitoring and reporting tools.

  • Application developer support. SQL coding and DB2 troubleshooting.

  • Experience of being on-call (level 1/2) on rotation during weekdays and weekends.


Qualifications:


  • 7 years IBM z/OS DB2 DBA experience and concepts, with extensive knowledge in the following:

  • DB2 Database structures: Database, Storage group, tablespace, table, index, views, aliases, DB2 Native stored procedures, triggers, UDFs.

  • IBM DB2 utilities, BMC Mainview for DB2 and CA Tools for DB2, particularly Detector and Platinum, Subsystem analyzer, RC migrator, IBM Data Studio and Fast unload.

  • DB2 z/OS as a distributed server.

  • SQL Analysis and tuning EXPLAINs, Types of Joins, understanding of Access paths, OPTHINTs, Data normalization concepts

  • Mainframe technical skills like JCL, TSO/ISPF, SDSF, RACF, etc.

  • Backup/recovery/logging facilities and strategies

  • DB2 locking

  • Experience in problem determination and analysis.

  • Analytical / critical / "outside-the-box thinking in problem solving, especially in possible critical, fast paced situations.


Additional Skills A Plus:


  • Knowledge of CA Unicenter DB2 Tools

  • Knowledge of Informatica PowerExchange

  • Knowledge of Java, web services, SOA concepts

  • Knowledge of REXX programming






Nesco Resource and affiliates (Lehigh G.I.T Inc, and Callos Resource, LLC) is an equal employment opportunity employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, or veteran status, or any other legally protected characteristics with respect to employment opportunities.

Recommended Skills

  • Administration
  • Aliasing
  • Analytical
  • Application Design
  • Data Migration
  • Database Design

About the company

Apply to this job.
Think you're the perfect candidate?
Apply Now

Help us improve CareerBuilder by providing feedback about this job:

Job ID: 21-73752

CareerBuilder TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.