SQL Developer

Job Description:

Your key responsibilities

·         Design, implement and manage the SQL queries to be consumed by multiple stakeholders.

·         Detect and resolve data quality and integrity issues in the dataset.

·         Enhance or create new logical and physical data model to meet business needs, applying data modeling standards and naming conventions.

·         Apply data modeling techniques to ensure development and implementation meets performance expectations.

·         Test and debug the deliverable code to ensure they function correctly.

·         Develop data mapping from existing systems to the new data structures.

·         Experience in data migration using the industry standard tools.

·         Experience in SQL tuning and optimization using explain plan and trace files.

·         Partitioning and indexing strategy for optimal performance

·         Must have a good verbal and written communication skill with strong interpersonal, analytical, and problem-solving abilities.

·         Experience in understanding complex source system data structures preferably in Financial Services

·         Ability to work with minimal guidance in a time critical environment.

·         Work with business stakeholders and Agile scrum teams on design, definition, documentation, and implementation of features for new applications and data structure

Skills for success

·         8+ years of experience working in different database technologies

·         Strong hands on knowledge of SQL

·         Apply data modeling techniques to ensure development and implementation meets performance expectations.

·         Run query plans, query tuning and schema refinement.

·         Help with database migrations and building database scripts

·         Work with change and release management teams

·         Experience with CI/CD and Liquibase is a plus

·         Experience with cloud platforms (Snowflake) is a plus

What we look for

·         Strong analytical and problem solving skills.

·         A self-starter, independent thinker with ambition and passion

·         Excellent inter-personal, communication, collaboration and presentation skills

·         Takes responsibility for continuous self-learning.

·         Takes the lead and make decisions in critical times and tough circumstances.

·         High level of integrity and honesty.

·         Ensure deliverables are up to a quality standards at the end of each sprint