EXPLORE PREMIER
OPPORTUNITIES

SQL DeveloperOutdefine Partner

Web3

10-50

San Francisco, CA, USA

About the job

Overview:

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