Job description
.
Job Description
Position: Senior Database Developer
Location: Flexible
Purpose of the Role
Design and create databases, write, and maintain stored procedures. Design databases to be scalable with a view of how to migrate to Data Lake architecture as the quantity of data scales.
Required to lead the Database development team, along with demonstrating best practice.
Roles and Responsibilities
- Design and build databases for optimal performance
- Ensure data security, scalability, and data integrity within all processes and solutions
- Apply established DB design methodologies
- Determines most effective and efficient software design to meet specifications
- Update project coordinator with progress against the project schedule
- Consulting with Account managers, Head of Operations and fellow colleagues concerning maintenance, enhancements, and development of the system.
- Streamline data import and integration processes
- Advise on areas that could be improved on and keep up to date with new trends in software development and technologies that can be used to benefit the company.
Key Competencies
- Skilled in importing data from various sources
- Ability to clearly document and execute processes relating to data setup, technical roadmaps for clients and solution design
- SQL code performance tuning
- Develop stored procedures for high performance
- Database performance troubleshooting and performance enhancements through performance analysis leading to SQL rewrites, table redesign, and/or indexing
- Strong working knowledge of developing Data Warehouse technologies
Qualifications & Experience
- Minimum 5 years database development experience
- IT related Degree or National IT Diploma
- MS SQL Database experience preferred, with ability to learn new technologies
- Snowflake experience hugely beneficial
- Preference for a person who has worked in a dynamic environment with large volume of records
- Experience working with Data Lake architecture beneficial
- Hadoop experience beneficial