ENGINEERING AND STRUCTURAL GEOLOGY SOFTWARE

Infrastructure & SQL Automation Engineer

Location: Guildford, Surrey

Apply Now

Company Information

Our organisation was created in 1990 as a vendor of integrated modelling software to the oil and gas industry. Since then we have built up a hugely successful business with more than 450 clients across the world, ranging from small consultancies to major multinational corporations. In our last trading year the company turned over £66m and has significant cash reserves which are to be held for future expansion.

In this regard, we see an exciting future which embraces the challenges around energy transition technologies and renewables. In addition, we see huge scope in applying the lessons that we have learnt within this industry to other sectors, notably mining, banking, and medicine.

PE Limited currently has around 100 staff members, split roughly between technical support, providing solutions for customers, product development, and contract and licensing administration. The technical staff are all highly qualified, with almost everyone having at least a Masters qualification and many holding PhDs.

 

Technical Team

We are responsible for Digital Oil Field Solutions for global clients, as well as providing trainings on all our tools and software products. We also conduct workshops on specific Engineering objectives for our clients to maximize value from their Oil & Gas fields and optimizing performance.

About this Vacancy

We are seeking a highly skilled and motivated Infrastructure & SQL Automation Engineer to join our Technical team. The ideal candidate will have deep expertise in:

  • PowerShell scripting,
  • SQL Server management and development,
  • Server infrastructure administration,
  • Automation of SQL deployments

 

This role requires a strong understanding of cloud environments, data synchronization, and data modelling, with a focus on scalability, security, and efficiency.

 

Key Responsibilities:

Server & Infrastructure Management:

·      Manage on-premise and cloud-based server infrastructure (Windows Server preferred)

·      Perform routine system updates, patches, and security audits.

·      Administer SQL Server instances and environments across dev, test, and production.

SQL Server Expertise:

·      Develop and optimize complex SQL queries, stored procedures, and functions.

·      Analyze and synchronize large-scale data across systems using SQL tools.

·      Design and maintain logical and physical data models to support business needs.

Automation & Scripting:

·      Use PowerShell to automate server and SQL deployments, configurations, and monitoring.

·      Build and maintain scripts for backup, disaster recovery, and routine database tasks.

Cloud Deployment & Management:

·      Manage deployments in cloud environments (Azure, AWS, or GCP).

·      Automate provisioning and scaling of SQL instances in the cloud.

·      Implement best practices for cloud security, storage, and performance.

Monitoring & Reporting:

·      Implement proactive monitoring and alerting solutions for server and database performance.

·      Prepare system documentation, performance reports, and capacity planning.

Qualifications

Preferred Qualifications:

·      Bachelor’s degree in Computer Science, Information Systems, or a related field.

·      Microsoft certifications (e.g., Azure Administrator Associate, SQL Server Database Development).

·      Experience with infrastructure-as-code tools like Terraform or ARM templates.

·      Exposure to DevOps pipelines and CI/CD tools for database and infrastructure deployment.

Skills

Technical Skills:

·      Proficient in PowerShell scripting for automation and task scheduling.

·      Expert-level knowledge of Microsoft SQL Server, T-SQL, and stored procedures.

·      Hands-on experience with server administration (Windows environment preferred).

·      Solid understanding of cloud platforms (Azure preferred; AWS/GCP a plus).

·      Experience in automated deployment of SQL instances and server configuration.

·      Familiarity with data modeling, ETL pipelines, and data synchronization.

 

Soft Skills:

·      Strong problem-solving and troubleshooting skills.

·      Ability to work independently and manage multiple tasks.

·      Excellent communication and documentation skills.

Package

Our package offers a competitive salary plus other benefits, including performance related bonus and company pension.