DB2 Database – Architect

Strong relational DB concepts in SQL/DB2. Strong experience in JDBC. Strong problem-solving, debugging, and troubleshooting skills. Strong analytical and problem-solving skills.

Manage and maintain IBM DB2 databases for efficiency and security. Integrate DB2 databases with platforms like IIB, ETL, and JAVA. Write and optimize complex SQL queries for performance tuning. Design DB2 schemas, including normalization and data modeling. Handle DB2 exceptions and coding practices. Manage lock contention and deadlock detection, providing solutions. Understand and provide solutions for row-level, page-level, and table-level locks. Utilize DB2 monitoring tools (IBM Data Studio, IBM Tivoli Monitoring) for performance analysis.