To develop within a functional data-driven solution using Microsoft SQL Server as the primary platform. Experience in designing and implementing complex T-SQL queries, stored procedures, and triggers is essential. The backend implementation involves relational database architecture and integration with web-based platforms. Extensive experience in SQL Server administration, performance tuning, and troubleshooting is a critical requirement for this position. The work contains a portion of support and refactoring of existing SQL objects and processes. What you’ll do: Develop complex T-SQL queries, Stored Procedures and Triggers. Assist in the design of the relational database architecture for new development projects. Develop new / alter existing SQL objects based off a set of requirements. Troubleshoot SQL objects that fail. Support the development team in troubleshooting application performance using SQL profiler and optimizing SQL queries or tuning indexing. Service requests from business, which include changes to processes or ad hoc data requests. Develop according to set coding standards and processes. Collaborate with Business Analysts to define scope and goals, track milestones, decide priorities, and report regularly to team leaders and Business Analysts. Work with Business Analysts to identify and understand source data systems. Contribute to all phases of the SDLC process extending from requirements gathering and design to development, testing and deployment. Investigate and fix production issues. Develop and test extraction, transformation and load processes. Work in a very data driven environment and use data analysis skills to anticipate and fix bugs. Support production databases. Monitor production databases regularly or respond to any database issues by bringing down the database or taking the database offline. Monitoring or optimizing the performance, security, backup, recovery or integrity of database management systems. Your Expertise: More than 10 years development experience as a senior SQL developer in custom project development environment with multiple go live events. Relevant Microsoft Certification (SQL developer/Azure) will be beneficial. 5 years relevant experience as a purely SQL developer in a multi-tiered application development environment. Experience working with security sensitive data (beneficial). Ability to work in a team environment: Follow mentorship/provide team leader mentorship, collaborate on a common (UML) design model. A good understanding of the SDLC process, tools and techniques specifically as applied to software development methodology. Experience of the following technologies: Relational database design principles SQL Server Administration SQL OLTP development SQL Query optimization and analysis Database object design XML and JSON structures (beneficial) Basic understanding of front-end languages like HTML, CSS, JavaScript (beneficial) SQL Server Management Studio 2012 upwards SQL profiler (beneficial) Knowledge of cloud services like Azure, AWS (beneficial) Good understanding of data integrity and security best practices Hands on experience in Exception Handling and Troubleshooting slow running queries, Profiling Performance Issues (beneficial) Qualifications: Relevant tertiary qualification in either Information Technology or Computer/Engineering Sciences  Other information applicable to the opportunity: Contract position Location: Johannesburg Own transport for Occasional travel within Johannesburg and Pretoria Home office setup for remote working, with backup power as well as reliable and uninterrupted internet connection, with a minimum of 20MBps up and down Why work for us? Want to work for an organization that solves complex real-world problems with innovative software solutions? At iOCO, we believe anything is possible with modern technology, software, and development expertise. We are continuously pushing the boundaries of innovative solutions across multiple industries using an array of technologies.  You will be part of a consultancy, working with some of the most knowledgeable minds in the industry on interesting solutions across different business domains.  Our culture of continuous learning will ensure that you will have all the opportunities, tools, and support to hone and grow your craft.  By joining IOCO you will have an open invitation to developer inspiring forums. A place where you will be able to connect and learn from and with your peers by sharing ideas, experiences, practices, and solutions.  iOCO is an equal opportunity employer with an obligation to achieve its own unique EE objectives in the context of Employment Equity targets. Therefore, our employment strategy gives primary preference to previously disadvantaged individuals or groups.
