Ms access sql data

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

My client is an exciting, fast growing company based in Lynnwood, Pretoria and they are currently recruiting for a MS SQL Report Developer. Main responsibilities will be to maintain, design and implement Reports as well as ad-hoc data retrievals, with the integration of databases. This includes selecting, gathering requirements, designing, and rolling out Report solutions to end users. This development projects are implemented within the current Microsoft platform.Minimum Requirements* Grade 12*An IT related qualification and at least 3 years’ experience in Report Development and SQL database support.MS SQL Server or later* Good understanding of relational database design, structures, theories, principles and practices* Excellent T-SQL skills including Stored Procedures, Views and FunctionsMS SQL Server Reporting Services or later* Knowledge of tables, Matrices, drill-down and drill-through capabilities and overall usage of expressions within various report properties/objects.Ideal: MCSA SQL Server and MCSE: Business Intelligence certification or similarJob ResponsibilitiesRequirements gathering of Report Specifications from internal users.Deployment of new Reports and maintenance of existing.Interact and communicate positively with all levels of staff and with the customer and end users.Track tasks and deliver on deadline dates.Prioritise and execute tasks in a high-pressure environment.Salary: R - RpmSend CVs to

IT qualified candidate – Degree/Diploma, with 2 years SQL database administration experience required to assist with the performance, integrity and security of the database. Minimum requirements: IT Degree/Diploma essential MCDBA or MCITP highly advantageous Minimum 2years DBA experience essential MS SQL Server and R competent T-SQL Scripting, SQL replication and exporting & importing of data essential Ability to create MS SQL Logins and string knowledge of Database Security essential SSIS, SSRS and Analysis Services experience beneficial Responsibilities: Database administration Improve business efficiency If you are a SA citizen and your CV meets the above requirements, please respond via email to   Recognising that diversity is key to excellence, our client especially encourages members of designated groups to apply.   If you have not heard from us within a 2 week period, please deem your application as unsuccessful.

Position: SQL/.Net developer Salary: R Highly Negotiable depending on experience Position Overview: Working under the guidance of the Strategic Information specialist, the.Net developer is responsible for designing, modifying, developing and writing software programming applications and components. This position will also be responsible for data transformation and import/export from a variety of sources.  Key responsibilities: Utilize established development tools, guidelines and conventions including but not limited to: ASP.NET, SQL Server, HTML, CSS, Javascript and C#/VB.NET and ensure that all work performed and decisions made have taken all the technical guidelines into consideration. Design, code, unit test and document windows and web software applications Create technical specifications and test plans Work on solving incoherencies in the detailed technical specifications and ask for or propose changes Write code or paramenters to provide software components according to technical specifications Maintain existing software systems by identifying and correcting software defects Maintain and optimise source code Escalate live errors and service problems to the relvent stakeholders to limit downtime and resolve the problems immediatley Rollout/publish to QA and production environment, ensuring back-up/rollback ability Database development and design Development of stored procedures, functions and views Database administration Data transformation Data import and export Qualifications: Software development orientated 3/4 year degree or equivalent (e.g. B.Com Information Systems or BSc Comp Science or Elec Eng) 3 - 5 years’ formal experience in developing software Skilled in.Net programming in Visual Studio , ASP.NET, MVC, WCF or Web API, REST or SOAP API web services and SQL Strong Database skills (Microsoft SQL ) Advanced Access and Excel Proficiency in HTML,JQuery, CSS, AJAX and Javascript Working knowledge of OO design and common design patterns Working knowledge of Windows server and IIS platform Familiarity with Agile engineering practices Strong numerical/statistical/mathematical aptitude Experienced in driving projects from start to finish. Ability to successfully train and make presentation to clients and colleagues Ability to manage multiple projects with minimal supervision, is a team player and a self-starter  Outgoing professional personality with good technical documentation, written and oral communication skills

