Sql database administrator

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

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

Check out the top 5 SQL database recovery software to recover the SQL database of your business. Here is a SQL repair software that you need to try to repair the SQL database for Your business. Just check out the list of best SQL recovery software.

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

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

My client a leading agricultural trading organization with the head office based in Stellenbosch is seeking to employ a Logistics Administrator with min 1 - 2 year experience in a similar role. A relevant Degree / Diploma will count in your favor. Duties: Daily administration function – feed all load data into computer database; reconciliation of POD's and loading weights. Collecting and compiling tracking. Follow up trucks to determine accurate ETA. Managing transporter database. Handling of client, transport and supplier related queries. Good communication with clients keeping them informed about the status of the cargo. Registering transporters and ensuring GIT insurance is in place. General administrative support. Collecting of POD’s. Requirements: Relevant Diploma / Degree advantages. At least 1 - 2 year’s relevant experience in a similar position. Ability to prioritise and work under pressure.

Our client, an FMCG Manufacturing company seeks a suitably qualified Key Account Administrator at their Head Office in Southern Paarl. The Key Account Administrator acts as the connecting piece between the Customer and the Sales Person by processing orders, keeping track of customer information and providing post sale customer reports, collecting, organizing, and filing sales orders using knowledge of paper and electronic filing systems. KEY PERFORMANCE AREAS Export Sales • Receive export contracts • Ensure client account details are up to date / sending take on forms • Send contract details to factory and logistics • Load contracts to Dropbox/OneDrive and contract sheets • Update shipment schedules • Daily correspondence with clients / handling queries • Daily correspondence with factory / logistics • Drafting Sales Confirmations where necessary Domestic Sales • Daily correspondence with clients / handling queries • Daily correspondence with factory / logistics / admin / lab • Drafting quotes and contracts • Ensure client account details are up to date/ Sending take on forms • Send contract details to factory and logistics • Load contracts to Dropbox/OneDrive and contract sheets • Coordinating local orders and deliveries for all factories • Client visits • Arranging payments for COD orders • Sending Invoices / Delivery notes / COA's • Arranging collection of empty drums from client sites Customer Care / Samples • Sending annual customer satisfaction questionnaires • Update of Quality Documents folder on Sharepoint • Sending sample requests to lab • Daily follow ups, sample details and results • Sending sample waybills and COA's • Invoicing of samples when necessary • Updating customer visit schedule PR and Marketing • Ordering and arranging marketing materials • Trade show applications and arranging materials • Linkedin, Website and other digital marketing Stock • Weekly group stock reports SA and EU • Managing intergroup stock between Malelane and the rest of the group REQUIREMENTS • Tech-savvy and have a strong eye for detail to accurately maintain a database of customer information. • Strong communication skills. • Their ability to navigate these situations directly affects the revenue of their employer. • Defusing upset customers using interpersonal communication skills • Using Microsoft Office Suite to maintain sales figures and create presentations • Presenting sales data to sales management • Be able to perform under pressure • At least 3 -5 years’ experience in the Key Account Administrator field • Added advantage would be if candidates is from the fruit juice concentrate / fresh fruit / beverage industry SALARY: R28 000 – R35 000 CTC, pension and medical aid included Please use the following reference number in the subject line of your email: CR500 when applying for this position. Please submit your CV in Word Format to info@cardosorecruitment.co.za. Kindly consider your application unsuccessful should you not receive feedback within 1 week. Salary: R28000 - R35000 Job Reference #: CR500 Consultant Name: Mari Cardoso

A dynamic Consulting Engineering company based in Nelspruit is seeking the services of a committed and hardworking Office Administrator to assist with the following duties: Office Administration, Procurement of office equipment’s and stock management, Supplier Database Management, Fleet management including: vehicle maintenance and Trip Planning management and management of drivers, Maintain accurate filing records for vehicle fleet, Secure vehicle fleet licensing is up today and keep accurate records of expiry dates, Maintaining detailed records of vehicle servicing and inspection and Book vehicles for repairs, Monitoring driver behaviour by utilizing tracker systems to monitor drivers and track vehicles in case of theft and Engagement with our brokers, manage traveling mileage claims and funds requisitions and insurance companies to ensure all office asset and vehicles are ensured and update and among other duties a market-related salary is offered plus benefits. MINIMUM REQUIREMENTS Matric (Gr 12), Computer Literacy (MS Office & Outlook), Relevant Tertiary qualification is an advantage, Minimum of 2 years’ experience in office administration, logistic / fleet management environment, driving experience with drive license (Essential). If you feel that you meet the requirements, please send your detailed CV, driver’s license & Qualifications to mondeconsultingmce@gmail.com not later than 30 July 2021 @12h00. Should you receive no response by 30 August 2021, please accept that your application has been unsuccessful.

