Loading...

@

  • jobs
  • 1 week ago

jobs description

Introduction:

StraTech is a fintech-as-a-service company, offering a comprehensive suite of integrated payments, commerce, and financial services capabilities that can be seamlessly embedded into any application or business process.

We're seeking a skilled and motivated Mid-Level Database Administrator (DBA) with a strong background in PostgreSQL within an AWS environment. The ideal candidate will possess advanced SQL development skills and experience with PLV8 JavaScript. This role requires a proactive individual who can manage database operations, optimise performance, and ensure data integrity.

Key Responsibilities:

Database Management:
• Proficiency in installations across operating systems and configuration for optimal performance.
• Create, manage and maintain PostgreSQL databases in an AWS environment, ensuring high availability and optimal performance.
• Understanding of normalisation and denormalisation techniques.

Performance Tuning:
• Optimize database performance... through indexing, query optimisation, and other tuning techniques like EXPLAIN, ANALYSE etc
• Managing and tuning database parameters for performance.
• Understanding indexing strategies and maintenance.

Backup and Recovery:
• Implement and manage database backup, recovery, and replication strategies.
• Setting up and managing streaming replication.
• Understanding of logical replication and use cases.
• Implementing high availability solutions such as Patroni or repmgr.
• Implementing and testing recovery procedures.

Security Management:
• Ensure database security by implementing best practices for data encryption, access controls, and audit logging.

SQL Development:
• Develop complex SQL queries, stored procedures, and functions to support application development and data analysis.

PLV8 JavaScript:
• Utilise PLV8 for server-side programming to extend PostgreSQL functionality with JavaScript.

Monitoring and Troubleshooting:
• Monitor database health, troubleshoot issues, and resolve database-related problems promptly.

Documentation:
• Maintain comprehensive documentation of database configurations, processes, and procedures.
• Keeping up-to-date with industry trends and technology developments.

Required Skills and Qualifications:
• Minimum of 3-5 years of experience as a DBA, with at least 2 years of experience in PostgreSQL.
• Bachelor’s degree in Computer Science, Engineering, or a related field. Advanced degree preferred.
• Proven experience managing PostgreSQL databases in an AWS environment.
• Strong proficiency in SQL development, including complex queries, stored procedures, and functions.
• Experience with PLV8 JavaScript for PostgreSQL.
• Expertise in database performance tuning and optimisation techniques.
• Knowledge of backup, recovery, and replication strategies for PostgreSQL.
• Understanding of database security best practices.
• Familiarity with database monitoring tools and techniques.
• Strong analytical and problem-solving skills, excellent communication skills, and the ability to work collaboratively in a team environment.

Preferred Skills:
• Experience in a leadership role or as a product champion.
• Strong communication and team collaboration skills.
• Experience with test-driven development (TDD) and continuous integration (CI) practices.
• Knowledge of additional programming languages and frameworks is a plus
Stellenbosch South Africa

salary-criteria

Apply - SQL Database Administrator Stellenbosch