Database Administrator

vor 4 Wochen

Canberra, Österreich ClearCompany Vollzeit

SQL DBA - Federal Government - Security Clearance Required

Location: Canberra, ACT - Hybrid
Contract: 12-month contract (plus two 6-month extensions)

About the Role: Our client, a major branch of the federal government, is looking for an experienced Database Administrator (DBA) who is an Australian Citizen with baseline security clearance. The successful candidate will join their dynamic team, providing expert management of their SQL Server databases and Azure cloud environments. This role requires a blend of project-based work and business-as-usual (BAU) operations, ensuring the performance, availability, and security of critical data systems.

Responsibilities:

  • Database Management: Oversee the installation, configuration, and maintenance of SQL Server databases to ensure optimal performance, availability, and security. This includes managing backups, restores, and data replication.
  • Performance Tuning and Optimisation: Analyse and tune database performance using SQL Profiler, Extended Events, and Dynamic Management Views (DMVs). Implement indexing strategies, monitor server performance, and resolve bottlenecks.
  • High Availability and Disaster Recovery: Design, implement, and manage high availability (HA) and disaster recovery (DR) solutions such as Always On Availability Groups, Failover Clustering, and Log Shipping.
  • Security Management: Ensure databases are secure by managing permissions, roles, and auditing. Implement encryption and other security measures to protect sensitive data.
  • Scripting and Automation: Develop and maintain T-SQL scripts and PowerShell scripts to automate routine database tasks, deploy database changes, and manage high availability clusters.
  • Monitoring and Maintenance: Utilise tools such as SQL Server Management Studio (SSMS), Azure SQL Database, and SQL Server Agent to monitor system health, job statuses, and performance metrics. Proactively identify and resolve issues.
  • Data Integrity and Recovery: Perform regular integrity checks, implement and monitor backup and restore procedures to ensure data recovery is reliable and efficient.
  • Collaboration and Support: Work closely with application developers, system administrators, and other stakeholders to support database-related needs. Provide guidance and best practices for database design, development, and maintenance.

Essential Tools and Technologies:

  • SQL Server Management Studio (SSMS): The primary interface for managing SQL Server instances. SSMS is used for database configuration, querying, and administration.
  • T-SQL (Transact-SQL): The primary language for interacting with SQL Server databases. T-SQL is used for writing queries, stored procedures, functions, and scripts.
  • PowerShell: A scripting language used for task automation and configuration management. PowerShell scripts can automate database maintenance tasks, deployments, and more.
  • SQL Server Agent: A component of SQL Server used to schedule and automate routine tasks, such as backups, maintenance plans, and alerting.
  • SQL Profiler and Extended Events: Tools used for monitoring and analysing SQL Server activity to troubleshoot performance issues and track down problematic queries.
  • Dynamic Management Views (DMVs): Built-in views that provide detailed information about the health, performance, and status of SQL Server instances.
  • Azure SQL Database: A fully managed relational database service provided by Microsoft Azure, used for building and managing scalable cloud-based applications.
  • Azure Data Studio: A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
  • Always On Availability Groups: A high availability and disaster recovery solution that provides an enterprise-level alternative to database mirroring.

Qualifications and Experience:

  • Demonstrable experience as a SQL DBA, with strong expertise in managing SQL Server databases and Azure environments.
  • Proficiency in T-SQL and PowerShell scripting for database management and automation.
  • Experience with high availability and disaster recovery solutions, including Always On Availability Groups and Failover Clustering.
  • Knowledge of performance tuning, query optimisation, and indexing strategies.
  • Understanding of database security best practices and experience implementing security measures.
  • Strong analytical and problem-solving skills, with the ability to troubleshoot and resolve complex database issues.
  • Excellent communication and collaboration skills to work effectively with cross-functional teams.

Eligibility:

  • Australian Citizenship is required.
  • Must possess baseline security clearance or be willing to undergo the clearance process.

This role offers an exciting opportunity to work on critical federal government projects, contributing to the modernisation and optimisation of their database infrastructure. If you are a dedicated and experienced DBA with a passion for technology and security, we encourage you to apply.

