Oracle sql

Minimum Requirements and Qualifications: Strong development experience, knowledge of OOP principals and other good practice patterns Experience with rational database management systems Experience with data query tools Experience with source code control systems Knowledge of Oracle Spatial or spatial concepts a plus Duties and Responsibilities: Develop and modify Oracle packages, stored procedures, functions and triggers and functions in PL/SQL which will be used by their systems applications. Create database tables, indexes, views, triggers and other objects in the development environment Participate in all phases of the Software Development process including design, development, testing deployment and maintenance. Maximize performance by analysing the execution plan and applying optimizers as needed. Resolve problems that arise with existing production applications to ensure the efficient and proper functioning of application components

MAIN PURPOSE The BI Data Integration Developer is responsible for developing scalable and robust data solutions for integrating data from disparate sources into an Oracle 11g Data Warehouse and Analytical Platform that will support diverse reporting and analytical capabilities. KEY OUTCOMES Give input into the impact analysis for new BI solutions (detailed development estimates, the technical feasibility of and risks associated with each solution design/project). Work with other BI team members to analyse and recommend BI solutions to meet business requirements. Give input into data integration designs. Design, develop and implement the best technique for extracting data from source systems and moving it to and through the BI system (Data Warehouse and Analytical Platform), adhering to internal architecture and data integration standards. Design, develop and implement data integration solutions that maximise re-usable components, incorporate audit, reconciliation and exception handling. Implement monitoring and measurement of data quality as defined by business rules and provides data quality metrics for Data Governance trend analysis. Adapt data integration processes to accommodate changes in source systems and new Business User requirements. Test data integration solution (unit testing and system integration testing) and verify that it meets business, functional and technical specifications. Document solutions, both technical (design, metadata) and procedural (process flows, rules) to ensure that peers understand how to support the solution. Work with production data to monitor and report on data conditions and quality. Remain current with industry trends and thought leadership on Business Intelligence, Data Warehousing, BI architecture and BI technologies. Establish effective and collaborative partnerships within the BI Team as well as with relevant IT teams, particularly BI source system teams. FUNCTIONAL COMPETENCIES In depth knowledge of Data Warehousing, Data Management and BI/Data Integration best practices In depth knowledge of BI environments, solutions and implementations (end-to-end BI architecture and technologies) Extensive knowledge of software engineering and development processes and is an expert in the field of data integration (ETL and OLAP) tools Extensive knowledge and experience in maintainability, scalability and performance of BI environments Able to create re-usable code and apply standards and best practices to that code Good written and verbal communication skills Disciplined in applying BI standards but open to suggestion and change MINIMUM QUALIFICATION Relevant 3 year tertiary or NQF aligned qualification. EXPERIENCE REQUIRED Minimum 5 years’ experience in Oracle PL/SQL. Relevant experience in a retail business would be an advantage. Proven track record of delivering BI technical solutions on large, enterprise BI projects Proven application of Data Warehousing and BI best practices Proven track record of implementing innovative BI solutions leading to clear business benefits SALARY: R360K - R420K p.a. LOCATION: Cape Town JOB TYPE: Contract (6 months)

Terms 6 month Contract Duties and Responsibilities Give input into the impact analysis for new BI solutions (detailed development estimates, the technical feasibility of and risks associated with each solution design/project). Work with other BI team members to analyse and recommend BI solutions to meet business requirements. Give input into data integration designs. Design, develop and implement the best technique for extracting data from source systems and moving it to and through the BI system (Data Warehouse and Analytical Platform), adhering to internal architecture and data integration standards. Design, develop and implement data integration solutions that maximise re-usable components, incorporate audit, reconciliation and exception handling. Implement monitoring and measurement of data quality as defined by business rules and provides data quality metrics for Data Governance trend analysis. Adapt data integration processes to accommodate changes in source systems and new Business User requirements. Test data integration solution (unit testing and system integration testing) and verify that it meets business, functional and technical specifications. Document solutions, both technical (design, metadata) and procedural (process flows, rules) to ensure that peers understand how to support the solution. Work with production data to monitor and report on data conditions and quality. Remain current with industry trends and thought leadership on Business Intelligence, Data Warehousing, BI architecture and BI technologies. Establish effective and collaborative partnerships within the BI Team as well as with relevant IT teams, particularly BI source system teams. Competencies In depth knowledge of Data Warehousing, Data Management and BI/Data Integration best practices In depth knowledge of BI environments, solutions and implementations (end-to-end BI architecture and technologies) Extensive knowledge of software engineering and development processes and is an expert in the field of data integration (ETL and OLAP) tools Extensive knowledge and experience in maintainability, scalability and performance of BI environments Able to create re-usable code and apply standards and best practices to that code Disciplined in applying BI standards but open to suggestion and change Qualifications and Experience Relevant 3 year tertiary or NQF aligned qualification. Minimum 5 years’ experience in Oracle PL/SQL. Relevant experience in a retail business would be an advantage. Proven track record of delivering BI technical solutions on large, enterprise BI projects Proven application of Data Warehousing and BI best practices Proven track record of implementing innovative BI solutions leading to clear business benefits Please note: Only shortlisted candidates will be contacted. Send your updated CV to info@acsrecruitment.co.za or visit our website at www.acsrecruitment.co.za