Position Overview: Working under the guidance of the Strategic Information specialist, the.Net developer is responsible for designing, modifying, developing and writing software programming applications and components. This position will also be responsible for data transformation and import/export from a variety of sources.  Key responsibilities: Utilize established development tools, guidelines and conventions including but not limited to: ASP.NET, SQL Server, HTML, CSS, Javascript and C#/VB.NET and ensure that all work performed and decisions made have taken all the technical guidelines into consideration. Design, code, unit test and document windows and web software applications Create technical specifications and test plans Work on solving incoherencies in the detailed technical specifications and ask for or propose changes Write code or paramenters to provide software components according to technical specifications Maintain existing software systems by identifying and correcting software defects Maintain and optimise source code Escalate live errors and service problems to the relvent stakeholders to limit downtime and resolve the problems immediatley Rollout/publish to QA and production environment, ensuring back-up/rollback ability Database development and design Development of stored procedures, functions and views Database administration Data transformation Data import and export Qualifications: Software development orientated 3/4 year degree or equivalent (e.g. B.Com Information Systems or BSc Comp Science or Elec Eng) 3 - 5 years’ formal experience in developing software Skilled in.Net programming in Visual Studio , ASP.NET, MVC, WCF or Web API, REST or SOAP API web services and SQL Strong Database skills (Microsoft SQL ) Advanced Access and Excel Proficiency in HTML,JQuery, CSS, AJAX and Javascript Working knowledge of OO design and common design patterns Working knowledge of Windows server and IIS platform Familiarity with Agile engineering practices Strong numerical/statistical/mathematical aptitude Experienced in driving projects from start to finish. Ability to successfully train and make presentation to clients and colleagues Ability to manage multiple projects with minimal supervision, is a team player and a self-starter  Outgoing professional personality with good technical documentation, written and oral communication skills  

Are you looking to enhance your development career? Are you tired of too much red tape and looking to take sole responsibility for your own solutions….look no more! This Nationally based company is looking for a hard working yet sharp Access Consultant who can hop on board and start implementing solutions from scratch. If your passion is development and solutions is your game, then don’t hesitate and apply now!! Qualification:NDip in IT2 years relevant experience Skills & Experience: Excel VBAAccessMySQL/MS SQL Job Description:Designing, Implementing and building systemsAbility to work independently Are you looking to enhance your development career? Are you tired of too much red tape and looking to take sole responsibility for your own solutions….look no more! This Nationally based company is looking for a hard working yet sharp Access Consultant who can hop on board and start implementing solutions from scratch. If your passion is development and solutions is your game, then don’t hesitate and apply now!! Please apply directly, by clicking on the apply button or visit www.communicate.co.za for more exciting IT jobs.If you have not had any response in two weeks, please consider your application unsuccessful. Your profile will be kept on our database for any other suitable roles / positions.We also invite you to contact us to discuss other exciting career opportunities in our niche area!For more information please call , Kim Ryan, quoting the ref: CIT or email your CV to

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.

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

We are looking for a Report Writer for a large Government Organisation in Johannesburg. Applicant must have the following: · A recognized Grade 12 certificate plus · A three (3) year tertiary qualification plus · A “Computer” qualification obtained at an acknowledged tertiary institution or equivalent experience. · Advance SQL Query Skills, OLTP and OLAP. · Proficiency in designing MS Visual Studio, VB.NET, Data collecting Web parts for share point server · Proficiency in data and business analysis techniques including process modelling, data collection, graphical and statistical analysis. · Awareness of database design concepts and SQL Reporting Services in particular. · Proficiency in MS Excel, Business Intelligence and statistical analysis tools such as ProClarity and Pivot tables. · Proficiency in MS Word, MS Powerpoint and MS Access. BASIC SALARY: R per annum plus benefits Please reply with cv only if you meet the requirments.

We are looking for a Report Writer for a large Government Organisation in Johannesburg. Applicant must have the following: · A recognized Grade 12 certificate plus · A three (3) year tertiary qualification plus · A “Computer” qualification obtained at an acknowledged tertiary institution or equivalent experience. · Advance SQL Query Skills, OLTP and OLAP. · Proficiency in designing MS Visual Studio, VB.NET, Data collecting Web parts for share point server · Proficiency in data and business analysis techniques including process modelling, data collection, graphical and statistical analysis. · Awareness of database design concepts and SQL Reporting Services in particular. · Proficiency in MS Excel, Business Intelligence and statistical analysis tools such as ProClarity and Pivot tables. · Proficiency in MS Word, MS Powerpoint and MS Access. BASIC SALARY: R per annum plus benefits

