Ms access sql

Our client has a position available in their organization based in Port Elizabeth, for an SQL Developer. The purpose of this role is to develop, test, deploy, maintain and support a portfolio of new and existing software applications and services, from high-level business requirements and designs, through the Software Development Life Cycle.   Requirements: B.Com/Bus Sci (IS); or BSc. (Comp); or B.Tech IT (Software Development). N.Dip IT (Software Development).  3-5 years’ development experience (essential). Skilled in Microsoft SQL Server database (TSQL). Understanding of SQL and RDBMS technology (MySQL, MS SQL Server, DB2). Knowledge of relevant programming languages.  Knowledge of software testing.   Desired competences: Communication skills. Interpersonal skills. Problem-solving skills. Planning and organizing skills. Analytical skills.   Duties and Responsibilities: Collaborate with the Scrum Master/Project Manager to deliver quality, effective software, in line with the agreed development process and business needs. Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests. Conduct research and evaluate potential technical solutions to identified business problems. Partner with Business and/or System Analysts to translate business requirements into workable solutions and document solutions into technical specifications. Design and code new software functionality using code that is readable, maintainable and re-usable. Conduct Unit Testing of own code, and System Integration Testing (SIT) of each solution and resolve all issues/queries timeously. Collaborate with the testing team to co-create test cases to ensure that features within each application are working as expected. Contribute to user acceptance testing (UAT) and training material to ensure that functionality is working correctly. Provide stakeholders with regular feedback on the technical design and timelines for solutions, ensuring that business needs are met. Maintain existing programmes according to change requests approved by business as and when needed. Diagnose root causes of system issues through problem-solving and recommend potential solutions. Monitor performance of solutions and make recommendations to improve the performance and functionality of the solution. Log issues found in existing systems as internal change controls and ensure successful resolution of issues. Provide authoritative expertise and advice to clients and stakeholders. Build and maintain collaborative, professional relationships with clients and stakeholders. Deliver on service level agreements made with clients and stakeholders in order to ensure that expectations are managed. Participate and contribute to a culture which builds rewarding relationships, facilitates feedback and provides exceptional client service. Develop and m

