DB2 DBA- Remote (XIN001_JDG5)
Company 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
- 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
- Updating physical database
- 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.