SQL Developer
Hi,
Please find the below Job Description. If interested, please share your updated resume along with below details.
Job Title: SQL developer
Location: Jersey city, NJ (Hybrid)
Duration: Fulltime
Responsibilities:
8+ years of exp required
As a part of Reference data modeling 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.
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
Thanks & Regards,
Sekhar
Job Type: Full-time
Pay: $125,000.00 - $130,000.00 per year
Benefits:
401(k)
Health insurance
Schedule:
8 hour shift
Experience:
SQL: 8 years (Required)
Data modeling: 5 years (Required)
STAKEHOLDERs: 5 years (Required)
database migrations: 4 years (Required)
database scripts: 4 years (Required)
Snowflake: 2 years (Required)
Work Location: On the road