Senior DBA at 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.