MS SQL Database Administrator

4 days ago

Sydney, New South Wales, Australia Ayan Infotech Full time
About the Role

Ayan Infotech is seeking a highly skilled MS SQL DBA to join our team in Sydney. As a key member of our database administration team, you will have the opportunity to contribute to the development and maintenance of our sophisticated database environment.

Key Responsibilities
  • Manage and troubleshoot high-priority incidents, high-change tickets, and vendor problem tickets.
  • Ensure timely resolution of open tickets and issues within established Service Level Agreements (SLAs).
  • Respond to critical SQL DB alerts and take appropriate action to prevent data loss or system downtime.
  • Participate in bridge calls for critical incidents and collaborate with L2/L3 DBAs to resolve complex issues.
  • Verify the integrity of database backups, including full, differential, and log backups.
  • Monitor SQL Server job performance and follow standard operating procedures (SOPs) to resolve any issues.
  • Perform regular health checks on servers to identify potential issues with space, CPU utilization, and memory.
  • Configure and maintain maintenance plans for backups, database integrity checks, index rebuilds, and statistics updates.
  • Troubleshoot locking issues, including deadlocks, blocking, and lock timeouts, and implement solutions to prevent recurrence.
  • Apply performance tuning techniques, including creating missing indexes, to optimize database performance.
  • Assist with database refresh and table refresh activities in both Azure and on-premises environments.
  • Install, upgrade, and migrate SQL Servers as needed.
  • Apply patches and service packs for SQL Server and address any resulting issues.
  • Configure and troubleshoot issues related to Always On Availability Groups (AG), log shipping, replication, and clustering.
  • Participate in disaster recovery (DR) activities, including AG, log shipping, replication, and clustering.
  • Collaborate with application developers to test, configure, and optimize servers based on application demands.
  • Deploy database objects to Integration, QA, UAT, and Production environments.
  • Experience with SSIS packages and troubleshooting issues.
  • Familiarity with features like query store, SQL audit, resource pools, server-level and database-level encryption, and Azure cloud.
