Database Administrator Job Description: Top Duties and Qualifications

Only Candidates with Baseline Clearance are eligible to apply.

Our client seeks to engage the services of an experienced Database Administrator/Data Engineer. The successful candidate will utilise their experience in database administration, database development, data warehousing (DW) and business intelligence (BI) spaces to assist in the design, implementation, and support of the ARC s Data capabilities.

The successful applicant will work within a small delivery team in providing data services as well as in supporting the development and support of new business analytics services. They will also engage with stakeholders and other members of the delivery team to develop work packages using an adapted scrum methodology.

Please refer to the attached selection documentation for full position description and duties.

In case of any queries, kindly feel free to contact Akshay from NewAge Recruitment at [phone number].

Job Type: Contract

Salary: $70.00 $100.00 per hour

Schedule:

Day shift

Monday to Friday

Ability to commute/relocate:

Canberra ACT: Reliably commute or planning to relocate before starting work Clearance (Required)

Established in 2017, Australian College of Community and Health Services (ACCHS) is a Registered Training Organisation (RTO ID: 45182) by the Australian Skills Quality Authority (ASQA) under the National VET Regulator Act 2011. Australian College of Community and Health Services is also registered on the Commonwealth Register of Institutions & Courses for Overseas Students (Cricos Code: 03687F).

Australian College of Community and Health Services specialises in providing training in various fields, including business, childcare, health, aged care, disability, and community sectors. Moreover, the institution collaborates closely with employers within the healthcare and business industries.

The school is currently undergoing rapid development. To meet the Australian society's increasing emphasis on health, our management team has decided to hire a Database Administrator to better optimize the organization's database management system. who can confidently deliver the job duties as below:

1. Construct and execute the information and database management systems that provide infrastructure for our institute.

2. Perform troubleshooting on database access, security, and performance issues.

3. Perform analysis, maintain, and update internal databases.

4. Conduct regular database restorations and backups.

5. Perform data cleansing and enhance data quality and integrity continuously.

6. Maintain database environments that are secure, recoverable, and in good condition.

7. Participate in data testing and query debugging, as well as offer technical assistance to personnel.

8. Perform database performance optimization in order to enhance data management procedures.

9. Enhance the database architecture and guarantee sufficient storage space to accommodate database expansion.

10. Ensure that all work is completed and documented in line with established processes.

11. Evaluate and suggest new tools and services to improve database efficiency and effectiveness.

Skills and Experience Requirements



· Degree qualified



· Mandarin Speaking Preferred (Most team members are speaking Mandarin)



· Knowledge of application security principles and practices, including encryption, authentication, and authorization.



· Strong problem-solving skills and the ability to think analytically to tackle complex technical challenges.



· At least 1 year of relevant work experience is required.

Job Type: Full-time

Pay: $85,000.00 – $90,000.00 per year

Schedule:

Monday to Friday
Supplemental pay types:

Bonus



Work Authorisation:

Australia Location: In person

Designation / Job title: Database Administrator 262111

Number of Positions: 10

Location:Tech Mahindra Sydney NSW Australia

Primary or Mandatory skills: -

Oracle Database

Microsoft SQL Server

MySQL.

PostgreSQL

Good to have skills: -

Golden Gate

OCP Redhat.

Having knowledge on how backup and storage solution works.

Detailed Job description: -

Specialist Knowledge AND Skills

The position requires:

Design, Manage & build Oracle, PostgreSQL, MySQL, SQL Server Databases

Oracle standalone

Oracle RAC

Oracle ADG

Golden Gate is added advantage

Knowledge and Hands-on on OCP and along with managing PostgreSQL on OCP

Design & build MySQL / PostgreSQL Databases

MySQL Standalone

MySQL Master-Slave configuration / DR setup

Design & build Microsoft SQL Databases

Standalone

Always On for SQL Server

Replication or Log shipping on SQL Server

Oracle Enterprise Manager, Ops Centre knowledge

Develop and maintain system documentation related to the database configuration

Perform Patch & release management

Perform database refresh using backup and storage solution s like BCV , Snap-shot or Data Domains

Perform performance trend analysis and manage the server/network capacity

React to potential problems using automation, scheduling, and monitoring tools -- escalating to management where appropriate

Participate in configuration and implement technical solutions to enhance and/or troubleshoot the system

Knowledge of following Operating System environments

Redhat/Oracle Linux

IBM AIX

Oracle Solaris

Windows Servers

Interpersonal Skills: -

The position requires:

Proven ability to deliver results as required within specific time frames.