IT Technician -Free State /N-Cape Qualification • A+ • N+ Experience and Knowledge • 3 years’ experience in computer networks, systems maintenance. • Extensive Knowledge of Computers and Networking RDP and VPN • Word / Excel / Outlook / Windows 10 • Windows Server/ Postgress /SQL • Printer Basic Knowledge The candidate must have a good understanding of networks VPN and RDP setups, Wireless networking setup, Fault finding and network cabling. Must be able to troubleshoot and think outside the box to solve problems in emergency situations. Candidate will report to the IT Manager. salary negotiable according to skill set Please send cv with ID attached to belinda@power4u.co.za / technical@power4u.co.za

Techairos is a small tech company based in Stellenbosch, South Africa. We specialise in building custom data-systems solutions, including integrations with Xero cloud accounting, building mobile apps, web-apps, and integrations to a range of other systems and tools. We are busy growing our team. We are looking for candidates with Computer Science, Informatics or Engineering degrees or diplomas, AND relevant work experience. ------- Why Techairos Consulting? Mostly work from home - one day in office a week. Generous leave policy Relaxed working environment Small company with room for growth – we are growing our team, and there will be opportunities to take on more responsibility as we grow Make a difference - Techairos Consulting has been the main tech partner to the Abalobi Project for several years Job description You will be given responsibilities on a variety of projects, depending on your skills and experience. Possible tasks may include: Testing new features and releases of mobile and web-apps Customer support - especially on the ABALOBI projetc. Monitoring project data integrity Database maintenance tasks Apply if you are: Eager to help us improve our testing department and provide great customer service Available to attend interviews in Stellenbosch in person (please indicate your current city/town of residence specifically in your application e-mail). Requirements SQL / Database experience Excellent written and spoken English At least 2 years’ relevant work experience Traits Attention to detail Self-motivated Good communication skills Problem solver Integrity Remuneration

Job description The client support technician’s responsibility is to be the first point of contact for Adept’s clients and the rest of the company. This position requires the technician to field calls and respond to tickets logged via the helpdesk systems. This is to be done either via troubleshooting the issue and then resolving or escalating to the relevant departments. Qualifications CompTIA N+, A+, L+ or equivalent MCSA or equivalent Advantageous CompTIA Security+ or equivalent CompTIA Server+ or equivalent MS SQL Database Fundamentals Exam 364 or equivalent CCNA will be extremely advantageous Skills Strong knowledge on Internet fundamentals Strong hardware, software and network troubleshooting skills Experience within a helpdesk environment Experience working within Windows, OS X and Linux desktop and server environments Personal competencies Exceptional communication skills Problem-solver Self-starter Attention to detail Team player and able to work in group environments Passion for technology A strong need for personal growth Please apply through the link below. Only applicants applying through the link will be accepted.

JUNIOR SYSTEM OPERATOR / EAST LONDON – to perform schedule computer and system related tasks - Must be prepared to work in shifts between the hours of 16h00 – 07h00 Job Purpose: To perform a sequence of IT operations and commands, by studying a production schedule, to ensure the successful outcome. Defined tasks per documented instructions/processes. Prepare equipment for operations by accessing software in computer, and where possible resolves issues and/or exceptions, reporting to the appropriate supervisor Minimum Requirements/Qualifications: Matric Minimum 1 years’ IT working experience with contactable references Effective communication and written skills Computer literacy (Windows, Microsoft Excel, Word, and Outlook email) Knowledge, experience in following systems/platforms would be an advantage Linux; A+ & N+ Duties To execute the instructions, as specified and shared from the Senior Systems and Database Administrator. Answering and Providing after hours telephonic, technical and user support Monitor, Execute, Check and document Daily procedures. Monitor, Test and Inspect ICT equipment. Monitor Daily email notifications and complete Daily Checklists. Escalate and Log Risks and Issues as they occur. Printing of reports & Statements Alternate to work in Shifts between the hours of 16h00 – 07h00 Salary – Market related Application Process: Online applications will receive preference, include certifications, alternatively e-mail CV and Certifications & Head and Shoulder photo to Solutions@workafrica.co.za and use “ JCO#1 ” as a reference in the Subject field. Closing date for applications 16th October 2020. If you don’t hear from us within 3 weeks, consider your application unsuccessful. Additional Info: 1 to 5 years Salary: RNegotiable Job Reference #: 1809144017

