Database Architect

  • Hexacorp
  • Madison, WI, USA
  • Nov 09, 2020
[Information Technology]

Job Description

Job Description:
Under guidance of the Section Manager of the KIDS Application Development Section, this position performs advanced DB architecture work for Child Support Systems. The KIDS DB architect: recommends and maintains data management policy; provides expert technical leadership to the applications development and technical staff; installs and maintains software on multiple mainframe platforms; plans, tests installs and updates to software; coordinates software upgrades with system DBAs; and advises application development staff on the use of database software, database designs and data models, efficient data access, and is available for evening/weekend on-call duties. Well qualified candidates will have DBA experience with a large (1000+ programs, 400+table, 4+DB2/CICS environments or equivalent and distributed systems accessing DB2) Child Support system, or equivalent, using Platinum, ERWin, Mainview, ChangeMan. IBM Utilities, log analyzer tools, IBM Data Studio, CNTL-M or like tools; and significant IT related knowledge.
Database Design:
10 Years in Buffer Pool Tuning
10 Years in Database Tuning and Maintenance to assure highest level of system availability and performance
10 Years in BM DB2 Utilities or CDB DB2 Utilities
10 Years in Implement Database Objects and Files needed by Database Applications
10 Years inProvide Multi Environment Database Support
10 Years in Database design
10 Years in Data Warehouse performance tuning
10 Years in DB2
10 Years in Implement Database Archive and Recovery Strategies
10 Years in Logical database design
5 Years in Move for DB2
10 Years in Physical database design
10 Years in Stored procedures and triggers
5 Years in IBM DB2 Utilities - Language/Tool.
2 Years in DB2 Application - DBA for a very large complex Child Support System supporting hundreds of tables in at least 5 environments
15 Years in DB2 Application - DBA for a very large complex system supporting hundreds of tables in at least 5 environments
10 Years in Implement and enforce security requirements
Associated topics: .net, architecture, c#, design, devops, java, lead, php, senior, senior software developer