PBT Group has an urgent requirement in Durban for 3 SQL Developers with strong database development experience. These will be for initial 24 month contracts.
Duties:Responsible for the design, development, testing, implementation and maintenance of new and existing data driven applications.
Specific Responsibilities include:- Liaise with business users to obtain business requirements and provide an analysis for the requirements.
- Research appropriate solutions and provide technical expertise and recommendations.
- Identify opportunities that can improve efficiency of business processes.
- Design components and applications in accordance with specified architectural design.
- Define scope, tasks and duration of the solution based on business requirements.
- Develop, enhance and maintain applications based on specifications received.
- Write well designed, efficient code according to technical specifications.
- Design and write test cases for developer testing and document the system specifications.
- Conduct necessary testing (Stress, Integration and Unit).
- Create the release by building the application, documenting it and setting up the configuration.
- Migrate applications into applicable environments.
- Conduct post implementation monitoring.
- Complete and maintain relevant documentation.
Skills Required:
- SQL
- Ideally experience with working on a retail merchandising / planning system called JustEnough.
Experience
- Five – ten years’ experience in Full-Stack application development
- Expert level understanding of SQL and physical database implementations.
- Expert level understanding of application development.
Required Skills and Attributes:- Strong understanding of application design principles and patterns
- Deep understanding of the following database principles:
- Relational algebra and its use in writing optimal queries and operations. This includes: set based operations (projection), natural joins, outer joins, Cartesian products.
- Indexing principles and selection.
- Data modelling techniques including normalisation.
- Concurrency – isolation and locks.
- Strategies for working with very large databases and tables.
- Interpreting execution plans, and using this to optimize the performance of existing operations in highly concurrent and high data volume systems.
- Practical experience implementing solutions with Microsoft SQL Server is preferable.
- Solid understanding of a modern, garbage collected language and platform:
- .Net or Java (.Net with C# experience preferable)
- Application design patterns and frameworks
- Business Analysis
- Analytical, conceptual, and problem-solving abilities
Qualifications:
- BSc in Computer Science or Engineering or a related degree
Competencies:
- Analytical
- Goal orientation
- Initiative
- Team work
- Communication
- Attention to detail
- Planning and organising
- Decision making
- Problem solving
- Innovation
- Technical experience
- Applying business knowledge
- Obtaining and processing information
- Service orientation