Requirements: Diploma/Degree in Computer Science or equivalent experience 7 years’ working in as a SQL / Oracle Database administrator 3 years Microsoft SQL Server Administration (including installation & configuration, Data Replication, DTS/SSIS, Log Shipping, clustering, DB Mirroring) 3 years Oracle database management. Duties: Maintaining a Microsoft SQL Server ORACLE(Database Administration and maintenance including ORACLE spatial components Database Administration through the following environments: development, Testing, QA, Pilot training, Production and Disaster recovery environments Managing Data Replication Disaster Recovery(Backup, Restore, Log-Shipping) Quality Assurance Systems Analyst and Developer Support Performance Tuning ication(Including Replication through firewalls and Replications To ORACLE) Integration, Analysis Services/DTS SQL Scheduled Jobs, SQL Server Clustering Data warehousing Troubleshooting, Debugging and problem solving skills, Database development quality assurance, Enterprise DataS project Modeling In depth knowledge of; Oracle SQL Server

We currently have a position for a Senior Mobility Developer at one of our biggest client. we need someone who will be available in 2 weeks. contract period = 8 months The scope of work is as follows: The Mobility Developer is responsible for the design, development and support of the Customer mobile application solution landscape. Provide specialist application development, support and maintenance services related to enterprise mobility that enable business to effectively and efficiently deliver on their mandate in accordance with Group IT’s strategy and service offering. 2. Shortlisting and Elimination Criteria Senior Developer: 3+ years relevant experience Proficient in: Objective-C, C++, Java, PHP, xHTML, HTML5, CSS, Javascript, Javascript libraries such as JQuery, AJAX and related technologies,.NET, Boostrap, AngularJS, PhoneGap/Cordova, XML, SOAP, JSON, RESTful service APIs, MSSQL, Oracle SQL, MySQL APi Design and SOAP and REST Web Services/SOA (producer and consumer) Analysis and Design of Modular Application and Database Components IOS, Windows and Android SDK’s a. Shortlisting candidate Digital/ User Experience Designer Mobility Developer - Intermediate Requirement Three year qualification or four years IT Experience Three years Mobility project Experience Two Years Mobile App Development If you know you meet the scope above kindly forward your CV to oscarm@sageinformatics.co.za and copy PerryK@sageinformatics.co.za For more information based on this position contact Perry Kruger on 011 466 2760. If you don't hear from us two weeks after profile submission consider application unsuccessful.

To apply for this job, please forward your updated CV to it.jobs@tumaini.co.za A leading digital agency based in Johannesburg is looking for a Java Web Developer. Responsibilities: • Responsible for Java/J2EE/J2SE application development supporting business objectives while providing expertise in software development lifecycle phases from concept and design to testing. • Analyses, designs and builds component-based applications in a Web/internet delivery environment, including introduction of an application layer, modelling techniques, component and object-oriented design, complex algorithmic coding, and systematic approaches to application integration. • Works on new and existing applications along with enhancements web sites, web applications, and infrastructure. • Performs hands-on coding, mentor’s junior developers and assists in architecting web content solutions. • Serves as liaison to internal customers, research groups and various business support areas. • Expertise in server-side web presentation technologies. Qualifications and Experience: • A Bachelor’s Degree in Computer Science, Mathematics, Engineering or related discipline is required, or equivalent work experience and technical training. • 5 or more years of Java experience managing application design, software development, maintenance and delivery with at least 2 years with application servers; e.g. Oracle 8i/9i/10g/11i Application Server; SQL Server; J2EE Application Server; JBoss, IBM Websphere, Tomcat, or BEA Weblogic; Apache. • Minimum of 3 years technical work experience in a team environment as a programmer. • Strong experience with Web architecture and Web design and development tools and languages, e.g. JSP, JDBC, Java Servlets, JavaBeans/EJBs, ASP, VB Script, SQL, Perl, UNIX, C++, CORBA, JavaScript, SOAP, XML/XSLT/FOP, HTML, Struts, ANT, CVS, CMP, WebLogic. • Strong relational database experience (DB2, Sybase, SQL, Oracle 8i/9i/10g/11i). Strong background working in distributed UNIX environments. • Experience designing N-tiered applications, with multi-tier architecture and production Internet architectures. • Strong experience developing and implementing highly complex technical solutions in a J2EE web environment. • Superior organizational and time management skills. • Excellent written and verbal communication skills Should you meet the requirements for this position, please email your CV to it.jobs@tumaini.co.za. You can also contact Megan on 031 350 4018 Correspondence will only be conducted with short listed candidates. Should you not hear from us within 3 days, please consider your application unsuccessful.

Mandatory requirements in Software knowledge and skills: · Microsoft Windows forms programming in VB.Net Frameworks (1.1 -3.5) · Visual Studio 2010 · Team Foundation Server · Visual Source Safe 6.0 · DEV Express 7.2 Components · Oracle 1Og, 11g and XE Databases · Oracle PL/SQL · Toad or equivalent tool · Web Services (Create and Consume) · Microsoft Message Queue · Internet Information Server (liS) · Oracle Data Provider for.NET · WinDebug for memory profiling and optimisation Please review the link provided for further information on the role: http://www.pcrecruiter.net/pcrbin/regmenu.aspx?uid=dlk%20group.dlkgroup

Mandatory requirements in Software knowledge and skills: Microsoft Windows forms programming in VB.Net Frameworks (1.1 -3.5) Visual Studio 2010 Team Foundation Server Visual Source Safe 6.0 DEV Express 7.2 Components Oracle 1Og, 11g and XE Databases Oracle PL/SQL Toad or equivalent tool Web Services (Create and Consume) Microsoft Message Queue Internet Information Server (liS) Oracle Data Provider for.NET WinDebug for memory profiling and optimisation Responsibilities/ Duties: Quality assurance of the products developed in response to the User Requirement Document. This includes Application Testing to ensure that the application meets the requirement and is of suitable form fit and function; Provide technical assistance and direction to sub-ordinates; Provide training and skills transfer to permanent and contract staff as required; Perform Technical Assessments of proposed third party and in-house sofiware solutions Please review the link provided for further information on the role: https://www.pcrecruiter.net/pcrbin/pcrnf.asp?uid=odbc.dlkgroup

An exciting new career opportunity is available in Johannesburg for a BI Specialist. Responsibilities: · Applies broad knowledge of technology options, technology platforms, design techniques, and approaches across the data warehouse life cycle phases to design an integrated solution to address business requirements. · Meets and collaborates with business users on requirements, objectives, and measures. · Designs the technology infrastructure across all technical environments. · Ensures completeness and compatibility of the technical infrastructure to support system performance, availability, and architecture requirements. · Designs and plans for the integration for all data warehouse technical components. · Supervises the technical implementation of the data warehouse and oversees hardware/software configuration. Reviews technical work of other team members. · Reviews and participates in testing of the data design, tool design, data extracts, networks, and hardware selections. · Optimizations, support and maintenance of the data warehouse environment. Qualifications and Experience: · BSc in Computer Science or Engineering or a related degree · 5+ years’ experience in data warehouse technical architecture, infrastructure components, ETL and analytical tools. · Qlikview Development and Design · Design and implementation of data warehouse environment. · Experience with Oracle and Microsoft preferred. · Deep understanding of data warehouse principles and implementation • Deep understanding of either MS SQL Server or Oracle (preferably both) • ETL processes, data warehouse modelling, cube development • Business Analysis • Analytical, conceptual, problem-solving and solution driven Interested candidates can forward their comprehensive written applications to the following e-mail: or fax to: , you can also contact Sharne on . Correspondence will only be conducted with short listed candidates. Should you not hear from us within 3 working days after the closing date, please consider your application unsuccessful.

An exciting new career opportunity is available in Cape Town for a BI Specialist. Responsibilities: · Applies broad knowledge of technology options, technology platforms, design techniques, and approaches across the data warehouse life cycle phases to design an integrated solution to address business requirements. · Meets and collaborates with business users on requirements, objectives, and measures. Designs the technology infrastructure across all technical environments. · Ensures completeness and compatibility of the technical infrastructure to support system performance, availability, and architecture requirements. · Designs and plans for the integration for all data warehouse technical components. · Supervises the technical implementation of the data warehouse and oversees hardware/software configuration. Reviews technical work of other team members. · Reviews and participates in testing of the data design, tool design, data extracts, networks, and hardware selections. · Optimizations, support and maintenance of the data warehouse environment. Qualifications and Experience: · BSc in Computer Science or Engineering or a related degree · 5+ years’ experience in data warehouse technical architecture, infrastructure components, ETL and analytical tools. · Qlikview Development and Design · Design and implementation of data warehouse environment. · Experience with Oracle and Microsoft preferred. · Deep understanding of data warehouse principles and implementation • Deep understanding of either MS SQL Server or Oracle (preferably both) • ETL processes, data warehouse modelling, cube development • Business Analysis • Analytical, conceptual, problem-solving and solution driven Interested candidates can forward their comprehensive written applications to the following e-mail: it.jobs@hireresolve.co.za or fax to: 086 600 7977, you can also contact Sharne on 011 807 8064. Correspondence will only be conducted with short listed candidates. Should you not hear from us within 3 working days after the closing date, please consider your application unsuccessful.

An exciting new career opportunity is available in Johannesburg for a BI Specialist. Responsibilities: · Applies broad knowledge of technology options, technology platforms, design techniques, and approaches across the data warehouse life cycle phases to design an integrated solution to address business requirements. · Meets and collaborates with business users on requirements, objectives, and measures. Designs the technology infrastructure across all technical environments. · Ensures completeness and compatibility of the technical infrastructure to support system performance, availability, and architecture requirements. · Designs and plans for the integration for all data warehouse technical components. · Supervises the technical implementation of the data warehouse and oversees hardware/software configuration. Reviews technical work of other team members. · Reviews and participates in testing of the data design, tool design, data extracts, networks, and hardware selections. · Optimizations, support and maintenance of the data warehouse environment. Qualifications and Experience: · BSc in Computer Science or Engineering or a related degree · 5+ years’ experience in data warehouse technical architecture, infrastructure components, ETL and analytical tools. · Qlikview Development and Design · Design and implementation of data warehouse environment. · Experience with Oracle and Microsoft preferred. · Deep understanding of data warehouse principles and implementation • Deep understanding of either MS SQL Server or Oracle (preferably both) • ETL processes, data warehouse modelling, cube development • Business Analysis • Analytical, conceptual, problem-solving and solution driven Interested candidates can forward their comprehensive written applications to the following e-mail: it.jobs(at)hireresolve.co.za or fax to: 086 600 7977, you can also contact Sharne on 011 807 8064 Correspondence will only be conducted with short listed candidates. Should you not hear from us within 3 working days after the closing date, please consider your application unsuccessful.

Duties and Responsibilities Give input into the impact analysis for new BI solutions (detailed development estimates, the technical feasibility of and risks associated with each solution design/project). Work with other BI team members to analyse and recommend BI solutions to meet business requirements. Give input into data integration designs. Design, develop and implement the best technique for extracting data from source systems and moving it to and through the BI system (Data Warehouse and Analytical Platform), adhering to internal architecture and data integration standards. Design, develop and implement data integration solutions that maximise re-usable components, incorporate audit, reconciliation and exception handling. Implement monitoring and measurement of data quality as defined by business rules and provides data quality metrics for Data Governance trend analysis. Adapt data integration processes to accommodate changes in source systems and new Business User requirements. Test data integration solution (unit testing and system integration testing) and verify that it meets business, functional and technical specifications. Document solutions, both technical (design, metadata) and procedural (process flows, rules) to ensure that peers understand how to support the solution. Work with production data to monitor and report on data conditions and quality. Remain current with industry trends and thought leadership on Business Intelligence, Data Warehousing, BI architecture and BI technologies. Establish effective and collaborative partnerships within the BI Team as well as with relevant IT teams, particularly BI source system teams. Competencies In depth knowledge of Data Warehousing, Data Management and BI/Data Integration best practices In depth knowledge of BI environments, solutions and implementations (end-to-end BI architecture and technologies) Extensive knowledge of software engineering and development processes and is an expert in the field of data integration (ETL and OLAP) tools Extensive knowledge and experience in maintainability, scalability and performance of BI environments Able to create re-usable code and apply standards and best practices to that code Good written and verbal communication skills Disciplined in applying BI standards but open to suggestion and change Qualifications and Experience Relevant 3 year tertiary or NQF aligned qualification. Minimum 5 years’ experience in Oracle PL/SQL. Relevant experience in a retail business would be an advantage. Proven track record of delivering BI technical solutions on large, enterprise BI projects Proven application of Data Warehousing and BI best practices Proven track record of implementing innovative BI solutions leading to clear business benefits Please note: Only shortlisted candidates will be contacted. Send your updated CV to info@acsrecruitment.co.za or visit our website at www.acsrecruitment.co.za