11 Nov
|
BlueRose Technologies
|
Sydney
11 Nov
BlueRose Technologies
Sydney
Job Title: SQL L2 Administrator (DBA)
Location: Sydney, Australia
Contract Duration: 6 Months
Experience: 6-8+ Years
:
We are seeking an experienced SQL SME / Lead to oversee SQL Server database environments, lead database operations, and ensure optimal performance, availability, security, and reliability. The ideal candidate should have robust technical expertise in SQL Server, database administration, performance tuning, and team leadership.
Key Responsibilities:
- Lead and mentor SQL Developers and DBAs, acting as the subject matter expert for SQL Server.
- Design, implement, and maintain scalable SQL Server database solutions.
- Develop and optimise T-SQL queries, stored procedures, and functions.
- Perform advanced performance tuning, query optimisation, and index management.
- Manage database health, security, integrity, backup, recovery, and archiving.
- Implement High Availability and Disaster Recovery solutions, including Always On, Log Shipping, Replication, and Mirroring.
- Participate in P1/P2 incident bridge calls and provide Root Cause Analysis (RCA) documentation.
- Maintain SOPs, technical documentation, audit evidence,
and compliance reporting.
- Implement automation and self-healing mechanisms for database operations.
- Manage certificate renewals in cluster environments and support capacity planning across production and non-production environments.
- Collaborate with cross-functional teams to deliver database solutions.
Mandatory Skills & Experience:
- 8+ years of hands-on experience in SQL Server environments, including leadership responsibilities.
- Strong expertise in SQL Server, T-SQL, and PowerShell scripting.
- Experience in database administration, performance tuning, and troubleshooting.
- Strong knowledge of High Availability, Disaster Recovery, and clustering.
- Understanding of Windows Server Administration, DNS, Active Directory, and networking concepts.
- Experience with monitoring and operational tools such as ServiceNow (SNOW), Foglight, AppDynamics, Splunk, DDBoost, Control-M, Windows PerfMon, and SSRS.
- Knowledge of audit, compliance, capacity planning, and database automation.
📌 SQLAdministrator (DBA) (Sydney)
🏢 BlueRose Technologies
📍 Sydney