Database systems design

Key Responsibilities Implement appropriate designs for databases, data warehouses, marts, reports and dashboards Specify database infrastructure requirements Design and implement database solutions for high performance and high availability Responsible for planning and implementing database replication Perform query and database optimisation Be responsible for database maintenance Work with development teams to identify databases for decommissioning Monitoring database user access and security Writing database documentation, including data standards, procedures and definitions Developing, managing and testing disaster recovery processes and servers as well back-up and recovery plans Keep abreast of new database technologiesMinimum Requirements At least 5 years’ experience as a database administrator Matric plus applicable tertiary equivalent experience or preferably, an ICT relevant diploma or degree from a recognised tertiary institution Relevant technical certifications Able to consult on data architecture and assess impact of project changes to data architecture Experience working with SQL Server and as a database administrator Design and development of MS SQL Server databases (DB design, optimization, tuning, ETL, stored procedures,triggers and views) MCDBA certification advantageous SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) beneficial.Contact Tanya or email

Database designer required to Design / Modify Database using MS Access & VB. Either full time or part time. Designer required to build Database in Modules. 

I am a 34 year old ICT professional with a degree in Computers and Management of Information Systems and several certifications. I have hands-on experience in Microsoft windows server ,AD,MS Exchange,HyperV and VMware, Linux OS,networking, software maintance and patching, backup and storage, database admin, Voip. I am immediately available and my CV is available on request.

Job Description: To improve efficiency, reduce waste, identify and implement solutions, meet project deadlines and accurately document the necessary requirements to be done in accordance with local / global strategic planning and standards in compliance to the Company''s Integrity & Anti Bribery Codes, Conflict of Interest Policy & S.H.E. requirements and to perform delegated S.H.E. tasks and duties & to inform superior about deviations   Qualifications & Experience: Minimum NQF 7 – BSC/BCom/BTech in Information Technology or B. Eng. (Industrial Engineering) or relevant equivalent 3+ Years’ experience in IT Experience with test automation tools. ISTQB/ISEB Certification will be advantageous   Requirements: Experience in Quality Assurance processes, software lifecycle, testing, planning, execution and defect tracking Experience with test automation tools (Selenium, SoapUI, Postman, HP UFT, etc.) Experience in container technologies such as Docker and orchestration with Kubernetes Demonstrated business acumen to take from design to implementation and preferably experience scaling a concept Must have IT Development and Systems Knowledge Experience with software development methodologies and practices (Agile, Scrum, etc.) Experience in Data Analysis and Advanced Proficiency in Microsoft Office suite, including Word, Excel, and Outlook Must have an excellent ability to multi-task effectively working on several projects synchronously Experience in rolling out initiatives that leverage multiplatform technologies Willingness to travel nationally and internationally Ability to perform the minimum required physical and mental requirements of the function Must have an excellent ability to multi-task effectively working on several projects synchronously Experience in rolling out initiatives that leverage multiplatform technologies Willingness to travel nationally and internationally Ability to perform the minimum required physical and mental requirements of the function   Responsibilities: Design, develop, implement and continuously improve software quality, testing tools, testing processes and testing environments through the application of appropriate testing methodologies and processes. Align test management strategy to industry best practices and frameworks. Design test plans on software applications based on business requirements and technical specifications. Participation in various phases of the software development process activities including analysis, development and technical support Implement, track and report on all testing activities to assure full coverage of functional and non-functional requirements Plan, design, create, execute and maintain test automation scripts that meet the business needs. Responsible for test planning, design and the creation of test data. Participate and provide feedback on any activities wher

Leading Engineering Consultancy seeks a Systems Engineer to do systems analysis, system design, subsystem specification, subsystem engineering reviews, integration and verification.  The candidate will report to the consortium's lead systems engineer.   Minimum qualification: •    Bachelors' degree in Engineering •    Minimum experience: •    5 years' experience working as a systems engineer   Desirable additional education, work experience and personal attributes: •    Education and experience with Signal-based Systems (Radar, Telecoms or equivalent) •    Solid technical background of working as a systems engineer •    Must be a team player, self-starter, self-discipline, ordered and structured   The ideal candidate will have the following competencies: •    work independently •    work in a team and maintain good relationships •    excellent organisational skills •    communicate effectively •    confident   Experience •    experience in a project environment working as part of a team •    experience in following the SE process from start to finish on a few projects is a requirement •    experience in performing this work on signal-based systems is highly desirable   Knowledge •    knowledge of the System Engineering process and the elements of the process •    domain knowledge of the system being developed   Mail your CV to:    anthonyjobs(at)wcp.co.za

