Gauteng: SQL Database Administrator/ Data Engineer posted by SAICA

Are you determined to go further as a Difference Maker? SAICA has a perfect opportunity to take you further on your journey of being a Difference Maker. SAICA has embarked on an exciting transformation to become an insights-driven, technology-enabled, and AI-powered organisation. As part of our journey, we are streamlining processes, enhancing our digital capabilities, and strengthening our focus on sustainability in the accounting profession. This transformation presents an opportunity for you to grow and contribute to SAICAs vision in a redefined, future-fit role. We are looking for enthusiastic, skilled professionals who are eager to innovate, embrace data-driven decision-making, and help shape the future of the profession. If you are ready to be part of this next chapter, make a meaningful impact, and you are a suitably qualified and experienced Difference Maker wanting to go further on this exciting journey, you are encouraged to apply. Purpose of the job The SQL Data Administrator / Data Engineer will be responsible for the design, management, and optimization of SQL-based data systems within the organization. This role focuses on ensuring high-performance, secure, and reliable data environments for both transactional and analytical data. This role will collaborate closely with cross-functional teams to support data-driven decision-making by efficiently managing and developing SQL-based data architectures, databases, and data pipelines. By leveraging SQL expertise, data engineering tools, and best practices, the individual will help drive the transformation of raw data into actionable insights for various business functions while ensuring data integrity, performance, and compliance with industry standards. Key/main outputs Output 1: Technical Support Administration of the database including performance monitoring and tuning. Configure and maintain database servers and processes, including monitoring of system health. To perform database administration. To conduct root cause analysis and resolve production problems and data issues. To lead efforts to develop and improve procedures for database performance monitoring and proactive intervention using appropriate tools. To lead efforts to develop and improve procedures for database performance monitoring and proactive intervention using appropriate tools. Track and resolve database related incidents and request. Output 2: Compliance and Security Control the access for database by giving security password and permission. Manage security settings and developer interaction. Manage Encryption of Data. Output 3: Business Continuity Management Conduct capacity planning. Preparing systems for SQL Server Installation. Backing up and restoring SQL Server databases. Setup, Manage and Monitor Database Replication (DR Synchronization), Maintenance, and Backups. Documentation: Maintain diagrams and other logical and physical database setup details. SQL Server Recovery Models. Output 4: Data and System Strategy To lead efforts to develop and improve procedures for database. To support, maintain, and monitor current ETL processes. Build and automate data pipelines. Build and automate data pipelines to ensure the continuous flow of data between systems and while maintaining data quality and integrity. Work in conjunction with end-user to define data business needs. Output 5: Embrace and drive organisational transformation Actively contribute to cost containment efforts by identifying opportunities for operational efficiencies, optimising resources, and ensuring value-driven decision making in daily activities. Support SAICAs transformation into an insights-driven organisation by leveraging data and analytics to enhance decision-making, improve processes, and drive continuous improvement in your area of work. Effectively utilise digital tools and technology to enhance productivity, streamline workflows, and improve service delivery. Stay informed about new and emerging technologies relevant to your role. Adopt and embrace AI-driven tools and automation to enhance efficiency, accuracy, and effectiveness in job-related tasks, while continuously seeking opportunities to improve processes through innovative technology solutions Identify and support SAICAs management of risks related to sustainability, including environmental risks, regulatory changes and social risks and integrating them into business continuity and risk management plans. To conduct root cause analysis and resolve production problems and data issues. Formal Education IT Diploma with emphasis on Data Management or B.Sc. (Computer Science) (advantageous). Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics. Knowledge and understanding of: database optimization techniques. Knowledge of cloud-based database services such as Azure SQL Database. Knowledge of ETL processes. Experience At least 5 years Database Administrator working experience.