Report this job

---

What is the problem? *

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

Database Architect 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 Additional Comments: Previous work experience in government, claims, accounting, or unemployment insurance management systems are preferred The successful candidate will be very technically competent, a consistently high producer, and very much a team player. They will have experience both with mainframe and client/server applications. Top Required Skills: Db2 V11 or V12 (8+ years' experience) z/OS v2.1 or higher (3 years' experience) PostgreSQL (3 years' experience) Data Modeling (8+ years) SQL & database performance Tuning (8+ years) Nice to Have Skills: Experience in migrating data from Legacy database (Db2) to Cloud database (PostgreSQL) COBOL/SAS/CICS/.NE (3+ years' experience BigQuery/GKE and or AWS (3+ years' experience Previous work experience in government, claims, accounting, or unemployment insurance management systems is preferred