Talent.com
vaaridatech
DB2 UDB (Universal Database) Developervaaridatech • New York, NY, New York, USA
DB2 UDB (Universal Database) Developer

DB2 UDB (Universal Database) Developer

vaaridatech • New York, NY, New York, USA
9 days ago
Job type
  • Full-time
Job description

Role - DB2 UDB (Universal Database) Developer

Location - New York Plaza,NY (3 days onsite /week)

Job Type- Full Time Employment

Job description Below

We’re seeking an experienced DB2 UDB Developer to design, develop, and maintain applications and database solutions on IBM DB2 (UDB). The ideal candidate has strong SQL and performance-tuning skills, experience with DB2 on LUW (Linux/Unix/Windows) and a track record of working with development

  • Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
  • 10+ years of hands-on experience working with IBM DB2 UDB (LUW).
  • Strong SQL skills (complex joins, subqueries, window functions, correlated queries).
  • Experience writing stored procedures, user-defined functions, triggers, and packages in DB2.
  • Proficient in performance tuning: explain plans, index design, bind/rebind concepts, and statistics.
  • Familiarity with database design concepts, normalization/denormalization, and ER modeling.
  • Experience with ETL processes and tools (e.g., IBM DataStage, Informatica, SSIS) or scripting for data movement.
  • Experience with backup/restore, high availability, and disaster recovery solutions for DB2.
  • Comfortable working with Linux/Unix/Windows environments and shell scripting for automation.
  • Strong problem-solving, communication, and collaboration skills.

Roles & Responsibilities

Role Summary

We’re seeking an experienced DB2 UDB Developer to design, develop, and maintain applications and database solutions on IBM DB2 (UDB). The ideal candidate has strong SQL and performance-tuning skills, experience with DB2 on LUW (Linux/Unix/Windows) and a track record of working with development teams to deliver reliable, high-performance data solutions.

Key Responsibilities

  • Design, develop, and maintain stored procedures, functions, triggers, packages, and SQL scripts for DB2 UDB.
  • Collaborate with application developers and architects to design efficient data models and queries.
  • Optimize SQL statements and database structures for performance, scalability, and maintainability.
  • Analyze and resolve database performance issues (e.g., high CPU, long-running queries, I/O bottlenecks).
  • Implement and maintain indexing strategies, table partitioning, and data distribution techniques.
  • Participate in database capacity planning, backup/restore strategy, and disaster recovery planning.
  • Support schema changes and data migrations; write migration scripts and assist with deployment planning.
  • Ensure data integrity, security, and compliance with organizational policies and standards.
  • Create and maintain technical documentation: data models, ER diagrams, SQL standards, and runbooks.
  • Work with DBAs to monitor database health, apply patches, and manage configuration changes.
  • Assist in troubleshooting application/database interactions, including connection pooling and transaction issues.
  • Participate in code reviews, knowledge sharing, and continuous improvement initiatives.

Preferred Qualifications

  • -Hands-on experience working with IBM DB2 UDB (LUW).
  • -Certification: IBM Certified Database Administrator or relevant DB2 certification.
  • Familiarity with application servers (WebSphere, JBoss), connection pooling, and JDBC/ODBC drivers.
  • Experience with CI/CD for database changes (Liquibase, Flyway, custom pipelines).
  • Knowledge of SQL performance tools (db2exfmt, db2expln) and monitoring tools (IBM Data Studio, Nagios, Prometheus).
  • Experience wit h data warehousing, OLAP, and analytical workloads.
  • Exposure to cloud-based DB2 deployments or migration experience to cloud platforms.

Create a job alert for this search

DB2 UDB (Universal Database) Developer • New York, NY, New York, USA

Similar jobs

Database Administrator

TradeJobsWorkForce10032 New York, NY, US
Full-time

Responsibility for the evaluation of database software purchases Supervision of modifications to any existing database software to meet the needs of their employer Responsibility for maintaining th... Show more

 • Promoted

Mgr, Database Management Systems

IQVIA HoldingsNew York, NY, United States
Full-time

Mgr, Database Management Systems.Designs or modifies data models to solve complex database requirements considering business and application needs.Organizes metadata for use by teams.Clinical Data ... Show more

 • Promoted

Labware LIMS Master Data Management Developer (Remote)

CapgeminiNew York City, NY, United States
Remote
Full-time

Labware LIMS Master Data Management Developer (Remote)-081250DescriptionJob Title :LabWare Master Data Management DeveloperLocation :Remote (Anywhere across United States)About the job you're consi... Show more

 • Promoted

Remote Software Developer $60 - $120/hourpay

Micro1Cresskill, New Jersey, US
$60.00–$120.00 hourly
Remote
Full-time

AI data lab for training frontier models and evaluating AI agents.Experts contribute their diverse subject matter knowledge across domains such as finance, healthcare, STEM engineering, and more.AI... Show more

 • Promoted

