Description:
Supports teams to develop, and implement innovative solutions to complex business and technology problems
Skills – Essential:
Experience on multiple full release project life cycles including Agile. (Essential)
Demonstrates technical leadership skills (Essential)
Expertise in working with SQL in an AWS data warehousing/data lake environment. (Essential)
SQL Programming: Strong command over SQL programming language and its syntax, including complex queries, joins, subqueries, indexing, and optimization techniques. (Essential)
Performance Tuning and Optimization: Ability to analyze query performance, identify bottlenecks, and optimize SQL statements and database configurations for improved efficiency and response times. (Essential)
Troubleshooting and Debugging: Proficiency in diagnosing and resolving database-related issues, such as connectivity problems, performance degradation, or data integrity concerns. (Essential)
Documentation and Communication: Strong written and verbal communication skills to effectively document scripts, procedures, and database changes. Ability to collaborate with other team members and stakeholders. (Essential)
Problem-solving and Analytical Thinking: Strong problem-solving skills and the ability to think analytically when analyzing complex data requirements, designing efficient queries, and resolving database-related issues. (Essential)
Experienced using AWS Glue or AWS RedShift (Highly Desirable) alternate cloud technologies would be considered also.
Skills – Desirable
Knowledge and experience of modem software design and development methodologies & frameworks (e.g. Agile/Scrum)
Scripting Languages: Familiarity with scripting languages like Shell scripting, Python, or PowerShell, which are often used for automating tasks, data manipulation, and integration with other systems. (Desirable)
Database Design and Modelling: Knowledge of database design principles, entity-relationship (ER) modelling, and normalization to ensure efficient and scalable database structures. (Desirable)
Familiarity with related technologies: Knowledge of other relevant technologies such as data warehousing, data analytics, reporting tools, and integration platforms can be beneficial. (Desirable)
Experience
Participates as a member of the development teams.
Development knowledge of multiple back-end languages and technologies
Participates in cross-functional teams.
Applies technical knowledge to provide maintenance solutions across one or more technology areas.
Supports the team to develop innovative team solutions
Participates in code reviews.
Uses knowledge and experience to help shape the application backlog.
Actively contributes to refinement sessions.
Flexible and willing to accept a change in priorities as necessary.
Attention to detail with a pragmatic and enthusiastic attitude to work.
Ability to work effectively in a globally dispersed team and with clients and vendors.