Full-Time DB2 Database Architect

Role: DB2 Database – Architect

Location: Remote

Responsibilities:

• Managing and maintaining IBM DB2 databases to ensure efficient and secure operations.
• Integration of DB2 databases on various platforms (IIB, ETL, JAVA, etc.).
• SQL & Query Optimization: Proficiency in writing complex SQL queries and optimizing them for performance improvements. Knowledge of the DB2 query optimization process.
• Database Design: Knowledge of normalization, data modeling, load management, and DB2 schema design best practices.
• Understanding DB2 exception handling and coding practices.
• Managing lock contention and deadlock detection, suggesting solutions for resolution.
• Understanding row-level, page-level, and table-level locks and providing solutions.
• Monitoring Tools: Familiarity with DB2's monitoring tools (IBM Data studio, IBM Tivoli Monitoring, etc.) for performance analysis and optimization.
• Strong relational DB concepts in SQL/DB2, and strong JDBC experience.
• Strong problem-solving, debugging, and troubleshooting skills.
• Strong analytical and problem-solving skills.

Desirable Skills:

• Excellent verbal and written communication skills.
• Strong Core Java and Object-oriented concepts.
• Experience with Agile methodologies (including Scrum).
• Experience in documentation skills.

What is the last date for applying to the job?

Which countries are accepted for this remote job?