Data Engineer (PROJ-4406)

Job Duties and Responsibilities

• Evaluate and test new system releases (including patches). Plan and coordinate the installation of new versions of system software.
• Action customer requests, including ad-hoc backup, migration and restoration jobs, and diagnose and resolve issues by following standard operating procedures; where none exist, document the procedure taken for repeatability and consistency.
• Manage system and database configurations across numerous environments (e.g. production, QA, and test).
• Monitor database activity and resource usage, undertaking proactive database performance tuning or as requested by the customer.
• Develop and maintain specialist knowledge of relational databases and replication technologies: Microsoft SQL Server Database and Always-On Availability Groups.
• Develop, implement and maintain moderately complex to complex scripts and automation capabilities to assist in the implementation, integration, and maintenance of the system software.
• Document daily work (steps taken, reasons and outcomes) to ensure transition of knowledge to the ASD Officers and to enable repeatability of procedures and compliance with relevant standards, including Commonwealth record keeping responsibilities.

Technical skills

• Intermediate practical experience with Microsoft SQL Server products, including use of Always-On Availability Groups
• Experience using scripting languages (e.g. PowerShell) to support the SQL Server software and streamline or automate daily database management activities
• Experience following software development methodologies, such as Agile and SCRUM
• Familiarity and experience with version control and automated build/test systems such as Git and CI/CD platforms

Essential criteria

• Monitors system software metrics and adjusts configurations for optimum availability and performance. Reviews system software updates and identifies those that merit action. Configures system software for required functionality and performance. Investigates and resolves system software problems, requesting action from supplier if required.
• Develops and configures tools to enable automation of database administration tasks. Monitors performance statistics and create reports. Identify and investigates complex problems and issues and recommends corrective actions. Performs routine configuration, installation, and reconfiguration of database and related products.
• Designs, codes, verifies, tests, documents, amends and refactors moderately complex programs/scripts. Applies agreed standards and tools to achieve a well-engineered result. Monitors and reports on progress. Identifies issues related to software development activities. Proposes practical solutions to resolve issues. Collaborates in reviews of work with others as appropriate.
• Follows agreed procedures to identify and resolve issues with applications. Uses application management software and tools to collect agreed performance statistics. Carries out agreed applications maintenance tasks.
• Investigates minor security breaches in accordance with established procedures. Assists users in defining their access rights and privileges. Performs non-standard operational security tasks. Resolves security events and operational security issues.