Lead MS SQL Data Platform Administrator

DFAT has a requirement to recruit a database administrator to work in the Database Management and Dynamics section to provide specialist development, technical services and support for DFAT’s database management capabilities. SFIA Role Category and Skills Level: Development and implementation - Database Administration - Database Administration (DBAD) - Level 4/5 APS equivalent level: EL1 equivalent is preferred. APS6 equivalent with sufficient experience and willingness to learn may be considered. Please note: DFAT has already selected a suitable number of panel suppliers to participate in this business opportunity. Vendor requests for inclusion will not be responded too.   Key duties and responsibilities Install, configure, and maintain MS SQL database instances, ensuring high availability and performance. Monitor and manage database performance, replication, identifying and resolving performance bottlenecks using index tunning, DVM and third-party monitoring tools. Develop, implement, and manage database clustering, maintenance plans, including automated backups and disaster recovery strategies. Manage security configurations, including certificate management and access control. Manage and optimise SSAS/SSIS/SSRS and Power BI reporting environments. Troubleshoot and resolve performance issues across hybrid and cloud environments, optimising configurations to enhance efficiency on Azure, AWS. Maintain comprehensive documentation for all database configurations, changes, and procedure for both on premises and cloud environments. Criteria The buyer has specified that each candidate must provide a response to each criterion. Each response is limited to 3000 characters. Essential criteria 1. Experience: 7+ Years in a similar role. 2. Platforms: Practical experience with Microsoft SQL Server products, including use of Always-On Availability Groups, Azure SQL databases. 3. Programming: Strong SQL/T-SQL, PowerShell to support the SQL Server software and streamline or automate daily database management activities. 4. Strong problem-solving skills and a proactive approach to database management. 5. Excellent communication skills, with the ability to work effectively in a team-oriented environment. Desirable criteria 1. Azure and DevOps: Experience with DevOps processes and tools such as Azure DevOps and Git, Azure SQL Databases. 2. Experience with SQL Database development. Opportunity summary Sellers can submit Up to 2 candidates Number of sellers invited More than 10 Number of candidates submitted Fewer than 10 RFQ closing time 02 Weeks 00 Days 12 Hours Send us feedback About Accessibility Privacy Terms of use Disclaimer and copyright An initiative of the Digital Transformation Agency The Australian Government acknowledges the Traditional Owners of Country throughout Australia and acknowledges their continuing connection to land, waters and community. We pay our respects to the people, the cultures and the Elders past and present. © Commonwealth of Australia