Responsibilities
• Designing database tables
• Creating views, functions and stored procedures
• Writing optimized SQL queries for integration with other applications
• Creating task schedules for use in automation
• Creating SSIS projects for ETL (Extract, Transform, Load),
• Creating reports in SSRS
• Optimize and maintain legacy systems
• Modify databases according to requests and perform tests
• Monitoring and managing user enquiries and issues on the systems helpdesk
• Troubleshooting system issues
• Extraction of reports as per the business requirements
• Support existing systems
Requirements
• In-depth knowledge on SQL server 2016 or above
• Hands-On experience on writing stored procedures, performance tuning and troubleshooting
• Experience with Microsoft SQL Server Reporting Services (SSRS) , Integration services (SSIS)
• Familiarity working with .Net Framework, JavaScript, HTML
• Understanding of Agile methodologies
• Good troubleshooting and communication skills
• Attention to detail
• Degree in Computer Science, Engineering or a related field