Database Developer

SUMMARY:
We are looking for a highly skilled SQL Developer and Integration Specialist to join our dynamic team. This role combines expertise in SQL development, database management, system integration, and automation.

POSITION INFO:
SQL Developer / Database Developer (scripting, integration)
Johannesburg, In Office

The ideal candidate will have strong SQL development experience, Python scripting skills, and the ability to integrate systems through REST APIs. You will be responsible for designing and optimizing database solutions, automating tasks, and ensuring seamless communication between different systems and platforms. This is an exciting opportunity to work across various stages of the SDLC, utilizing Service-Oriented Architecture (SOA) principles to enhance our operations.

Requirements:

• 3+ years of experience in SQL development and Python scripting.
• Experience in integrating systems via REST APIs.
• Strong understanding of database design, optimization, and maintenance.
• Experience in automating tasks and creating reusable scripts.
• Knowledge of SOA (Service-Oriented Architecture) principles.
• Strong problem-solving and troubleshooting skills.
• Ability to collaborate with cross-functional teams and provide technical support.

• Develop and optimize SQL queries, stored procedures, and functions to support business applications and data analytics.
• Design, implement, and maintain database schemas, tables, and views for efficient data storage and retrieval.
• Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions.
• Integrate systems and applications using REST APIs to ensure smooth data exchange.
• Automate data processing tasks and streamline workflows using Python scripting.
• Perform system and impact analysis, providing solutions that adhere to SOA design principles.
• Create, monitor, and maintain databases, including backup strategies and data retention policies.
• Write and maintain custom scripts to improve system efficiency, reduce manual intervention, and automate repetitive tasks.
• Troubleshoot and resolve SQL query performance issues and integration challenges.
• Build and maintain reusable ETL processes to handle data from various sources and systems.
• Provide 2nd and 3rd line technical support, address slow-running processes, and optimize services for better performance.
• Participate in scoping, designing, and developing database solutions for live and development environments.
• Ensure all technical documentation is up to date for easy handover and support.
• Stay up-to-date on industry trends and emerging technologies in SQL development, database management, and system integration.