Overview: In the steelmaking production process, the ladle is the key equipment for holding molten steel, secondary refining, and continuous pouring. In a modern steelmaking plant, refractory materials are required for converters, refining, and ladles. In the steelmaking process, ladle is the main equipment for using and consuming refractory materials. Improving the service life of ladles and reducing refractory consumption is the key technology for steelmaking plants to save costs and reduce energy consumption for green production. In order to ensure the orderly operation of the ladle, save the consumption of refractory materials, prolong the service life of the ladle, and ensure the safe operation of the ladle, Wuhan CenterRise M&C Engineering CO. developed and launched the LDT-N200 integrated management system for the ladle. Introduction: LDT-N200 ladle integrated management system integrates LDT-L200 ladle lining thickness gauge, TBP-S300 ladle, tundish baking temperature and leakage monitoring system, RFD -C100 metallurgical electronic positioning system, and also integrates SQL Server database and NeuralWare (American computer software company) neural network software NeuralWorks to realize intelligent and optimized management of ladles. LDT-L200 ladle lining thickness gauge uses a laser area array scanning sensor to accurately measure the real-time thickness of the ladle lining, calculate the lining loss, and predict the service life of the ladle. TBP-S300 ladle, tundish baking temperature and leakage monitoring system uses infrared thermal imaging camera and embedded armor wire system to comprehensively monitor and prevent ladle leakage. RFD-C100 metallurgical electronic positioning system installs RFID electronic tags on all ladles to realize full-time and full-space ladle positioning and tracking. LDT-S200 ladle optimization control and analysis software, based on SQL Server database, B/S network structure, realizes online management of ladles, and adopts BP neural network system to realize intelligent optimization control of ladles. LDT-N200 ladle integrated management system can realize ladle age management based on ladle lining data and neural network algorithm, safety process control of ladle turnover and use, full-time tracking management of steelmaking production and full-space tracking management of ladle use and provide optimal control and management of steelmaking production and ladle maintenance. Comprehensive ladle measurement and monitoring, ladle positioning and management, and data management and optimization enable the LDT-N200 ladle integrated management system to fully realize ladle entire process management, optimize the service life of ladles, and comprehensively reduce the cost of refractory materials. The features: Using a lining thickness gauge to measure the thickness of the ladle lining Using infrared thermal imaging camera/embedded armor wire to realize ladle leakage detection Using RFID/number plate recognition to realize the location management of ladles Ladle age management system based on overall tracking Overall (full-time full-space) ladle management system based on database Provide overall production scheduling data Using neural network to predict ladle service life based on big data Ladle Optimal Scheduling System based on database and ladle service life Increase the service life of ladle by 12%-20% Reduce the use of refractory materials more than 15% Realize orderly management of ladle baking Realize full space and full time domain control Reduce the costs of ladle management and maintenance Improve the efficiency of ladle turnover operation

