Sql Database Administrator

Pretoria, Gauteng, South Africa

Job Description


Qualifications & Experience:
-National Diploma or Bachelor's degree in Computer Science, Information Systems, or a related field.
-5+ years of experience in administering Microsoft SQL Servers, SQL scripting, big-data, and business intelligence applications.
-Proven experience as a SQL Database Administrator, specifically with MsSQL, SSIS, SSRS, SSAS, and DBMS.
-Prior experience working with ERP applications and systems.
-Strong understanding of database architecture, performance tuning, and optimization techniques.
-Proficiency in writing complex SQL queries, stored procedures, and functions.
-Proficiency in programming languages such as C++, HTML, Java, JavaScript, Python, Visual Basic, C#, PHP
-Experience with database backup and recovery strategies.
-Familiarity with database security and access controls

Requirements:
-Proficiency in programming languages such as C++, HTML, Java, JavaScript, Python, Visual Basic, C#, PHP

Responsibilities:
-Installation and Configuration: Install and configure database management systems (e.g., SQL Server, MySQL).
-Database Design and Implementation: -Design and implement database structures based on business requirements. Ensure data integrity and normalization.
-Performance Monitoring and Tuning: Monitor database performance and optimize queries.
-Implement performance-tuning techniques .
-Backup and Recovery: Develop and implement backup and recovery strategies. Ensure data integrity and availability.
-Security Management: Implement and maintain database security measures. Control access to databases and sensitive information.
-Patch and Upgrade Management: Apply patches and updates to the database management system. Plan and execute database upgrades.
-Capacity Planning : Forecast future database capacity requirements. Plan for scalability and growth.
-Troubleshooting: Investigate and resolve database-related issues. Provide support for database-related incidents
-Collaboration: Collaborate with development teams, system administrators, and other stakeholders.
-System Design: Design software solutions, including architecture, modules, and interfaces.
-Create technical specifications and documentation.
-Coding and Programming: Write efficient, maintainable, and scalable code. Implement software solutions according to design specifications.
-Excellent problem-solving and troubleshooting skills.
-Strong communication and collaboration abilities to work effectively with cross-functional teams.

ExecutivePlacements.com

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD1291436
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Pretoria, Gauteng, South Africa
  • Education
    Not mentioned