What are the responsibilities and job description for the Data Warehouse Administrator 4 position at CRI Advantage?
CRI Advantage is looking for a 100% remote, Data Warehouse Administrator to support our client, Nevada Department of Motor Vehicles (DMV). The DMV application (CARRS) is an integrated system that is supported by both client server and web applications written in Power Builder, VB.NET, ASP.NET, COBOL, DB2, CICS, and SQL Server. The DMV application has over 900 internal users, 800,000 portal accounts, many external customers, and interfaces with local, State and Federal agencies. The core application runs on System Z with multiple CICS and DB2 environments secured by RACF. The core application is COBOL/DB2 programs that run both in batch and CICS environments.
Terms: 3 months initially, based on performance can be extended up to 15 months. 100% remote.
The consultant will be working on the following but not limited to:
Document changes and follow protocols established by Nevada DMV.
Follow guidelines established by Nevada DMV.
Administer DB2 database and subsystems
Monitor storage
Support Capacity planning
Support securing ZOS resources
Support Application team as needed
Perform routine maintenance tasks
Data migration
Troubleshoot and resolve issues
Log time using DMV Time tracking software (Remedy) daily.
Provide status reports as required by DMV personnel
The consultant will work with the DMV IT team and complete the assigned tasks in the scope of work in accordance with the DMV IT standards and procedures
Scope of Work
Consultant must provide the following based on the agreed upon project plan/schedule.
Manage, monitor, and tune DB2 subsystems and application environments.
Clone databases and establish additional application environments.
DB2 database and dataset backup and recovery.
Refresh data, as needed.
Clone and establish additional application environments, as needed.
Aid in data conversion project and extract data to staging environments, as needed.
Maintain privacy and security of data.
Support Application Lifecycle, Application development tools, as needed.
Migrate database changes.
Document and update procedures and check list.
Coordinate upgrades to ZOS, CICS, DB2, Administration tools, and Application development tools.
Coordinate DR testing and support data conversion and migration.
Help Application team with SQL review and tuning.
Discuss business requirements and help with Application and database design.
Support CICS environments.
Experience and Skills Required
ZOS DB2 DBA consultant must
Have the capability to perform the functions described in Section ii, Scope of Work
Have a bachelor’s degree in computer science, or any other equivalent degree with a minimum of seven (7) years of DB2 DBA experience in ZOS platform
Have experience administering complex DB2 environments with multiple subsystems
Be experienced working on ZOS tools and utilities - TSO, ISPF, SDSF, JCL, DFSORT, ICETOOL, DFDSS, DFSMS, DFHSM, OMVS, RACF, REXX/CLIST
Be experienced with using DB2 tools – SPUFI, QMF, DB2 Admin Tool or equivalent, DB2 Object Compare or equivalent, IBM Data Studio, OMEGAMON or equivalent, Query Monitor or equivalent
Be proficient with DB2 utilities
Be proficient with DB2 backup and recovery
Be able to work with the DMV Application team to understand the requirements and design databases
Be able to implement and migrate database changes
Have experience securing database objects
Have expertise in evaluating, and tuning SQL
Have experience tuning DB2 subsystem
Have knowledge of DB2 Attachment facilities
Have good knowledge of COBOL/CICS/DB2 application programming environment
Have good communication, documentation and user requirement gathering skills
Be proficient in analyzing, debugging, and troubleshooting issues and ABENDs
Be a team player who can work with other contractors/consultants and permanent employees under a complex team structure.
Experience and Skills Preferred
Experience installing and configuring DB2 Connect.
Experience working with Application Lifecycle Management tools similar to LCM, CHANGEMAN, ENDEVOR, SCLM, RTC, or similar
Experience working with data modeler tools like ERWIN or Oracle Data Modeler
Employee Job Functions
Employee Job Functions are physical actions and/or working conditions associated with the position. These functions may also constitute essential functions for the job position which the employee must be able to fulfill, with or without reasonable accommodation. The information provided below is to help describe the job so that the applicant has a reasonable understanding of the job duties/expectations. An applicant's ability to perform these actions will be discussed and workplace accommodations may be made on a case-by-case basis following an individualized assessment of the applicant and other considerations, including but not limited to any governing safety standards.
- Stooping, kneeling, crouching, turning, and twisting - Never
- Ability to reach, feel and handle items – Never
- Moving about to accomplish tasks or moving from one work site to another - Never
- Moderate noise (i.e., business office with computers, phone, and printers, light traffic) - Occasionally
- Repeating motions that may include the wrists, hands and/or fingers - Never
- Operating motor vehicles - Never
- Physical Demands – Sedentary work that primarily involves sitting/standing
- Moving self in different positions to accomplish tasks in various environments including tight and confined spaces - Never
- Ability to sit at a computer terminal for an extended period of time - Constantly
- Adjusting or moving objects up to 25 pounds in all directions - Never
- Communicating with others to exchange information - Constantly
- Operating machinery and/or power tools - Never
- Regular, predictable attendance is required - Constantly
Great things happen when you have the CRI Advantage!
CRI has a family-oriented company culture and is family-owned. Our management team believes employee growth is equally important to company growth and offers many types of learning opportunities. We work on unique projects including supporting missions involving national security, energy research, law enforcement, transportation, and health and welfare. We are headquartered in Boise, ID with offices in Idaho Falls and DC. Our corporate mission from the very beginning has been to make a positive difference in people’s lives.
CRI Advantage provides flexible benefit packages to fit employee and family needs. Benefits are effective from the first day of employment.
- Medical (PPO and HDHP plans), Dental, Vision, STD, LTD, Life and AD&D
- Access to Flexible Spending Accounts (FSA) and Health Savings Accounts (HSA)
- Paid Time Off (PTO) accruals, Paid Holidays, and for some roles – sick leave
- 401(k) with employer match
- Employee Assistance Program (EAP)
- Discount Rewards Program
- Free technical and professional training with access to over 8,000 classes
- Credit Union Membership
- Employee Wellness Program
CRI Advantage is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. CRI Advantage is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. To request a reasonable accommodation, contact Human Resources at HR@criadvantage.com or 208-287-4120.
