Position: Database Administrator Duration: 4 months Location: Carson City ,NV (Initially Remote) Agency: DMV
| |
Must 9+ or 10+ Candidate 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.
| | | Thanks, Harshad Bhardwaj Mail: Harshad@tecnixonline.com Note: "We respect your Online Privacy. If you wish not to receive any email, please send us an email with REMOVE in the subject and we will REMOVE you from our mailing list." | | TechNix LLC || www.technixonline.com | | | | | | | |
|
Post a Comment