.Net MSSQL Server

Role: .Net MSSQL Server

Job Requisition Number: MB008

Location: Singapore

Job Description:

• 4 - 6+ years of experience in IT industry and experience supporting Microsoft applications.

• Proficient in developing applications using Microsoft .NET Framework, ASP.NET, .Net Core, MVC, HTML5, CSS, JavaScript, Bootstrap, Telerik Controls, JIRA, Angular and GitHub.

• Proficient in MS SQL server / SSIS and SSRS design and development.

• Write clean, scalable code using .NET programming languages Test and deploy applications and systems.

• Create applications from scratch, configure existing systems and provide user support.

• Strong experience in developing relational databases (MS SQL/Oracle)- stored procedures, views, query performance tuning, etc.

• Manage Software releases, projects, enhancements, security patches, DR Drills industry testing and follow Secured Software Development Life cycle

• Should be able to coordinate with internal support, IT security, Infra stakeholders, compliance, Quality group, user groups, interfacing applications, vendor teams to ensure timely project deliverables, environments stability, security and service availability during operating hours.

• Perform any scheduled and standard maintenance during non-operating hours which may include weekends.

• Monitor Service Levels, system / application alerts, maintain operating manual sand procedures, identify trouble areas and take proactive measures to avoid incidents.

• Design, code and test web applications and supporting web services for apps.

• Participate in requirements analysis Collaborate with internal teams to produce software design and architecture.

• Revise, update, refactor and debug code.

• Develop documentation throughout the software development life cycle (SDLC)serve as an expert on applications and provide technical support.

• Ability to work in a fast paced, constantly changing Agile environment.

• Strong interpersonal and effective communication (both written and verbal)skills.

• Knowledge of functional testing, integration testing, system testing, and useracceptance testing.

• Knowledge of Web API programming is advantageous.

• Able to adapt readily & effectively to unexpected or changing conditions.

• Analytical mindset and problem-solving attitude.

Project Scope:

Project Name: SP2A- Trade Transformation Project.

As part of System Development Life Cycle (SDLC)gathering requirements, development, testing, Implementation and Post Implementation support using the technologies below.

· Database: MS SQL Server, SSDT

· Programing Languages: MS SQL Server / C#.net, .NET,ASP.NET, SSIS

· Product: Customer Liability Inquiry Portal System(CLIPS)

· Scripting: Windows

§ Develop the pipeline to process the FTI interface in CLIPS application

§ Develop CLIPS layout for the respective interface

§ Define the source code configuration

§ Customize the product configuration to handle parallel interface for the FITAS and new FTI interface

§ Configure and establish connectivity between FT Iand CLIPS

§ Test: Perform SIT with FTI and FITAS parallel Support UAT functional testing.

§ Deployment: Support for Prod deployment activities(documentation, preparing and go-live)