ENGINEERING AND STRUCTURAL GEOLOGY SOFTWARE

Infrastructure & SQL Automation Engineer

Location: Guildford, Surrey

Apply Now

Company Information

PE Limited is a market leader in integrated engineering software solutions, delivering state-of-the-art modelling and optimisation products, primarily to the global oil and gas, mining and renewable industries. Our cutting-edge tools support critical decision-making for all of the world’s leading energy companies by integrating complex data into powerful, easy-to-use models. 

Established in 1990, we have grown into a hugely successful business with more than 450 clients across the world, ranging from small consultancies to major multinational corporations. Our expansion led us to relocating our UK Headquarters from Edinburgh to Guildford in 2025, with further growth anticipated internationally. 

With ambitious plans to expand into new industry sectors, this is an exciting time to join us as we grow our brand presence and broaden our impact across the energy landscape. 

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.