DATABASE ADMINISTRATOR - DATACOM
TEKsystems c/o Allegis Group
Fort Knox KY 40122 US
Description:
Qualifications
5+ years in Datacom Technology performing Datacom DBA and/or Database Engineering duties. To include knowledge of Mainframe internals like SMP/E, TSO/E, ISPF/PDF, JCL, z/OS Utilities, etc.
Effective problem determination and resolution skills
Excellent communication (oral and written) skills with the ability to influence
Demonstrated change management skills
Ability to multi-task, work effectively and collaboratively in a team environment, and demonstrated ability to provide quality client support
Experience with Agile Practices and Agile Service Management a plus
Debug system software problems and communicate with Tech Support to resolve these problems.
Take lead during incidents and drive incident management effort to restore service and lead postmortem discussions and actions.
Support the career growth of junior members by providing technical guidance & mentoring.
Participate in Production on call support (24x7).
Utilize Agile Framework to manage tasks and your workload
Working knowledge of Datacom/DB architecture.
DataDictionary - Maintain Datacom object definitions includes adding, changing, updating, and retiring objects:
Database, Areas, Tables, Keys, and Elements.
DataDictionary maintenance via online (DDOL) and/or batch.
DataDictionary Utilities, DDBTGLM, DDUPDATE, DDRMFLM, and VLS files.
Working knowledge of change impact and doing impact assessments - steps that must be completed after a changes to the dictionary are made.
Understanding Copybooks and how they can be defined and used in a COBOL environment.
Logging and Recovery, understand the LXX, the active log and the RXX the archive log and how to use them for forward and backward recovery.
Understanding of the Dynamic System tables and how to query them via SQL queries.
DB Utility DBUTLTY used to produce CXX reports, manage backup and recovery, perform 24x7 tools for on-line-area-moves (OAM), online reorgs of data, TM24 to move and reorganize data and remain on-line, TM24 used to add or remove data compressions without taking table offline.
Understanding of Datacom Accounting tables and how to review data to assist programmers with tuning programs or problem solving.
URTs - User Requirements Tables role in batch and on-line access.
Understanding of basic problem solving, evaluating error conditions, and problem resolution
Working knowledge/understanding of new Datacom enhancements for partitioning large tables, converting BDAM datasets to Linear VSAM to improve performance and resource usage, and using online area move to re-allocate datasets without taking them offline.
CICS Service Facility
Basic understanding of module DBCVTPR and its assembly
Monitoring throughput via Sysview - this can be learned.
Reviewing CICS output for problem solving and resolution.
Basic understanding of Inter-Product Components (IPC)
Programmer and Datacom System Support
Ability to review customer requests and/or assistance with problem solving. Review failed job and assist with providing corrective measures.
Ability to assist with tuning application code or assist with reducing run time for long running batch jobs.
Mainframe Knowledge/Skills
Working knowledge of JCL to run batch jobs, allocate and manage Datacom datasets, output files, etc.
Ability to review job output to help resolve error conditions or problems.
Understand DASD management for the Datacom environments.
Skills:
Database development, Database administrator, Mainframe, datacom, smp, tso, jcl, ispf, z/0s
Top Skills Details:
Database development,Database administrator,Mainframe,datacom
Additional Skills & Qualifications:
Need secret security clearance and Sec+ certification (TEK will reimburse for the exam cost).
Experience Level:
Expert Level
*Can NOT sponsor for a DoD clearance
Salary range: $90,000- $120,000
About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. Database Administrator - Datacom
Qualifications
5+ years in Datacom Technology performing Datacom DBA and/or Database Engineering duties. To include knowledge of Mainframe internals like SMP/E, TSO/E, ISPF/PDF, JCL, z/OS Utilities, etc.
Effective problem determination and resolution skills
Excellent communication (oral and written) skills with the ability to influence
Demonstrated change management skills
Ability to multi-task, work effectively and collaboratively in a team environment, and demonstrated ability to provide quality client support
Experience with Agile Practices and Agile Service Management a plus
Debug system software problems and communicate with Tech Support to resolve these problems.
Take lead during incidents and drive incident management effort to restore service and lead postmortem discussions and actions.
Support the career growth of junior members by providing technical guidance & mentoring.
Participate in Production on call support (24x7).
Utilize Agile Framework to manage tasks and your workload
Working knowledge of Datacom/DB architecture.
DataDictionary - Maintain Datacom object definitions includes adding, changing, updating, and retiring objects:
Database, Areas, Tables, Keys, and Elements.
DataDictionary maintenance via online (DDOL) and/or batch.
DataDictionary Utilities, DDBTGLM, DDUPDATE, DDRMFLM, and VLS files.
Working knowledge of change impact and doing impact assessments - steps that must be completed after a changes to the dictionary are made.
Understanding Copybooks and how they can be defined and used in a COBOL environment.
Logging and Recovery, understand the LXX, the active log and the RXX the archive log and how to use them for forward and backward recovery.
Understanding of the Dynamic System tables and how to query them via SQL queries.
DB Utility DBUTLTY used to produce CXX reports, manage backup and recovery, perform 24x7 tools for on-line-area-moves (OAM), online reorgs of data, TM24 to move and reorganize data and remain on-line, TM24 used to add or remove data compressions without taking table offline.
Understanding of Datacom Accounting tables and how to review data to assist programmers with tuning programs or problem solving.
URTs - User Requirements Tables role in batch and on-line access.
Understanding of basic problem solving, evaluating error conditions, and problem resolution
Working knowledge/understanding of new Datacom enhancements for partitioning large tables, converting BDAM datasets to Linear VSAM to improve performance and resource usage, and using online area move to re-allocate datasets without taking them offline.
CICS Service Facility
Basic understanding of module DBCVTPR and its assembly
Monitoring throughput via Sysview - this can be learned.
Reviewing CICS output for problem solving and resolution.
Basic understanding of Inter-Product Components (IPC)
Programmer and Datacom System Support
Ability to review customer requests and/or assistance with problem solving. Review failed job and assist with providing corrective measures.
Ability to assist with tuning application code or assist with reducing run time for long running batch jobs.
Mainframe Knowledge/Skills
Working knowledge of JCL to run batch jobs, allocate and manage Datacom datasets, output files, etc.
Ability to review job output to help resolve error conditions or problems.
Understand DASD management for the Datacom environments.
Skills:
Database development, Database administrator, Mainframe, datacom, smp, tso, jcl, ispf, z/0s
Top Skills Details:
Database development,Database administrator,Mainframe,datacom
Additional Skills & Qualifications:
Need secret security clearance and Sec+ certification (TEK will reimburse for the exam cost).
Experience Level:
Expert Level
*Can NOT sponsor for a DoD clearance
Salary range: $90,000- $120,000
About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. Database Administrator - Datacom