Duties & ResponsibilitiesCompany ValuesValues are not a snapshot of what they are or what they do, they are a set of interactive mediums from which they gain direction and confidence in everything they do.They promise to:Provide you with an excellent service;Build great products for you;Consistently deliver results;Provide only the highest standards of service;Honour, respect and support everyone in their sphere.Duties and Responsibilities:Develop T-SQL stored procedures and functions to implement business logic;Develop regression tests to test T-SQL code;Perform database performance optimization;Build responsive web pages that provide a good user experience and use efficient data transfer between front-end, service layer, and back-end databases;Effective C# development to ensure seamless interface between Backend and front end functionality;Use Angular / AngularJS to develop reusable front-end components;Recommend and implement performance improvements to sites and applications;Design and implement Web site security measures, such as firewalls and message encryption;Incorporate technical considerations into design plans, such as budgets, equipment, performance requirements, and legal issues including accessibility and privacy;Analyze data to determine, recommend, and plan installation of a new system or modification of an existing system;Analyze product needs and requirements to determine feasibility of design within time and cost constraints;Engage with project managers to obtain information on limitations or capabilities for products;Engage with analysts, engineers, programmers, and others to design systems and to obtain information on performance requirements and interfaces;Engage with all internal and external stakeholders on project status, proposals, or technical issues, such as software system design or maintenance;Obtain and evaluate data on factors such as reporting formats required, costs, or security needs to determine hardware configuration;Determine and set system performance standards;Provide clear, detailed descriptions of specifications, such as product features, activities, software, communication protocols, programming languages, and operating systems software and hardware;Develop, maintain or direct software system testing or validation procedures, or documentation;Modify existing components to correct errors, or upgrade interfaces and improve performance;Monitor system operations and functioning to ensure conformance with stakeholder specifications;Perform tests which adhere to planned schedules, or after any revision reporting any anomalies;Document test plans, procedures, or results;Perform application support on a rotational basis;Prepare reports concerning project specifications, activities, or status;Communicate with network personnel or hosting agencies to address hardware or software issues affecting sites or applications;Respond to user inquiries;Monitor security system performance logs to identify problems and notify security specialists if problems occur;Continuously develop and improve understanding of current Web technologies or programming practices through continuing education, reading, or participation in professional conferences, workshops, or groups;Confer with management or development teams to prioritize needs, resolve conflicts, develop content criteria, or choose solutions.Desired Experience & QualificationRole Requirements:Education and ExperienceMicrosoft SQL ServerSolid experience with T-SQL programming writing stored proceduresExperience debugging stored procedures using tools such as SQL Server Management StudioSQL Server ProfilerExperience identifying and addressing query performance issuesExperience with processing bulk datasets (100,000+ rows daily) into large databases (50 million+ rows)Experience with Analysis ServicesExperience with SQL SERVER Data toolsExperience with modular DB's would be advantageousFront End (3-5 Years Experience)Solid experience building and debugging responsive web applications using:ASP.Net MVC, .net CoreAngular / Angular JSCSSSCSSTypescriptMiddle Layer (3-5 Years Experience)Solid experience building and debugging responsive web applications using C#Experience in N-tiered project architecture, using .Net core Entity Framework/Dapper.Good understanding of SOLID principles, DRY Principles, object inheritance.Good understanding of Data Structures and Design patternsExperience building and maintaining modular enterprise applicationsSOLIDState machinesGITScheduling tool such as Visual CRON would be advantageousScrum / agile tool to manage user stories and capture time such as Target Process or JiraAgile DevelopmentSkills and Behavioral CompetenciesAttention to detail;Communication skills - written;Quality orientation;Analytically orientated;Strong problem-solving skills;High levels of conscientiousness;Resilience and emotional maturity;Experience with tools like SSMS, Swagger, Azure DevOps;
#J-18808-Ljbffr