eim database developer in sydney cbd

posted
job type
temporary
apply now

job details

posted
location
sydney cbd, new south wales
job category
IT & ICT
job type
temporary
working hours
Full-Time
reference number
90M0353604_1531870925
phone
00 00
apply now

job description

We have a Government Opportunity for an SQL Database Developer who will be responsible for developing data migration and batch interfaces from third party systems into the Siebel Platform.

The position holder will perform design, development, unit testing, performance testing and production execution of the bulk data processes, to achieve integrity and quality in all system functionality. Development will focus on initial data migration from legacy systems into the platform via Siebel EIM and Microsoft SQL Server Integration Services (SSIS).


Key Responsibilities:
• Work with Business Analysts and Solution Architects to understand the existing data schema, transform and upload legacy data into 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 process
• Design and develop SSIS packages to facilitate the migration and transformation 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 data migration solutions
• Troubleshoot and performance tune the database solutions
• Deploy the database solutions across non-production and production environments. Run trial migrations to ensure data integrity and performance are met
• Monitor production jobs and environments and provide on-going second level support to the database components

Competency Requirements:
• 3+ years hands-on experience in Microsoft SQL Server development, ETL using SSIS packages, Siebel EIM
• Database/SQL performance tuning and optimisation
• Proficiency with PowerShell scripting is a plus
• Must possess good organisational and interpersonal skills
• Must have good communication (verbal and written) skills
• Must be able to work independently but, at the same time, have the ability to participate as an effective member of the database development and support team
• A tertiary qualification in Information Technology or a related field or equivalent work experience

If you are a passionate and experienced SQL Database Developer that is looking for their next challenge and possess the required skills and experience, please apply online or via email katie.frost@randstad.com.au. To have a confidential conversation, please contact Katie Frost on (02) 8235 3304.

At Randstad, we are passionate about providing equal employment opportunities and embracing diversity to the benefit of all. We actively encourage applications from any background.

skills

Siebel EIM Database Developer

qualification

bachelors degree

educational requirements

Bachelor Degree