DB2 UDB (Universal Database) Developer

Tata Consultancy Services

Alpharetta (GA)

On-site

USD 120,000 - 130,000

Full time

4 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical Coverage

Parental Leaves

401K Plan

Certification & Training

Vacation & Holidays

Job summary

Tata Consultancy Services in Alpharetta, GA, seeks a seasoned DB2 UDB Developer to design and maintain database solutions on IBM DB2 (LUW). The role emphasizes strong SQL, performance tuning, and collaboration with cross-functional teams to deliver high-performance data services.

The ideal candidate has 10 years of DB2 LUW experience, expertise with stored procedures and data modeling, and hands-on ETL or scripting experience.

Qualifications

Bachelor's degree or equivalent experience in CS/IS or related field
10 years hands-on experience with IBM DB2 UDB (LUW)
Strong SQL skills (joins, subqueries, window functions)
Experience writing stored procedures, UDFs, triggers, packages in DB2
Proficient in performance tuning: explain plans, indexing, bind/rebind, stats
Familiar with DB2 DB design concepts and ER modeling
ETL tools or scripting for data movement (e.g., DataStage, Informatica, SSIS)
Backup/restore, high availability, DR for DB2
Linux/Unix/Windows environments and shell scripting
Strong problem-solving, communication, and collaboration skills

Responsibilities

Design, develop, and maintain stored procedures, functions, triggers, packages, and SQL scripts for DB2 UDB
Collaborate with developers and architects to design efficient data models and queries
Optimize statements and structures for performance, scalability, and maintainability
Analyze and resolve database performance issues (CPU, long-running queries, I/O)
Implement and maintain indexing, table partitioning, and data distribution techniques
Participate in capacity planning, backup/restore strategy, and DR planning
Support schema changes and data migrations; write migration scripts
Ensure data integrity, security, and compliance with standards
Create technical docs: data models, ER diagrams, SQL standards, runbooks
Work with DBAs to monitor health, apply patches, manage config changes
Assist in troubleshooting app/db interactions and transaction issues
Participate in code reviews and knowledge sharing

Skills

DB2 LUW

SQL

Stored procedures

Performance tuning

Linux scripting

ER modeling

Education

Bachelor's degree in Computer Science

Tools

IBM DB2 UDB

CI/CD for DB changes

JDBC/ODBC

IBM Data Studio

Job description

Job Description Must Have Technical/Functional Skills

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.

Soft Skills