The Role
Design, implement, and maintain database solutions that meet business requirements. Perform day-to-day administration, ensure service availability, manage database backups, handle incident management, and optimize database performance. Collaborate with software developers and infrastructure teams. Develop data models and database schemas, monitor database systems, provide technical expertise, implement security measures, and optimize SQL queries. Support information and security governance, troubleshoot system issues, and provide technical support to users.
Summary Generated by Built In
Title
Database Specialist
Job Description
KEY RESPONSIBILITIES:
- Design, implement, and maintain database solutions that meet business requirements and align with industry best practices.
- Perform day-to-day administration and support, including problem diagnosis and resolution.
- Ensure service availability according to SLAs and manage changes effectively.
- Manage database backups, including ad-hoc data backups and restores.
- Handle incident management, monitoring, and reporting for all databases.
- Stay up to date with relevant technology and infrastructure advances.
- Upskill and obtain certifications in relevant vendor and software fields.
- Optimize database performance through tuning, monitoring, and troubleshooting.
- Ensure data integrity, security, and compliance with data protection regulations.
- Collaborate with software developers and infrastructure teams to integrate database systems with applications and IT systems.
- Develop and maintain documentation, including database schemas, configurations, and processes.
- Perform database upgrades, migrations, patch management, and backup/recovery strategies.
- Proactively monitor database systems for availability and reliability.
- Provide technical expertise and support to resolve database-related incidents.
- Develop data models and database schemas that support business processes.
- Assist in database capacity planning and scaling efforts.
- Implement security measures to protect data from unauthorized access.
- Design and optimize SQL queries in collaboration with application developers.
- Implement database procedures, standards, and guidelines.
- Monitoring of IT Database Systems making use of tools provided
- Monitoring and Manage Database Applications
- Perform routine duties as set out in daily procedure guides which are updated from time to time.
- System Maintenance Management and co-ordination with support partners.
- Go Live Process co-ordination with departments and support partners.
- Define users and enable data distribution to the right user, in appropriate format.
- Data analytics and representation to stakeholders
- Support of Information and Security Governance in line with relevant policies.
- Troubleshoot system and applications issues in conjunction with departments and partners.
- Be available to work after hours where necessary to minimize business downtime.
- Resolve issues within maintenance window periods and SLA’s.
- Provide technical support and guidance to users and stakeholders.
- Setup and maintain database replication.
QUALIFICATIONS, EXPERIENCE, & SKILLS:
Educational Qualifications:
- Matric
- Bachelor’s degree in computer science, Information Technology, or a related field; or equivalent work experience.
- Proven work experience as a Database Specialist, Database Administrator, or similar role in a FinTech or IT environment.
- Solid understanding of database management systems (DBMS) such as MySQL, PostgreSQL, SQL Server, Oracle, etc.
- Experience with database design, implementation, and performance optimization.
- Knowledge of database security best practices and data protection regulations.
- Develop & implement data policies, procedures, security & standards.
- Managing data repositories.
- Resolving data conflicts.
- Performance tuning of database systems.
- Familiarity with database backup and recovery processes.
- Proficiency in SQL and database programming languages.
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
- Ability to troubleshoot and resolve database problems independently.
- Experience with both independent work and collaborative teamwork.
Years of Experience
- 8 – 10 Years Information Technology experience will be an advantage
Other requirements
- Relationship building
- Emotional intelligence
- Time management essential
- Analytical thinking
- Problem Solving
- Advanced Computer literacy
- Excellent administrator with strong attention to detail
- Be a team player
- Fluency in English is mandatory
- Other additional languages will be an advantage
- Strong oral and written communications skills.
Education
Languages
Top Skills
MySQL
Oracle
Postgres
SQL Server
The Company
What We Do
Altron is a proudly South African technology group. We harness the power of data, technology and human ingenuity to solve real-world problems, from the everyday to the epic. A technology industry leader since 1965, we’re partnering with customers across all industries to help them grow, build a thriving economy and transform today into a simpler, safer and smarter tomorrow. Altron operates in six countries, employs 4,700+ people and reported revenue of ZAR 7.9bn for the 12-month period ended 28 Feb 2023.
