DB2 DBA- Remote (XIN001_JDG5)

Xinnovit; Dallas (TX); Remote; USD 90,000 - 120,000; Full time

Job summary

A global technology consulting firm is seeking a skilled DB2 and Cloudant Database Administrator. In this role, you will design and implement database environments, engage in performance tuning, and manage data models. Ideal candidates have strong experience in DB2, Cloudant, and SQL, and are adept at solving complex database architecture challenges.

Qualifications

• Strong understanding of both DB2 and Cloudant architecture.
• Ability to design complex database environments and solutions.
• Experience with SQL creation and physical database definition (DDL).

Responsibilities

• Design and implement complex database environments.
• Develop technical standards and ensure compliance.
• Analyze internal customer needs and recommend solutions.

Skills

DB2 administration

Cloudant administration

DataStage

SQL

Database design

Database architecture

Backup and recovery methods

Job description

Xinnovit is a global leader in technology consulting, outsourcing, and workforce management solutions.

Our mission is to enable our clients to become more agile and competitive with the help of innovative technologies. We empower our clients to respond faster and more intuitively to changing market dynamics.

The business environment is complex, often under significant constraints and pressures from various sources. We have the knowledge, experience and capabilities to provide our clients the tools they require to achieve better, faster and effective transformation that make them the leaders in their industry.

Our Goals Are:

• To use our expertise to the benefit of our clients and partners through open communication and collaboration.

• To ensure sustainable and profitable long-term growth.

• To provide a return on investment to shareholders.

• To promote employee development.

Job Description

Client is looking for a highly-skilled DB2 and Cloudant Database Administrator (DBA). Responsibilities include DB2 administration, Cloudant administration, DataStage administration, DataStage job creation and scheduling, Structured Query Language (SQL) creation, DB2 performance tuning, physical Database Definition (DDL) and understanding of logical database design (i.e. data models and dictionary). Ability to update Logical Data Model and Dictionary, update Physical Database, and create Database Scripts. This role is responsible for designing and implementing application solutions that support Worldwide Software Technical Sales and Deployment.

Primary duties include:

• Designing and implementing complex database environments and developing creative solutions to meet performance objectives

• Developing technical standards and reviewing the environment to ensure compliance with standards,

• Reviewing and validating database architecture

• Resolving highly complex problems and implementing systemic changes, including designing new solutions and/or deciding which solutions to adopt

• Analyzing internal customer needs, including participating in strategic planning and ensuring solutions adopted are appropriate to meet such needs

Required Technical and Professional Expertise:

• Identifying database requirements by analyzing applications, programming, and operations; evaluating existing systems and designing proposed systems.

• Recommending solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.

• SQL Creation, DB2 command line creation and execution, Database view creation

• Physical database definition (DDL) and understanding of logical database design (i.e. data models and dictionary)

• Ability to update logical data model and dictionary

• Creating database scripts and stored procedures

• Strong understanding of database architecture concepts in both DB2 and Cloudant

• Knowledge and experience with back-up and recovery methods, including point in time recovery

• Knowledge and experience with back-up and recovery using DB2 backup and restore commands

Additional Information

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