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

 LOGIN WITH
 
 
 
 
 EMPLOYERS
 
 
 
 
 
 NEWSLETTER
 
 
 
 
 FOLLOW US

Senior Database Administrator

Job Ref
274536
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 705 times.
Employer:
Datacentrix

Location:
South Africa

Salary:
Negotiable

Benefits:


Role details:
Datacentrix is an integrated,service-orientated ICT systems provider that operates across the entire information value chain. Thecompany is currently looking for an exceptional Senior SQL Database Administrator and this comeswith a lot of pressure at times
- - - - - - - - - - - - - -
ROLE DESCRIPTION
Responsible 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




 
HOME|
INFO|