Requirements
  • Strong knowledge of database connectivity issues, slow response times, and database incident resolution.
  • Excellent problem-solving skills, with the ability to troubleshoot issues across infrastructure layers.
  • Proficiency in writing and troubleshooting shell scripting, SQL, and PL/SQL scripts.
  • Proven experience in automation and orchestration, with a focus on one-touch solutions.
  • Experience with DevOps, Terraform, Ansible, and shell/PS scripting is a plus.
  • Familiarity with Paas database maintenance, Redis, and other related technologies is a plus.
  • Strong SQL tuning skills and experience in refactoring SQL queries to improve performance.
  • Cross-functional experience with other RDBMS (Oracle, PostgreSQL) or NoSQL open-source databases is a plus.

  • MS SQL Database Administrator

    7 days ago

    Sydney, New South Wales, Australia Ayan Infotech Full time

    About the RoleAyan Infotech is seeking a highly skilled MS SQL DBA to join our team in Sydney. As a key member of our database administration team, you will have the opportunity to contribute to the development and maintenance of our sophisticated database environment.Key ResponsibilitiesManage and troubleshoot high-priority incidents, high-change tickets,...

  • SQL Database Administrator

    11 hours ago

    Sydney, New South Wales, Australia Zone IT Solutions Full time

    {"h1": "SQL Database Administrator Job Description", "p": "We are seeking an experienced SQL Database Administrator to join our team at Zone IT Solutions. As a key member of our IT team, you will be responsible for the installation, configuration, and maintenance of SQL database systems for our clients.Key Responsibilities:* Install, configure, and maintain...

  • SQL Server Database Administrator

    12 hours ago

    Sydney, New South Wales, Australia Ayan Infotech Full time

    {"title": "MS SQL DBA Role at Ayan InfoTech", "description": "Ayan InfoTech is seeking a skilled MS SQL DBA to contribute to an exciting project in Sydney. The role offers the opportunity to work in a well-structured environment, enhancing sophisticated projects.Key Responsibilities:Manage high-priority incidents, high-change tickets, and vendor problem...

  • SQL Database Architect

    6 days ago

    Sydney, New South Wales, Australia Zone IT Solutions Full time

    We are seeking an experienced Database Systems Administrator to join our team at Zone IT Solutions. As a key member of our IT team, you will be responsible for the installation, configuration, and maintenance of database systems for our clients.**Key Responsibilities:**Design and implement database systems to meet client requirements.Configure and maintain...

  • Database Systems Administrator

    5 days ago

    Sydney, New South Wales, Australia Cotalent Full time

    Job Title: Database Systems AdministratorCotalent is seeking a highly skilled Database Systems Administrator to join our team.Job Summary:We are looking for a seasoned Database Systems Administrator to ensure the availability and performance of our Clearing database environment. The ideal candidate will have extensive experience implementing and supporting...

  • Database Systems Administrator

    3 days ago

    Sydney, New South Wales, Australia Cotalent Full time

    Job Title: Database AdministratorContract RoleHybrid Work - Sydney Based$ per day all inJob Description:As a key member of our team at Cotalent, you will be responsible for ensuring the availability and performance of our Clearing database environment. This involves managing non-production, production, and disaster recovery database environments to ensure...

  • Senior Developer SQL/ GIS

    7 days ago

    Sydney, New South Wales, Australia EBR Full time

    Job SummaryEBR is seeking a highly motivated Technical Lead with extensive experience in SQL, GIS, and Geospatial technologies to lead our technology function and drive innovation in business systems and processes.About the RoleLead the technology function of the business, driving successful outcomes and working with service providers to achieve...

  • Database Architect

    12 hours ago

    Sydney, New South Wales, Australia Pyramid Global Technologies Full time

    About the RoleWe are seeking an experienced SQL Developer to join our team at Pyramid Global Technologies in Sydney. As a key member of our database team, you will be responsible for designing, implementing, and maintaining complex database systems using SQL.Key ResponsibilitiesWork with business stakeholders to interpret requirements and provide effective...

  • Database Developer

    7 days ago

    Sydney, New South Wales, Australia Pyramid Global Technologies Full time

    About the RolePyramid Global Technologies is seeking an experienced Database Developer to join our team. As a key member of our data management team, you will be responsible for designing, implementing, and maintaining our relational databases.Key ResponsibilitiesWork with business stakeholders to interpret requirements and develop effective solutions.Design...

  • Database Administration Leader

    7 days ago

    Sydney, New South Wales, Australia CMC Markets Full time

    About the RoleWe are seeking a highly skilled and experienced Database Administration Leader to join our IT Production department at CMC Markets. As a key member of our team, you will be responsible for guiding our local DBA team and managing our Microsoft SQL Server environment.Key ResponsibilitiesLead and support the local DBA team, providing guidance and...

  • Database Administration Manager

    1 week ago

    Sydney, New South Wales, Australia CMC Markets Stockbroking Limited Full time

    About the RoleWe are seeking a highly skilled and experienced Database Administration Manager to join our IT Production department at CMC Markets Stockbroking Limited. As a key member of our team, you will be responsible for leading our local DBA team and managing our Microsoft SQL Server environment.Key ResponsibilitiesLead and support the local DBA team,...

  • Database Administration Leader

    6 days ago

    Sydney, New South Wales, Australia CMC Markets Full time

    About the RoleWe are seeking a highly skilled and experienced Database Administration Leader to join our IT Production department at CMC Markets. As a key member of our team, you will be responsible for guiding our local DBA team and managing our Microsoft SQL Server environment.Key ResponsibilitiesLead and support the local DBA team, providing guidance and...

  • Database Administration Leader

    5 days ago

    Sydney, New South Wales, Australia CMC Markets Full time

    About the RoleCMC Markets is seeking a highly skilled and experienced Database Administration Leader to join our IT Production department on a permanent basis. As a key member of our team, you will be responsible for guiding our local DBA team and managing CMC's Microsoft SQL Server environment.Key ResponsibilitiesLead and support the local DBA team,...

  • Database Administration Leader

    1 week ago

    Sydney, New South Wales, Australia CMC Markets Full time

    About the RoleWe are seeking a highly skilled and experienced Database Administration Leader to join our IT Production department at CMC Markets. As a key member of our team, you will be responsible for guiding our local DBA team and managing our Microsoft SQL Server environment.Key ResponsibilitiesLead and support the local DBA team, providing guidance and...

  • Database Administration Leader

    4 days ago

    Sydney, New South Wales, Australia CMC Markets Stockbroking Limited Full time

    About the RoleWe are seeking a highly skilled and experienced Database Administration Leader to join our IT Production department at CMC Markets Stockbroking Limited. As a key member of our team, you will be responsible for guiding our local DBA team and managing our Microsoft SQL Server environment.Key ResponsibilitiesLead and support the local DBA team,...

  • Oracle Database Administrator

    13 hours ago

    Sydney, New South Wales, Australia FinXL Full time

    Database Administrator OpportunityFinXL Professional Services is a leading IT services organisation providing a broad range of services to assist large Australian enterprises and Government departments to deliver IT projects.We are seeking a highly experienced Oracle Database Administrator to join our team.Key ResponsibilitiesDesign, implement, and maintain...

  • Database Architect

    6 days ago

    Sydney, New South Wales, Australia Objective Corporation Full time

    About the RoleAt Objective Corporation, we are seeking a highly skilled Database Administrator/Engineer to join our team. As a key member of our CTO office, you will be responsible for designing, implementing, and maintaining databases for our Software as a Service (SaaS) application.Key ResponsibilitiesDesign and implement databases for optimal performance,...

  • Database Administration Leader

    13 hours ago

    Sydney, New South Wales, Australia CMC Markets Full time

    Role OverviewWe are seeking a highly skilled and experienced Database Administration Leader to join our IT Production department at CMC Markets. As a key member of our team, you will be responsible for guiding our local DBA team and managing our Microsoft SQL Server environment.Key ResponsibilitiesLead and support the local DBA team, providing guidance and...

  • Database Architect

    7 days ago

    Sydney, New South Wales, Australia FinXL Full time

    About the RoleWe are seeking a highly skilled and experienced Database Developer to join our team at FinXL IT Professional Services.Key ResponsibilitiesDatabase Design and Development: Design and build databases to meet the needs of our clients, ensuring stability, efficiency, and integrity.Database Administration: Ensure the smooth operation of databases,...

  • Database Administration Leader

    6 days ago

    Sydney, New South Wales, Australia CMC Markets Full time

    Job Description**About the Role**CMC Markets is seeking a highly skilled and experienced Database Administration Leader to join our IT Production department on a permanent basis. As a key member of our team, you will be responsible for guiding our local DBA team and managing CMC's Microsoft SQL Server environment.Key Responsibilities:Lead and support the...