Senior SQL Developer (Durban)

Location: Mount Edgecombe, Durban ,Umhlanga, South Africa
Date Posted: 11-10-2017
Our client  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.

Key Responsibilities:
  •  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
  •  Analyze 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 optimization of the analytics database
  •  Continuous up skilling on new technologies, frameworks and market trends
  •  Identifying, selecting and integrating any Big Data tools and frameworks required to provide real-time analytics

Job Requirements:
  •  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
Minimum Qualifications:
  •  Matric
  •  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 Center Environment.
  •  Knowledge & Experience in working with Cloud Data would be an advantage .This Job description is not exhaustive and may be subject to change depending on business requirements. Duties, functions, hours of work and responsibilities may be changed in accordance with changing business requirements, or either the employer or the client of the employer for whom you are contracted to provide a service.
this job portal is powered by CATS