• Login Name       Password       Remember me       LOGIN LOGIN    FORGOT PASSWORD
  • REGISTER

 LOGIN WITH
 
 
 
 
 EMPLOYERS
 
 
 
 
 
 NEWSLETTER
 
 
 
 
 FOLLOW US

Intermediate SQL DatabaseAdministrator

Job Ref
274537
Job Type
Permanent
Employer Type
Recruitment Agency
Date Added 22 Jun 2017
Expiry Date 6 Aug 2017
* There have been 4 applications to this job.
* This job has been viewed 673 times.
Employer:
Datacentrix

Location:
South Africa

Salary:
Negotiable

Benefits:


Role details:
Datacentrix isan integrated, service-orientated ICT systems provider that operates across the entire informationvalue chain. The company is currently looking for an exceptional Intermediate SQL DatabaseAdministrator and this comes with a lot of pressure at times
- - - - - - - - - - - - - -
Assess and develop long-term strategic goalsfor production databases in conjunction with data owners and customers.
Work withapplication development staff to develop database architectures, coding standards, and qualityassurance policies and procedures.
Create models for new database development and/orchanges to existing ones.
Install and configure relevant network components to ensuredatabase access as well as database consistency and integrity.
Respond to and resolvedatabase access and performance issues.
Monitor database system details within thedatabase, including stored procedures and execution time, and implement efficiencyimprovements.
Design and implement redundant systems, policies, and procedures for disasterrecovery and data archiving to ensure effective protection and integrity of data assets.
Monitor, optimize and allocate physical data storage for database systems.
Plan andcoordinate data migrations between systems.
Develop, implement, and maintain change controland testing processes for modifications to databases.
Create, or support creation of,required reports in response to business user needs.
Conduct research and makerecommendations on database products, services, protocols, and standards in support of procurementand development efforts.
Perform database transaction and security audits.
Establish appropriate end-user database access control levels.
Develop routines forend-users to facilitate best practices database use.
Delegate duties and tasks within theteam
Review completed tasks to ascertain compliance with standards.
Keep up withtrends in the constantly evolving information technology industry.
Perform regular IT auditto discover areas of weaknesses and fortify them.
Customer SLA’s are key
Provide solution to any complex IT related challenges in the organization.

Enterprise Tasks

Database hardware requirements (Capacity Planning).
Benchmark, analyse and test new technologies.
SQL flavour requirements, upgrades anddowngrades (Enterprise through to Express).
Data and/or server migrations.
HighAvailability assessments and best-fit application (AOHA and Failover).
Data Warehousingsetup and capacity planning.
Backup and recovery strategies (PIT and PID).
SQLpatching and Rollup installations and planning.
Facilitate enterprise integrations with SXiand other vendors.
Develop applications for specific tasks (C++ and C#).

 
Daily Support

Evaluate new software releases and products.
Ensure regular updates, plan future rollouts.
High Availability health checks andregular failover tests.
DMV maintenance – Outdated index updates and tuning ofexisting.
SQL performance monitoring (General, Locks, Buffer) managers.
Reviewerror mails from ALL integration packages and fix code bugs and/or improvements (SSIS and customcode written).
Ensure SSAS packages executed the previous night.
Review errormails on replication errors and spot check a few instances.
Keep QA and DEV databasesup-to-date with PROD for testing.
Ensure IIS on web servers are running and isresponsive.
Deploy new/existing code and patches to running software (C++/C#).
Storage management (Log and log files that needs shrinking).
Verify SQL backups todisk.


 
 
QUALIFICATION AND EXPERIENCE
Desired Qualification:
Relevant IT Degree
Minimum Qualification:
Relevant Industry Certification

·         MCSD - Solutions Developer
·         MCPD - Professional Developer

Relevant Experience:
4-6years experience
 
If you fit this profile,please load your CV on the Datacentrix website. To view more of Datacentrix IT jobs, go to www.datacentrix.co.za and click on‘Search Jobs'




 
HOME|
INFO|