Job Description

Are you energetic, ambitious, and looking to develop your career? Our Cape Town Operations department is looking to add a Junior SQL Database Administrator to their team. We offer a dynamic and challenging environment where we achieve our business objectives and have fun doing it.Youre perfect for this position if you:

• Have proven experience in the day-to-day database administration activities for operational databases and Database Administration of Microsoft SQL Server 2014 onwards.
• Have hands-on experience supporting .NET (C#, VB, ASP) and VBA applications.
• Have high level of competency with data extraction, transformation and loading (ETL) disciplines and tools (SSIS) and SQL Server reporting services (SSRS).
• Have experience creating and deploying SSIS Packages using SSDT.
• Have experience defining database server security, user creation, roles, and permissions.
• Have experience in maintaining and creating stored procedures, functions and triggers to facilitate applications with data driven dependencies.
• Are proactive and able to prioritise effectively.
• Have exceptional troubleshooting and problem-solving skills.
• Are a good communicator, both written and spoken.
• Can work independently and within a team.

Extra points if you:

• Have a Microsoft certification.

Your role and responsibilities:Among other tasks, your main responsibilities will include:

• Ensuring high levels of performance, availability, sustainability and security are maintained.
• Maintaining data quality as well as server and database security as per the user privileges set by the business units.
• Analysing, solving, and correcting any database issues in real time.
• Performing scheduled maintenance and support release deployment activities.
• Creating database backup and recovery plans and procedures.
• Handling data extraction, transformation and loading.
• Writing optimised SQL queries for integration with other applications.
• Modifying existing code, adapt it to new hardware or to upgrade interfaces and improve performance.
• Assisting developers with query tuning and schema refinement.
• Designing database tables with efficient structures.
• Consulting with staff to evaluate interface, develop specifications and performance requirements, and resolving of any bugs.
• Understanding issues related to network performance and security.
• Refining and automate regular processes.
• Performing scheduled troubleshooting.
• Providing ad hoc support to the business units or end users.

Would you like to apply?Send us an email to sajobs@sableinternational.com with your CV and one-page covering letter. Please note: If you havent heard from us within two weeks, you may consider your application unsuccessful.About Sable InternationalSable International offers innovative professional services to international citizens. We create tailor-made solutions to meet the accounting, wealth, financial, currency and nationality needs of our clients. We pride ourselves on providing solutions that suit our clients unique individual circumstances; our employees are key in achieving this goal.The staff in our global offices are passionate about their areas of expertise and take pride in helping our clients achieve their goals. As a result, we have an energised and fun company culture, something that sets us apart from other professional services firms.

Careers24