SQL Database Engineer
HANJersey City, NJjob_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
- serp_jobs.job_card.full_time
job_description.job_card.job_descriptionyears of experience working in different database technologies Strong hands-on knowledge of SQL Apply data modelling 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
Job Description :
- 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 modelling standards and naming conventions.
- Apply data modelling 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 :
serp_jobs.job_alerts.create_a_job
Database Engineer • Jersey City, NJ