Reference: JC52415 Our client who specializes in the import and export of consumables is seeking a Senior MS SQL Developer within the Port Elizabeth Region. Duties include, but are not limited to: * Strong T-SQL Development, SSIS and ETL experience. * Performance tuning and optimising SQL query and T-SQL. * Monitor and manage database performance. * Maintain data and code standards. * Troubleshoot and resolve the following problems: database integrity, performance, blocking and deadlocking, replication, log shipping, connectivity, and security problems. * Control access permissions and privileges. * Develop, maintain, perform, and test database backup and recovery strategies and procedures. * Ensure that storage, archiving, backup, and recovery procedures are functioning correctly. * Monitor database capacity. * Provide proactive performance monitoring and capacity planning for future database and server growth. * Monitor and complete all DBA related Services. * Develop and maintain best practices database documentation. * Research and evaluate new databases trends and technologies and provide best practices and recommendations for Qualifications & Accreditations. Position requirements as follows: * Diploma/BCom in IT. * Masters in IT/MS Certificates will be an advantage. * Database Administration experience will be an advantage. * Strong intermediate/Senior (Minimum 5 - 10 years' experience in SQL development). * Big data process experience. Should you want to apply for the position, please send through your CV and qualifications to the following email address and use the reference number for the position as the subject of the email Email: (Email Address Removed) Should you not get an email from us within 2 weeks, consider your application unsuccessful *Desired Skills: * * SQL * SQL Developer * SQL Server * Developer *Desired Work Experience: * * 5 to 10 years *Desired Qualification Level: * * Diploma

Nova Life is a company where drive, opportunity, and dedication meet excellence. We focus on providing our clients with innovative telemarketing solutions and achieving above-market results in a synergistic atmosphere. The great quality of our staff and our solid foundation is the key to our continued growth and success year on year. We employ only the finest and pay above-market salaries due to our ability to achieve above-market results.   We are seeking a Junior Data Coordinator to join our dynamic team. * Basic administrative, system, and data-driven tasks. * Data preparation and management. * Data manipulation for statistics and projects. * Development and new business requirements relating to data, systems, and reporting. * Forming part of a dynamic, data-driven team that supports the business across multiple functions. * Adhoc duties.  * 3 Year completed degree in any field. * Fluent in Afrikaans and English * SQL (MS Access or My SQL) preferred. * MS Excel (Minimum requirement). * Good time management skills. * Detail orientated. * Hard-working. * 3 Year completed degree in any field. * Fluent in Afrikaans and English * SQL (MS Access or My SQL) preferred. * MS Excel (Minimum requirement). * Good time management skills. * Detail orientated. * Hard-working.

We specialize in providing a Business / System Analysis service with the associated custom software written to suit your business requirements. We assist businesses and individuals to improve their business processes through data modelling and database management. We make use of sophisticated and customizable SQL database solutions and MS Access to suit your own requirements. Our system offers a dynamic approach to software development. Our software is a user-customizable application that allows users to create their own software modules on the fly. Our software is unique in that it allows its users to build additional functionality within the software completely, without programmer intervention. Modules can be added to the system which supports hierarchical data structures, with customizable fields for each module created. The system is an effective Interactive Database Data Management System that has been designed to allow setups to suit user requirements from all industries. Our system program is also particularly useful to freelance consultants, freelance programmers or system developers to use as their preferred database system platform for their own clients. The development time for programmers and developers is substantially less than other conventional system platforms available. The process of database design has been simplified to the extent that users proficient in Microsoft Excel can easily convert a spreadsheet application into our database application type. Programming is simple as it mirrors much of Microsoft Excel and Microsoft Access functionality. Advanced Crystal Report writing, VB.Net, VB Visual Basic, VBA, C Sharp or C++ functions can also be integrated into the system. The system platform offers a combination of the functionality of a database program together with spreadsheet, word processing, documentation control functionality and Microsoft Project-style gantt chart planning. Multiple databases can be combined into one application using the system platform. The system platform supports various methods to populate a database including a direct interface, a webpage interface, a tablet interface or through an Excel or Word interface. The system can be setup to run on a stand alone computer or on a network. We currently have applications setup on the system that include: Construction Management Document control and Document Management Marketing Management Tender Management and Construction Cost Estimating Contract Management Subcontract Management Correspondence Management Programming and Planning Management Risk Management Health and Safety Management Quality Assurance Environmental Management Human Resources Management Internal Plant Management Stores Management Wage Personnel Management Salary Personnel Management Labour Costing Goods Received Costing Hired Plant and Equipment Costing Overheads Costing Subcontractor Costing Head Office Costing Accounting Cost and Management Performance Reporting Our skill sets include: Dynamic SQL / T-SQL SQL Server Database Administration, Reporting, Integration, Management, Database Building, SQL Store Procedures C#, VB.Net, VBA, HTML, AjaxControlToolkit, Javascript Crystal Report Writing Web interfaces to integrate data to databases Tablet Interfaces to integrate data to databases Windows server management Network setup and secity Microsoft Visual Studio Kaspersky security management Infragistic controls

Position availabe for data capturer of technical plant data and maintenance history. The position is a 6 month fixed term contract with the possibility of extending the contract into permanent employment. Minimum requirements for this position: Matric certificate, at least two years experience in either data capturing or administration and excellent computer skills (MS word, MS excel, MS Access) Additional attributes -Good time management skills -Ability to work independently -Ability to work accurately -Ability to drive a common cause Duties and responsibilities - Capturing technical plant data - Tracking and keeping history of technical plant failures and maintenance interventions - Ensuring quality control of information - Generate a weekly report on plant status to submit to key role players - Update database information as deemed necessary - Provide administrative support to contracts manager Position closing date: 1/07/2015 Please email cover letter and cv to Carina Myburgh at atecosales@gmail.com

A virtual admin offers administrative service at affordable rate, Offer typing service 24 hours, 7 days a week. Our business is virtual and do everything electronically.Qualified in the following Microsoft Offices MS Word, Excel, Powerpoint, Email, MS Access.Should you have the interest in the above kindly contact us at hlekhuzwayo@gmail.com

Purpose of the role: To lead a software team – to develop a number of applications to enhance business. An interest in machines, mechatronics etc would be ideal. The company has a plan to invest in the world best processing equipment and need a bright, sharp mind to assist them to integrate these machines and develop applications that will make them the number one processor in the country. This company is progressive within the industry by bringing innovative ways for their customers to order specific products using one button and ensuring they receive it perfect every time ! The long term run way for this candidate is to get exposure and access to some of the best European machine manufacturers which can connect them with and provide programmes for bright minds to get exposure to the international stage. Skill set required: Flutter. C#. SQL. PHP. Other Beneficial Skills:.Net Framework..Net Visual Studio. Agile and Scrum. AJAX. Android Studio. AppScan. ASP.Net. Azure. C#. Crystal. CSS. Entity framework. Flutter. GitLab. HTML. JavaScript. JQuery. Microsoft Office. Microsoft Visual Studio. MS Office. MVC. MySQL. PHP. Python. SQL - Server & Server Management. Syspro. Team Foundation Server. Telerik Reports. Testing UI. TFS source control. Uipath Studio. VB. Visual Studio. WCF. WPF. Xamarin Android (Beginner). XAML. Requirements: BSC Computer Science and Applied Mathematics Degree. Matric. Driver''s License. 8+ years of experience as a Senior Automation Developer. Excellent leadership skills and the ability to lead and drive a team in new innovation! Please consider your application unsuccessful should you not receive a response within 2 weeks of applying.

Port ElizabethTo lead a software team – to develop a number of applications to enhance business. An interest in machines, mechatronics etc would be ideal. The company has a plan to invest in the world best processing equipment and need a bright, sharp mind to assist them to integrate these machines and develop applications that will make them the number one processor in the country. This company is progressive within the industry by bringing innovative ways for their customers to order specific products using one button and ensuring they receive it perfect every time ! The long term run way for this candidate is to get exposure and access to some of the best European machine manufacturers which can connect them with and provide programmes for bright minds to get exposure to the international stage.Skill set required:FlutterC#SQLPHPOther Beneficial Skills:.Net Framework..Net Visual Studio.Agile and Scrum.AJAX.Android Studio.AppScan.ASP.Net.Azure.C#.Crystal.CSS.Entity framework.Flutter.GitLab.HTML.JavaScript.JQuery.Microsoft Office.Microsoft Visual Studio.MS Office.MVC.MySQL.PHP.Python.SQL - Server & Server Management.Syspro.Team Foundation Server.Telerik Reports.Testing UI.TFS source control.Uipath Studio.VB.Visual Studio.WCF.WPF.Xamarin Android (Beginner).XAML.Requirements:BSC Computer Science and Applied Mathematics Degree.Matric.Driver's License.8+ years of experience as a Senior Automation Developer.Excellent leadership skills and the ability to lead and drive a team in new innovation!

Qualifications: Relevant degree in a related field. Requirements: 5+ years experience as a BI Analyst Developer. Strong skills in either Power BI or Qlik. Advanced SQL proficiency. Demonstrated project delivery success. Strong numeracy and analytical thinking. Advantageous Skills: Experience with MS SQL Server, SSIS, Power BI. Exposure to Snowflake, Talend, Qlik. Key Performance Areas: Elicit and analyse business requirements. Design, build, and maintain end-to-end BI solutions. Integrate data from multiple sources into a single source of truth. Conduct relational and dimensional data modelling. Build insightful reports and dashboards to drive business improvement. Mentor and support junior team members. Apply now!

Job Position: IT Systems Administrator Ref: 3748 Location: Port Elizabeth Salary: R16 000 per month commensurate with experience and qualification Permanent with 3 month probation 08:00 – 17:00 - Monday to Friday plus standby available on your mobile device Email your updated CV to recruit@onlinepersonnel.co.za Qualifications / Requirements: • Matric + Degree/Diploma • Minimum of 2 years IT experience • Excellent communication skills • Attention to detail and the ability to interpret concepts • Self-starter and pro-active individual • Attention to time-management • High degree of self-discipline • Troubleshooting of computers, physically and remotely • Willing to travel. • Experience with: - Microsoft 365 + Azure - CompTIA Network+ or CCNA - Working knowledge of MS server or Desktop systems - Microsoft Active Directory, DNS and DHCP Key Performance Areas: • Look after users and infrastructure • Recording and managing of IT assets in business • Engage with 3rd party vendors for service delivery • Action IT procurement requests • Ensure that Governance is applied and followed for all Change Controls • Determine network and system requirements • Maintain integrity of the network, server deployment and security • Assign configuration of authentication and authorization of directory services • First level user support (creating users, resetting passwords, access levels, file interface validation, etc.) across all clients • General desktop support: printing setups. office and application support • Cloud infrastructure Please see link for ad and POPIA requirements http://www.onlinepersonnel.co.za/index.php/vacancies/job-detail/job-it-systems-administrator-1143 Responsibility: Job Position: IT Systems Administrator Ref: 3748 Location: Port Elizabeth Salary: R16 000 per month commensurate with experience and qualification Permanent with 3 month probation 08:00 – 17:00 - Monday to Friday plus standby available on your mobile device Email your updated CV to recruit@onlinepersonnel.co.za Qualifications / Requirements: • Matric + Degree/Diploma • Minimum of 2 years IT experience • Excellent communication skills • Attention to detail and the ability to interpret concepts • Self-starter and pro-active individual • Attention to time-management • High degree of self-discipline • Troubleshooting of computers, physically and remotely • Willing to travel. • Experience with: - Microsoft 365 + Azure - CompTIA Network+ or CCNA - Working knowledge of MS server or Desktop systems - Microsoft Active Directory, DNS and DHCP Key Performance Areas: • Look after users and infrastructure • Recording and managing of IT assets in business • Engage with 3rd party vendors for service delivery • Action IT procurement requests • Ensure that Governance is applied and followed for all Change Controls • Determine network and system requirements • Maintain integrity of the network, server deployment and security • Assign configuration of authentication and authorization of directory services • First level user support (creating users, resetting passwords, access levels, file interface validation, etc.) across all clients • General desktop support: printing setups. office and application support • Cloud infrastructure Please see link for ad and POPIA requirements http://www.onlinepersonnel.co.za/index.php/vacancies/job-detail/job-it-systems-administrator-1143 Salary: R16000 Job Reference #: IT Systems Administrator

Job Position: Assistant Information Specialist Location: Port Elizabeth Salary: commensurate with experience and qualification (lower end) Email your updated CV to recruit@onlinepersonnel.co.za Working hours: Monday to Thursday 10 am to 7 pm Friday: 8 am to 12 noon Saturday: 8 am to 1 pm Qualifications / Requirements • Minimum of Advanced Diploma / Bachelors Degree in Library and Information Science • Must have professional registration with LIASA • Minimum of 1 years experience as an Assistant Librarian in a small to medium sized facility within an education environment • Experience in academic compliance, functions / activities experience within a Higher Education environment • Best suited to a friendly, organised person who works accurately and is able to handle pressure • Time management skills • Digital literacy skills • Working knowledge of MS Word, Excel and PowerPoint • Understanding of library related technology Key Performance Areas: Continuously train customers on how to use information centre databases to enable them to research and access information required Facilitate presentations Ensure adherence to policies and procedures and provide ad hoc support Assist with research by searching for relevant articles and research material Request material from publishers and source additional material for staff Update new books on the system to ensure accurate record keeping Compile journal content pages Co-ordinate day-to-day book loans Facilitate academic support and training sessions Participate in Marketing initiatives and strategies Responsibility: Email your updated CV to recruit@onlinepersonnel.co.za Working hours: Monday to Thursday 10 am to 7 pm Friday: 8 am to 12 noon Saturday: 8 am to 1 pm Qualifications / Requirements • Minimum of Advanced Diploma / Bachelors Degree in Library and Information Science • Must have professional registration with LIASA • Minimum of 1 years experience as an Assistant Librarian in a small to medium sized facility within an education environment • Experience in academic compliance, functions / activities experience within a Higher Education environment • Best suited to a friendly, organised person who works accurately and is able to handle pressure • Time management skills • Digital literacy skills • Working knowledge of MS Word, Excel and PowerPoint • Understanding of library related technology Key Performance Areas: Continuously train customers on how to use information centre databases to enable them to research and access information required Facilitate presentations Ensure adherence to policies and procedures and provide ad hoc support Assist with research by searching for relevant articles and research material Request material from publishers and source additional material for staff Update new books on the system to ensure accurate record keeping Compile journal content pages Co-ordinate day-to-day book loans Facilitate academic support and training sessions Participate in Marketing initiatives and strategies Job Reference #: Assistant Information Specialist

Job Position: Assistant Information Specialist Location: Port Elizabeth Salary: commensurate with experience and qualification Email your updated CV to recruit@onlinepersonnel.co.za Working hours: Monday to Thursday 10 am to 7 pm Friday: 8 am to 12 noon Saturday: 8 am to 1 pm Qualifications / Requirements • Minimum of Advanced Diploma / Bachelors Degree in Library and Information Science • Must have professional registration with LIASA • Minimum of 1 years experience as an Assistant Librarian in a small to medium sized facility within an education environment • Experience in academic compliance, functions / activities experience within a Higher Education environment • Best suited to a friendly, organised person who works accurately and is able to handle pressure • Time management skills • Digital literacy skills • Working knowledge of MS Word, Excel and PowerPoint • Understanding of library related technology Key Performance Areas: Continuously train customers on how to use information centre databases to enable them to research and access information required Facilitate presentations Ensure adherence to policies and procedures and provide ad hoc support Assist with research by searching for relevant articles and research material Request material from publishers and source additional material for staff Update new books on the system to ensure accurate record keeping Compile journal content pages Co-ordinate day-to-day book loans Facilitate academic support and training sessions Participate in Marketing initiatives and strategies Responsibility: Email your updated CV to recruit@onlinepersonnel.co.za Working hours: Monday to Thursday 10 am to 7 pm Friday: 8 am to 12 noon Saturday: 8 am to 1 pm Qualifications / Requirements • Minimum of Advanced Diploma / Bachelors Degree in Library and Information Science • Must have professional registration with LIASA • Minimum of 1 years experience as an Assistant Librarian in a small to medium sized facility within an education environment • Experience in academic compliance, functions / activities experience within a Higher Education environment • Best suited to a friendly, organised person who works accurately and is able to handle pressure • Time management skills • Digital literacy skills • Working knowledge of MS Word, Excel and PowerPoint • Understanding of library related technology Key Performance Areas: Continuously train customers on how to use information centre databases to enable them to research and access information required Facilitate presentations Ensure adherence to policies and procedures and provide ad hoc support Assist with research by searching for relevant articles and research material Request material from publishers and source additional material for staff Update new books on the system to ensure accurate record keeping Compile journal content pages Co-ordinate day-to-day book loans Facilitate academic support and training sessions Participate in Marketing initiatives and strategies Salary: R14000 Job Reference #: Assistant Information Specialist

IT Administrator Automotive company requires an IT Administrator Knowledge and skills - Microsoft SQL Server & Microsoft 2012/2016 Server - Microsoft Development tools & Microsoft Office suites - VMWare - Desktop computer Operating Systems (Windows7 and Windows10) - Active Directory & Backup software/solutions - Anti-Virus software & Network security and infrastructure - LAN/WAN topologies and structures - CISCO equipment knowledge - Juniper & Aruba equipment knowledge - Ethernet and TCP/IP - ERP systems (SAP) - CCTV Technology - Access control & Time attendance technology - A sound knowledge of all hardware and network concepts - Fluent in English - Willing to travel (Domestic and international) - Willing to work shifts and overtime when needed Please send cv to etongoodwin@e2estaffing.co.za Responsibility: Key performance areas - Monitoring availability of all servers - Support workstations/notebooks, scanners, CCTV infrastructure, telephone and access control infrastructure and printers - Software management and control - Capacity Management on all servers and desktop computers - SHE audits (Responsible areas) Salary: R16 - 18k Job Reference #: IT Administrator Consultant Name: Eton Goodwin

**Purpose Statement** * To own, analyse, architect, design and implement Cloud Infrastructure Platforms, Services and Systems in regard to ALL IT security aspects and security solutions in support of the Capitec organization. **Experience** Min: 5+ years experience in IT Security-related Architecture role 4+ years experience designing, deploying and supporting Cloud and Infrastructure deployments and its supporting technologies in a medium to large sized organization Proven experience integrating security solutions and practices in a large-scale environment. Ideal: 7+ years experience Mircrosoft and OpenSource Server Operating Systems 5+ years experience with containerised and serverless workloads 7+years experience in ITIL concepts and policies 5+ years experience Cloud Security Technologies including IAM 4+ years experience in expert performance monitoring/analysis and capacity planning 3+ years experience integrating security solutions and practices in a large-scale environment. **Qualifications (Minimum)** * Grade 12 National Certificate / Vocational **Qualifications (Ideal or Preferred)** * A relevant qualification in Information Technology * Certification in ITIL Foundation **Knowledge** Min: Windows Linux Server Architecture Secure network architecture, identity and access management principles and application security principles. Security principles, IT Security procedures and Best Practices Design and deployment of highly available enterprise scale cloud infrastructure. Hand-on experience with Public Cloud (laaS, PaaS, SaaS) and infrastructure as Code capabilities. Developing and delivering systems on at least one of the following Public Cloud Platforms (AWS, Azure, GSP) Experience with authentication and authorization technologies and protocols **Skills** * Communications Skills * Computer Literacy (MS Word, MS Excel, MS Outlook) * Consultation skills * Facilitation Skills * Presentation Skills * Negotiation skills * Influencing Skills * Analytical Skills * Attention to Detail * Planning, organising and coordination skills * Leadership Skills **Competencies** * Achieving Personal Work Goals and Objectives * Working with People * Delivering Results and Meeting Customer Expectations **Conditions of Employment** * Clear criminal and credit record * A valid driver's license and own vehicle is required * Contactable via own mobile phone Capitec is committed to diversity and, where feasible, all appointments will support the achievement of our employment equity goals.

Our client in the banking industry is looking for Cloud Security Architects. The purpose of the role is to own, analyse, architect, design and implement Cloud Infrastructure Platforms, Services and Systems in regard to ALL IT security aspects and security solutions in support of the organisation.   Experience Min: 5+ years’ experience in IT Security-related Architecture role 4+ years’ experience designing, deploying, and supporting Cloud and Infrastructure deployments and its supporting technologies in a medium to large sized organization Proven experience integrating security solutions and practices in a large-scale environment. Ideal: 7+ years’ experience Microsoft and Opensource Server Operating Systems 5+ years’ experience with containerised and serverless workloads 7+years’ experience in ITIL concepts and policies 5+ years’ experience Cloud Security Technologies including IAM 4+ years’ experience in expert performance monitoring/analysis and capacity planning 3+ years’ experience integrating security solutions and practices in a large-scale environment. Qualifications (Minimum) Grade 12 National Certificate / Vocational Qualifications (Ideal or Preferred) A relevant qualification in Information Technology Certification in ITIL Foundation Knowledge Min: Windows Linux Server Architecture. Secure network architecture, identity and access management principles and application security principles. Security principles, IT Security procedures and Best Practices Design and deployment of highly available enterprise scale cloud infrastructure. Hand-on experience with Public Cloud (laaS, PaaS, SaaS) and infrastructure as Code capabilities. Developing and delivering systems on at least one of the following Public Cloud Platforms (AWS, Azure, GSP). Experience with authentication and authorization technologies and protocols (LDAP. Kerberos, AD, OAuth 2.0, OpenID Connect, SAML). Basic understanding of at least one high-level programming language (Golang /.net / Java). Advanced scripting skills in at least one interpreted language and best practices. Understanding of Networking in cloud environments. A solid understanding of: IT Systems development processes (SDLC lifecycle). Business compliance requirements. Business continuity planning. Skills Communications Skills Computer Literacy (MS Word, MS Excel, MS Outlook) Consultation skills Facilitation Skills Presentation Skills Negotiation skills Influencing Skills Analytical Skills Attention to Detail Planning, organising and coordination skills Leadership Skills Competencies Achieving Personal Work Goals and Objectives Working with People Delivering Results and Meeting Customer Expectations Conditions of Employment Clear criminal and credit record A valid driver's license and own vehicle is required Contactable via own mobile phone <