Database Development & Administration (Information & Communication Technology) Headquartered in Darwin, the family-owned PPG is a diverse group of companies employing 900 people nationally & internationally. Whilst Paspaley's core business is pearling, including pearl production, wholesale and retail, it also has interests in agriculture, aviation, hospitality & resort accommodation and commercial property.The RoleWe are looking for an experienced Microsoft Database Administrator to join our IT Department.In this role, you will oversee the administration and maintenance of our Microsoft SQL Server environments along with MS Access databases, ensuring high performance, availability, and security. You will also contribute to software development, enhancing our capabilities in Microsoft Dynamics AX and other platforms.Key Responsibilities:Administer and maintain day-to-day operations of MS SQL databases, including maintenance plans, backups, replication, SQL servers, and instances.Manage MS Access databases and develop front-end applications.Engage in software development using Microsoft Dynamics AX4 X++, MS Access VBA, Visual BasicDevelop and support reporting in SQL using SSRS and SSAS Reporting.Implement and manage database security measures, data warehouses, and ETL processes, particularly for Shopify integration using middleware tools (Boomi) and Phocas BI Reporting PlatformDevelop and optimize SQL queries, stored procedures, and ensure robust database structures for scalability and performance.Collaborate with cross-functional teams to support ERP and BI tool integration.Extract, transform, and load data, preparing it for use in BI tools to drive decision-making processes.Extensive experience with MSSQL Server, including server administration, replication, data warehouse management, security, and job scheduling.Preparing data for BI tool consumptionProficiency in Visual Basic, MS Access, and Microsoft Dynamics AX4 X++ or higher.Experience with ETL processes for Data Warehousing and Integration using middleware tools.Strong skills in data extraction and preparation for BI tools, ensuring accurate and timely availability of data for analysis.Preferred Skills:Experience in X++ coding language for AX, specifically AX 4 SP1.Familiarity with Boomi integration software.Familiarity with Phocas BI platformQualifications:Bachelor's degree in Computer Science, Information Technology, or a related field.Proven track record as a Database Administrator with deep expertise in managing MS SQL Server environments.Strong background in application development and software programming.As well as the above, we want someone with strong communication skills, with a friendly, approachable, can-do attitude, a real passion for building things and committed to delivering high quality, resilient, secure systems. You are hardworking, a team player who can work autonomously when required. Ability to manage time and meet deadlines while balancing competing priorities. Strong analytical ability, integration, and problem-solving skills. Ability to work to tight deadlines while maintaining a high level of attention to detail, even under pressure.The successful candidate must be an Australian citizen or permanent visa holder with full rights to work and reside in Australia.Applications close Friday 14th June 2024. Your CVshould be emailed attention to the Group IT Manager via (email protected) Your application will include the following questions: Which of the following statements best describes your right to work in Australia? How many years' experience do you have as a Database Administrator? Which of the following Relational Database Management Systems (RDBMS) are you experienced with? Which of the following programming languages are you experienced in? Which of the following data analytics tools are you experienced with? What's your expected annual base salary? The Paspaley Group is an Australian family-owned and run company with a heritage of over 80 years and three generations. Recognised as pioneers of the Australian South Sea pearling industry, today the company has a diverse portfolio ranging from pearling to retail, aviation to agriculture.The Paspaley company was founded in 1935 with the collection of mother-of-pearl shells for the button trade.In the years that followed, cultivation of Australian South Sea pearls became the company's primary focus. Every great company can point to a source of inspiration that set it on course for success.Source: this is an extract from the company's own websiteThe Paspaley Group is an Australian family-owned and run company with a heritage of over 80 years and three generations. Recognised as pioneers of the Australian South Sea pearling industry, today the company has a diverse portfolio ranging from pearling to retail, aviation to agriculture.The Paspaley company was founded in 1935 with the collection of mother-of-pearl shells for the button trade.In the years that followed, cultivation of Australian South Sea pearls became the company's primary focus. Every great company can point to a source of inspiration that set it on course for success.Source: this is an extract from the company's own website Don't provide your bank or credit card details when applying for jobs. What can I earn as a Database Administrator #J-18808-Ljbffr
