Duties & Responsibilities
Company Values
Values 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 & Qualification
Role Requirements:
Education and Experience
- Microsoft SQL Server
- Solid experience with T-SQL programming writing stored procedures
- Experience debugging stored procedures using tools such as SQL Server Management Studio
- SQL Server Profiler
- Experience identifying and addressing query performance issues
- Experience with processing bulk datasets (100,000+ rows daily) into large databases (50 million+ rows)
- Experience with Analysis Services
- Experience with SQL SERVER Data tools
- Experience with modular DB’s would be advantageous
Front End (3-5 Years Experience)
- Solid experience building and debugging responsive web applications using:
- ASP.Net MVC, .net Core
- Angular / Angular JS
- CSS
- SCSS
- Typescript
Middle 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 patterns
- Experience building and maintaining modular enterprise applications
- SOLID
- State machines
- GIT
- Scheduling tool such as Visual CRON would be advantageous
- Scrum / agile tool to manage user stories and capture time such as Target Process or Jira
- Agile Development
Skills and Behavioral Competencies
- Attention 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
