Ms access sql

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.

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

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

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  

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

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

We 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:

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

Database designer required to Design / Modify Database using MS Access & VB. Either full time or part time. Designer required to build Database in Modules. 

MS Metalworks is a professional metal work company. Specializing in the manufacture and installation of: driveway gates, swing gates, custom design security gates, balustrades, burglar bars, fencing, access control, gate motorization, With over 13 years experience, MS Metalworks produces unsurpassed quality with the finest finishes and attention to detail. Mike Strack owner and manager brings his personal skill to each project, guaranteeing a quality end product. Please call Mike on or reply via email.

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