Unisys OS 2200 Database Administrator

Title: Unisys OS 2200 Database Administrator

Location: Remote

Duration: Long-term Contract

Qualifications

• Bachelor of Science, or equivalent education.
• Minimum of 8 to 10 years of Unisys DBA experience on an OS 2200 platform.
• 15 years of Unisys DBA experience on an OS 2200 platform in place of a degree.
• Must be client-focused, display people skills, and be an effective team member.

Required Skills

• Experience as a DBA on Unisys OS 2200 primarily for Database Management System (DMS 2200) (Network Database) but also Relational Database Management System (RDMS 2200) using fundamental principles, theories, techniques, and methodologies of data processing systems analysis.
• Knowledge of computer programming, database design, and applicable tools.
• Experience with Unisys COBOL, both ACOB and UCOB.

Desired Skills

• Knowledge and experience in the following areas is highly desirable.
• Meta-Assembler (MASM)
• Symbolic Stream Generator (SSG)
• Access Location Number (ALN)
• CMplus

Job Description

• Selected candidate will provide Unisys database administration, design, and development support in a diverse, fast-paced, & growing environment of a Federal Government Agency. The Database Administrator will collaborate with Development teams to modify and tune new and existing database access interfaces as well as analyze database performance as needed.
• The DBA candidate will support the operations and maintenance of non-production databases and provide secondary support to production database support personnel. The operating environment consists of multiple Unisys Dorado 8590 partitions. Most applications utilize DMS 2200 databases with a few smaller applications utilizing RDMS 2200. The DBA will have experience with modification of existing schemas, subschemas, and RDMS tables; maintaining and executing UCOB applications; programming, planning, designing, developing, analyzing, evaluating, and resolving application problems using the databases; knowledge of database backup, restore, recovery capabilities.

Day to Day Job Responsibilities

• Monitor database area space usage on the Production systems.
• Respond to all user requests for information and support on an as needed basis.
• Employ technologies to support applications development and routine maintenance of Unisys databases: DDL, SDDL, UREP, etc.
• Work with management to develop database strategies to support agency needs; Consult and advise users on the use of databases Troubleshoot the problems and design solutions to operational and/or performance problems with the databases.
• Answer questions about installation, operation, configuration, customization, and usage of database-related software products. Identify and solve application and system problems, and issues on a 24x7 basis.
• Apply diagnostic techniques to identify problems, investigate causes, and recommend solutions to correct failures.
• Provide alerts and situation status information to the customer management team.
• Coordinate critical issues as well as new product and/or system implementations.
• Monitor performance and ensure completion of operational processes including incident resolution, root cause analysis, change management, and continual service improvement.
• Prepare, approve, and coordinate the implementation of technical documentation and ensure that technical documentation is current, accurate and complete.
• Identify, develop, and conduct training needs for others as appropriate.
• May participate in or lead defined project activities, and initiates process improvements.
• Will be required to provide on call support when required.
• Performs system/application and database monitoring, alerting, database performance tuning.
• Collaborate with developers and others to support their ability to use the data to further the interests of the customer. This includes data cleanup, conversions, running scripts, synchronizing versions, database upgrades, etc.
• Periodical and Ad hoc Tasks Execution
• Monitor and respond to any issues resulting from the implementation of the new schemas on an annual basis.
• Implement scheme changes as directed by the business unit on an annual basis and coordinate the changes with all Unisys applications within the customer environment.
• Every other year execute the process to refresh test data on the Development system.
• Amend unload/reload/conversion programs corresponding to the schema changes.

Execute processes to

• Install the new scheme on the Development system.
• Migrate the data from the prior schema to the new schema on the Development system.
• Execute schema installation tasks for
• Systems Acceptance Test system.
• Final Integration Test system.
• Production systems.

Upon User Request

• Execute the process to refresh the data used for Training purposes on the Production systems.
• Update glossaries (data dictionaries) based on user requests.
• Make source schema changes based on user requests.