DB2 Database - Architect

ZipRecruiter; Erie (Erie County); Remote; USD 90,000 - 130,000; Full time

Job summary

A leading IT consulting firm is seeking a DB2 Database Architect to manage and maintain IBM DB2 databases. The role involves optimizing SQL queries, ensuring database security, and providing solutions for performance issues. Ideal candidates will have strong problem-solving skills and experience in database design, along with excellent communication abilities.

Qualifications

• Proficiency in writing complex SQL queries and optimizing SQL Queries.
• Knowledge of normalization, data modeling, and DB2 schema design.
• Strong experience in JDBC.

Responsibilities

• Manage and maintain IBM DB2 databases efficiently and securely.
• Optimize SQL queries for performance issues.
• Provide solutions for lock contention and deadlock detection.

Skills

SQL

Database Design

Problem Solving

Analytical Skills

Communication

Tools

IBM Data Studio

IBM Tivoli Monitoring

Job description

Job DescriptionJob DescriptionCompany Description

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.

Job Description

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

Additional Information

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