Database Engineer

Job Description

Purpose of the Role

You will be leading a team of technical professionals that arerequired to support all areas of the enterprise, ensuring all databases run at optimal performance. Database structures and tables are designed and implemented to deliver dynamic reporting at multiple levels. Ensure that industry-wide security standards are properly implemented. Develop and optimize complex T-SQL and PL/SQL code. Design and develop SQL code, ETL processes and SSRS reports based on provided requirements. Maintain and develop automation applications using various programming languages.

Qualifications

Qualifications Required:

Essential

• Matric/Grade 12 Certificate
• A bachelor’s degree in computer science, software engineering, or a related field of study with a minimum of 5 years  previous work experience in database development.
• Database engineers who possess extra education, such as a master’s degree, can substitute education for work experience

Microsoft Certification (MCSD, MCDBA

Knowledge and Skills:

• 5+ year experience on Microsoft SQL Server and or related RDMS
• Computer coding –write and review computer codes to design high-functioning database systems, support programs, and to debug systems. Can design write and deploy complex code to extract data from various data sources in a big data environment using SQL, Python and other relevant code
• Programming languages – proficient to write in several common programming languages, including Python, C# and Java
• Problem-solving – identify potential problems in the database, and work to solve these issues before and after they occur
• Attention to detail – comb through lines of code to spot potential error-causing problems and possible database security and storage capacity issues
• Database Architecture - Able to structure, integrate and organise data to create and extend data models for an information system by applying certain formal techniques typically implemented in a database management system
  • Good Understanding of T-SQL
  • Microsoft Reporting Services (SSRS) or similar
  • Microsoft SQL Server Integration Services (SSIS)
  • Understanding of DWBI concepts
  • Understanding of ETL concepts
  • Exposure to ETL tools
  • Scripting tools
• Agile - Understands agile methodologies (e.g. Kanban, Lean, Scrum, Scaled Agile) and apply agile ways of working. Is a role model of the agile mind-set and principles.

Role Responsibilities:

• Design New Databases - design new databases based on company needs, data storage needs, and the number of users accessing the database. Design and develop data models and cubes.

• Write and Maintain Database Programs write new database programs and maintain existing programs to ensure they can handle the flow of traffic and the amount of data being stored in the database.
• Monitor Databases and Programs - continuously monitor databases and related systems to ensure high functionality.
• Write Programs and Scripts - write new support programs and scripts for databases to increase data storage capacity and fix existing database problems.
• Troubleshooting - troubleshoot database code, checking for potential problems that affect database functionality and related database programs.
• Debugging -  look through coding language to debug existing database scripts and programs.
• Review Database Reports - review daily, weekly, and monthly database reports, including user reports and systems information, to spot problems and ensure that all databases and support systems are working

• Leadership and mentoring skills - Training and Mentoring of direct reports. Cross skilling to enable everyone to work on all environments. Train and mentor junior team members on process and technology 
• Licensing, Risk Management and Compliance - Service Monitoring and Alerting. Consulting on IT strategy and architecture from technical and business perspective 

Behavioral Traits Required:

Essential

• Strong communication skills (verbal, written and interpersonal)
• High Attention to detail
• An ability to quickly grasp complex technical issues

• Curiosity and passion for understanding data to develop reporting to help identify trends and support decision making
• Desire to continually research and learn (new technologies, tools, techniques, platforms)
• Ability to work under pressure in a fast paced and dynamic environment
• Great at building individual, team and partner relationships
• A strong sense of ownership and accountability
• Able to Prioritise workload effectively and deliver to deadlines
• Strong stakeholder management
• Honest and Reliable delivers on promises or commitments
• Ability to work remotely and independently as well as part of a team

Additional Information