Description
Seeking a Database Developer to join our Development Team to provide development and analytical support for SQL Server databases and SSIS applications. This support will involve auditing, analysing and advancing our current Database infrastructure and usage. This position will be responsible for organizing, integrating and managing data from multiple operational systems and various sources. In collaboration with the Development Team, the Database Developer will be responsible for data manipulation and data warehousing (inspecting, cleaning and transforming data). The Database Developer will also be responsible for creating, editing and organizing stored procedures.
We are looking for a candidate that can audit and analyze our current infrastructure and propose development solutions to improve the methods we use. These improvement proposals will involve the change of our manual data processes to transform them into web interfaces. The right candidate will have a strong background in database analysis and development as well as a workable knowledge of .Net/Web development. This person should have the desire and ability to analyze current database structures and improve future structures using both database and web development knowledge. Our ideal candidate will also be able to communicate effectively with other team members and our vast amount of clients.
SKILLS:
Technical skills and abilities:
- Knowledge of database development (data modelling & data analysis)
- Proven ability to write reusable and clean code
- Transforming XML from 3rd party APIs to MS SQL Server
- SSIS
- SSRS
- T-SQL
- SQL Server
- CLR(common language run-time)
- Database back-up and maintenance plans
- Security(configuring roles to integrate with Windows)
- Comfortable building a schema (database design)
- Data integrity constraints
- Data warehousing
- C#
- .NET
- MS Visual Studio
- Si-Sense experience a plus
- Able to follow instructions
- Excellent oral and written communicator
- Ability to work well in large and small teams
- Detail oriented
- Self-sufficient & able to work independently
- Team player
- Motivated, fast and efficient