Position: Microsoft SQL Developer
Reporting to: SQL Database Manager
Job Purpose: Maintain, troubleshoot and use full MS toolset to develop various projects in enterprise level MS SQL database systems.
Key Responsibilities and Duties:
- Develops software solutions by studying information needs; conferring with users; studying systems flow, data usage, and work processes; investigating problem areas; following the software development lifecycle.
- Design, Develop, Test, Debug and deliver new products and features based on Microsoft SQL technologies (T-SQL/SSIS/SSRS/SSAS).
- Design, develop and deploy reporting solutions (SSRS).
- Design, develop and deploy integration packages (SSIS).
- Assist with effort estimates and project schedules.
- Enhance and maintain system functionality.
- Improving/troubleshooting system performance.
- Installs and maintains MS SQL servers running MS SQL server 2012 in an enterprise level production environment.
- Planning backup and recovery of databases.
- Configuring, deploying and maintaining database servers.
- Documents and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, and code.
- Improves operations by conducting systems analysis; recommending changes in policies and procedures.
Education/Skills/Experience:
Education: Degree in Computing
Needs to be proficient at analysing Information
Needs to have excellent SQL Server database development & administration skills including T-SQL, Stored Procedures, SSIS, SSRS & SSAS. Familiarity with Java is a plus.