Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Manage server infrastructure and automate SQL deployments using PowerShell.
- Company: Join a leading software vendor in the oil and gas industry with a global client base.
- Benefits: Enjoy a competitive salary, performance bonuses, and a company pension.
- Why this job: Be part of an innovative team tackling energy transition technologies and making a real impact.
- Qualifications: Bachelor's degree in Computer Science or related field; Microsoft certifications preferred.
- Other info: Work in a dynamic environment with opportunities for growth and learning.
The predicted salary is between 43200 - 72000 £ per year.
ENGINEERING AND STRUCTURAL GEOLOGY SOFTWARE
Infrastructure & SQL Automation Engineer
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.
· 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.
#J-18808-Ljbffr
INFRASTRUCTURE & SQL AUTOMATION ENGINEER employer: Petroleum Experts
Contact Detail:
Petroleum Experts Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land INFRASTRUCTURE & SQL AUTOMATION ENGINEER
✨Tip Number 1
Familiarise yourself with the latest trends in cloud environments, especially Azure, as this role requires a strong understanding of cloud infrastructure. Consider joining online forums or communities where professionals discuss their experiences and share insights about cloud technologies.
✨Tip Number 2
Brush up on your PowerShell scripting skills, as automation is a key part of this role. You might want to create small projects or scripts that demonstrate your ability to automate SQL deployments and server configurations.
✨Tip Number 3
Network with professionals in the oil and gas industry, particularly those who work with SQL Server and automation. Attend industry conferences or webinars to make connections and learn more about the specific challenges they face.
✨Tip Number 4
Prepare to discuss your experience with data modelling and ETL pipelines during interviews. Having real-world examples ready will help you demonstrate your expertise and how it can benefit our team at StudySmarter.
We think you need these skills to ace INFRASTRUCTURE & SQL AUTOMATION ENGINEER
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in PowerShell scripting, SQL Server management, and server infrastructure administration. Use specific examples that demonstrate your expertise in automation and cloud environments.
Craft a Compelling Cover Letter: Write a cover letter that connects your skills and experiences directly to the job description. Emphasise your understanding of energy transition technologies and how your background aligns with the company's future goals.
Showcase Technical Skills: In your application, clearly outline your technical skills related to SQL deployments, data modelling, and cloud platforms. Mention any relevant certifications or projects that showcase your capabilities in these areas.
Proofread and Edit: Before submitting your application, carefully proofread all documents for spelling and grammatical errors. A polished application reflects attention to detail, which is crucial for the role of an Infrastructure & SQL Automation Engineer.
How to prepare for a job interview at Petroleum Experts
✨Showcase Your Technical Skills
Be prepared to discuss your experience with PowerShell scripting and SQL Server management. Bring examples of complex queries or automation scripts you've developed, as this will demonstrate your hands-on expertise.
✨Understand the Company’s Focus
Research the company's role in the energy transition and how they apply their technology across various sectors. This knowledge will help you align your answers with their goals and show your genuine interest in their mission.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving abilities, especially related to server management and data synchronization. Practice articulating your thought process when faced with technical challenges.
✨Highlight Your Soft Skills
While technical skills are crucial, don't forget to emphasise your communication and teamwork abilities. Share examples of how you've successfully collaborated with others or managed multiple tasks in a fast-paced environment.