Ability to work within a team in a cross-cultural environment.

Ability to work after hours.

Ability to lead the team technically during a major incident

Ability to handle major incidents and escalations along with interacting with the customer.

Qualifications AND Experience

The position requires:

5+ years of hands-on experience as Database Admin on Oracle, EDB Postgres, MySQL, Microsoft SQL .

Formal IT-related qualifications.

Job Type: Full-time

Salary: $80,000.00 $100,000.00 per shift

Position Overview:

SecureIT Services, a trusted IT service provider headquartered in Perth, extends its expertise to clients throughout Western Australia, including regional centers. Our comprehensive service range encompasses IT Service Desk, Managed IT Services, Cyber Security, Disaster Recovery, Network Support, Cloud Services, and IT Consulting, all tailored to individual client needs. We are a small team of 5 looking after corporate clients for more than 20 years, most of our team work remotely from their home offices when we are not engaged on client sites.

We are currently seeking a customer-oriented Database Administrator to join us in a full-time capacity. As an BI Database Administrator, you will take charge of overseeing and upholding BI dashboards for our clients. Your adeptness in database optimization and management will significantly enhance the efficiency and performance of our new projects.

Your role will involve frequent on-site visits to clients for dashboard assessment and design, in a dynamic team environment offering remarkable flexibility.

Responsibilities:

BI Dashboard Development: Create and administer BI dashboards for our customers, ensuring smooth functionality, performance and security.

Data Integrity and Security: Implement and enforce data integrity and security measures, including data encryption, access controls, and compliance with relevant regulations and industry standards.

Database Design and Development: Collaborate with software developers, data analysts, and other stakeholders to design and develop efficient and scalable database solutions. Participate in the design of data models, schema, visulisation and indexing strategies to support business requirements.

User Management: Create and manage user accounts, groups, and permissions within the Office 365 environment, following best practices for security and data access.

Troubleshooting and Support: Provide technical support and troubleshooting for cloud and on premise databases connected to customers line of business applications. Investigate and resolve problems in a timely manner, ensuring minimal disruption to their operations.

Performance Optimization: Monitor and optimize the performance of Microsoft SQL databases and BI dashboards. Identify and resolve performance bottlenecks, optimize queries, and provide recommendations for infrastructure enhancements.

Backup and Recovery: Implement and manage backup and recovery procedures for Microsoft SQL, Azure and on premise based databases to ensure data integrity and minimize the risk of data loss. Test and validate backup and recovery processes regularly to ensure their effectiveness.

Documentation and Reporting: Maintain comprehensive documentation of BI dashboard configurations, processes, and procedures. Generate regular reports on dashboard performance, capacity and utilization for customers and management.

Collaboration and Communication: Collaborate with customers, internal teams, and stakeholders to understand and address their BI dashboard requirements. Communicate effectively to provide updates, recommendations, and guidance related to BI development and database administration.

Knowledge of Hubspot API s and SQL Server Integration Services is highly desirable.

Qualifications:

Minimum 5 years proven experience as a BI Database Administrator or in a similar role.

Strong knowledge of Microsoft SQL, Power BI, Office 365 administration, including dashboards, user management, and security settings.

Experience with database management and troubleshooting within the Office 365 and Azure environment.

Understanding of data integrity, security principles, and compliance requirements.

Familiarity with Office 365 services and applications such as Power BI, Azure, SQL, Exchange Online, SharePoint Online, and Microsoft Teams.

Must have working knowledge of Connectwise Manage and Connectwise Automate.

Proficiency in PowerShell scripting for Office 365 administration and automation.

Excellent problem-solving and analytical skills.

Strong attention to detail and the ability to prioritize and multitask in a fast-paced environment.

Excellent communication and customer service skills.

Join our team as an Database Administrator and play a crucial role in managing and optimizing the BI dashboards for our customers. Your expertise and dedication will contribute to the success and satisfaction of our valued customers.

If you think you are suitable for this role, click on the Apply Now link to submit your application.

Job Type: Full-time

Salary: $80,000.00 $100,000.00 per year

Benefits:

Profit sharing

Work from home
Schedule:

Monday to Friday
Supplemental pay types:

Bonus



Experience:

Microsoft SQL Server: 3 years (Required)

Licence/Certification:

Full Driver Licence (Required)

Work Authorisation:

Australia (Preferred)

Ability to Commute:

Currambine, WA 6028 (Preferred)

Ability to Relocate:

Currambine, WA 6028: Relocate before starting work (Preferred)


Work Location: Hybrid remote in Currambine, WA Deadline: 21/09/2023