Ethics Code

Senior SQL Engineer

Ethics Code

contract

Posted on:

Location Type: Remote

Location: Dominican Republic

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

ETLMS SQL ServerSQL

About the role

  • Design, develop, and maintain intricate T-SQL queries, stored procedures, views, and functions.
  • Analyze and convert business requirements into efficient SQL code.
  • Execute data transformations, cleansing, validation, and enrichment tasks.
  • Compose and schedule custom data scripts for insertion, updating, deletion, and movement operations.
  • Design, generate, and maintain reports utilizing Crystal Reports or other business intelligence tools.
  • Engage in code reviews, peer programming, and unit testing cycles.
  • Enhance existing queries to improve performance and scalability.
  • Investigate data issues, perform root cause analysis, and assist with data integrity initiatives.
  • Administer job automation and support ETL processes where necessary.
  • Ensure comprehensive documentation of SQL logic, data dictionaries, and version histories.
  • Participate in sprint planning, refinements, and collaborative solution development.

Requirements

  • Four or more years of practical experience with Microsoft SQL Server and T-SQL.
  • Strong expertise in crafting optimized queries, procedures, and scripts.
  • Experience with stored procedures, triggers, indexing, and query performance enhancement.
  • Thorough understanding of relational database concepts and data normalization.
  • Proficient in working with substantial datasets, including joins, subqueries, common table expressions (CTEs), and window functions.
  • Experience utilizing version control tools such as Git for managing SQL artifacts.
  • Capability to interpret entity-relationship diagrams (ERDs), functional specifications, and data mapping documents.
  • Demonstrated experience in writing unit tests and collaborating with quality assurance teams.
  • Familiarity with data export/import procedures, including bulk operations.
  • Excellent verbal and written communication skills.
Benefits
  • 💲 USD salary
  • 🏡 100% Remote.
  • 🌎 Opportunity to work on projects worldwide.
  • 👨🏽‍🎓 Access to E-learning platforms.
  • 🎉 2 weeks of paid time off.
  • 🎓 Certification coverage.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
T-SQLSQLstored proceduresdata transformationsdata cleansingdata validationdata enrichmentquery performance enhancementrelational database conceptsdata normalization
Soft Skills
communication skillscollaborationproblem-solvinganalytical skillsattention to detail