Job Description
Ayan Infotech are looking for a Sr. MS SQL Server Developer for a long term contract job opportunity in Sydney.
All applicants must have full work rights in Australia.
Title: Sr. MS SQL Server Developer
Location: Sydney
Type: Contract (6 months + long term)
Required Skills and Experience:
Experience: 6-12 years
Mandatory Skills:
- SQL Server (writing SQL queries, Stored Procedures, Functions, Triggers etc.)
- Exposure to Batch Scheduling tools
- Dimensional Modeling
- ETL Design and Development
- Informatica knowledge is added advantage
Desirable Skills:
Exposure to Agile Methodology
Exposure to Dev-Ops, GIT-Hub and Version Control
SSIS
Roles and Responsibilities:
- Database Development including create tables, write SQL queries, Develop Stored Procedures, Functions, Triggers etc.
- Database Design, Data Modeling including Dimensional Modeling for DWH/ Data Marts
- ETL Design & Development
- Database Performance Optimization
- Data Analysis and create Data templates in Excel and create Excel Macros
- Liaison with Operations Teams for Production Issues
- Create Operational Guide for Operations Team for items Released
- Create Release Notes and coordinate with DBA's for Code Release.
- Deliver code in agile Manner
- Create Batch Job Specifications and design Batch Scheduling
- Optimize Batch Scheduling
Contact: 02 9412 4178 for more details.
www.ayaninfotech.com
