04 Oct
|
PALAS Consulting
|
Canberra
04 Oct
PALAS Consulting
Canberra
Job Description
Canberra | In office | Federal Government ICT Sustainment and Upgrade Program n
PALAS Consulting is seeking a Senior SQL Server Engineer for a significant Federal Government ICT sustainment and upgrade program commencing late ****. This is a multi-year engagement, contracted yearly with extensions, supporting a large SQL Server estate on a secure Federal Government network.
n
The role combines application database work with platform ownership. On the application side you will support and enhance the databases behind business applications in daily use, including T-SQL development, schema change and Service Broker messaging. On the platform side you will run SQL Server as a managed service, covering patching, availability, backup and recovery, capacity and performance. You will work within a delivery team alongside application support specialists, integration engineers and platform engineers.
Key Responsibilities n
n
Administer and develop SQL Server databases supporting custom built and commercial applications in production use.
n
Write and tune T-SQL, stored procedures and Service Broker components, and advise developers on database design.
n
Operate SQL Server as a managed service, including patching, Always On availability groups or failover clustering, backup and recovery, and capacity planning.
n
Diagnose performance and availability issues across the database, storage and application layers, resolving them within formal incident, change and release processes.
n
Support releases, upgrades and migrations, including verification and rollback readiness.
n
Maintain platform documentation, build standards and standard operating procedures.
n
Required Experience n
n
Extensive hands-on SQL Server experience spanning both database development and database administration.
n
Demonstrated experience running SQL Server in an enterprise DBA or managed service capacity, with high availability and disaster recovery configurations in production.
n
Strong T-SQL, including performance tuning and query optimisation.
n
Experience working within structured ITSM processes for incident, problem, change and release management.
n
Clear written documentation and confident engagement with developers, infrastructure teams and business stakeholders.
n
Australian citizenship is mandatory.
n
Must hold a current and active AGSVA security clearance at NV1 or higher. NV2 is preferred, and NV1 holders must be willing to upgrade.
n
Service Broker implementation or support experience.
n
SSIS, SSRS or other components of the Microsoft data platform.
n
PowerShell for SQL Server automation.
n
Experience supporting SQL Server in secure or highly governed environments.
n
Microsoft certification in SQL Server or Azure database administration.
n
Location and Working Arrangements n
This role is Canberra based and on-site. Commencement is expected in late ****, with candidates holding notice periods encouraged to apply early.
About PALAS Consulting n
PALAS Consulting is a Canberra-based consultancy supporting complex government transformation and technology initiatives. We are known for trusted delivery, professional credibility and long-term client relationships. Our consultants work on nationally significant programs and are supported by a professional, high-standard culture.
#J-*****-Ljbffr
📌 Senior Sql Server Engineer (Canberra)
🏢 PALAS Consulting
📍 Canberra