DB2 Database Architect

Title: DB2 Database Architect

Location: Remote

Length: Long term

Restriction: W2 or C2C

Description:

**** Webcam interview; *** Long term project *** Remote ***

Job Description

• Experience 12+ years (Relevant experience of 4+ years in Database architect)
• A DB2 Architect responsible for managing and maintaining IBM DB2 databases, ensuring that they are running efficiently and securely.
• Knowledge of integration of DB2 databases on various platforms (IIB, ETL, JAVA etc.).
• SQL & Query Optimization standards: Proficiency in writing complex SQL queries and optimizing SQL Queries for finetuning performance issues. Knowledge of the DB2 query optimization process, which selects the most efficient method for executing queries.
• Database Design: Knowledge of normalization, data modeling, Load management, and suggesting best practices for DB2 schema design if needed.
• Good understanding on Db2 exception handling and coding practices
• Skill: Managing lock contention and deadlock detection and suggesting solutions for resolutions
• Skill: 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.) to analyze and optimize performance.
• Strong relational DB concepts in SQL/DB2, Strong experience in JDBC.
• Strong problem solving, debugging and troubleshooting skills.
• Strong analytical and problem-solving skills.
• Primary Skill: IBM Db2

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.