Overview: Manage a team of Health Informatics Technical Assistance Officers who provide technical assistance in the form of mentorship, training and implementation in order to assist the Department of Health (DoH) to improve the quality and integrity of information reported. In addition, the Team Lead will provide Technical Assistance to Provincial and District Management teams.   Key Responsibilities: Assign, monitor and co-ordinate the work of team members Manage team performance Train, coach and mentor team Create detailed functional tactical plans to meet the teams objectives Gather facility/site data to inform team solutions Translate and consolidate data into information and present to relevant stakeholders Direct the implementation of the tactical work plan at activity level Identify issues and or deviations from the plan and escalate accordingly Provide Technical Assistance to Province and District Management teams to support M&E and HI processes including the collection, collation, validation and reporting of data usage at facility level Impact measurement and reporting Stakeholder engagement Ensure data quality and integrity   Qualifications: Information Technology/Healthcare Degree or Diploma 5 years experience in a data/information technology role 2 years experience in managing people Advanced database skills, specifically SQL and MS Access Experience in facilitation and mentoring Project Management Send a detailed CV to:

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

We are urgently looking for a Java Developer to start ASAP. Positions in based in JHB Northern area. We are only looking for SA Citizens. You will be require to write client and server-side code for web-based applications, create robust production applications, and develop prototypes quickly. Also to collaborate on scalability issues involving access to massive amounts of data and information. TECHNICAL SKILLS: • Java EE • Flex • Basic SQL (PostgreSQL) • Eclipse IDE • Linux • Hibernate • JDBC • REST Interviews are being conducted starting this week already. Please send you CV urgently in MS Word Format. We are also looking for iOS and C# Developers for other clients, please contact us in this regard for further information.

Senior Tax Associate Location: Sunninghill, Johannesburg Purpose of the Role: Tax focuses on assisting corporates and individuals to control and minimise their tax burden, helping clients with compliance issues, and providing advice on HR-related issues and the tax implications thereof. Requirements: Degree in BCom Informatics or equivalent 2- 3 years of relevant technology experience Experience with Indirect Tax (VAT) and accounting will be beneficial Dynamic individual to fulfil an integral role in developing the indirect tax technology practice Demonstrates individual initiative in contributing to the development of the practice Ability to take ownership of projects and produce a high-standard deliverable Profound numerical & analytical skills and a technical mind, well organised, solution driven, ability to multi-task and good attention to detail Good communication & interpersonal skills Team player with ability to work autonomously in a customer-driven and results oriented environment Excellent English language skills (oral and in writing) Working knowledge of common software applications (MS Office/Lotus Notes, PowerPoint & Excel) Ability to understand and interpret the structure and relationships within large data sets Working knowledge of SQL, ACL, Qlikview, Qliksense as well as various ERP systems and other analytical software will be beneficial Duties: Assist with indirect tax technology projects within the TPC (Technology Processes and Controls) team Process data and information by applying technology skills Extract data from ERP systems Perform data analysis Interpret and understand ERP system data, which includes understanding databases and their relationships within various ERP systems, eg. SAP and Oracle Develop software tools for data analytics and reporting Apply indirect tax (VAT) and accounting skills Assist with client proposals, demonstrations and presentations Involved in various tasks associated with practice development Developing client relationships Ensure project deadlines and budgets are met Managing billings, debtors and assignment budgeting Complying with risk management procedures

Candidates must currently be Cape Town based. Responsibilities Design and document database architecture Design Data Warehousing and Business Intelligence platform Build database scheme, tables, procedures and permissions Develop database utilities and automated reporting Create shell scripts for task automation Create, test and execute data management languages Analyse, consolidate and tune database for optimal efficiency Analyse and sustain capacity and performance requirements Monitor systems and platforms for availability Restore and recover corrupted databases Install and test corrupted databases Install and test upgrades and patches Implement security and encryption Evaluate and recommend new databases technologies storage, archiving, backup and recovery procedures are functioning correctly Monitor access and security Assist database architect where required Ensure that DB systems are functioning correctly and meeting the company’s clients needs Qualifications, Experience & Skills Matric MCDBA or MCITP (Microsoft qualification) 2-years SQL Database administration in a highly pressurized environment Extensive use of Standard Query Language SQL, T-SQL,, MSSQL (2000, 2005, 2008 R2, 2014) SSIS, SSRS and Analysis Services experience Advantageous: - Programming knowledge - Project Management - Resource Management - Network Knowledge - OS Admin Knowledge Other Requirements Eager to learn Have a high attention to detail Be able to work independently as well as be a team player Be result and deadline driven Work well under pressure Have excellent communication and interpersonal skills, both oral and written Be able to take ownership of problems and co-ordinate to resolution Be able to prioritise and manage multiple tasks Be available for 24hr Standby (should it be required)