Htc Global Services - Las Vegas, NV

posted about 1 month ago

Full-time - Mid Level
Las Vegas, NV
Professional, Scientific, and Technical Services

About the position

HTC Global Services is seeking an experienced SQL Developer to join our team and contribute to the design and implementation of databases. In this role, you will collaborate closely with data architects and database developers to implement data modeling and SQL solutions that streamline and support enterprise information management. As a SQL Developer, you will work collaboratively with all participants in software development projects, providing support to developers and testers as they set up their data schemas and data models. This position also involves close collaboration with module leads, business analysts, and project leadership as the team develops new applications and modules. You will have the opportunity to work with the latest emerging technologies and contribute to the success of our clients while advancing your career in a supportive environment. Your responsibilities will include analyzing and translating business needs into long-term solution data models, evaluating existing data systems, and working with the development team to create conceptual data models and data flows. You will implement data strategies and develop physical data models, update and optimize local and metadata models, and evaluate implemented data systems for variances, discrepancies, and efficiency. Troubleshooting and optimizing data systems will also be a key part of your role, ensuring that our data management processes are efficient and effective.

Responsibilities

  • Analyzing and translating business needs into long-term solution data models.
  • Evaluating existing data systems.
  • Working with the development team to create conceptual data models and data flows.
  • Implementing data strategies and developing physical data models.
  • Updating and optimizing local and metadata models.
  • Evaluating implemented data systems for variances, discrepancies, and efficiency.
  • Troubleshooting and optimizing data systems.

Requirements

  • Bachelor's degree in computer science, information technology, or a similar field.
  • 5 years of hands-on experience with SQL development and physical and relational data modeling.
  • Expert knowledge of metadata management and related tools.
  • Strong interpersonal skills.
  • Experience with team management.
  • Excellent communication and presentation skills.
  • Advanced troubleshooting skills.
  • Advanced SQL programming skills.
  • SQL query optimization/performance tuning.
  • SQL query execution plan.
  • Experience with SQL Server 2008R2/2012/2014/2019, including writing TSQL.
  • Ability to write basic queries.
  • Understanding and ability to create CTEs, stored procedures, and user-defined functions.
  • SSRS report development and performance tuning is required.
  • DBA skills such as database restore/backup/assigning roles/permissions is a plus.
  • Data modeling/diagram skills, ability to read data models, and understanding of dimensional table relationships is a must-have.

Benefits

  • Paid-Time-Off
  • Paid Holidays
  • 401K matching
  • Life and Accidental Death Insurance
  • Short & Long Term Disability Insurance
  • Variety of other perks
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service