Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Under guidance of the Section Chief of the Unemployment Insurance Application Development Section, this position performs advanced application architecture work for various Unemployment insurance systems and UI Modernization project. The UI architect: recommends and maintains data management policy; provides expert technical leadership to the applications development and technical staff. Can do data modeling, data fixes, performance tuning, analysis of query and indexes, analysis of data structure and data definition, for the UI benefits system for both Oracle and DB2 databases. Has knowledge of SQL server and Cloud SQL. Well qualified candidates will have very strong HANDS-ON DBA experience with large application systems, i.e., 1000+ programs, 300+ tables, and 8+ years in DB2/CICS/Oracle environments or equivalent. Also experience with large system, or equivalent, using Platinum, ERWin, Omegamon, ChangeMan, CNTL-M or like tools, and significant IT related knowledge. Hardware/Software Environment: Db2 V11 or V12. z/OS v2.1 or higher (link removed). IBM DB2 utilities. IBM Data Studio. Db2 SQL PL. Platinum. BMC Mainview. Move for Db2. ChangeMan. Control-M Scheduler JCL SQL FILEAID ERWin Additional Skills: SQL & database performance Tuning Expert level SQL experience Dynamic SQL experience BI / Analytics support Top Required Skills: Db2 V11 or V12 (8+ years' experience) z/OS v2.1 or higher (3 years' experience) COBOL/SAS/CICS/.NE (8+ years' experience) Nice to Have Skills: SQL & database performance Tuning and Expert level SQL experience is preferred Previous work experience in government, claims, accounting, or unemployment insurance management systems is preferred