Senior DBA
2024-07-01
South Africa
Payspace
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.
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.