Senior SQL Engineer

Posted 1hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

SQL Engineer developing and maintaining T-SQL queries and reports for international projects. Collaborating on code reviews, documentation, and performance enhancements in a remote setting.

Responsibilities:

  • 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.