Viva USA - Richardson, TX

posted 2 months ago

Full-time - Mid Level
Richardson, TX
Administrative and Support Services

About the position

We are looking for a highly skilled and experienced Senior SQL Developer to join our dynamic team. The ideal candidate will have a strong background in SQL Server and SSIS, with a proven track record of delivering high-quality database solutions. You will be responsible for designing, developing, and optimizing SQL databases, as well as implementing processes using SSIS. This role requires a deep understanding of database design, performance tuning, and data integrity, ensuring that all database solutions meet the highest standards of security and compliance with industry regulations. As a Senior SQL Developer, you will design, develop, and maintain complex SQL queries and database objects, including stored procedures, functions, and views. You will create and manage SSIS packages for data extraction, transformation, and loading, optimizing database performance through indexing, query tuning, and other best practices. Collaboration with cross-functional teams is essential, as you will gather requirements and provide technical guidance to ensure that database solutions align with business needs. Additionally, you will troubleshoot and resolve database-related issues promptly, ensuring data integrity and security throughout the process. Documentation of database designs, processes, and procedures will also be a key responsibility in this role.

Responsibilities

  • Design, develop, and maintain complex SQL queries and database objects (stored procedures, functions, views).
  • Create and manage SSIS packages for data extraction, transformation, and loading.
  • Optimize database performance through indexing, query tuning, and other best practices.
  • Collaborate with cross-functional teams to gather requirements and provide technical guidance.
  • Troubleshoot and resolve database-related issues promptly.
  • Ensure data integrity, security, and compliance with industry standards.
  • Document database designs, processes, and procedures.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • 5+ years of experience as a SQL Developer, with a strong focus on SQL Server.
  • Proficiency in SQL, database design, and ETL processes using SSIS.
  • Experience with performance tuning and optimization of SQL queries and databases.
  • Strong analytical and problem-solving skills.
  • Excellent communication and collaboration abilities.

Nice-to-haves

  • Knowledge of cloud-based database solutions (e.g., Azure SQL, AWS RDS).
  • Familiarity with data warehousing concepts and methodologies.
  • Experience with version control systems (e.g., Git).
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service