Demo

DB2 Specialist (IBM) - w2

ITCommence Inc
Harrison, NY Full Time
POSTED ON 1/15/2025 CLOSED ON 3/4/2025

What are the responsibilities and job description for the DB2 Specialist (IBM) - w2 position at ITCommence Inc?

Role: DB2 Specialist
Location: Harrison NY
Duration: Long term

Must have: DB2, SQL, and AWS

Key Responsibilities:

  • Database Assessment & Analysis.
  • Conduct an in-depth review of current DB2 databases (schemas, stored procedures, triggers).
  • Identify any compatibility concerns related to DB2 on AWS RDS.

Migration Planning & Execution.

  • Develop and implement migration strategies using tools like AWS DMS or custom scripts.
  • Ensure data integrity, minimal downtime, and robust rollback procedures

Performance Optimization

  • Monitor database performance before, during, and after migration.
  • Perform SQL tuning, index analysis, and query optimization to meet POC performance targets

Collaboration & Stakeholder Communication

  • Work closely with the Cloud Architect/Engineer to configure RDS instances.
  • Align migration efforts with application teams and provide status updates to project stakeholders

Documentation & Knowledge Transfer

  • Maintain comprehensive records of configurations, migration steps, and performance benchmarks

Provide clear handoff materials to support teams and assist in post-POC analysis

Required Skills and Qualifications:

  • 5 years of hands-on experience administering IBM DB2 (10.x, 11.x, or later).
  • Strong understanding of SQL development, performance tuning, and troubleshooting.
  • Familiarity with cloud migration concepts, especially AWS (e.g., RDS, DMS, EC2).
  • Experience with backup and recovery strategies, high availability, and disaster recovery (HADR, log shipping, etc.).
  • Proven analytical and problem-solving skills for diagnosing performance and compatibility issues.
  • Excellent communication skills for interacting with cross-functional teams and stakeholders

Job Type: Full-time

Pay: $50.00 - $55.00 per hour

Benefits:

  • 401(k)
  • Health insurance

Schedule:

  • 8 hour shift

Education:

  • Bachelor's (Required)

Experience:

  • AWS: 3 years (Required)
  • IBM DB2: 5 years (Required)
  • SQL development: 6 years (Required)

Ability to Relocate:

  • Harrison, NY 10528: Relocate before starting work (Required)

Work Location: In person

Salary : $50 - $55

Network Services Specialist - W2 Role
DRC Systems -
Yorktown Heights, NY
Fortra Automate Specialist (W2 only)
Sharp Decisions -
New York, NY
Senior Specialist Growth Automation (W2 and Local only)
Sharp Decisions -
New York, NY

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a DB2 Specialist (IBM) - w2?

Sign up to receive alerts about other jobs on the DB2 Specialist (IBM) - w2 career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$92,249 - $117,370
Income Estimation: 
$93,716 - $124,745
Income Estimation: 
$118,976 - $146,289
Income Estimation: 
$112,672 - $149,113
Income Estimation: 
$98,475 - $115,895
Income Estimation: 
$66,897 - $84,160
Income Estimation: 
$74,161 - $98,561
Income Estimation: 
$92,249 - $117,370
Income Estimation: 
$88,359 - $121,264
Income Estimation: 
$113,076 - $148,099
Income Estimation: 
$92,249 - $117,370
Income Estimation: 
$93,716 - $124,745
Income Estimation: 
$118,976 - $146,289
Income Estimation: 
$112,672 - $149,113
Income Estimation: 
$98,475 - $115,895
Income Estimation: 
$150,731 - $188,044
Income Estimation: 
$176,131 - $238,730
Income Estimation: 
$172,979 - $241,697
Income Estimation: 
$118,976 - $146,289
Income Estimation: 
$115,719 - $153,093
Income Estimation: 
$137,343 - $165,639
Income Estimation: 
$135,811 - $184,429
Income Estimation: 
$120,390 - $162,969
This job has expired.
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at ITCommence Inc

ITCommence Inc
Hired Organization Address Washington, DC Full Time
Job Title: Helpdesk Specialist Work Location: Washington, D.C., New York, New York, or Remote w2/ 1099, long term contra...
ITCommence Inc
Hired Organization Address Longmont, CO Full Time
Role: ASIC STA and CAD Methodology Expertise for High-Performance Design Implementation and Timing Closure Duration – 12...
ITCommence Inc
Hired Organization Address Hartford, CT Full Time
We are seeking a STRONG technical Databricks developer. Not a remote position. It can be a hybrid though. We are seeking...
ITCommence Inc
Hired Organization Address Jackson, MS Full Time
Role: Business Analyst Location: Jackson MS Duration: 3 yrs The candidate will have a minimum of10 years experience in d...

Not the job you're looking for? Here are some other DB2 Specialist (IBM) - w2 jobs in the Harrison, NY area that may be a better fit.

DB2 DBA

Saxon Global, New York, NY

BA Risk Specialist (W2 Only)

PTR Global, New York, NY

AI Assistant is available now!

Feel free to start your new journey!