Home > Find Jobs

Job Search

A tropical beach
Payspace company logo

Payspace

South Africa

Posted on: 01 July 2024

Experience

n/a

Work

n/a

Employee Type

n/a

Salary Range

n/a

Senior DBA

Job Purpose

As a SQL DBA, you will play a crucial role in SQL development, data modelling, and database design, with a focus on optimizing and maintaining complex database systems. This role will involve working closely with cross-functional teams to support the development and deployment of our SaaS products.


  • Duties and Responsibilities

    • Database Development: Design, develop, and optimize complex SQL queries, stored procedures, functions, and views to support various applications and reporting needs.
    • Data Modelling: Create and maintain logical and physical data models to ensure database structures align with business requirements.
    • Performance Optimization: Analyse and improve database performance, including query optimization, indexing strategies, and database tuning.
    • Collaboration: Work closely with software developers, data analysts, and other stakeholders to gather requirements and deliver high-quality database solutions.
    • Security: Implement and maintain database security policies and procedures to protect sensitive data.
    • Troubleshooting: Diagnose and resolve database-related issues, ensuring high availability and reliability of data systems.
    • Mentorship: Provide guidance and support to junior developers and team members, fostering a culture of continuous learning and improvement.


Requirements

  • Experience:
    • Minimum of 5 years of experience as an SQL Developer, with a focus on database design and development in a SaaS environment.
  • Education:
    • Bachelor's degree in computer science, Information Technology, or a related field would be advantageous. 
  • Technical Skills:
    • Proficient in SQL and experience with major RDBMS systems such as MySQL, PostgreSQL, SQL Server, or Oracle.
    • Strong knowledge of database design principles, normalization, and data modelling techniques.
    • Experience with performance tuning, query optimization, and indexing.
    • Understanding of database security practices and data protection regulations.
  • Soft Skills:
    • Excellent problem-solving and analytical skills.
    • Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
    • Detail-oriented and able to manage multiple tasks and projects simultaneously.
    • Ability to work independently and take ownership of tasks and projects.
  • Preferred Qualifications:
    • Experience with cloud-based database solutions such as Azure SQL Database.
    • Knowledge of NoSQL databases and big data technologies.
    • Experience with data visualization and BI tools.
    • Familiarity with DevOps practices and CI/CD pipelines.

Tags

security
sql
performance optimization
Apply to job