SC Cleared SQL Schema Engineer

fortice; Shrewsbury; Hybrid; GBP 45,000 - 60,000; Full time

Job summary

A technology consulting firm is looking for an SQL Schema Engineer to apply SQL schemas across various environments. The role will involve managing and deploying SQL schemas, specifically in VME and WebLogic environments, while performing upgrades and maintenance tasks. Strong experience with SQL schema application and Unix/WebLogic environments is required. The position is based in Telford with a mandated onsite presence for 2 days a week.

Responsibilities

• Apply SQL schemas and packages across various environments.
• Manage and deploy SQL schemas, focusing on VME schemas.
• Create and manage handovers for different environments.
• Perform upgrades and maintenance for dev/test environments.
• Rebuild WebLogic domains as necessary.
• Deploy HostTalk MSI handovers and manage versions.
• Conduct Unix/WebLogic housekeeping tasks.

Skills

SQL schema application

VME knowledge

WebLogic experience

Problem-solving abilities

Deploying handovers

Organizational skills

Unix housekeeping

Job description

SQL Schema Engineer

Clearance Required : SC

Duration : 6 months

Location : Telford 2 days onsite

IR35 Status : Mandated PAYE only

Key Responsibilities

Apply SQL schemas and packages across various environments, including 30 CESA VME STU, 40 CRS, and 20 SLP WebLogic environments.

Manage and deploy SQL schemas, particularly focusing on VME schemas.

Create and manage handovers for VME, WebLogic, and HostTalk environments.

Perform upgrades and maintenance for dev / test environments.

Rebuild WebLogic domains and edit properties files as needed.

Deploy HostTalk MSI handovers and manage different versions for various projects.

Perform housekeeping tasks, especially for Unix / WebLogic environments, and raise RFCs with Fujitsu for filesystem issues.

Required Skills

• Strong experience with SQL schema application and management.
• Knowledge of VME, WebLogic, Tuxedo, Windows, and SQL databases.
• Ability to solve problems related to VME, WebLogic, and HostTalk environments.
• Familiarity with deploying handovers and performing upgrades.
• Ability to rebuild WebLogic domains.
• Strong organizational skills for managing different versions of HostTalk and GovRules.
• Experience with Unix / WebLogic housekeeping.