At a Glance
- Tasks: Lead SQL Server administration and optimise database performance in Azure environments.
- Company: Join a forward-thinking tech company focused on geospatial data management.
- Benefits: Attractive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic team environment with excellent career advancement potential.
- Why this job: Make an impact by managing cutting-edge database technologies and supporting innovative GIS solutions.
- Qualifications: Expertise in SQL Server, Azure, and ArcGIS with strong analytical skills.
The predicted salary is between 63000 - 77000 £ per year.
Job Overview
We are seeking a Senior Azure SQL Server Database Administrator with deep expertise in Microsoft SQL Server, Azure cloud technologies, and support for Arc GIS Enterprise environments.
This role is ideal for professionals who excel in SQL Server administration, cloud integration, database performance optimization, and geospatial data management.
The successful candidate will work on SQL Server initiatives including high availability, performance tuning, monitoring, deployment configurations, and support of Arc GIS Enterprise geodatabases deployed on Azure as SQL Server MI.
Key Responsibilities
- SQL Server Administration
- Lead installation, configuration, and maintenance of SQL Server instances (2016/2019/2022) in on-premises and Azure environments.
- Design and implement High Availability solutions including Always On Availability Groups, Failover Clustering, and Azure Geo-Replication.
- Perform database performance tuning using DMVs, Query Store, Extended Events, and Database Tuning Advisor.
- Manage SQL Server Agent jobs, linked servers, and Database Mail.
- Oversee database migrations, upgrades, patching, and lifecycle management.
- Implement robust backup and recovery strategies using native SQL Server tools and Azure Backup.
- Ensure database security through role-based access controls, encryption, auditing, and compliance best practices.
- Collaborate with development, infrastructure, and cloud teams to optimize system performance and troubleshoot database issues.
- Maintain technical documentation including SOPs, DR plans, capacity planning, and operational runbooks.
- Arc GIS Database Administration & Support
- Administer and support Arc GIS Enterprise geodatabases hosted on Microsoft SQL Server.
- Support Arc GIS Server, Portal for Arc GIS, and associated GIS infrastructure teams.
- Monitor and optimize GIS database performance for map services, feature services, and geospatial workloads.
- Perform geodatabase maintenance activities including index rebuilding, statistics updates, compress operations, and data integrity checks.
- Support GIS data migration, replication, and synchronization processes.
- Troubleshoot database-related issues impacting Arc GIS applications and services.
- Collaborate with GIS administrators, developers, and business stakeholders to ensure platform reliability and scalability.
- Ensure adherence to ARCgis and Microsoft best practices for geodatabase management and performance.
- Required Qualifications & Skills
- Technical Skills
- SQL Server (Senior Level)
- Strong experience with SQL Server administration and Azure SQL.
- Expertise in Always On Availability Groups, Clustering, performance tuning, backup/recovery, and security.
- Experience with Azure SQL Managed Instance, Azure Virtual Machines, Azure Monitor, Azure Backup, and Azure Storage.
- Proficiency in T-SQL and Power Shell scripting.
- Experience implementing monitoring, automation, and operational best practices.
- Arc GIS & GIS Database Support
- Experience supporting Esri Arc GIS Enterprise environments.
- Knowledge of Enterprise Geodatabases on SQL Server.
- Understanding of Arc GIS Server, Portal for Arc GIS, and GIS architecture.
- Experience with geodatabase maintenance, versioning, replication, and performance tuning.
- Familiarity with GIS data management and spatial data concepts.
- Understanding of Arc GIS deployment and integration within Azure environments is highly desirable.
- Soft Skills
- Strong analytical and troubleshooting abilities.
- Excellent communication and documentation skills.
- Ability to work independently and collaboratively in a fast-paced environment.
- Strong stakeholder management and cross-functional collaboration skills.
- Ability to prioritize critical production incidents and operational tasks.
- Preferred Certifications
- Microsoft Certified: Azure Database Administrator Associate.
- Microsoft Azure Administrator Associate.
- Esri Technical Certification (Arc GIS Enterprise Administration or related GIS certification) preferred
Senior Azure SQL Server Database Administrator employer: PFH Technology Group
Join a forward-thinking company that values innovation and expertise in the realm of cloud technologies and database management. As a Senior Azure SQL Server Database Administrator, you will thrive in a collaborative work culture that prioritises professional growth and offers opportunities to enhance your skills in SQL Server and ArcGIS environments. Located in a vibrant area, our company provides a supportive atmosphere with competitive benefits, ensuring that you can make a meaningful impact while advancing your career.
