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
Senior Database Administrator
Job Ref
274533
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 6 applications to this job.
* This job has been viewed 1802 times.
Employer:
Datacentrix
Location:
South Africa
Salary:
Negotiable
Benefits:
Role details:
- - - - - - - - - - - - - -
ROLE DESCRIPTIONResponsible for the provision of day-to-day database administration and support in a largecorporation with a multiple database environment, including resolution of database problems, databackup and restore, and the production of database performance statistics. Includes theinstallation, configuration, upgrade, administeration, and monitoring of databases and associatedsoftware products, in support of operational systems and the development environment. Ensuresdata integrity across multiple databases and ensures consistent data structure, data recovery,maintenance, data integrity, and space requirements for physical database are met throughimplementation of policies, procedures, and standards relating to database management. Able tointerrogate databases using an appropriate programming / query language.
Automation is KEY to this role
KEY PERFORMANCE AREAS
Assess and develop long-term strategic goals for production databases in conjunction with dataowners and customers.
Work with application development staff to develop databasearchitectures, coding standards, and quality assurance policies and procedures.
Createmodels for new database development and/or changes to existing ones.
Install and configurerelevant network components to ensure database access as well as database consistency andintegrity.
Respond to and resolve database access and performance issues.
Monitordatabase system details within the database, including stored procedures and execution time, andimplement efficiency improvements.
Design and implement redundant systems, policies, andprocedures for disaster recovery and data archiving to ensure effective protection and integrity ofdata assets.
Monitor, optimize and allocate physical data storage for databasesystems.
Plan and coordinate data migrations between systems.
Develop, implement,and maintain change control and testing processes for modifications to databases.
Create,or support creation of, required reports in response to business user needs.
Conductresearch and make recommendations on database products, services, protocols, and standards insupport of procurement and development efforts.
Perform database transaction and securityaudits.
Establish appropriate end-user database access control levels.
Developroutines for end-users to facilitate best practices database use.
Delegate duties and taskswithin the team
Review completed tasks to ascertain compliance with standards.
Keep up with trends in the constantly evolving information technology industry.
Performregular IT audit to discover areas of weaknesses and fortify them.
Customer SLA’s arekey
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 ANDEXPERIENCE
DesiredQualification:
Relevant IT Degree
Minimum Qualification:
If you fit this profile, please load your CV on the Datacentrixwebsite. To view more of Datacentrix IT jobs, go to www.datacentrix.co.za and click on‘Search Jobs'
RelevantIndustry Certification
· MCSD - Solutions Developer
· MCPD - Professional Developer
Relevant Experience:
4-6years experience