Database Administrator jobs

Cobol Unisys OS DBA

Sonsoft Inc (agency)Harrisburg, PAContractOn-siteNo US visa sponsorship

Pay not listed

2 things to check before you apply.

On Sonsoft Inc’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 9 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 60 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Design, maintain, reorganize, and plan capacity for Unisys OS2200 DMS and RDMS databases.
  • Code and interpret database schemas and subschemas, and maintain the OS2200 data dictionary.
  • Develop COBOL database unload, reload, maintenance, and reorganization programs and routines.
  • Monitor database sizes and overflow-page usage; plan expansions and recommend purge and archive processes.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • Familiarity with both transaction and batch processing
  • Familiarity with distributed transaction processing based on the x/Open model and standard

Skills

  • Proficiency with the DBE (Database Editor) utility for analysis and maintenance of Unisys OS2200 DMS databases

Other requirements

  • Ability to work on-site in Harrisburg, Pennsylvania
  • Ability to work non-standard hours occasionally
  • U.S. citizenship or independent authorization to work in the United States; sponsorship is unavailable

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Sonsoft Inc’s careers site

Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Duration: Up to 5 years Interviews: 1st will be over the phone. 2nd will be over Skype or in person, if local. Note: More than likely you're going to find ex-Unisys employees that have this experience, which is fine. Summary:

Show full descriptionShow less
  • This position description is for an on-site consultant who would provide design support and maintenance for the customer’s Unisys OS2200-based hierarchical (DMS) and relational databases (RDMS).
  • Unisys OS2200 hierarchical (DMS) databases conform to CODASYL network database standards.
  • Unisys OS2200 relational (RDMS) databases are compliant with SQL standards.
  • This position will be on-site working with the customer’s IT staff in their offices in Harrisburg, PA.
  • The candidate selected for this position will provide support for OS2200 logical and physical database design and maintenance and review and prepare for growth of OS2200 databases.
  • This consultant would also be called upon to develop special utility programs for database maintenance.
  • The types of database maintenance to be performed include the addition, modification, or deletion of database records and the addition, modification, or deletion of fields in database records.
  • Other database maintenance areas would involve the analysis and addition of access mechanisms to improve the performance of database queries.
  • Coordination of the data dictionary for the Unisys OS2200 databases would also be required.

The following list includes the job responsibilities for this consultant position:

  • Perform logical database design for Unisys OS2200 DMS hierarchical databases.
  • Perform physical database design for Unisys OS2200 DMS hierarchical databases.
  • Code and interpret schemas for Unisys OS2200 DMS hierarchical databases.
  • Code and interpret subschemas for Unisys OS2200 DMS hierarchical databases.
  • Perform database reorganizations for Unisys OS2200 DMS hierarchical databases.
  • Perform logical database design for Unisys OS2200 RDMS relational databases.
  • Perform physical database design for Unisys OS2200 RDMS relational databases.
  • Code and interpret schemas for Unisys OS2200 RDMS relational databases.
  • Code and interpret subschemas for Unisys OS2200 RDMS relational databases.
  • Create COBOL programs to perform database unloads and reloads, as needed, for Unisys OS2200 DMS and RDMS database maintenance functions.
  • Create hierarchical (DMS) database maintenance and reorganization routines, as needed, using I-QU PLUS-1 software from KMSYS Worldwide Inc.(http://www.kmsys.com).
  • Create hierarchical (DMS) database maintenance routines, as needed, using Unisys OS2200 DMU and DRU utilities.
  • Coordinate and maintain the data dictionary using the Unisys UREP products.
  • Proactively monitor the sizes of Unisys OS2200 DMS and RDMS databases and proactively develop and execute plans to increase sizes of databases and make recommendations on purge and archive processes to deal with the removal of old records.
  • Proactively monitor Unisys OS2200 DMS DARP and SARP page usage for handling the storage of additional records onto overflow pages.
  • This is critical so that there is always a sufficient amount of overflow pages to handle the requirements of the customer’s mission-critical applications.
  • Perform capacity planning for Unisys OS2200 DMS and RDMS databases to plan for disk storage capacity to meet the needs of current and upcoming applications.
  • This is also critical to help ensure that sufficient lead time is availalble for funding, purchasing, and preparing additional disk storage.
  • Assist in diagnosing and addressing application issues in COBOL programs that use Unisys OS2200 DMS and RDMS databases.
  • Based on the nature of the application issues and the impacts to the database design and integrity, this consultant will be called upon to develop automated processes to identify and correct the impacted fields in database records and relationships between records.
  • The COBOL programs may perform transaction processing or batch processing.
  • Familiarity with both transaction and batch processing is critical.
  • The customer also has a large number of Windows-based custom-built .NET multi-tier applications that integrate with the Unisys OS2200 COBOL applications and DMS and RDMS databases.
  • Familiarity with distributed transaction processing based on the x/Open model and standard is critical.
  • Be proficient in the use of the DBE (Database Editor) utility for performing analysis and maintenance of Unisys OS2200 DMS databases.
  • This consultant will be required to work non-standard hours, on occasion, to complete some of the migration work to avoid disrupting users or systems during the normal business day.

Additional Information

** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.

Note:-

  • This is a Contract job opportunity for you.
  • Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, OPT-EAD & TN-Visa can apply.
  • No H1B candidates, please.
  • Please mention your Visa Status in your email or resume.

** All your information will be kept confidential according to EEO guidelines.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs

Database Administrator

Stevens Capital Management LP · Radnor, PA

$100k–$200k/yr · see posting

2 to checkChecked open todayPosted 5 months ago

Cleared Sr. Oracle DBA

Oracle · Reston, VA +2 places

$85k–$210k/yr · see posting

Wide pay rangeChecked open todayPosted 4 days ago

See more like this