JOB SEEKERS
EMPLOYERS
JOBS QUICK-SEARCH
.net
.net developer
a+
abap
account manager
accountant
admin
administrator
analyst
architect
bookkeeper
business analyst
business intelligence
c#
call centre
ccna
cisco
cloud
cobol
consultant
delphi
desktop
desktop support
developer
engineer
finance
graduate
graduates
helpdesk
internship
it manager
it support
it technician
java
java developer
junior developer
legal
linux
manager
marketing
mcse
network
network administrator
oracle
personal assistant
php
php developer
programmer
project
project administrator
project manager
receptionist
sales
sap
secretary
security
sql
support
technical support
technician
test analyst
tester
web developer
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
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:
- - - - - - - - - - - - - -
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'