OUR SERVICE IS AVAILABLE IN GAUTENG Design Waterproofing Systems is a family owned business specializing in waterproofing, roofing and damp proofing and have been in business since . There are currently branches in Cape Town and Johannesburg.Our company has been providing an affordable and accredited service. Get the service that you deserve.For more information visit tradecheck.info Contact Craig Napier for enquiries and free quotes (office and after hours) –

The Systems Analyst supports the business by helping them to transform operational objectives into business solutions by gathering, analysing and translating their specific needs into clear, unambiguous business requirements and functional specifications, and ensuring that all end to end requirements of change and projects are met. This role is dealing with advanced business issues that have medium to high complexity and have not been fully covered by precedents in similar ways. Job Description and Responsibilities · Translate business needs into high level and detailed business requirements, and work with the Development Team to convert them into feasible technical solutions that resolve existing issues and make business and system improvements which support business objectives. · Build business cases using modelling tools, cost benefit analysis and impact assessments to support or define cost effective and workable solutions for the business. · Define functional and system specifications and support the user and acceptance testing to ensure that each step has been carried out, the built solution meets budget, quality, and customer need and any implications for the business have been identified and analysed. · Provide project managers with estimates, business cases, planning, and risk identification, problem and issue management to support the design and delivery of projects that implement proposed solutions to agreed time and budget. · Liaise with 3rd party suppliers to create functional specifications and co-ordinate the delivery of their services in line with proposed solutions and project timelines. · Document business requirements, business processes and system requirements including the outputs of formal analysis techniques so that there is an accurate record. · Investigate, research and propose new developments in technology that may be usefully applicable to the wider business to improve the current service. Education and Experience • B. Sc / B. Comm / B. Sc Eng - IT related degree or IT related diploma Skills, Attributes & Other requirements v A good understanding of Prince 2 or similar project methodologies v Has worked concurrently on several analysis engagements varying in size and complexity v Good understanding and experience of business process modelling v Experienced to both Waterfall and Agile development v Proven stakeholder management EMAIL: recruit@rmgrecruitment.co.za

Reference  : PTA//SBA/LT Salary  : Market Related A great opportunity is available for a BA to join a reputable company based in Centurion. The individual will be responsible for developing of new functionality as reflected in the design documents.  Requirements: •3-5 years’ experience •IT Degree/ Business Analysis Diploma •VB.NET  •ASP.NET  •Microsoft Visual Studio or above  •Microsoft SQL Server or above  •Stored Procedures  •Microsoft Team Foundation Server  •Reporting Services or above  •.NET Framework 3 or above  •Web Development  •Strong troubleshooting skills  •Strong debugging skills  •Microsoft Patterns and Practices  •XML  Should you meet the following requirements for this position, please email your CV and detailed skills matrix to . You can also contact Lize on   NOTE:  When replying to the advert, also include the reference number in the subject line. Correspondence will only be conducted with short listed candidates. Should you not hear from us within 3 days, please consider your application unsuccessful.

