Connecting...

W1sizmyilcivc3j2l3d3dy9vbgl2zxivy3vycmvudc9wdwjsawmvchjvzhvjdglvbi9wzw9wbgvzb2x2zwqvaw1hz2vzl2jhbm5lci1kzwzhdwx0lwe0n2e3ndcxzmfiyzk3mzkwnzywytaxyzazmjc1nzi0otfizjg0yzdiztcxyjlhmzbjyme4ztnlztg0owm0odcuanbnil0swyjwiiwidgh1bwiilciyntywedqwmcmixv0

Database Administrator

Database Administrator

Job Title: Database Administrator
Location: Gauteng
Industry:
Salary: 440000.00
Reference: JN -032017-7892
Job Published: April 25, 2017 08:43

Job Description

An intelligent solutions company with strong, industry-specific expertise and core capabilities in data management, GIS, analytics and software development.
We specialise in delivering integrated, online knowledge solutions, batch and real-time data quality solutions, and a broad range of geo-spatial and analytic projects to a range of property, business to consumer, government and financial services clients.
We hire exceptional people and provide them with the environment where they can excel. Our non-corporate culture encourages flexibility, collaboration and innovation.
We pride ourselves on our core values of excellence, integrity, creativity, flexibility, impact and teamwork which are reflected in each development, project, product or service we undertake to deliver.

Qualifications
 Matric and a relevant tertiary qualification required
 BSc/MSc in Computer Science, Engineering, MIS or equivalent advantageous. Experience will be considered in lieu of a degree
 Role-related certifications preferred (e.g. MCSE, MCSD)

Experience
At least 2 years of database administration experience required, including:
 database architecture strategy development and implementation
 database performance monitoring and tuning
 management of high-availability operational databases
 Experience in performance testing, Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
 Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
 Strong Knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, clustering, database mirroring, replication
 Solid acquaintance with windows server, security delegation, SPNs, storage components
Technical skills
 Excellent database design, development and administration skills in a Microsoft SQL Server environment, including:

o Microsoft SQL Server 2014 (other DB products advantageous) including ETL, SSIS, SSRS, SSAS
o best practice database design and refactoring skills
o experience in working with very large databases (multi-terabyte)
o backup, recovery and performance tuning
o stored procedures and T-SQL
o database security
o knowledge of business intelligence and data warehousing technologies preferable
 Good verbal and written communication skills

Non-technical skills
 Ability to work well in a team as well as individually
 Ability to accurately estimate work required on tasks, prioritise work and deliver to deadlines
 Positive outlook on life, work and other people
 Attentive to detail and passionate about data
 Excited about learning, pushing technical limits and finding new solutions
 Able to think creatively outside the box

Duties

 deployment and maintenance of the MS SQL environment
 ensuring availability and performance of the Database that support the system
 implementation and release of Database changes according to agreed timescales
 improvement and maintenance of the database to include rollout and upgrades
 ensure that the necessary resources are allocated to the servers, clusters and databases to ensure high resilience and performance tuning
 monitor the database systems to ensure secure services within minimum downtime
 provide trend analysis to the team in terms of ETL, SSIS, SSRS as well as SSAS
 working with application owners to tune databases to best practices and optimise performance
 troubleshooting and assisting Software Development perform solving of MS SQL development related issues
 documentation of the processes and procedures
 Work as part of a team and provide support where required