IBM DB2 Architect – Remote – 6m C2C

Job Description

DB2 Mainframe IBM Architect

Any Work Autho: CITIZEN,G4,GREEN CARD,H1B,TN Permit

Prime client of ours: LinkedIn Profile should be 3 years old.

Role : DB2 Database – Architect

Duration : 6 Months

Remote

Experience

12+ years (Relevant experience of 4+ years in Database architect)

Primary Skill IBM – Db2

Job Description

* 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.

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.