Senior Software Developer | Port Elizabeth - Eastern Cape Salary: R45K+ Per Month Purpose of Position: Complement Recruitment are recruiting for a Senior Software Developer to join our client and their growing database of clientele and new projects in Gqeberha, Port Elizabeth, Eastern Cape. Core functions are to deliver high-quality Digital Transformation, Software Development and other solutions for the company & it’s expanding client base. Position is permanent.   Apply Directly for this Job by clicking here - https://bit.ly/3LkgmiK   Requirements: Proven track record with Minimum 5+ years of experience in similar position PE based or willing to move to PE, but open to remote work To start within the next 1 – 2 months maximum, but the sooner the better Matric, BSc, BIT, MSc, MIT or other relevant qualifications preferred, but not essential Microsoft, AWS or other certifications preferred, but not required Driver’s License, Own Reliable transport – Must be able to travel on site to clients Roles and Responsibilities: Lead the delivery of high-quality Digital Transformation, Software Development and other solutions based on the company’s portfolio and product offerings, on time and within budget Assist with Technical Presales, Planning and Implementation, Testing/Quality Assurance, Business/Systems Analysis and Project Management Meet goals and targets that are aligned with those of the organisation Commit to continuous improvement and ongoing skills development Must be willing to travel and have their own reliable vehicle with valid driver’s license Knowledge of and experience with as much of the following as possible is preferred: Development   o.NET Framework and Core o ASP.NET, MVC, Web API and Core o HTML, CSS, JavaScript and TypeScript o jQuery, Angular o ORM (EF, EF Core) o Web Services (REST & SOAP) o Mobile Development o React o SharePoint 2013-2019 & Online o Workflow Development o Nintex or K2 o Office 365 Development o Azure Development o Dynamics CRM 2013-2016 & Online o Azure DevOps   Databases: SQL Server 2012-2019; Database Design; Database Administration Applications: Windows Server 2012-2019; Internet Information Services (IIS); Visual Studio; Git source control   Industry Experience & Product Services: Digital Transformation, Software Development, Cloud Solutions, Internet Solutions, Voice Solutions and IT Consulting. Products: Microsoft 365, Microsoft Azure, Microsoft Dynamics 365, Microsoft Office 365, Microsoft Power Platform, Microsoft SharePoint, K2, Software Licensing and Hardware. Company Culture – Work Hard, Play Hard   Find Us on Social Media

Innovative, dynamic, evolving are just some of the characteristics about us. We are looking for an API developer from the IT field/arena who is looking to take charge and initiative and lead a team of individuals whom are making a difference! Responsibilities: 1. Develop effective software that meets given specifications with review and mentoring by others in the team; 2. Write appropriate tests using automated test-driven techniques for ensuring code quality; 3. Integrate the software with monitoring and support tools, supported by others in the team; 4. Contribute to technical documentation; 5. Help to troubleshoot and resolve issues throughout the product life cycle, including out of hours support (with support from other in the team); 6. Learn and use the team's agile planning and delivery process; 7. Learn and participate in the team’s software development methodologies, such as pairing, code and documentation reviewing and continuous delivery; 8. Learn new technologies and keep abreast of existing technologies; 9. Configuration of systems including knowledge / experience with Linux, Key competencies: 1. Have excellent organizational and administration skills; 2. Exceptional verbal, written and communication skills; 3. Attention to detail and analytic skill set; 4. A proven ability to quickly and methodically resolve technical and user related issues; 5. Excellent leadership skills and ability to drive solutions; Requirements: 1. Bachelor’s degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field; 2. 2-3 years of experience as Java/J2EE developer. 3. Strong knowledge of API development; 4. Strong knowledge of the java frameworks (Spring MVC, Spring Security); 5. Strong knowledge of UI development (JSP, HTML, CSS, Ajax, XML); 6. Strong knowledge of web services (WSDL Soap, Restful); 7. Should have payments/ payments staging exposure on APIs; 8. Proficient and hands on with Application Servers; 9. Good knowledge of relation database, specifically Oracle (SQL - PL/SQL); 10. Technical expertise in the design, development, coding, testing, and debugging of software; 11. 2-3 years’ experience in Linux; 12. 2-3 years’ experience in coding; 13. 2-3 years’ experience in back-end development; 14. Own vehicle and valid driver’s license essential. Remuneration Package: R 40,000.00 - R 50,000.00 gross per month (CTC) Benefits: Group Medical Scheme, Provident / Pension Fund *To be discussed at interview The position is office bound in Cape Town CBD. Unfortunately remote work is not applicable in this instance. If you feel you have what it takes to be a part of a growing initiative and enterprise who is breaking barriers APPLY NOW don't miss out on this exciting opportunity! Should you not hear back from us within 5 - 7 days of applying, kindly consider your application as unsuccessful! Expected Start Date: Job Types: Full-time, Permanent Salary: R40,000.00 - R50,000.00 per month Send your CV to hr@gqm-services.com