OnBase Developer - Remote

The Dignify Solutions LLCJersey City, NJ, United States
Remote
Full-time

Hands on experience of document workflow automation, document import processes like SCAN / OCR, COLD / DIP, Document Management, and system administration.Should able to write optimize queries in S... Show more

 • Promoted

Complete Online Surveys For Cash (Up to $25/per)

Earn HausLong Branch, NJ, US
Full-time +1

Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion.You will help influence brand decisions on se... Show more

 • Promoted

Database Development

TradeJobsWorkForce10040 New York, NY, US
Full-time

Database Development Job Duties: Database Developers are responsible for data gathering before development of ... Show more

 • Promoted

BA-Derivative Products and SQL -- US

Zortech SolutionsNew York, NY, United States
Full-time

BA-Derivative Products and SQL.Location: Charlotte, NC/NY/NJ Hybrid-3 days of office.Good functional knowledge on Derivative products across all Asset classes IRD, EQD, FX and CRD.Ability to intera... Show more

 • Promoted

Remote Guidewire Billing Center Lead Developer (GOSU/Java)

Hermitage InfotechJersey City, NJ, United States
Remote
Full-time

A technology company is looking for a skilled Guidewire Billing Center Lead Developer to work remotely.The role requires strong expertise in GW Billing Center configuration and integration, GOSU, C... Show more

 • Promoted

Oracle DBA - Remote

CyrtenEast Rutherford, NJ, United States
Remote
Permanent

Oracle DBA - Remote PositionLocation :RemotePreferred Time Zones :EST, CST, MTNRate Type :W2 ONLYCompensation :Upto $70 per hrLength :1 to 3 yearsWe are looking for a highly skilled and experienced... Show more

 • Promoted

Senior Oracle APEX Developer

ClearanceJobsNew York City, NY, United States
Full-time

Senior Oracle APEX DeveloperCGS is hiring a Senior Oracle APEX Developer to support a range of IT services, including software application support, enterprise infrastructure support, service desk, ... Show more

 • Promoted

Manager of End User Computing IT Englewood

Englewood Hospital And Medical CenterEnglewood, NJ, United States
Full-time

Manager Of End User Computing It.Englewood Health, a leading healthcare system comprising Englewood Hospital and the Englewood Health Physician Network, is committed to delivering exceptional patie... Show more

 • Promoted

Senior Mainframe Systems Architect - Remote

Expert Technology ServicesPearl River, NY, United States
Remote
Full-time

Job Summary (List Format) :Lead the design and optimization of enterprise systems supporting operational financial and productivity reporting.Align technology solutions with business processes acro... Show more

 • Promoted

Director of Coding Compliance

Essen Medical AssociatesBronx, NY, United States
Full-time

Essen Health Care is the largest privately held, multispecialty medical group in New York, providing high-quality, compassionate care to some of the state's most vulnerable and underserved resident... Show more

 • Promoted

Senior Manager, IT Operations

LOG-NET, Inc.Asbury Park, NJ, United States
Full-time

Operations And Compliance Manager.LOG-NET is a leader in the global autonomous logistics marketplace.Our platform powers some of the largest brands in the world in the global distribution of their ... Show more

 • Promoted

Tableau Developer

ClifyXNew York City, NY, United States
Full-time

Optech Technical Architecture EngagementDesign, deliver, and support technical architecture engagements for the enterprise.Primary responsibilities include:Leading technical architecture design ses... Show more

 • Promoted

SYNON Developer - Remote

Nava Software Solutions LLCNew York City, NY, United States
Remote
Full-time

NAVA Software solutions is looking for SYNON DeveloperDetails :SYNON Developer - 6 positionsLocation :RemoteDuration :12 monthsWe are seeking a skilled developer with 3-5 years of experience in SYN... Show more

 • Promoted

Behavior Technician-In home

Bounce ABA PreschoolLong Branch, NJ, United States
Part-time

We are seeking energetic, reliable, and caring Behavior Technician to join our team for in-home clients located in the Hazlet, NJ and Freehold, NJ areas! $28-30.If you're interested in any of the c... Show more

 • Promoted

Freelance Luxury Brand Evaluator - Central & Southern New Jersey, US

CXGWest Long Branch, NJ, United States
Full-time

Turn your passion for luxury into a career opportunity.Explore the world of premium brands and make a lasting impact in fashion, beauty, jewelry, or automobiles.Join CXG, the global leader in custo... Show more

 • Promoted

LBA / BCBA Flexible Hybrid Role (Mostly Remote, Local Clients)

Matchly Staffing SolutionsPassaic, NJ, United States
Remote
Full-time

Looking for a dedicated LBA or BCBA to join our supportive team! This hybrid role is mostly remote, with occasional in-person visits to clients near Passaic, NJ.We value trust, collaboration, and m... Show more