Responsibilities: Identify, understand and plan for organizational and human impacts of planned systems, and ensure that new technical requirements are properly integrated with existing processes and skill sets. Guide and the review the source code development process with regards to alignment to the technical design. Monitor the systems performance and proactively finds ways to enhance efficiency and ensure stability Outputs: Create a detailed design, logical design, high level mapping (data, process) and code design Ensure that the technical design will integrate to required systems Assist in developing alternative solution proposals, and participate in the evaluation and selection process. Document the Decision Analysis, Resolution Report & Release Notes Assist Systems Architect in defining the test strategy to test performance on new infrastructure after it has been commissioned. Assist developers in understanding the architectural principles of the environment. Implement the Technical Specification using the relevant development language Consult with BA and Architect on technical issues encountered Document Database structure changes and rule changes Qualifications: B. Sc (Informatics or Mathematics) Essential Project Management qualification Beneficial) Minimum Required Experience: 5 years experience on software development in corporate environments Java Development Other: System integration experience UML Process Design experience Systems Architecture experience Spring Integration experience Relevant business experience or product/systems knowledge Knowledge: SDLC Project Management Systems Architecture ITIL processes CMMI Technologies - Programming Languages: C, Java, Java script, SQL, Flex, HTML, Magic, PSQL, Oracle. UML, BPM, Modeling. Data modeling techniques, UML Process Design, Usability design. Technical Skills: Process & Data Mapping Entity Diagram mapping  Project Management Business Writing Skills Presentation and Facilitation Skills Advanced Problem solving Analytical and systemic thinking Technical Architecture Please contact us to apply.

Information Technology tutor available, I am a qualified software developer, I tutor in the following: Windows operating systems basics, How to setup computers and install windows, Web Development and web design, Database management and database design, For more info call or whatsapp me on O64,508,6896

Brief overview  The SQL database environment is growing rapidly and requires increased focused attention to service project requirements, implement requests, resolve issues and incidents, as well as perform the necessary maintenance; Personal development and continuous learning are very important in this area and you will be expected to stay abreast of technical development in the SQL Server database environment. Your day to day office tasks:   You will be responsible for the definition, creation and maintenance of Client application database structures; Analysing, testing, and implementing physical database designs supporting business applications; Ensuring data recoverability, database availability, data integrity, agreed level of performance and capacity planning for physical databases; SQL Server DBMS installation, configuration and overall management; Documentation and MIS collection for the assigned application area databases; Researching and development of technical area assigned to you; Escalation of issues, incidents and risks to management when they arise; Setup and coordinate client application area interaction on a regular basis; Ensuring that maintenance plans and documentation are in place, re-visited and updated at least once quarterly or after changes impacting the application area; DBA process refinement; DBA reporting to DBA management; Participation in team stand-by activities, every 4th week after initial training period. Job Requirements 'Must have' Qualifications and experience: At least three years DBA working experience; Experience needs to include all disciplines of DBA work i.e. Administration, performance tuning, security, backup and recovery etc.; Microsoft SQL Server Database certification. DBMS Knowledge that you will need: • Sound working knowledge of System Architecture and IT Components; • An in-depth knowledge of database concepts; • Detailed understanding of SQL Server and ; • Working knowledge and understanding of SQL ; • Basic knowledge of underlying operating systems the DB resides on; • Knowledge and understanding of all available products, services and resources in the SQL Server suite of    products. Lastly you will need to show why you are a good team fit to the company and successfully complete the ITISS DBMS technical proficiency assessment.  

Job user ID: Location: Gauteng, Randburg Duration: 6 months Date: November   The IS Operator Internship role provides the perfect opportunity for a young and energetic individual to lay the foundations for a career with the Information Systems space.   This internship will provide the IS operations with support of day to day processes necessary for the transmission of information within the business.   Requirements:   ·         Matric with an ICT related subject (essential)   ·         A+ or IDCL (desired)   ·         Some ICT work would be ideal   ·         Ability to perform mundane tasks   ·         Knowledge of SQL would be very useful   The intern will be responsible for:   ·         Running day to day and cycled operational processes as defined by established procedures   ·         Monitoring systems, servers and processes   ·         Recognising and logging system errors / failures in order to timeously escalate for resolution   ·         Action and monitor relevant database back-ups   ·         General maintenance and housekeeping of internal systems   ·         Server performance monitoring   To apply for this opportunity please visit www.gogap.co.za (filter Internship ID )

