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

Are you a highly skilled SQL Database Administrator looking for your next challenge? We are seeking an Intermediate to Senior SQL Consultant to join our team and take ownership of SQL support contracts and projects. If you thrive in a dynamic environment and have a passion for database optimization, administration, and cutting-edge SQL technologies, we want to hear from you! Key Responsibilities: â?? SQL Database Administration, Optimization & Performance Tuning â?? Incident Management & Change Control â?? Disaster Recovery Planning & Backup Management â?? SQL Server Patch Management & Upgrades â?? Reporting Services (SSRS) & Power BI Report Development â?? Data Warehousing & Azure Data Services (Azure SQL MI, Data Factory, Synapse) â?? Always On Availability Groups & SQL Replication (Merge & Transactional) â?? Capacity Planning & Security Best Practices What Were Looking For: â??️ 7+ years SQL Server DBA experience â??️ 4+ years working with SQL 2012/2014/2016/2022 â??️ Hands-on experience with SSIS, SSAS, Power BI, and Azure SQL DB â??️ Strong knowledge of Transact-SQL, query optimization, and indexing â??️ Ability to design and implement Data Warehouses & ETL workflows â??️ Excellent problem-solving, analytical, and troubleshooting skills â??️ Willingness to travel and provide after-hours support when required Please note that only experienced candidates will be considered and contacted. Apply ONLINE now at:

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

Experience The successful incumbent must possess at least three (3) to five (5) years experience in Syspro System administration, with specific reference to month and year ends, security and permissions. Formal qualifications A bachelors degree in IT or any other relevant field Syspro certification High proficiency in Microsoft Projects Fluent in English Valid driving license code 08 Own transport Special conditions Relocation to Klerksdorp is essential The successful incumbent must be willing to travel and to work outside of South African borders for prolonged periods of time The successful incumbent should have a valid passport Responsibilities Collaborate with Syspro during the system design and implementation stages of the new ERP system. Troubleshoot and adjust the system where the need arises. Ensure system efficiency Perform SQL database administration, including backups, user security, and maintenance. Provide end-user Syspro support and training. Regularly liaise with Syspro administrators. General administration and clerical support. Maintain thorough documentation and recordkeeping. Daily interaction with clients to determine, interpret and implement their needs and requirements and represent them in the field Assign responsibilities to team members Coaching and mentoring the team members Review deliverables and initiate corrective action if need be Inherent requirements for the position High proficiency in MS Projects Proficiency in project administration Excellent verbal and written communication skills, with the ability to convey technical information Foundational knowledge of the Syspro system Detail-oriented with a strong focus on accuracy and quality assurance Ability to work independently and collaboratively in multi-disciplinary teams to achieve project goals and milestones Strong communication skills to interact effectively with team members, stakeholders, and external partners Familiarity with relevant software tools and platforms Good problem-solving skills Reliable and dependable Analytical and logical Ethical and trustworthy Accurate reporting Strong leadership skills. Advanced experience in troubleshooting systematic problems Ability to adapt to industry trends. High level of integrity, honesty, and reliability. Exceptional customer service skills and professionalism. Shortlisted candidates will be expected to undergo psychometric testing and background screening. Applicants who fulfil the abovementioned requirements are in