SQL Database Administrator (DBA) with Cloud Exp. - Sydney New

Ayan Infotech; Council of the City of Sydney; On-site; AUD 90,000 - 130,000; Full time

Job summary

A technology services provider is seeking a SQL Database Administrator (DBA) with cloud experience for a project in Sydney. The ideal candidate will manage and optimize databases, ensuring availability and performance. Expertise in SQL Server and MySQL is required, with familiarity in NoSQL technologies preferred. This is a mid-level role offering a chance to work on significant projects within a dynamic team.

Qualifications

• 5-7 years of experience as a Database Administrator in an enterprise environment.
• Strong proficiency in administering and tuning multiple relational database systems.
• Familiarity with NoSQL databases is highly desirable.
• Solid understanding of database architecture, replication, high availability.
• Proficiency in SQL and scripting languages.
• Experience with cloud database services is a plus.
• Excellent verbal and written communication skills.

Responsibilities

• Administer, monitor, and maintain relational and NoSQL databases.
• Identify and resolve database performance issues.
• Implement and manage robust backup and recovery procedures.
• Enforce database security policies and manage user access.
• Develop and implement automation scripts.
• Work closely with development teams on application deployments.
• Maintain documentation of database configurations and procedures.
• Provide out-of-hours support for critical database incidents.

Skills

Database Management

Performance Tuning

Backup and Recovery

Database Security

Troubleshooting

Automation

Collaboration

Analytical Skills

Communication

Tools

SQL Server

MySQL

MongoDB

Cassandra

PowerShell

Python

Bash

Azure SQL Database

GCP Cloud SQL

Job description

AYAN InfoTech is looking for SQL Database Administrator (DBA) with Cloud experience to join an exciting project based in Sydney. The role offers you the opportunity to contribute towards an extremely well structured and mature environment, working on sophisticated enhancement projects.

Role: SQL Database Administrator (DBA) with Cloud experience
Location: Sydney
Contract Duration: 6 Months with high possible extensions
Experience: 7+ Years

Job Overview:

We are seeking a talented and motivated Mid-Level Database Administrator (DBA) to join our dynamic and growing technology team. In this role, you will play a crucial part in managing, maintaining, and optimising our critical database infrastructure, ensuring high availability, performance, and security across our various business units. This is an exciting opportunity to contribute to significant projects and work with a range of modern database technologies within a large-scale enterprise environment.

Key Responsibilities:

• Database Management: Administer, monitor, and maintain relational databases (SQL Server, MySQL) and NoSQL databases (MongoDB, Cassandra) to ensure optimal performance, availability, and reliability.
• Performance Tuning: Identify and resolve database performance issues, including query optimization, indexing strategies, and system configuration adjustments.
• Backup and Recovery: Implement and manage robust backup and recovery procedures, ensuring data integrity and rapid restoration capabilities.
• Security: Enforce database security policies, manage user access, and implement best practices to protect sensitive data.
• Troubleshooting: Diagnose and resolve database-related incidents, including connectivity issues, data corruption, and system failures.
• Automation: Develop and implement automation scripts and tools to streamline database administration tasks and improve efficiency.
• Collaboration: Work closely with development teams, system administrators, and other IT professionals to support application deployments, migrations, and new initiatives.
• Documentation: Maintain comprehensive documentation of database configurations, procedures, and troubleshooting steps.
• On-Call Support: Participate in an on-call rotation to provide out-of-hours support for critical database incidents.

Required Skills and Experience:

• Experience: 5-7 years of experience as a Database Administrator in an enterprise environment.
• Strong proficiency in administering and tuning at least two major relational database systems (SQL Server, MySQL).
• Familiarity with NoSQL databases (MongoDB, Cassandra) is highly desirable.
• Solid understanding of database architecture, replication, high availability, and disaster recovery concepts.
• Proficiency in SQL and scripting languages ( PowerShell, Python, Bash).
• Experience with cloud database services (Azure SQL Database, GCP Cloud SQL) is a plus.
• Analytical Skills: Strong problem-solving and analytical abilities with a keen eye for detail.
• Communication: Excellent verbal and written communication skills, with the ability to explain complex technical concepts clearly.
• Collaboration: Proven ability to work effectively in a team-oriented environment and collaborate with diverse stakeholders.
• Proactive: Self-motivated, proactive, and able to manage multiple priorities in a fast-paced environment.

Contact: 61-[phone] for more details.

Please note we will be able to contact only shortlisted candidates for this role. We thank you in advance for your interest.