Manufacturing IT Systems Analyst – East London (24 month contract) Please note: 1. This position is a fixed term contract for 24 months 2. Completed tertiary qualification at NQF level 7 is essential (certificate to be submitted with CV) Requirements: · Matric certificate · Completed degree in Information Technology (NQF 7) · Minimum 2 years working experience (post-grad) as a Systems Analyst · Must be willing to work shifts if required Must be proficient in the following: · Linux, Storage, Networks, VWWare, Interfaces · Data modelling and database management systems – SQL, Oracle, PostgreSQL, · JAVA · Experience using Crystal Reports · DevOps (JIRA, GitHub, SonarCube, Jenkins) Outputs: · Responsible for designing solutions, failover designs, system sizing requirements · Manage software upgrades, deployments, downtime, patches etc. · Conduct testing after deployment or patches · Managing interfaces between applications · Provide technical support · Responsible for monitoring system performance and capacity planning · Develop reports (Crystal Reports) · Managing cross-functional programs and projects Salary negotiable, based on experience

Introduction Growth in our client’s web services team requires expansion of their web server configuration and technical support services and expansion in their core products and infrastructure. The Senior LINUX Systems Engineer with the ability to automate administration tasks using scripting, administer and support multiple servers including a number of hosted servers critical to the business’s clients.   Minimum Requirements Matric Relevant certification Minimum of 5 years in a Linux Systems Engineer role   Job Specification Purpose of the role:  General administration (Windows and Apple) Linux system administration o    Installations, maintenance and security updates o    Web server (Apache & PHP) o    Database server (MariaDB / MySQL) o    Other services (DNS, FTP, Mail, ssh, etc.) Strong scripting skills (Bash, Perl, PHP, Python, etc) Networking (Configuration and troubleshooting) Firewalling and security Backups and disaster recovery Capacity planning, performance and reliability analysis and tuning Management of a junior technical resource Skills required: Ability to explain technical problems to non-technical people Skills exchange to other members of the team Excellent command of the English language Solid client and staff management skills If you do not hear from us within 1 month of the closing date, you may assume that your application was unsuccessful. All qualifications and certificates will be verified. Our Client reserves the right not to fill the position. Candidates may be expected to undergo psychometric testing. It is the applicant's responsibility to have foreign qualifications evaluated by the South African Qualifications Authority (SAQA) and to provide the evaluation results.

Job Position: Mechanical Design Engineer Ref: 3946 Location: Port Elizabeth Salary: R28 000 to R35 000 per month CTC commensurate with experience and qualification Email your updated CV to recruit@onlinepersonnel.co.za Qualifications / Requirements: Suitable Mechanical Engineering qualification (minimum National Diploma Mechanical Engineering) Advanced skills in Autodesk Inventor with proven experience/history Intermediate/Advanced skills in Ms Excel, Ms Word, Ms Powerpoint Automotive OEM supplier design experience would be advantageous Working knowledge of automotive vehicle electrical systems would be advantageous Key Performance Areas: Generating of concept designs Generating of functional and structural designs Oversee prototyping of product and related processes. Final design including generating of drawings for manufacturing New component development with suppliers Product design for vehicle derivatives Production handover and implementation for new/revised products Management of product design information (CAD, drawings and product libraries) Generating and management of bill of material information Product quality management (design related NCR’s, CAR’s and 8D reports) Responsibility: Salary: R28 000 to R35 000 per month CTC commensurate with experience and qualification Email your updated CV to recruit@onlinepersonnel.co.za Qualifications / Requirements: Suitable Mechanical Engineering qualification (minimum National Diploma Mechanical Engineering) Advanced skills in Autodesk Inventor with proven experience/history Intermediate/Advanced skills in Ms Excel, Ms Word, Ms Powerpoint Automotive OEM supplier design experience would be advantageous Working knowledge of automotive vehicle electrical systems would be advantageous Key Performance Areas: Generating of concept designs Generating of functional and structural designs Oversee prototyping of product and related processes. Final design including generating of drawings for manufacturing New component development with suppliers Product design for vehicle derivatives Production handover and implementation for new/revised products Management of product design information (CAD, drawings and product libraries) Generating and management of bill of material information Product quality management (design related NCR’s, CAR’s and 8D reports) Salary: R28000 to 35000 Job Reference #: Mechanical Design Engineer