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.

WE Develop Websites for you using the Visual Basic C Sharp Visual Studio SQL Database Graphic Design

We offer the following: Desktop support. Microsoft office windows antivirus application setup and maintenance. Emails and internet remote support. Upgrading of workstations and reinstall of workstations. Hosting of domains – emails and web sides. (this include graphic and web designing) Backup solutions onsite and offsite with remote support (this include every workstation backup once a week offsite.) Price will be different depending on how big the organization is. SQL Database maintenance, setup and backup. PBX Hosting. (Creating of telephone systems of your dreams for next to nothing) Offside server hosting. (Rent a server for x amount and we secure and backup the server.) Deployment of new Active Directories and connecting computers to active directories and setting up group Policies. (DHCP, DNS, WLAN and Active directories) Security – antivirus (MacAfee, Avast, Norton and Eset) firewalls with group policies including active directories. VMware setup, maintain and hosting. We also have special offer where you as a business can rent a server offside and be sure to never loose data. This if a guaranteed secure server with only access who is given to. Server renting options. Ry- Tec Server Hosting Types of serversTruserv tm Price Per MonthR1299 Server Specs2 TB traffic Intel Xeon E3-1230 16 GB ECC RAM 2 x 1TB SATA HDD enterprise-class disk single power supply Software RAID 1 R445 setup Trusserv tm Plus Price Per MonthR1999 Server Specs4 TB traffic Intel Xeon E5-1620 32 GB ECC RAM 2 x 1TB SATA HDD enterprise-class disk single power supply Software RAID 1 R695 setup Truserv tm Commerce Price Per MonthR3099 Server Specs6 TB traffic Intel Xeon E5-2620 64 GB ECC RAM 3 x 1TB SATA HDD enterprise-class disk dual hot swap power supply H/Ware RAID 5 (battery backup) R895 setup We do remote support from anywhere. Costing related to our special support. Costing for remote support. 0 - 15 min15 - 30 min30 min and up per hour R62.50R125.00R250 Travel and call out Call out Distance1-10 km out10 to 20 km20 to 3030 and up Cost for travelR50R100R150R200 0 - 15 min15 - 30 min30 min and up per hour R62.50R125.00R250 We also offer SLA's on month to month bases and also half year and year contracts. SLA Contract cost. Special SLA PackagesMonth to month6 month contract1 year Contract CostingR1600.00R1400.00 per monthR1200.00 per month What is included 4 hour onside support every week 1 hour. Normally for backups and check is network and desktops is running smoof. There is also a contract for once off 1 year support R12000 once off for one year support. Please keep in mind all specials have one hour onside support per week. All other support will be R250 per hour. All hardware and software (licensing) will be at additional Cost. So this is a short idea of what we offer. Our motto for this business is not to get rich and charge a lot. We try to build relationships with every company and end user. That includes making everyone a part of the company and also to make sure you as end user end up being happy with our support. Feel free to contact us. Tel: 021 987 0479 Cell: 072 066 6819 Email: rytecits@gmail.com

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