Application Support Analyst (Database)
Core
Level 2 Application Support and Database Administration for enterprise business applications and database environments.
Role type
Senior IC Application Support Engineer (Database)
Builds
Enterprise business applications and database environments
Domain
IT Services / Database Administration
Required skills
Microsoft SQL Server administration, Azure SQL Database, T-SQL, database monitoring, query tuning, PowerShell scripting, ITSM processes, database security, backup and restore procedures
Preferred skills
Microsoft database certification (DP-300), cloud migration experience
Technologies
Microsoft SQL Server, Azure SQL Database, Azure SQL Managed Instance, PowerShell
Responsibilities
Investigate and resolve incidents across application, integration, and database layers; Administer and maintain production, test, and development databases; Perform database installation, configuration, patching, upgrades, and scheduled maintenance; Monitor database health, performance, availability, storage capacity, and scheduled jobs; Troubleshoot slow queries, blocking, deadlocks, and performance issues through query tuning and index optimisation; Manage database backups, restores, security permissions, encryption, and audit requirements; Support Azure SQL Database, Managed Instance, cloud migrations, and database optimisation; Assist with application releases, upgrades, system integrations, and change management activities; Automate routine database administration tasks and maintain technical documentation and support procedures; Collaborate directly with Australian IT teams and business stakeholders to resolve technical issues.
Seniority
Senior, hands-on IC