Database Administrator

1 week ago

Canberra, ACT, Australia Cox Purtell Full time

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.

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia HiTech Personnel Full time

    Reference #: JF/MF0085Title: Database Administrator Salesforce, SQL, Cloud Federal Government DepartmentCategory: ICTLocation: ACTWork Type: ContractRemuneration:- $NegTerm: 12 Months + 12 MontDescription:High Profile Federal Government Department Work in an evolving database environment- initial 12 months contract with 2-year extensionsOne of Australia's...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia HiTech Group Full time

    Exciting opportunity within a Federal Government Department Initial 6 month contract Rewarding hourly rates $$$ A leading Federal Government department is looking to engage a skilled Database Administrator to join a highly capable team. In this you will assist with the management and administration of the departments ICT databases in an integrated...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia Illuminated Solutions Full time

    LOCATION:***- CanberraSALARY:***- negotiableJOB TYPE:***- ContractPOSTED:***- 2 hours agoCATEGORY:***- Database AdministratorDEADLINE:***- March 21, 2023JOB LEVEL:***- SFIA 4The Database Administrator will be accountable for the administration of a range of databases of varying technologies. The Database Administrator will plan, organise, integrate, deliver...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia Paxus Australia Pty Ltd Full time

    Posted 06 February 202- SalaryNegotiable LocationAustralian Capital Territory Job type Contract DisciplineIT General Reference264535Job description:Database Administrator - CapabilityOneLocation:ACTAre you an experienced Database Administrator seeking a challenging role? Play a pivotal role in enhancing CapabilityOne (C1), a crucial portfolio management and...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia Quality People Full time

    Our client URGENTLY requires a Database Administrator for 12 months + Contract in Canberra. The Database Administrator will focus on maintaining and sustaining database environment, including on-premises and cloud hosted. The Database Administrator will play a key role in ensuring DBA project deliverables are met, and will have the ability to work across...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia HiTech Group Full time

    Exciting opportunity within a Federal Government Department 12 month contract + 6 month extension and hybrid working arrangements Rewarding hourly rates One of Australia's leading Federal Government departments are looking to engage an experienced SQL Database Administrator to focus on maintaining and sustaining the departments database environment,...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia Infinite Talent Group Pty Ltd Full time

    Length of contract: 12 MonthsContract extensions: 24 MonthsSecurity clearance: Australian Citizen - Must have Negative Vetting Level 1The Db2 Database Administrator will be involved with the:Migration of ObjectStar Table data store to DB2 on Z/OS; design, maintenance and optimising DB2 databases; and upgrading DB2 to V13. Database Administrator Experts will...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia Powerdata Group Consulting Full time

    IT & Telecomms Database Administrator Russell Offices, ACT Contract Or Permanent9/1/2024Open to:Holders of NV2 or aboveLocation:Russell Offices, ACTCapabilityOne (C1) is Defence's portfolio management and decision support tool. It comprises an ecosystem of user interfaces, reporting and business intelligence tools that enable users to manage, view and...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia Nixil Full time

    Work options:Mon to Fri Office HoursCapabilityOne (C1) is Defence's portfolio management and decision support tool. It comprises an ecosystem of user interfaces, reporting and business intelligence tools that enable users to manage, view and interrogate data relating to programs, projects and domains and a range of other Defence capabilities.Work...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia CYOS Solutions Full time

    Application closing date: Tuesday, 16 April :59pm, Canberra time (in Canberra)Estimated start date: Wednesday, 01 May 2024Location of work:ACTWorking arrangements:All work is to be undertaken at Services Australia's Canberra office.Length of contract:12 monthsContract extensions: 2 x 12 monthsSecurity clearance: Must have Negative Vetting Level 1Rates: $120...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia Illuminated Solutions Full time

    LOCATION:***- CanberraSALARY:***- negotiableJOB TYPE:***- ContractPOSTED:***- 2 hours agoCATEGORY:***- Database AdministratorDEADLINE:***- March 1, 2023JOB LEVEL:***- SFIA 4A Database Administrator (DBA) is required to facilitate the design, implementation, administration and monitoring of data management systems and to ensure design consistency, quality and...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia Illuminated Solutions Full time

    LOCATION:***- CanberraSALARY:***- negotiableJOB TYPE:***- ContractPOSTED:***- 2 hours agoCATEGORY:***- Database AdministratorDEADLINE:***- March 1, 2023JOB LEVEL:***- SFIA 5A Database Administrator (DBA) is required to lead and coordinate the design, implementation, administration and monitoring of data management systems and to ensure design consistency,...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia CYOS Solutions Full time

    Application closing date: Friday, 12 April :59pm, Canberra time (in Canberra)Estimated start date: Wednesday, 01 May 2024Location of work:ACTWorking arrangements:All work is to be undertaken at Services Australia's Canberra office.Length of contract:12 monthsContract extensions: 2 x 12 monthsSecurity clearance: Must have Negative Vetting Level 1Rates: $120 -...

  • Database Administrator

    2 days ago

    Canberra, ACT, Australia Randstad Australia Full time

    12 month contractCanberra based roleBaseline clearance mandatoryOur federal government client is seeking an experienced, highly skilled and motivated Database Administrator to play a key role in ensuring DBA project deliverables are met. The resource will have the ability to work across multiple work packages both on a project and a business-as-usual team.As...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia Etainsolutions Full time

    Open to:Holders of NV2 or aboveLocation:Canberra, ACT Hybrid or (WHFH considered)We are seeking an MS SQL DBA to work on a program that comprises of an ecosystem of user interfaces, reporting and business intelligence tools that enable users to manage, view and interrogate data relating to programs, projects and domains and a range of other Defence...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia Kinexus Australia Full time

    ABOUT THIS ROLEDatabase Administrator (Multiple) - RFQ-ASD SOW - RereleasedMission Data Division (MD) within the Australian Signals Directorate (ASD), will deliver cutting edge capabilities to Defence through a variety of different programmes and projects. To facilitate this ASD has a requirement for a Database Administrator.The Database Administrator will...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia Itbility Full time

    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 Essential criteria1. Tertiary qualifications in ICT or a related field and/or...

  • database administrator

    1 week ago

    Canberra, ACT, Australia Effective People Full time

    Database Administrator- AGSVA Baseline Clearance required upon commencement- 12-month assignment with potential for 2 x 6-month extensions- $80 - $100/h incl. super- Located in Canberra, ACT - Onsite- Job Reference #1222650WHY CHOOSE EFFECTIVE PEOPLE?We pay fortnightly with in-house payroll Salary packaging & bank your hours Novated leasing, corporate...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia ClearCompany Full time

    SQL DBA - Federal Government - Security Clearance RequiredLocation: 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...

  • Database Administrator

    1 week ago

    Canberra, ACT, Australia face2face Recruitment Full time

    Closing Date:06 April 2023, 9:00 AMface2face reference:583160Location:CanberraHours:full-timeContract length:12 Month Contract + 2x 12 Month Extensions - Pending approvalEntry requirements:Australia Citizen + Negative Vetting 1Pay range:$ p/h inc superAbout the role:This client is seeking the services of an experienced Database Administrator to participate...