DB2 Database – Architect

Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.

With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.

Role: DB2 Database – Architect

Location: Remote   

Responsibilities:

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

Regards,

Manoj

Derex Technologies INC

Contact : 973-834-5005 Ext 206

All your information will be kept confidential according to EEO guidelines.