Job ID: MI-651993 (97790510)
Location: Dimondale, MI (Treasury)
Duration: 2 months
Interview: Webcam Interview Only
Skills:
Knowledge of Unisys DMSII DB administration and related tools Required 5 Years
Knowledge of DataBridge administration and related tools Required 5 Years
Knowledge of COBOL, XGEN, WFL, and ALGOL languages and related tools Required 5 Years
Knowledge of UNISTAR/URSA, BLSOURCE, BLPACK, BLSCHED administration Required 5 Years
Knowledge of the fundamental principles, theories, techniques, and methodologies of data processing systems analysis Required 5 Years
Knowledge of computer programming, data modeling, and applicable tools Required 5 Years
Ability to prepare detailed written instruction and documentation Required 5 Years
Ability to express complex technical concepts at a level appropriate to the audience, both verbally and in writing Required 5 Years
Knowledge of Oracle and/or SQL Server database administration Desired 5 Years
Knowledge of T-SQL, SQL and PLSQL Desired 5 Years
Knowledge of PowerShell or similar scripting and OS administration Desired 5 Years
Seeking senior DBA to support the operations and maintenance of production as well as non-production databases running on a Unisys ClearPath MCP server running DMSII and DataBridge, and to support interfaces to Oracle and SQL Server databases.
In this role, the selected DBA will provide Unisys DMSII database administration, design, and development support in our diverse, fast-paced, & growing environment. The Database Administrator will also analyze system performance, database performance, system health checks, and collaborate with Development teams to tune new and existing database access interfaces. This role provides plenty of opportunity for personal growth and development, while interacting with a positive, open team that is supportive of continued knowledge sharing and team advancement.
-Perform database administration, maintenance, and operational support activities for Department of Treasury.
-Performs system/application and database monitoring, alerting, database performance tuning.
-Identify and solve minor and major bugs, and issues on a 24×7 basis.
-Work with developers and others to support their ability to use the data to further the interests of the agencies. This includes data cleanup, conversions, running scripts, synchronizing versions, database upgrades etc.
-Employ technologies to support applications development and routine maintenance of Unisys DMSII databases: Unisys DASDL schema language, Unisys DMALGOL programming language, Unisys WFL script language, Unisys CANDE editor, Unisys DMSII utilities, DMSII security controls, DBATools for DMSII database performance and resources monitoring software, DMSII database recovery and Unisys SimpleInstall utility for installing DMSII-related Unisys software.
-Employ DataBridge and Oracle technologies to support the replication of Unisys DMSII databases onto Oracle and other databases.
-Troubleshoot the problems and design solutions to operational and/or performance problems with the databases.
-Work with management to develop database strategies to support agency needs; Consult and advise users on the use of databases and resolve data conflicts.
-Perform DBA tasks including but not limited to: Data and Structural Definition Language (DASDL) and DASDL compilation; Unisys Dmutility functionality including backup and restore; DMSII host- language interface with COBOL, XGEN, WFL and ALGOL, including syntax and execution process; DMSII internals, including structure of datafiles and indexes.
-Administration activities related to UNISTAR/URSA, BLSOURCE, BLPACK, BLSCHED
MI-RTR-651993
MI_Resume_Template-651993