Sql database administrator

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.

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

Description The purpose of the Database Administrator role is to perform installation, configuration, customisation, creation, implementation and support of the Oracle databases. Whist maintaining and administering databases to ensure client database performance is optimized Education & Qualification OCP Relevant Experience 2-5 years Database administration experience Solid Linux skills Ability to troubleshoot Solid understanding of Oracle databases. Good knowledge of operating system(s). Knowledge and practice of Oracle backup and recovery scenarios. Ability to install and administer databases. Understands how objects in a db works

Urgently looking for a Database Administrator certified in SharePoint with 5 years experience. email CV and Certificates to hlengiwemfondo@gmail.com

Purpose of this role: Responsible for the proactive monitoring of Oracle/ SQL databases in the Midrange environment and performs tier 1 and 2 diagnosis on incidents. Qualifications and Experience: 3 year Diploma/ Degree in a relevant discipline/ NQF level 5. 3-5 years Oracle/ SQL DBA Computer Operations or Application Technical competencies description: Knowledge of Oracle/ SQL I.T hardware and software Database administration Client focus How to apply: Kindly send us your CV to maggie(at)resourceplus(dot)co(dot)za

Brief overview  The SQL database environment is growing rapidly and requires increased focused attention to service project requirements, implement requests, resolve issues and incidents, as well as perform the necessary maintenance; Personal development and continuous learning are very important in this area and you will be expected to stay abreast of technical development in the SQL Server database environment. Your day to day office tasks:   You will be responsible for the definition, creation and maintenance of Client application database structures; Analysing, testing, and implementing physical database designs supporting business applications; Ensuring data recoverability, database availability, data integrity, agreed level of performance and capacity planning for physical databases; SQL Server DBMS installation, configuration and overall management; Documentation and MIS collection for the assigned application area databases; Researching and development of technical area assigned to you; Escalation of issues, incidents and risks to management when they arise; Setup and coordinate client application area interaction on a regular basis; Ensuring that maintenance plans and documentation are in place, re-visited and updated at least once quarterly or after changes impacting the application area; DBA process refinement; DBA reporting to DBA management; Participation in team stand-by activities, every 4th week after initial training period. Job Requirements 'Must have' Qualifications and experience: At least three years DBA working experience; Experience needs to include all disciplines of DBA work i.e. Administration, performance tuning, security, backup and recovery etc.; Microsoft SQL Server Database certification. DBMS Knowledge that you will need: • Sound working knowledge of System Architecture and IT Components; • An in-depth knowledge of database concepts; • Detailed understanding of SQL Server and ; • Working knowledge and understanding of SQL ; • Basic knowledge of underlying operating systems the DB resides on; • Knowledge and understanding of all available products, services and resources in the SQL Server suite of    products. Lastly you will need to show why you are a good team fit to the company and successfully complete the ITISS DBMS technical proficiency assessment.  

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

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  

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

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.

DBA Date: October Location: Durban Employment Type: Permanent Salary Offer: R- R (Experience and Negotiable) Description of role: The purpose of the Database Administrator role is to perform installation, configuration, customization, creation, implementation and support of the Oracle databases. Whist maintaining and administering databases to ensure client database performance is optimized. Qualifications and Experience: • OCP Relevant Experience: • 2-5 years Database administration experience • Solid Linux skills • Ability to troubleshoot • Solid understanding of Oracle databases. • Good knowledge of operating system(s). • Knowledge and practice of Oracle backup and recovery scenarios. • Ability to install and administer databases. • Understands how objects in a db works JOB OUTPUTS & REQUIREMENTS: • Resolves alerts generated by Gauge timeously and within an acceptable timeframe. • Creates and maintains all databases required for development and production sites. • Performs the capacity planning required to create and maintain databases, working closely with the system administrators as and when required. • Monitors and optimizes the performance of the database by performing ongoing performance health checks to ensure the achievement of performance goals. • Troubleshoots database problems as and when needed. This may include interfacing with 3rd party vendors, clients and other internal staff to track down and solve performance problems. • Maintains strict administration of database security at all times. • Scheduling and execution of database file back-ups. • Creation of ad hoc queries and reports as required by users. • Configures database servers • Evaluates new database tools by testing and recommending new database software and tools to management. • Designs and tests new database components – Including development of input/output requirements, tables and reports. • Migrates application upgrades from the development server to the production server. • Establishes standards and schedules for database backups. • Develops recovery procedures for all databases.

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

Intermediate SQL Developer Woodstock At Nu Beginnings we are dedicated Career Specialists. This means that we are devoted to assisting our aspirants with their desired career growth. Exciting opportunities are readily available with our vast client base! More so, we believe in you and we work hard to get you your dream job interview! We pride ourselves on the strong relationships we keep with our aspirants and clients. Send us an email with your information and realise the difference between having your career managed properly and being applying for any old vacancy. What you will need:   ·         Matric and preferably an ICT relevant diploma or degree from a recognised tertiary institution ·         Appropriate Microsoft technical certifications are beneficial ·         3+ years valid and strong work experience in a similar role ·         Have a Drivers' License and a willingness to travel ·        .Net and C# Development experience ·         Python knowledge beneficial What you will be doing:   ·         Develop and modify complex SQL queries, SSIS packages and stored procedures to meet business requirements ·         Ensure standardization of SQL/SSIS coding practices and adherence to coding standards, change control, and SQL best practices ·         Perform problem resolution and root cause analysis along with recommending and implementing preventative techniques ·         Ensure operational database and integration systems are functioning within specification and provide optimisation where necessary ·         Perform tests and produce results to ensure accurate compliance with project requirements ·         Manage priorities across design and development activities as well as defect resolution ·         Interact with technical and business stakeholders to, create solutions and solve problems collaboratively ·         Assist in data analysis and data modelling where required Package:    Salary up to R per month CTC   For more information, send your CV to Laura  NOW to book your interview (email subject line: SQLDev)  

Duties: Develop and maintain software Document software Test software Develop unit tests Responsibilities include: Building Strategic Working relationships   Behaviour: Displays Company Values Managing Work (includes Time Management) Contributing to Team Success through the Company Values Quality orientation Continuous learning and improvement Required Qualifications: Relevant degree or diploma (ie; BSC Comp Sci or NDip IT) or at least 5 years solid software development experience Required Skills: Problem solving skills Strong technical and troubleshooting skills 3 years + SQL Server database development experience Database Design and Development C#.Net would be an advantage