SQL Developer Job at TalentOla, Jersey City, NJ

dDJ6THVUdUk4Q25BeTBPUWpOZWpGeWdEdWc9PQ==
  • TalentOla
  • Jersey City, NJ

Job Description

Job Title: SQL Database Engineer

Location: Jersey City, NJ (1 Pershing Plaza, Jersey City, NJ) – Hybrid Role

FTE role with Mphasis

The Opportunity: As a part of data modelling and entitlements team, you will use the latest technology stack and will have an opportunity to develop and implement new solutions. Being responsible and accountable for gathering and delivery of functional and non-functional requirements in accordance with the Pershing-X standards and timeframe. Review existing business requirements and ensure they contain appropriate design, and architectural components support the deployment of projects.

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 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:

  • 5+ years 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

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 standard at the end of each sprint

Job Tags

Similar Jobs

Compass Group

CATERING ATTENDANT- Camp Randall Stadium & Kohl Center Job at Compass Group

 ...oriented attitude with a friendly demeanor. Availability to work remaining UW-Madison Football games and a majority of events at the Kohl Center for the 2025-2026 season. Willingness to complete ServSafe Alcohol Certification and ServSafe Food Handler Certifications.... 

Truck with Jed Logistics

Truck Driver/CDL-A /1099 / OTR Job at Truck with Jed Logistics

 ...Hiring immediately for Class A Driver! Bold Safe Trucking is a top employer of CDL Truck Drivers across the country. In addition to a great starting salary, we offer great benefits and great schedules. Come work for a great company that takes pride in its Drivers.... 

Mission Recruit LLC

Web Developer Job at Mission Recruit LLC

~100% remote work!~ Great work culture ~ Work life balance ~ Work with talented and high performing team! Were seeking a contract Web Developer to build secure, scalable web applications and integrate them with enterprise systems across the organization. You... 

Rosen Ford

Ford Master Technician Job at Rosen Ford

 ...current hours for the first 90 days* We pay all your toolbox relocation expenses* We will honor any prearranged vacation days...  ...Employees* 401k (Match)* Open to flexible scheduling* Paid factory training* Earn weekly cash spiffs, above and beyond... 

MHF MGMT, LLC

Team Member Job at MHF MGMT, LLC

You are applying for work with a franchisee of Taco Bell, not Taco Bell Corp. or any of its affiliates. If hired, the franchisee will be your only employer. Franchisees are independent business owners who set their own wage and benefit programs that can vary among franchisees...