Sql Developer

Details of the offer

Duties & Responsibilities: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 the scope and goals, track milestones, decide priorities, and report regularly to team leaders and BAs.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.Supporting production databases. Desired Experience & Qualifications:Relevant tertiary qualification in Information Technology or Computer/Engineering/Mathematical Sciences.Relevant Microsoft Certification (SQL Developer/Azure) will be beneficial.2 years of relevant experience as an Intermediate SQL Developer as part of a team in a software development environment.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 working with security-sensitive data (beneficial). Skills and Knowledge Requirements:Knowledge of security vulnerabilities and working impact on solutions.Experience of the following in Microsoft SQL Server:Relational database design principlesUnderstanding of SQL Server AdministrationSQL OLTP development, query optimization, SQL Query analysisDatabase object designXML and JSON structures (beneficial)Basic understanding of front-end languages like HTML, CSS, JavaScript is beneficial. Ability to deliver production-quality software by e.g. paying attention to detail, doing extensive unit testing, and supporting quality testing phases. Knowledge and Experience of the Following Toolsets:SQL Server Management Studio 2012 upwardsSQL profiler (beneficial)Some knowledge on cloud services like Azure, AWS (Beneficial)Good understanding of data integrity and security best practicesHands on experience in Exception Handling and TroubleshootingTroubleshooting slow running queries, Profiling Performance Issues (Beneficial) Apply now! If you possess the skills and experience required for this role, we invite you to apply and become an integral part of an innovative team.


Nominal Salary: To be agreed

Source: Whatjobs_Ppc

Requirements

Security Engineer: Digital Trust Services

Introduction: Leaders in Digital Security solutions are looking for a Security Engineer with experience in Digital Trust Services to help build, maintain, an...


From Oasis Health Services - Gauteng

Published a month ago

Senior Software Engineer

Let's Write Africa's Story Together! Old Mutual is a firm believer in the African opportunity and our diverse talent reflects this. Job Description A season...


From Old Mutual - Gauteng

Published a month ago

Data Scientist / Machine Learning Engineer

If you are a curious, creative and innovative person with a passion for challenging, meaningful work, this role is for you! This is a unique opportunity to d...


From Pillango Placements - Gauteng

Published a month ago

Data Scientist Data Engineer - Gauteng, Johannesburg

Are you based in Canada? Select your country to see jobs specific to your location. Data Scientist Data Engineer - Gauteng, JohannesburgJob Specification: Te...


From Chosen Online - Gauteng

Published a month ago

Built at: 2024-11-07T09:54:14.537Z