#J-18808-Ljbffr

  • Database Administrator

    vor 3 Wochen

    Canberra, Österreich Itbility Vollzeit

    Database Administrator (DBA)CanberraContract - 12 +MonthsMy client in Canberra is looking for Database Administrator (DBA) role.Kindly go through the below PD and let me know if the role suits and interests you, your friends or colleagues. You can send me your resumes/referrals at supriya.thorat@itbility.com.auEssential criteria1. Tertiary qualifications in...

  • Database Administrator

    vor 4 Wochen

    Canberra, Österreich Minutes To Seconds Vollzeit

    Canberra, Australia | Posted on 06/05/2024 State/Province Australian Capital Territory Country Australia Job DescriptionAbout the jobAt Minutes to Seconds, we match people having great skills with tailor-fitted jobs to achieve well-deserved success. We know how to match people to the right job roles to create that perfect fit. This changes the...

  • Database Administrator

    vor 1 Monat

    Canberra, Österreich Kirra Services Vollzeit

    The department is seeking an experienced Senior SQL Server Database Administrator, to enable the delivery of the Commissions objectives and outcomes by undertaking the design, implementation and operational support of database services infrastructure.The role will be responsible for, but not limited to:• Delivering solutions and support for our evolving...

  • Database Administrator

    vor 4 Wochen

    Canberra, Österreich Kirra Services Vollzeit

    The department is seeking an experienced Senior SQL Server Database Administrator, to enable the delivery of the Commissions objectives and outcomes by undertaking the design, implementation and operational support of database services infrastructure.The role will be responsible for, but not limited to:• Delivering solutions and support for our evolving...

  • Database Administrator

    vor 4 Wochen

    Canberra, Österreich CYOS Solutions Vollzeit

    Application closing date: Tuesday, 18 June 2024 • 11:59pm, Canberra time (or once all sellers have responded) (in Canberra) Estimated start date: Monday, 01 July 2024 Location of work: ACT Length of contract: 12 months Contract extensions: 2 x 6 months Security clearance: Must have Baseline Rates: $90 - $120 per hour (inc. super) The Department of the...

  • SQL Server Database Administrator

    vor 4 Wochen

    Canberra, Österreich Powerdatagroup Vollzeit

    Canberra, Australia | Posted on 05/06/2024 Requirement: Must have baseline Clearance We seek to engag an experienced Database Administrator. You will focus on maintaining and sustaining our database environment, including on-premises and cloud hosted. We are looking for a skilled resource that will play a key role in ensuring DBA project...

  • SQL Database Administrator, EL 1

    vor 3 Wochen

    Canberra, Österreich Geoscience Australia Vollzeit

    SQL Database Administrator As the SQL Database Administrator, you will independently own and drive operational excellence in the ACMA SQL infrastructure and services within the ICT platform services and support section. The ideal candidate is proficient in Microsoft SQL Server, has a strong understanding of database management systems, possesses excellent...

  • Database Administrator

    vor 3 Wochen

    Canberra, Österreich Hastha Solutions Vollzeit

    Canberra, Australia | Posted on 06/05/2024 State/Province Australian Capital Territory Country Australia Job Description Urgentrequirement of Database Administrator (DBA) - Contract - Canberra Requirements Tertiary qualifications in ICT or a related field and/or equivalent experience as a database administrator (8+ years). Experience...

  • SQL Database Administrator

    vor 4 Wochen

    Canberra, Österreich Experis ManpowerGroup Sp. z o.o. Vollzeit

    DeliverablesThe successful candidate will work to the direction of the project manager as well as: Deliver work packages to support multiple projectsDeveloping relevant documentation including handover to BAU, SoPs, detailed designs and high-level designs.Providing on the job training and knowledge transfer to other Treasury staff to support internal...

  • SQL Database Administrator, EL 1

    vor 3 Wochen

    Canberra, Österreich Australian Communications & Media Authority Vollzeit

    Full time $110,807 to $124,958 plus 15.4% superannuation As the SQL Database Administrator, you will independently own and drive operational excellence in the ACMA SQL infrastructure and services within the ICT platform services and support section. The ideal candidate is proficient in Microsoft SQL Server, has a strong understanding of database...

  • EL1 - Senior Systems Administrator

    vor 2 Monaten

    Canberra, Österreich HUMANISED GROUP Vollzeit

    Networks & Systems Administration (Information & Communication Technology) As a world leading customer facing Federal Government department, our client offers an innovative and collaborative workplace where exceptional team players and technical specialists can flourish. As part of the team, you will help support organisational reform, working...

  • EL1 - Senior Systems Administrator

    vor 4 Wochen

    Canberra, Österreich HUMANISED GROUP Vollzeit

    Networks & Systems Administration (Information & Communication Technology) As a world leading customer facing Federal Government department, our client offers an innovative and collaborative workplace where exceptional team players and technical specialists can flourish. As part of the team, you will help support organisational reform, working...

  • EL1 - Senior Systems Administrator

    vor 3 Wochen

    Canberra, Österreich HUMANISED GROUP Vollzeit

    As a world leading customer facing Federal Government department, our client offers an innovative and collaborative workplace where exceptional team players and technical specialists can flourish. As part of the team, you will help support organisational reform, working collaboratively with your team to shape the department’s future. We are seeking to...

  • Senior PeopleSoft Administrator

    vor 1 Monat

    Canberra, Österreich Bright Horizons Family Solutions Vollzeit

    Title: Senior PeopleSoft AdministratorDivision: Information Technology ServicesClassification: ANU Officer 8 (Information Technology)Position Description & Selection Criteria: Position Description - ANU8 - Senior PeopleSoft Administrator.pdfSalary package: Competitive remuneration package including 17% superannuationTerm: Full time, Fixed Term (up to 3...

  • Senior PeopleSoft Administrator

    vor 4 Wochen

    Canberra, Österreich Bright Horizons Family Solutions Vollzeit

    Title: Senior PeopleSoft AdministratorDivision: Information Technology ServicesClassification: ANU Officer 8 (Information Technology)Position Description & Selection Criteria: Position Description - ANU8 - Senior PeopleSoft Administrator.pdfSalary package: Competitive remuneration package including 17% superannuationTerm: Full time, Fixed Term (up to 3...

  • System Administrator Level 1

    vor 3 Wochen

    Canberra, Österreich CEA Technologies Vollzeit

    Networks & Systems Administration (Information & Communication Technology) Providing innovative technology solutions with commitment to strengthen Australia’s sovereign defence capability. About the CompanyCEA Technologies is one of Australia's leading Defence Industries specialising in the design, development, and manufacturing and through life...

  • Mutiple Data Analytics/ Business Intelligence Roles

    vor 4 Wochen

    Canberra, Österreich Opus Recruitment Solutions Ltd Vollzeit

    Mutiple Data Analytics/ Business Intelligence RolesCanberra, Australia Apply Mutiple Data Analytics/ Business Intelligence RolesCanberra, AustraliaContract$500 - $1000 per weekMUST HAVE NV1 CLEARANCE FOR ALL ROLESData Migration Analyst: Experience with SQL, Ingress and AdabasPower BI Developer: Proficieny in SQL server DB query dedign, M/Power Query,...

  • Security and ICT Technical Specialists

    vor 1 Tag

    Canberra, Österreich Canberracyberhub Vollzeit

    Are you a talented Security or IT specialist looking for an exciting opportunity to make a real impact? We are seeking highly skilled and experienced individuals to join our Canberra team. In these pivotal roles, you'll be at the forefront of providing project, data, operational and strategic cyber security, digital forensics, data management or system...

  • Project Engineer

    vor 4 Wochen

    Canberra, Österreich Spectrum Center, Inc. Vollzeit

    Spectrum Center, Inc. is a leading supplier of innovative spectrum management and engineering software solutions. We are seeking a skilled Project Engineer to join our team and support the implementation of our web application product into a Microsoft Azure environment for a customer in Australia. This is a full-time remote work opportunity. The successful...

  • Travel Advisor

    vor 1 Tag

    Canberra, Österreich Travel Associates Vollzeit

    Update your details, view your application and progress >> Login Job search Job search e.g. "Administrator, Melbourne" Refine searchWork type Full time 1 Region Australia 1 Location Australia Australian Capital Territory 1 Brand Travel Associates 1 Category Apply now Job no: 519883 Brand: Travel AssociatesWork type: Full time Location: ...