The Company

Our client is an Enterprise level NSW Government organisation focused on leveraging technology to deliver simple and efficient services to the people of NSW.

The Role

The incumbent will be primarily responsible for developing and supporting batch interfaces between 3rd party systems and the Siebel platform. Key responsibilities will include (but not limited to):

• Design, development, unit testing, performance testing, production deployment and support of the bulk data processes, to achieve integrity and quality in all system functionality.

• Development and support will focus on batch interfaces via Siebel EIM and Microsoft SQL Server Integration Services (SSIS).

• Work with Business Analysts and Solution Architects to understand the existing data schema, transform and upload data into or extract data from the Siebel platform that meets the business requirement and follows the best technology practice.

• Design and develop database objects such as indexes, stored procedures, functions etc. that support the data load and extraction process.

• Design and develop SSIS packages to facilitate the transformation and loading/extraction of data. Document the detailed design and support procedures of the database components.

• Unit, integration and performance testing of all database components developed

• Work with the development and testing teams in developing and testing the end-to-end interface and database solutions.

• Troubleshoot and performance tune the database solutions.

• Deploy the database solutions across nonproduction and production environments.

• Perform testing to ensure data integrity and performance are met.

• Monitor production jobs and environments and provide on-going second level support to the database components.

Requirements

• 3+ years hands-on experience in Siebel EIM, Microsoft SQL Server development, ETL using SSIS packages.

• Database/SQL performance tuning and optimisation.

• Proficiency with PowerShell scripting is a plus.

• A tertiary qualification in Information Technology or a related field or equivalent work experience.

How to Apply

Please click on the APPLY button and we will happily review your application against our clients' requirements.

Please note we prefer MS Word formatted resumes please.

Please only apply if you have valid Australian working rights.