Job Description :
DirectClient: Texas Department of Comptroller of Public Accounts(CPA)
Solicitation#304125538
Title: Senior Mainframe DB2 Developer
Location: Austin, Texas 78774
Duration: 12+ Months Contract
Last date for submission: July 20, 2017(2.00 PM-CST)
Job Description:
Worker will perform highly advanced analysis and programing tasks such as:
development of new batch or online programs and modifications of existing programs including developing and modifying reports
development of ad hoc reports
developing complex SQL Queries in a DB2 z/OS environment to assist with data analysis and to update data based on specific business requirements
A senior level Programmer / Developer Analyst must have a strong background in data and database analysis with DB2 z/OS DBMS and be able to analyze data for irregularities and patterns. Must be able to quickly develop expertise in complex systems, be quality conscious and be dedicated to delivering quality products on time and on budget. Experience with COBOL is not required, but is desirable.
Worker must cross-train and transfer knowledge to current CPA staff.
Onsite Requirement:Worker will be required to work onsite with the team. Working remotely will be limited and must be pre-approved by the Project Manager/Direct Supervisor
On-call Requirement:Worker may be required to provide after-hours on-call support on a rotation basis
WORKER SKILLS AND QUALIFICATIONS
Strong written, verbal, and interpersonal communication skills
Must be able to work independently
Must be able to work in a diverse team environment
Must possess problem-solving skills and ability to multi-task
Must be able to retain knowledge of environment and systems once given instruction
Knowledge of project management and software development methodologies
Must be able to work around projects and deadlines with readiness to put in extra efforts when necessary
Perform related work as assigned
II. WORKER SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Skills/Experience
8 Experience creating, maintaining, and enhancing information systems written in Natural for DB2
8 Experience with z/OS JCL and TSO ISPF
8 Experience working with CPA’s applications including the Integrated Tax System (ITS), Audit Systems, and Statewide Financial Systems.
6 Experience with the development of various DB2 reporting mechanisms such as IBM’s Query Management Facility (QMF), Squirrel, Query Man, or Teradata Data SQL Assistant
6 Experience creating complex SQL queries, reports, and data extracts from DB2 z/OS DBMS
4 Extensive experience analyzing data from various data models, databases, and tables
3 Experience with software development processes, prepare detailed documentation and generate work estimates in an Agile, RAD and other SDLC environments
3 Extensive experience with highly complex security application requirements
3 Experience in unit and system integration testing of developed application
3 Experience writing conversion programs to transform extremely large complex data structures into other formats.
3 Experience accepting assignments from a formal process such as an ITIL ticketing system
Preferences:
Years Skills/Experience
4 Experience creating, maintaining, and enhancing information systems written in COBOL
2 Experience working with enterprise software solutions
2 Public sector experience (Federal, State or Local Government)
2 Experience with Web-enabling mainframe Natural programs
2 Proficient with the Microsoft Office products, including Microsoft Project, Word, Visio, Excel and PowerPoint