Velan Consulting Pty Ltd Hiring for SQL Database Administrator at Australia Full Time

Velan Consulting Pty Ltd – Australia Based Direct Supplier to all our Clients (Government & Private)

All Velan Consulting Active Roles PD Link:

https://lnkd.in/ghx6xWNn

SQL Server/Azure Database Administrator | Canberra | Hybrid / Offsite / Remote | Citizens | Contract

Job Description:

The Database Administrator will be required to:

• Manage and optimize Azure-based database solutions, including Azure SQL Database and Azure SQL Managed Instance
• Troubleshoot common database issues, integrity, performance, blocking and deadlocking, query plan pinning, tuning database queries, replication issues, log shipping issues, connectivity and network issues, security issues, etc. including detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
• Monitor and on database service availability, performance and proactively identify and resolve performance bottlenecks and issues
• Perform database capacity planning and ensure scalability and high availability of database systems.
• Conduct regular database maintenance activities, including data purging, index rebuilding, and statistics updating.
• Create documentation to including s, processes, procedures, and troubleshooting steps.
• Provide technical guidance and input into the design and build of on premise and cloud-based systems
• Ensure that the enterprise and system solutions maintain adherence to whole-of-government standards
• Work with the delivery manager to support our agile delivery approach
• Collaborate and mentor team members and support cross-skilling
• Undertake additional duties as required

Essential criteria

1. Experience with Microsoft SQL (all versions), Windows Servers (all versions), PowerShell scripting, managing backups, replication, log shipping, knowledge in storage Infrastructure, SQL performance monitoring and tuning, security principles and best practices
2. Experience with SQL Server internals, performance tuning, and query optimization
3. Experience with Azure SQL Database and Azure SQL Managed Instance, Azure DevOps and Visual Studio for code development, management, repositories, and deployments CI/CD
4. Familiarity with Azure Data Studio, Azure Portal, and other Azure database management tools.
5. Ability to analyse and troubleshoot database-related issues.
6. Excellent communication and teamwork skills.
7. Experience working with agile multi-disciplinary teams to deliver secure, user friendly and reliable solutions that meet stakeholder, citizen, and business expectations.
8. Ability to pragmatically change direction and scope as new information is discovered and challenges or opportunities present themselves

Desirable criteria

1. Demonstrated track record of technical leadership across project and operational tasks
2. Demonstrated experience and understanding of SQL architecture at an Enterprise Level
3. Demonstrated experience in Migration of SQL into Azure
4. Experience designing and documenting architectures for large, complex enterprise systems

Please mail your Resume in word format along with Residency Status, Security clearance, Location, Availability details, Role Preference, Current & Expected Salary, Reason for Job change, constraints if any – to : jobs@velanconsulting.com.au

Cheers,

Recruitment Team

Velan Consulting Pty Ltd.

LinkedIn Group Subscription Link:

https://lnkd.in/ei-YP3B

Phone: +61 2 8007 4575 / +61 2 8006 1416