TCI has an immediate need for a Mainframe Database Administrator for a long-term government contract. This role can be remote as long as one resides in the EST or CST time zones. This is not a Corp2Corp opportunity. This is a long-term contract opportunity with the possibility of hire. In addition to competitive, market-rate based pay, TCI provides all our Consultants with Comprehensive Medical/Dental Insurance, 401k, Life Insurance and Long-Term Disability benefits.
** THIS POSITION REQUIRES A PUBLIC TRUST SECURITY CLEARANCE PRIOR TO START**
SUMMARY
The Mainframe Database Administrator will ensure integrity, availability and performance of DB2 database systems by providing technical support and maintenance.
RESPONSIBILITIES
- Monitor database performance and recommend improvements for operational efficiency.
- Assist in capacity planning, space management and data maintenance activities for database system.
- Perform database enhancement and modification as per the requirements.
- Perform database recovery and backup tasks on daily and weekly basis.
- Develop and maintain patches for database environments.
- Identify and recommend database techniques to support business needs.
- Assist in implementation of new features and program fixes in databases.
- Maintain database security and disaster recovery procedures.
- Perform troubleshooting and maintenance of multiple databases.
- Resolve any database issues in accurate and timely fashion.
- Monitor databases regularly to check for any errors such as existing locks and failed updates.
- Oversee utilization of data and log files.
- Manage database logins and permissions for users.
REQUIREMENTS
- 5+ years of experience as an IBM DB2 for z/OS administrator.
- Experience and recent working knowledge in the following:
- DB2 for z/OS Function Level V12R0M508 experience.
- DB2 for z/OS version upgrade experience.
- DB2 for z/OS Data Sharing and z/OS SYSPLEX experience.
- IMS for z/OS Database Administration experience.
- CA Datacom/DB Database Administration experience.
- Experience in efficiently working with LOBS, CLOBS, and BLOBS.
- IBM TSO ISPF/PDF, SDSF, and JCL experience.
- IBM DFSMSdfp (ADRDSSU) & ISMF experience.
- Performance tuning, Explain, BIND, Package management.
- Encryption of Data at rest and data in transit.
- Vulnerability identification, response and remediation.
- Efficient use of tools, including but not limited to QMF, Enterprise QMF, CA Tools, BMC Tools, BMC utilities, IBM Utilities, and SPUFI.
- Experience with IBM DB2 Desktop tools, including but not limited to, Data Studio (IBM).
- Must have the ability to obtain a Public Trust Security Clearance prior to start.
- Remote work available in EST or CST time zones only.