Full-Time Senior SQL Developer (EHC437)
Senior SQL Developer
Mount Edgecombe, Kzn
Bachelor’s Degree/ Diploma or IT Related Degree equivalent e.g. MCSE – Database and Business Intelligence
5+ Years hands-on experience with Microsoft SQL 2016 in an enterprise and/or Data Centre Environment.
Knowledge & Experience in working with Cloud Data would be an advantage a software development house is seeking a SQL Database Developer.
The successful candidate will be responsible for the SQL Database development and administration which will include writing efficient SQL code and optimization. A Senior SQL Developer should have the ability to reduce the time it takes to retrieve data from several seconds to just a few milliseconds. This optimization is critical for high-end databases and applications. It is also an opportunity for the successful candidate to apply their skills in a dynamic work environment while developing well-rounded competencies in the company’s products and services. The position may also expose individuals to a complete Software Development Life Cycle.
Creating complex analytic queries on large data sets
Provide technical support to and supervision of junior data administrators
Data modeling to visualize database structure
Monitoring performance and advising any necessary infrastructure changes
Generating code to extract, transform and load data
Analyse query execution plans and optimize database code
Proactively analyze and bring forth ideas for continuous improvement
Implementing ETL processes
Implement best practices in database security
Defining data retention policies
Management of customer lead data
Provision of data for advanced analytics
Maintenance of internal client scorecards
Assisting team in resolving data-related support queries
Optimize existing data processes through automation
Assist with all data-related reporting and documentation
Maintenance and optimisation of the analytics database
Continuous upskilling on new technologies, frameworks and market trends
Identifying, selecting and integrating any Big Data tools and frameworks required to provide real-time analytics.
Senior SQL Developer
Strong Experience with Database administration in SQL Server (2016) and SQL server tools
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues etc.
Experience in performance tuning, query optimization, using performance monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space, and other resource contention.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, clustering.
Expert experience in implementing operational automation
Strong knowledge of indexes, index management, integrity checks, configuration and patching
Strong knowledge of how statistics work, how indexes are stored and how they can be created and managed effectively
Extensive ability to write SQL code and design (stored procedures, functions, tables, views, triggers, indexes)
Strong skill sets in Database Administration, Database Tuning, Database Management, Database Security & Database Development
Strong knowledge and experience with database design, data migration tools, and data analysis
- Posted By: kontak
- Locaton : Mount Edgecombe, KwaZulu-Natal, South Africa
- Job Categories: Information Technology.
- Job Types: Full-Time.
- Job Tags: SQL Developer.
- Salary: 20,000 - 40,000.
Job expires in 19 days.
97 total views, 5 today
2nd Tier IT Support Engineer (EHC436) Area: Rivonia, Sandton Salary: R 18 000 to R 22000 per month We are looking for a 2nd tier IT support engineer, who will predominantly be required to complete on-site visits at client premises. Please note that the company provides outsourced IT managed services, so the primary technical requirement […]
UI Developer EHC426
UI Developer Mount Edgecombe Market Related /Negotiable We are looking for developers that are enthusiastic and looking to make a name for themselves, with an appetite to create truly awesome apps. We are a market leader in the telecommunications industry, with a focus on innovation and automation. Experience & Qualifications: A degree, diploma or equivalent […]
Jnr Android PHP Developer EHC454
JNR ANDROID PHP/SQL DEVELOPER (WITH ANDROID/IOS MOBILE APPLICATION DEVELOPMENT) (EHC454) Fourways Salary: R15 000 CTC (Note CTC is Cost to Company and includes the Company’s contributions to medical aid, Vitality, provident fund, UIF and Skills Levy) A large Insurance Underwriting Management company based in Johannesburg are currently looking for young, energetic candidates for the position […]